Categories

Getting Started

Learn through 101 guides and easy solutions.

How to Display the Number of Marketing Activities for Leads and Contacts in Salesforce

How to Display the Number of Marketing Activities for Leads and Contacts in Salesforce

min. reading

Want to be able to report on how many marketing touchpoints have occurred your leads and contacts? With some help from an App from the Salesforce App Exchange, you can rollup the number of marketing campaigns a lead has responded to with a couple of clicks.

Install Rollup Helper

Rollup summary fields only work if there is a master-detail relationship, so to rollup the number campaigns Rollup Helper will need to be installed from the Salesforce AppExchange. Follow the instructions to install the free app in your Salesforce Org.

Create fields for Leads & Contacts

Create a number field for leads and contacts.

Create a rollup for leads

Naviate to the Rollup Helper app and click on create a new rollup. Select Lead for where you would like your rollup results to reside.

Select your new field from the list for where you want the results to reside.

Select the Campaign Member as the object would you like to use as the source of your rollup and Lead ID – CampaignMember.LeadId as the relationship field.

Select count as the source type of the roll up and click add new filter.

Now, add any filters for campaigns that you want to include or exclude from the rollup field. For my campaigns, I’m only going to count campaigns where Responded = TRUE. You can also use filters to exclude certain campaign types, or certain dates.

Save and run your rollup. Depending on how many leads and campaigns you have, this might take a while.

Create a rollup for contacts

Repeat the same process for contacts by creating a new rollup helper with Contact as the option for where you would like your rollup results to reside.

Questions?

Send me a tweet @jennamolby, or contact the Sercante team for help.

Subscribe to The Spot

Hidden
Hidden
Hidden
Hidden

Categories

Top 3 Recent Post

  • Jenna is a Marketing Operations leader with over 10 years of experience working with both enterprise organizations and start-ups. She started her career as a consultant, helping B2B and B2C clients get the most out of Marketo, Pardot, Marketing Cloud and Salesforce. She then moved in-house, working with B2B SaaS companies, helping them build their sales and marketing technology stacks and processes from scratch.

Leave Your Comment

Related Articles

Bot Single Post