Salesforce Campaign Attribution Models and Campaign Reporting

by | Last Updated: Apr 25, 2023 | Blog, Campaigns, Pardot | MC Account Engagement, Reporting, Solutions

Welcome to the second part of what may or may not be a series on Pardot and Salesforce best practices. In an earlier blog post, Best Practices for Salesforce and Pardot Campaign Set up, we went over how to set up a connected campaign in Pardot and Salesforce and gave you some best practices on naming and measuring campaigns. In this post, we’ll go into detail on the various campaign reporting tools and templates available to you. We’ll also go over campaign attribution models and how to use them to gauge marketing’s true impact on your campaigns.

Campaign attribution models

Campaigns are an integral part of Pardot, since most assets need to be assigned to a campaign. Pardot assets can be assigned to a single campaign, and prospects can be assigned to multiple campaigns in a one-to-many relationship, where one prospect can belong to many campaigns.

The Salesforce influence model is the default Salesforce model and attributes 100% revenue credit to the primary campaign and 0% to any other campaigns users assign to an opportunity. It shows the number of opportunities and amount of revenue each campaign has influenced. Use the Campaigns with Influenced Opportunities report to view opportunities that are influenced by each of your campaigns. Great for total dollar graphs segmented by the opportunity.

Campaigns with influenced opportunities

Customizable Campaign Influence is also available in Salesforce. Campaign Influence works by linking contacts to campaigns (via campaign member records) and contacts to opportunities (via contact roles).

The Customizable Campaign Influence models rely on the campaign object, the opportunity object, and a campaign influence junction object. When you enable Customizable Campaign Influence, the standard objects CampaignInfluence and CampaignInfluenceModel are added to your org.

When campaign influence is enabled a new report type is created, ā€œCampaigns with Influenced Opportunities.ā€

Here are a few reports campaign influence reports to consider

Influenced Pipelineā€”Provides a snapshot of active opportunities and their campaigns.

Influenced Closed Opportunitiesā€”How marketing influenced converted revenue, so called ā€˜Holy Grailā€™ of marketing.

Campaigns with Influenced Opportunitiesā€”Great for total dollar graphs segmented by the opportunity.

Opportunities with Campaign Influenceā€”Similar to Campaigns with Influenced Opportunities but segmented by campaign. Shows the number of opportunities and amount of revenue each campaign has influenced. Use the Opportunities with Campaign Influence report to view opportunities that are influenced by each of your campaigns. Great for total dollar graphs segmented by the campaign.

Influenced opportunities

Contacts with Campaign Influenceā€”A great way for the sales team to review activities and a great way for the marketing team to find opportunities that donā€™t have contact roles.

Campaign ROI Analysis Reportā€”The Campaign ROI Analysis Report calculates the ROI and average costs for your campaigns. The ROI is calculated as the net gain (total value opps minus actual cost) divided by the Actual Cost. The ROI result is expressed as a percentage.

Campaign ROI analysis

Accounts with Campaign Influenceā€”Into account-based marketing? This is a visual roll-up of how your accounts are interacting with marketing campaigns.

Campaign Leads or Campaign Contactsā€”Use the Campaign Leads or Campaign Contacts reports to list the leads or the contacts associated with your campaigns.

Campaign Call Down or Campaigns with Campaign Membersā€”Use the Campaign Call Down report (single campaign) or the Campaigns with Campaign Members report (multiple campaigns) to show information about leads and contacts.

Campaign Memberā€”Use the Campaign Member report to view the members of campaigns.

Campaign Member Analysisā€”Run the Campaign Member Analysis report to summarize information about who has responded to campaigns.

Campaign Revenue Reportā€”Use the Campaign Revenue Report to analyze which opportunities have resulted from your campaigns. You can also analyze products and revenue schedules in this report.

Pardot campaign influence attribution models

Pardot campaign influence attribution models bring multi-touch campaign attribution models to Salesforce dashboards. Pardot campaign influence attribution essentially shows campaign influence on the opportunity.

Attributing influence to one touchpoint isnā€™t always accurate, so enabling multiple attribution models makes it easier to track and measure campaign influence with greater accuracy. First touch, last touch and even distribution models are supported directly from the opportunity records in Salesforce. First touch is set as default primary model unless other settings are configured.

First touch, last touch and even distribution campaign attribution models are supported directly from the opportunity records in Salesforce.

Campaign attribution

First touchā€”Assigns 100% of influence and revenue earned to the first campaign a prospect touches. Even if a prospect interacts with other marketing assets or activities, this model attributes all of the influence to the first touch. This model relies on the campaign memberā€™s created date and is for Pardot users only. First touch is set as default ā€˜Primary Modelā€™ unless other settings are configured.

Even distributionā€”Assigns an equal percentage of influence and revenue earned to every campaign a prospect touches. This model is for Pardot users only.

Last touchā€”Assigns 100% of influence and revenue earned to the last campaign a prospect touches before a deal is closed. No matter what other campaigns the prospect has interacted with, this model attributes all influence to the final touchpoint. This model relies on the last modified date of the campaign member and is for Pardot users only.

Campaign reporting

There are several native Salesforce campaign reports available and already set up for you, which is a great starting point.

Standard reports include:

Campaign ROI Analysis Report: How are each of your campaigns performing?

Campaign Call Down Report: Shows all the members of a specific campaign.

Campaign Member Report: Shows all the members of your campaigns.

Campaign Member Analysis Report: Who has responded to your campaigns?

Campaign Leads: Which leads have been marketed to in the past?

Campaign Contacts: Which contacts have been marketed to in the past?

Campaign Revenue Report: Shows the revenue generated from your campaigns.

Campaigns with Influenced Opportunities (Customizable Campaign Influence): Shows the opportunities influenced by your campaigns (tracks pipeline and revenue for multiple Campaigns and ties all Campaign membership of a Lead/Contact associated with an Opportunity to that Opportunity).

NOTE: Prospects who are not syncing with a lead or contact cannot be seen by these Salesforce engagement metrics and reports. If you have a large number of prospects only in Pardot you cannot see the ā€˜realā€™ number of interactions until you sync those prospects to Salesforce. The reverse may also be true…the number of prospects may appear lower in Pardot’s Salesforce campaign view compared to the Salesforce campaign report if there are Salesforce leads/contacts in the campaign who have not yet been created as Pardot prospects (Pardot does not have records for those prospects yet so they are not included in Pardot’s Salesforce campaign view).

About the Pardot rename

In April 2022, Salesforce announced the rebrand of Pardot to Marketing Cloud Account Engagement. While the rebrand unfolds and the world adapts to the new nomenclature, we'll typically keep the Pardot name in our blog posts.

There are several permutations of the new name being thrown about, so you may see us use any one of them as things evolve:

  • Pardot
  • Marketing Cloud Account Engagement
  • Marketing Cloud Account Engagement (Pardot)
  • MCAE
  • MC Account Engagement
  • Account Engagement by Pardot

Certified Consultant/Owner | Jeff Kemp

Marketing Automation & CRM Consultant

hire Jeff Kemp | Marketing Automation & CRM Consultant

I help select your tech stack and optimize your processes for improved marketing & sales effectiveness, operations, and ROI.

My superpowers are Knowledge, Experience, and Business acumen. I enjoy the intersection of working with people, processes, and technology where I can provide leadership and add value.

With over 30 years of marketing and sales experience I've been laser targeted on Marketing Automation for 10 years, seven of those as a Salesforce Certified Marketing Cloud Account Engagement (Pardot) Consultant, and also as a Certified Salesforce Administrator and HubSpot Expert. Prior to that I have over 15 years of WordPress development experience and additional roles in sales and marketing management.

Since I've worked with a lot of clients in various industries I've seenĀ several of the same struggles that are common to almost all organizationsĀ (as outlined inĀ this article). With each organization and project that I'm involved with I work hard to solve many of those typical problems, plus identifying and solving sometimes unique and complex issues which often involve cleaning up technical debt from legacy systems, and architecting processes and solutions to help organizations set up effective lead management systems and operational efficiencies using best practices and proven methodologies.

I also love dogs :0)

Optimal Business Consulting (OBC) is proud to be a Salesforce Partner since 2018 and also became a HubSpot Solution Partner in 2023. -->More about Jeff & OBC

Content Satisfaction Survey

We value your feedback. You may remain anonymous if you like.

Subscribe to our Blog

Follow Us

Latest Posts

Does migrating marketing automation or CRM platforms actually pay off?

Are you thinking about migrating Marketing Automation or CRM platforms and wondering if itā€™s worth it? Will your company/organization be better off in the long run if you migrate MAP and/or CRM platforms? Download our ā€˜Marketing Automation & CRM Platform Migration Checklistā€˜ Google Sheet as a valuable resource to give you some things to consider before making the jump.

Quick Tip: Syncing HubSpot with Salesforce Do Not Email

If you are connecting HubSpot with Salesforce and setting up HubSpot to sync with Salesforce, you donā€™t want to map the ā€˜Marketing contact statusā€™ field directly to Salesforceā€™s ā€˜Do Not Emailā€™ (DNE) field; those fields will not sync the proper values based on how they are intended to work.

Trending Posts

Subscribe to our articles

Like this article? Comment with your feedback below, andĀ subscribeĀ for all the latest helpful information.

ī€š

Apply to be a Guest Poster if you are interested in writing one or more articles for our blog. To qualify you must be a subject matter expert that aligns with one of our current blog categories.

Related articles…