Pardot Reporting: How To Justify Your Marketing Spend

MarCloud Apple iPad retina favicon

Pardot Reporting   •   Campaign Management

The goal for any marketer is to be able to build marketing campaigns, track performance and show leads generated as a direct result of marketing to the rest of the business. In doing so, it justifies marketing spend and helps the team obtain more budget for future marketing campaigns as ROI has clearly been demonstrated.

Pardot reporting empowers the marketing team by automatically updating these key reports, which is pretty useful because exporting stats and creating reports in Excel/Google Sheets is such a ball-ache!

Using the reporting in Pardot isn’t just a massive time saver, it is a living and breathing part of the system that updates in real time which means you can be confident that the stats you bring into your meetings are completely up to date.

How do Pardot campaigns work?

Cost

It all begins with a new campaign. An often overlooked part of this campaign creation is the ‘Cost’ option. Here, you should input the campaign budget (you can always come back and reduce this once the campaign spending has stopped, to update the real figure). This is important because this lets Pardot figure out the cost per prospect, cost per opportunity and ROI % of the campaign.

Tip: A campaign in Pardot should be created when you want to track the performance of a new thematic touchpoint. For example, an event you attend would have it’s own campaign created as there will be emails, lists, landing pages, forms and other assets linked to this event/campaign.

Tracking code

Once the campaign is created, it will generate a campaign tracking code which you can place on your website or 3rd party landing page. You’ll want to add this tracking code to pages that you’re promoting through paid ads, events, direct mail and any other offline marketing. For example, you might want to track how many new prospects each salesperson has found by setting up landing pages with a unique tracking code on each and having a unique URL on their business cards. Campaign ‘Tom Ryan Business Cards’ could be set up and so on.

For landing pages hosted within Pardot, you do not need to add the tracking code as Pardot will automatically add this when you assign the landing page to the campaign in the editor.

Creating/assigning assets to the campaign

I mentioned this above and if you’ve ever created an asset in Pardot, you’ll know that you need to assign all assets to a campaign. It’s a compulsory setting for a reason, it let’s Pardot know where to attribute ROI. If a brand new prospect views your landing page from an event 6 months ago and then converts today, you can attribute the value back to the event and make a data driven decision as to whether you should attend next year.

Understanding Visitors, Prospects, MQL’s, SQL’s and won deals

To learn more about the terminology in the Pardot reports, check out our quick reference Pardot terminology infographic (If anyone has a better/shorter/cooler name for this, please send me your suggestion).

Synchronisation with Salesforce Opportunities

The best part about all of this closed loop Pardot reporting is the integration with Salesforce opportunities. Once an opportunity is created and subsequently closed won, this updated the ROI figures and campaign stats. Remember you updated the cost of the campaign? This is where it ties in.

Important: To tell Pardot which prospect is assigned to the opportunity, you need to update the contact role in the opportunity. This then updates the reporting in Pardot, attributing the opportunity back to the prospect record.

What will the Pardot reports show me?

Lifecycle report

If you haven’t got the lifecycle report working yet, it’s something to add to the priority list. The information this report tells you is invaluable and helps you to easily inform senior management on how things are going from a marketing perspective. It will show you your marketing funnel and gives you a strong idea of your current pipeline. On the right-hand side, the velocity chart gives an indication as to the time it takes to go from prospect to a won deal which really helps you to plan your future campaigns!

Pardot lifecycle report

Campaign reporting

When you head to Reports > Campaigns, it will give you an overview of all of the campaigns you’ve created including the campaign performance graph. This gives you a visual aid so you can see at a glance what campaigns are most successful, where most of the budget is going and where to focus your attention. This graph is interactive to play around with the dropdowns and sliders to familiarise yourself with the tool and to get the exact report that you want.

Pardot campaign reporting

Underneath the graph you’ll be able to see each campaign and these stats:

  • Number of visitors
  • Prospects
  • Assigned prospects
  • Cost per prospect
  • Opportunities
  • Number of opportunities vs Prospects %
  • Cost per opportunity
  • Total value
  • Revenue
  • ROI %

Pardot Campaign report stats

When you click on the campaign you can then see all prospects who are associated with the campaign.

Questions?

You may have questions or ideas about Pardot reporting after reading this. If you do and want to talk about them, send a message using the button below.

Ask a question
Tom Ryan Pardot Consultant
Connect with me on LinkedIn
By |2018-06-26T04:46:48+00:00January 25th, 2018|Campaign Management|

About the Author:

Tom is a is a Salesforce Certified Pardot Consultant and has a passion for all things marketing automation. He's written blogs for Pardot.com and MarketingProfs.com, featured in a Pardot e-book and hosted a webinar with Pardot on custom form templates and landing pages.

2 Comments

  1. Neeraj Singg April 16, 2018 at 8:15 pm - Reply

    Hi Tom
    Can we get Prospects Lifecycle Report via API. We have scenarios where we need data as JSON for Lifecycle report specially Funnel data. Any help or guidance would be great for me. Thank You : )

    • Tom Ryan April 17, 2018 at 8:15 am - Reply

      Hi Neeraj,

      As far as I am aware, there isn’t a way to do this via API without the consent of Pardot themselves. I’m sure if you had a specific case and got in touch with the Pardot technical team then they would be able to advise on the best approach here but from the knowledge that I have as a technical marketer, I’m unaware of an approach to extract and manipulate the lifecycle report data.

      I hope this helps,

      Tom

Leave A Comment