SOLVED

How to Get Data for Used and Unused Smart List from Marketo Database

Go to solution
Sorabh_Bhatia
Level 1

How to Get Data for Used and Unused Smart List from Marketo Database

I have a query related to check how many smart lists are in used and how many are not in use. Is there any way to check all in one go expect manually by clicking on Used by One by one. 

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

Re: How to Get Data for Used and Unused Smart List from Marketo Database

No, I don't think there's an easier way for this. I like to organize SLs in different folders like Operational SLs, Test SLs, Reporting SLs, One-Off Checks, etc. so I quickly know which ones could be deleted/cleaned and which ones needs to be given a thought before removing references and deleting.

 

View solution in original post

2 REPLIES 2
Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

Re: How to Get Data for Used and Unused Smart List from Marketo Database

No, I don't think there's an easier way for this. I like to organize SLs in different folders like Operational SLs, Test SLs, Reporting SLs, One-Off Checks, etc. so I quickly know which ones could be deleted/cleaned and which ones needs to be given a thought before removing references and deleting.

 

Sorabh_Bhatia
Level 1

Re: How to Get Data for Used and Unused Smart List from Marketo Database

Thanks @Darshil_Shah1 . I will apply the same. But this is for some audit that we need to perform on database and there are so many already built smart lists which are not easy to maintain in specific folders.