Salesforce Marketing Reporting for a Management Level Audience

By Lucy Mazalon

Marketers have a tough time proving their campaigns have influence on the sales pipeline, let alone proving the return on investment (ROI) of their efforts.

The link between opportunities and campaigns can be tenuous because ‘influence’ can be challenged in a number of ways – the length of time between the prospect’s interaction and the opportunity creation, the quality of the marketing touchpoint with the prospect, plus, sales reps’ calls and meetings cited as ’sealing the deal’ or ‘getting it over the line’.

This gets tougher when showcasing what you have achieved to senior management or ‘The Board’. This audience doesn’t care for email opens and clicks, event attendees, or webinar registrations.

Although ‘Campaign Influence’ is an obvious answer that springs to mind, this group may not find the figures credible (see the reasons listed above).

What should you do in this situation? What other metrics, reports, or tactics could you add to your marketing presentations?

1. Campaign Influence

As I mentioned in the introduction, Campaign Influence is the obvious answer that springs to mind. Although management not working so closely with marketing may not find the figures credible, I believe that Campaign Influence still has a seat at the table when deconstructed, explained, and caveated in the correct way.

READ MORE: Complete Guide to Salesforce Campaign Influence

Deconstructing Campaign Influence is explaining that one opportunity can be influenced by many campaigns, and one campaign can influence many opportunities.

This is a many-to-many relationship (in Salesforce-jargon, ‘Campaign Influence’ is a Junction Object).

The easiest way I find to show this is by displaying Salesforce Campaign Influence reports as crude tables in a dashboard, like below:

Caveats are important to engage stakeholders in the conversation – Campaign Influence will never be 100% accurate, just as we can’t capture and quantify every single moment of intent, and aspect of human decision making. There are two caveats up for discussion:

  • Influence Timeframe: How much time is allowed to pass between the prospect’s touchpoint with that campaign, and whether that campaign contributes towards the opportunity. You will find this in the Campaign Influence settings in Salesforce Setup. Setting a timeframe that’s suitable for your organisation will depend on the length of your sales cycle – longer sales cycles (especially lengthy lead qualification) will justify a longer influence timeframe.
  • Quality of the Touchpoint: This is where Campaign Member Status comes into the limelight. That field determines whether a Lead was just sent the email campaign, or whether they interacted with it; whether a customer registered for the event or actually spoke to a sales rep.
READ MORE: 7 Tips for Working With Salesforce Campaign Member Status

2. Pipeline Velocity

Pipeline velocity refers to the speed at which an opportunity or a lead progresses through the pipeline stages, for example, from ‘Contacted’ to ‘Converted’, or from ‘Proposal/Price Quote’ to ’Negotiation/Review’.

Velocity can be calculated using date fields and formula fields (or row-level summary formulas in reports) – this article will give you a starting point. Show the comparison between a lead who marketing has engaged with versus a lead that marketing hasn’t engaged with.

READ MORE: Customisable Pardot Prospect Lifecycle Report: MQL Reporting How You Want It

A good indication is prospect score, as the higher the score the more marketing content that prospect has interacted with. As score is often not a perfect picture in organisations, another example could be comparing the velocity of prospects in multiple marketing campaigns vs. prospects in none. Hopefully, what you will see is either:

  • Prospects with a higher score have a velocity x% higher.
  • Or, prospects part of multiple marketing campaigns have a velocity x% higher.

Don’t forget to extend this analysis to the opportunity funnel too!

3. Account-based Marketing (ABM)

Marketing is often ridiculed for being too ‘fluffy’, with an outdated reputation that marketers grab leads that happen to bite the bait from a widely cast net. ABM puts a stop to these ’spray and pray’ approaches and gives legitimacy to marketing plans by showing a thoughtful and targeted approach to engaging prospects.

The target accounts list should decided upon in collaboration with the Sales Director, once you have decided on your target job titles, or seniority and function, the marketing team can get to work.

READ MORE: Building a Cross-Team Account-Based Marketing Machine

Re-configure your org for ABM leveraging tricks, such as data ‘roll-up’ from Contacts to Accounts, or the Salesforce Account page to visually map coverage by job role, or to identify ‘whitespace’.

READ MORE: Get Your Salesforce Data in Shape for Successful Account-Based Marketing

Engagement History Dashboard on Campaigns include account engagement. Based on which Leads and Contacts are associated to your Campaign (as Campaign Members), the chart totals up those activities, and splits them by Account.

READ MORE: Engagement History Dashboards: Enhanced Pardot Campaign Reporting

Also, behind the scenes, there are now stronger data relationships between Accounts and Campaigns. Related lists will show:

  • Which Accounts are related to a Campaign (on the Campaign page).
  • Which Campaigns are related to an Account (on the Account page).
READ MORE: Accounts as Campaign Members with Salesforce (and Pardot Account Engagement)

Aside from all these new features, how about you revisit good ol’ fashioned prospect grading? By setting up your grading model to favour prospects with job titles that fit your ideal customer profile, you can quickly separate out the ‘A grade’ from the less relevant. Use a blended scoring and grading model to prove that marketing efforts are getting your organisation in front of these target buyers.

READ MORE: The Ultimate Guide to Pardot Grading
READ MORE: Pardot Scoring vs Grading: Pinpoint Hot Prospects

Alternatively, if you are on a higher edition of Pardot (Account Engagement), try out the AI-driven equivalents to scoring and grading, Einstein Key Account Identification and Einstein Behavior Score, respectively.

READ MORE: Salesforce Einstein Key Account Identification: Grade Accounts With AI
READ MORE: What is Pardot Einstein Behaviour Score? vs Pardot Score

4. Call Abandonment

When this topic came up on the Trailblazer Community Group, call abandonment was one suggested approach.

Business Development Reps calling long lists of leads all day can bring results, but it is expensive (BDR time, data acquisition costs) and becoming increasingly ineffective.  If BDRs cannot work through the entire call list, or give up after a single attempt, then there’s money leaking out of the business.

Marketing can step in to take over using email, after one unsuccessful call attempt. It would be interesting to measure the % of 2nd call success after marketing intervention compared to the period before the nurture initiative.

Note: To track this properly, the ’Status’ field on Tasks need to have a ‘Completed- Successful’ status and a ‘Complete – Not successful’ status. This does not come out-of-the-box.

5. Recycling Campaign

Similarly to improving call abandonment rates at the top of the lead lifecycle, marketing can have an impact on the other end.

Recycling campaigns can add prospects to a nurturing program via Engagement Studio for a few scenarios including (but not limited to): disqualified leads, lost opportunities, dormant opportunities.

The impact of these campaigns are particularly lucrative for marketing if these Leads/Opportunities are no longer being actively pursued by the sales team. Sometimes it’s a matter of timing, that a prospect isn’t ready just yet. Marketing can potentially scoop up ‘low hanging fruit’, while sales will be glad to shed the ‘dead weight’ from their pipeline.


This guide has included some ideas I have come across in my time as a Salesforce and Pardot Consultant, helping marketers showcase the results of their marketing efforts in a more impactful/imaginative way for a management-level audience. I hope this has given you some ideas to experiment with – you may be surprised what you uncover when reporting on your data in alternative ways!

The Author

Lucy Mazalon

Lucy is the Operations Director at Salesforce Ben. She is a 10x certified Marketing Champion and founder of The DRIP.

Leave a Reply