Added to SFDC Campaign in Last 90 Days - Best Way? | Community
Skip to main content
Samantha_McCol1
Samantha_McCol1
February 7, 2017
Question

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

  • February 7, 2017
  • 2 replies
  • 2460 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Devraj_Grewal
Devraj_Grewal
February 7, 2017

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
Samantha_McCol1Author
February 7, 2017

Dory_Viscoglio
Dory_Viscoglio
February 7, 2017

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
    Samantha_McCol1Author
    February 7, 2017

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

    Terms & ConditionsAccessibility statement

    Loading footer...