Pardot Reporting & Proving Marketing Attribution Using Salesforce

One of the core reasons you purchased Pardot and Salesforce is to be able to have full visibility on the ROI of your different channels. To be able to show that X was spent on a particular channel and it generated Y is extremely useful when presenting to the C-suite and linking marketing activity with sales performance. Yet with so many channels, and prospects engaging with multiple different campaigns before converting, you would be right in thinking that revenue should be shared across multiple campaigns. A last touch attribution model is not insightful enough.

This is where marketing attribution using Salesforce and Pardot together is essential.

Before going into a little more detail into what that is and how you can use Pardot to set campaign attribution up, it’s important to understand the basics of how Pardot reporting works.

Pardot reporting

To use Pardot effectively, you need to ensure that data enters your data ‘ecosystem’ via Pardot first. There’s a number of reasons for this, mostly due to the way the reporting works. For example, if you input data into Salesforce first and assign to a user, Pardot will immediately think that prospect is an MQL and update the Lifecycle & Campaign Report to show the MQL generated. Furthermore, the velocity chart will be skewed as the average time from visitor to prospect to MQL will be completely wrong.

The below diagram I drew up shows the direction of travel for data and I talk about this in more detail on my other blog here.

The gist is that data will enter Pardot first as this is your filter and the first line of defence for data hygiene. If all prospects are vetted by Pardot first via a well thought out lead qualification criteria and subsequent automated lead assignment, then, in theory, Salesforce will naturally become a clean database full of genuine MQL’s/Leads and Contacts.

Once nurtured and qualified, the prospect will be assigned (MQL) and then synced to Salesforce. Sales will pick this up (depending on your process) and then an opportunity will be associated (SQL). This syncs back to Pardot and updates the values generated for that particular Pardot campaign and when the opportunity closes, ROI can be calculated.

Marketing Attribution Modelling

This is where things start to get a lot smarter. The above shows a basic ROI relationship where you’re looking at direct input (Pardot Campaign Cost) vs. output (Revenue) on a particular channel. An example being if you spend £10,000 on Google Ads, you check in on the report and can see a total Revenue figure from the Google Ads campaign as £20,000. Good job, the ROI is 100%. What about all of the other touchpoints?

Marketing attribution modelling enables you to use Pardot to track ROI on the source where the prospect was acquired. However, we want to be able to see how effective that whitepaper was or whether the event you attended made any impact, or perhaps you held a webinar and need to see if that’s impacting conversions.