Showing Marketing’s Influence on Pipeline with Salesforce Campaigns

 

This session, led by Ben Lamothe, focuses on the core mechanics of connecting marketing actions in Pardot to revenue attribution in Salesforce. It provides essential guidelines for structuring campaigns, member statuses, and using Salesforce’s native Campaign Influence models to prove marketing’s impact on pipeline.

Key Takeaways

 

• Consistency is Mandatory: The most critical step is establishing consistent naming conventions for campaigns and member statuses. Inconsistency prevents accurate reporting and makes roll-up calculations impossible.

• Contact Role is King: For any attribution to occur, the prospect must have an Opportunity Contact Role in Salesforce. Without it, Pardot’s visibility and influence reporting are severely limited.

• “Responded” Matters: Only campaign member statuses marked as “Responded” in Salesforce are considered influential actions for attribution modeling.

• Pardot is Extensible: Marketing planning (Pardot completion actions) must be mapped to the Salesforce campaign hierarchy to ensure every influential touchpoint is recorded as a Campaign Member.

1. Establishing Campaign Structure and Naming

 

To leverage influence reporting, campaign naming conventions must be descriptive and consistent.

• Descriptive Naming: Campaign names should include key identifiers such as segment/audience shorthand, year, campaign name, and asset name (e.g., ES_2020_ConnectedCustomer_Email1). This allows for specific filtering and reporting later.

• Campaign Hierarchy: Plan your campaign structure in Pardot and Salesforce simultaneously. For example, a child campaign (Email 1) must be connected to its parent campaign (Connected Customer) for roll-up reporting.

• Influential Activity Definition: Decide at the campaign development level what counts as an influential touchpoint (e.g., a form fill or webinar registration) and what does not (e.g., a simple email open). Only focus on recording the influential activities as Campaign Members.

2. Campaign Member Statuses and Consistency

 

Consistency in member statuses is vital to avoid reporting gaps and ensure all actions are counted correctly.

• Status Purpose: The status illustrates the specific action taken by the prospect (e.g., Downloaded White Paper, Registered for Webinar). Sales reps view this history on the Lead/Contact record as an indicator of engagement.

• Responded Checkbox: When creating statuses, ensure the “Responded” checkbox is ticked only for statuses that represent a true action taken by the prospect. Salesforce only uses “Responded” statuses when calculating Campaign Influence.

• Consistency Enforcement: Avoid a “Wild West” where different marketers use different statuses for the same action (e.g., five ways to say “Completed Form”). Standardize all acceptable statuses across the organization. Tools (like third-party apps mentioned) can be used to auto-populate and enforce acceptable statuses by Campaign Type.

3. Understanding Campaign Influence Models

 

Salesforce provides four native models to allocate revenue credit for an Opportunity.

• Primary Campaign Source Model: Puts 100% of influence and revenue share on the campaign listed in the Primary Campaign Source field on the Opportunity. This model is subjective and can be manually overridden by sales.

• First Touch Model: Gives 100% credit to the very first campaign the prospect was associated with (the initial entry point).

• Last Touch Model: Gives 100% credit to the last campaign the prospect touched before the deal closed.

• Even Distribution Model: Distributes the revenue share equally across all campaigns that were associated with a Contact Role on the Opportunity.

Note: If no Primary Campaign is set, the system defaults to the other models (First, Last, Even) based on which ones are enabled.

4. Visibility and Reporting

 

Native Salesforce reporting provides granular visibility into the marketing funnel, but only if the data foundation is correct.

• The Contact Role Requirement: The entire attribution framework hinges on the Opportunity Contact Role. If this is missing from the Opportunity, no influence reporting is possible in Pardot or Salesforce. Sales organizations often struggle with this.

  • Workaround: Some organizations use flows and process builders to automatically populate a Contact Role when the Opportunity is created or meets specific criteria, bypassing manual entry.

• Engagement History Dashboards: Once Connected Campaigns are enabled, these dashboards can be added to the Lead, Contact, and Opportunity page layouts. They provide a quick view of:

  • Activity over time for that record.

  • Most engaged campaigns and content assets.

• Reporting Output: Salesforce reports (e.g., Campaigns with Influenced Opportunities) allow users to filter and view the results by any of the active influence models, enabling comparison between First Touch and Last Touch performance.

• Pardot Reporting Check: To ensure Salesforce reports include all relevant Pardot prospects, add a filter that requires the Pardot URL field to be not empty.