top of page

How to Force Sync your Entire Pardot Database the Quick and Easy Way


One basic behavior of the Pardot/Salesforce databases is that the only way a record will sync is if there is a change to that record on one side or the other.

Occasionally there will be times when you want to sync all your Pardot records to make sure everything is caught up between the two systems. This can happen when you've had user assignment issues to clean up, when you want to make sure that salesforce campaign data is in sync (campaigns won't sync member status changed on the salesforce side if there's no change to a lead or contact record), or if you've made a change to a Pardot value that doesn't automatically offer a "sync the entire database" option, such as changing a pre-existing value in a dropdown list.


"Since there's no button to press to sync your entire Pardot and Salesforce database, there are limited options to do this." That's what I wrote when I originally published this article...but since then, a new button has appeared!


You can find this button in the Salesforce connector under the gear icon, there's a new option called Sync All Prospects.


This is only available to Account Engagement (Pardot) Administrator roles, and can only be done once a day.




The remainder of this article is pretty much out of date due to this change, but I'm leaving it in place because of the extra informative bits that may still be of use or interest to the general user community.


One is to export the entire Pardot database and import it again, simply by importing the email field as the only imported field. This will force a sync. However, with the advent of allowing multiple records with the same email address, and the ability to match by CRM ID instead, simply importing by email address could miss records, and personally I find exporting and re-importing using CRM ID's to be tedious since you can only do it if all your records have the ID, and the ID's a in different columns on the export, forcing you to edit the exported file before you import it. Not exactly quick and easy.


Here's a quick and easy method to do a full sync of the database without importing

The best part of this method is once you create it, it will be at the ready for the next time you need to sync the database again.

  1. Create a custom field in Pardot with the type "number" called "~Force Sync". You do not have to match this field to any Salesforce fields, in fact, it's better if it's not. Adding the tilde ~ to the name makes it show up at the bottom of all your other custom fields where it's out of the way.

  2. Create an automation rule for every record where the email address contains @ to increment the ~Force Sync field by 1, and run it.



Result: This will force the entire database to sync since you just changed a record value on every record in Pardot. It doesn't matter that this field isn't synched to Salesforce, it will still sync. And don't worry, it will not create new Salesforce records if they didn't exist before.


That's it!


Once the rule has run and the entire database has synched (give it time, it could take a while), just pause this automation. If you need to sync the database again, just clone the rule and run it again. You must do this because a non-repeating automation rule will only run once, and don't recommend making this a repeating rule, because you don't want to accidentally keep syncing the whole database over and over.


This method also produces an ongoing count of how many times you've used it, as the ~Force Sync field will tick up by 1 on all of your records every time you use it (check an old record that existed before you ran this rule for the first time for the most accurate total count).


2,157 views

4 Comments


Nicholas Loporto
Nicholas Loporto
Jul 12, 2023

This is still valid if your database is too large to run 'Sync all Prospects'. Thanks for this!

Like

adam
adam
Aug 27, 2021

That's a great option — especially for accounts that are not on v2 Connector!


Another super quick and easy option for folks using v2 Connector:

  • Edit any Prospect field that is syncing with Salesforce

  • Add or Remove a random tag

  • Click Save, then "Sync Prospects" when prompted


Just adding or removing a tag will prompt that option to trigger a full sync!

Like
adam
adam
Sep 30, 2021
Replying to

One more thing worth mentioning: anytime you push a sync (whether via automation rules or "Queue Full Sync"), it updates the "Last Updated Date" on *every* Prospect.


"Last Updated Date" is often used to determine the most relevant record — e.g. when there are duplicate records with same email address and a Prospect submits a form, or is imported using email to match, or when duplicates are merged. If they all have the same updated date, this becomes a less reliable measure of relevance.


So whenever possible, I think it's better to use automation like Bill describes, but set criteria to match only those who are necessary to sync. But sometimes that's not possible (e.g. when the criteria you'd want…

Like

Jaime
Jaime
Aug 27, 2021

Nice one! thanks for sharing

Like
*As of April 2022, Pardot has been renamed Marketing Cloud Account Engagement, as part of Salesforce's effort to organize all the marketing products under the same platform umbrella. "MCAE" is simply the same Pardot we know and love under a new name. The product is temporarily being referred to as "Marketing Cloud Account Engagement powered by Pardot."   

Did you find this article useful?  Buy me a coffee. 🙂

Want more tips? Subscribe and be the first to know of new coffee-worthy content.

Thanks for Subscribing!

Need some help?

Consultations offered on a pay-as-you-go basis by the hour.  Buy hours below and I will schedule a session at your convenience.

bottom of page