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

Samantha_McCol1
Level 3

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

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?

4 REPLIES 4
Devraj_Grewal
Level 10

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

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
Level 3

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

lead created.PNG

Dory_Viscoglio
Level 10

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

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
Level 3

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

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