Added to SFDC Campaign in Last 90 Days - Best Way?

[Samantha_McCol1]

Hi Community! Creating a smart list of anyone that has been added to ANY SFDC campaign in the last 90 days. The only available filter that I can find is "Member of SFDC Campaign" with the "Campaign Member Created Date/Time" constraint, but this actually requires adding all of the SFDC campaigns as "is any" is not an option. We have thousands of campaigns with new ones being added daily - so this isn't feasible. Any suggestions?

[Devraj_Grewal]

Samantha,

Could you provide a screenshot of this filter? I am not seeing a "Campaign Member Created Date/Time" constraint for the "Member of SFDC Campaign" filter.

[Samantha_McCol1]

[Dory_Viscoglio]

I don't have a great solution, but have a workaround that you could use moving forward. You could timestamp anytime someone is added to a SFDC campaign and then reference that field.

If you have RCE you can also report on members by month for your Marketo programs, which hopefully relate consistently to campaign membership by channel.

[Samantha_McCol1]

Thanks, Dory! It can be very frustrating trying to use SFDC filters. Wish there was a better way.