BY MIKE CREUZER
As one of the chief “Pardot API Geeks” here at Sercante (no, it’s not a real title, but I think it really should be) I’m really excited about two big changes to the Pardot API – one of which was confirmed on this week’s Pardot Product Roadmap webinar.
Wait, you don’t know what you can do with the Pardot API? Then you must’ve missed this post. I’ll forgive you if you open it a new tab and read it later.
What’s New with the Pardot API
These two new methods open up new capabilities for large and small Pardot users alike. The great thing about them both is – GEEK TERM ALERT – they are asynchronous, which means we can start processing a job and let it work while the code goes on to do other things. This is really great because the computer doesn’t have to wait and do nothing else while large amounts of data are being processed. We can parallel process and REALLY get a lot done without wasting processing power.
The first Pardot API change is Prospect Import.
We saw the Prospect Import at the 2019 Pardot Developer Experience Dreamforce session I was proud to co-host with my fellow Sercante Dragon Mike Fazio. Documentation can be found here for v4 or v3. As for what it does…Think about how you might import thousands of Prospects into Pardot today. Then throw that out and imagine it happens in the background, automatically, with as many fields as you want mapping over. Every day. Without you having to touch it.
If you have an Enterprise Data Warehouse or some other external source where you are getting records from (HINT HINT a little operation called “Salesforce” fits that description as well) and you want to be able to have the computer send large numbers of Prospects into Pardot without needing a person to manually do the import, this is the feature for you.
So again, powerful stuff on its own, but let’s take it to the next level. Imagine these possibilities:
- On a regular basis, you could use code to clean up junk and normalize picklist field values – turn those “United States” or “U.S.” into US – all without touching Excel.
- You could use code to add some data from a vendor by API before sending the data into Pardot.
- And you could used code to fix every marketer’s Achilles Heel – those ALL CAP NAMES or all lower case names that show up randomly and without reason.
So Much Activity, so Little Time to Analyze
Now, the second API change will be a huge time saver as well. It involves Visitor Activity Export.
This will allow us to export ALL visitor activities a whole year at a time.
On the surface, you might wonder what you’d do with a year’s worth of data about how all your Prospects have been engaging with you. Think about…
- Exporting it all into a BI tool to get all the bar, pie, and line charts you’d ever want
- Export into a Analytics tool
- Export into a Enterprise Data Warehouse which can interface with your BI/analytics tool on a regular basis to give you tasty marketing activity dashboards
- Summarize into a spreadsheet (We do this with some of our Audits)
- Export into your own database so you can do SQL queries for ad-hoc reporting (if that’s your sort of thing)
So yeah, COOL STUFF.
According to the docs v4 and v3, the only filtering currently available is date. So if we want to grab just a certain type of activity, such as email opens, we are going to have to pull down the entire data-set and then do our own filtering for email opens. This may mean that what we currently have available to us won’t work with your destination BI or analytics tool if it can’t filter for you.
Now, a quick pause to elucidate via true geek-speak for those who want the In the Weeds version:
The new methods don’t appear to be included in many wrapper libraries yet, but we are working on getting these added to a few. One thing to note is that they no longer use just GET/POST variables but rather a ContentType: application/json and a body with the JSON string. Thus you may need to make some adjustments to your code if you plan on using these new methods.
A Bright Future Ahead for the Pardot API
Looking at how the documentation is structured for these changes, we are optimistic! We think we’re seeing a new pattern for Bulk API calls and can likely expect additional Pardot record types to be built to follow these two new patterns. That means we’ll be able to surface even more Pardot data in our external tools of choice, and therefore marketers can show the business how Marketing is really bringing in more leads and revenue.
What’s Your Pardot Data Challenge?
Like I said, Sercante (heart emoji) the Pardot API. If you’re seeing data quality challenges on a regular basis that you’re spending a lot of time on manually correcting, let us know in the comments! We may be able to save you some major time through the magical API world.