How to Force Sync your Entire Pardot Database the Quick and Easy Way
- August 27, 2021
- Pardot Sync, Unfettered Marketing
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.
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.
- 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.
- 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).
This Pardot article written by:Â Bill Fetter
Unfettered Marketing
A collection of random thoughts on how people, places and things in our fascinating world connect to sales and marketing, and what we can learn from it.
Original Pardot Article: https://www.unfetteredmarketing.com/post/how-to-force-sync-your-entire-pardot-database-the-quick-and-easy-way
Find more great Pardot articles at https://www.unfetteredmarketing.com/blog
Pardot Experts Blog
We have categorized all the different Pardot articles by topics.
Pardot Topic Categories
- Account Based Marketing (ABM) (7)
- Business Units (14)
- ChatGPT / AI (3)
- Completion Actions (5)
- Connectors (10)
- Custom Redirects (4)
- Data Cloud (1)
- Demand Generation (8)
- Dynamic Content (6)
- Einstein Features (12)
- Email Delivery (17)
- Email Open Rates (3)
- Pardot A/B Testing (2)
- Email Mailability (16)
- Do Not Email (1)
- Double Opt-in (2)
- Opt Out / Unsubscribe (14)
- Email Preferences Page (6)
- Engagement Studio (16)
- Industries (1)
- Non Profit (1)
- Landing Pages (9)
- Lead Generation (1)
- Lead Management (13)
- Lead Routing (3)
- Lead Scoring (16)
- Leads (3)
- Marketing Analytics – B2BMA (9)
- Marketing Automation (1)
- Marketing Cloud (3)
- Marketing Cloud Account Engagement (4)
- Marketing Cloud Growth (1)
- New Pardot Features (6)
- Opportunities (2)
- Optimization (2)
- Pardot Admin (62)
- Duplicates (1)
- Marketing Ops (1)
- Pardot Alerts (1)
- Pardot API (2)
- Pardot Automations (3)
- Pardot Careers (12)
- Pardot Certifications (4)
- Pardot Consulting (1)
- Pardot Cookies (3)
- Pardot Custom Objects (3)
- Pardot Email Builder (8)
- Pardot Email Templates (9)
- HML (6)
- Pardot Events (16)
- Pardot External Actions (1)
- Pardot External Activities (4)
- Pardot Forms (29)
- Form Handlers (8)
- Pardot Integrations (20)
- Data Cloud (1)
- Slack (1)
- Pardot Lead Grading (5)
- Pardot Lead Source (2)
- Pardot Lightning (1)
- Pardot Migration (1)
- Pardot Nurture / Drip Campaigns (1)
- Pardot Personalization (3)
- Pardot Profiles (1)
- Pardot Releases (18)
- Pardot Sandboxes (2)
- Pardot Segmentation (5)
- Pardot Strategy (7)
- Pardot Sync (2)
- Pardot Sync Errors (1)
- Pardot Tracker Domains (5)
- Pardot Training (3)
- Pardot Vs Other MAPs (4)
- Pardot Website Tracking (2)
- Reporting (21)
- Salesforce and Pardot (31)
- Marketing Data Sharing (2)
- Pardot Users (3)
- Salesforce Automation (4)
- Salesforce Flows (1)
- Salesforce Campaigns (20)
- Salesforce CRM (3)
- Record Types (1)
- Salesforce Engage (3)
- Salesforce Queues (2)
- Security and Privacy (1)
- Tags (3)
- The Authors (497)
- Cheshire Impact (9)
- Greenkey Digital (50)
- Invado Solutions (37)
- Jenna Molby (9)
- Marcloud Consulting (6)
- Nebula Consulting (58)
- Pardot Geeks (42)
- Salesforce Ben | The Drip (235)
- SalesLabX (2)
- Slalom (4)
- Unfettered Marketing (45)
- Uncategorized (1)
- Website Tracking (2)
- Website Search (1)
More Pardot Articles
See all posts
This Pardot article written by:Â Bill Fetter
Unfettered Marketing
A collection of random thoughts on how people, places and things in our fascinating world connect to sales and marketing, and what we can learn from it.
Original Pardot Article: https://www.unfetteredmarketing.com/post/how-to-force-sync-your-entire-pardot-database-the-quick-and-easy-way
Find more great Pardot articles at https://www.unfetteredmarketing.com/blog