This content has been marked as final. Show 6 replies
Could you share a screenshot of all of the filters for one of your Smart Lists?
Hey Jeff--if you can find any way around nesting smartlists within smartlists, it would probably be a good idea. Running a smart list that queries 150 other smart lists could potentially take a very long time. Depending on the size of your database, it could even take a couple of hours.
Is there a way for you to add a field in Marketo that you could mark TRUE if a lead would meet any of the criteria in the 150 smart lists you are trying to pull? Then when you are creating your master smart list, instead of using the "member of smart list filter", you could just include "New Marketo Field = True". That would save you from having to add 150 individual filters, and your smart list would probably run in a more manageable amount of time.
What I've done for this is make a seperate smartlist that combines all of the ones you wish to automate on.
Then for the "Member of Smart List" you can select just the one aggregated list. This may not help if you're creating something for one-time use but does help if you may have this need often or have complex automation.
hope it helps!
This is a one-time list I will have to pull, so I'm looking for a solution to avoid doing a step manually 150+ times.
So basically I have 150 Events named DATE-EVENTNAME each one containing one email named DATE-EVENTNAME.NoShow.
Each Event contains a Smartlist pulling the leads that clicked a link of the NoShow email of that event (see attachment). The final output I need is an excel file containing the leads that clicked on one of those links, and what email/event the link belonged to and this compiled for all the 150 events
Is there any way to automate this retrospectively? With reports maybe?
You can acheive a list of everyone who has already clicked one of the links in any of your events with a filter using Email "contains", like this:
While this performs the function of the filter you are attempting above, I do not know how you can "group" these leads by what program they clicked in.
If you currently connect your click activity to SFDC, there might be a way to run an SFDC report ...