How to Clear a Dedupliction Error from the Sync Queue (and stop it from happening)
- April 21, 2022
- Pardot Admin, Unfettered Marketing
The Pardot-Salesforce Connector Sync Queue is one of those things that a good admin knows to check regularly, and one of those things that, maddeningly, has no way of sending you a proactive alert that there’s something “stuck” in it.
One of the most common reasons that something gets stuck is that the Salesforce duplication rules are in place and it’s sending an “alert” that there is a potential duplicate. This alert reads:
This prospect has a sync error: You’re creating a duplicate record. We recommend you use an existing record instead.
Now, Pardot (MCAE*) will not typically create a duplicate record with the same email address, so the most typical reason for this rule to fire is someone using the same name but a different email address, or, depending on how the duplication rules are set up, it could simply be a lead that likely matches an account being enough to set it off. This “alert” to a regular user is in the form of a popup message on creation that asks you if you’re sure you want to create a record, because it might be a duplicate.
The problem is that while a regular user can say “I’m sure, go ahead and create the record,” and push the override button. the connector user cannot do this, and so the record gets stuck in the sync queue.
How do you fix this sync problem? You have to allow the connector user to ignore the deduplication rules.
This is one reason why having a dedicated Pardot connector user– the “free” B2BMA Integration user is ideal for this, since it has no other purpose other than syncing with Pardot. If you aren’t using the B2BMA user, and your connector user is a “real” user, then there are of course consequences for alllowing the duplicate rules to be ignored.
The process for overriding the duplicate rules is pretty simple. You really only need to it for leads, since if Pardot is going to create something, it’s going to create a lead♦. Essentially you are going to create an exception to the standard lead duplicate rule that says it only applies to usernames that that ARE NOT equal to the connector’s username. In the example below I inserted the B2BMA Integration’s username, which you can find in the users section of Salesforce settings.
Once this is in place, if you have a lot of sync errors from deduplication rules, you can do a mass-resync of the sync queue by selecting mupliple (or all) records and choosing “resync prospects” from the dropdown at the bottom of the sync queue page. All those leads should now push into Salesforce, and going forward, this type of sync error won’t be an issue.
Incidentally, this same strategy can be used to prevent failures on creating records with web to lead as well. This problem is a lot harder to “see” because you’re unlikely to get any indication at all that the submission failed. However, the standard ‘create’ user on web to lead is usually an real user, so once again, you are creating a situation where that user is immune to the duplication rules.
♦ In certain circumstances you might want Pardot/MCAE to only create contacts (if your org does not use leads). This is possible, and can be enabled by contacting support.
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-clear-a-dedupliction-error-from-the-sync-queue
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) (8)
- Business Units (13)
- ChatGPT / AI (3)
- Completion Actions (5)
- Connectors (10)
- Custom Redirects (4)
- Demand Generation (8)
- Dynamic Content (5)
- Einstein Features (11)
- Email Delivery (18)
- 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 (14)
- Industries (1)
- Non Profit (1)
- Landing Pages (10)
- Lead Generation (1)
- Lead Management (12)
- Lead Routing (2)
- Lead Scoring (15)
- Leads (3)
- Marketing Analytics – B2BMA (9)
- Marketing Automation (1)
- Marketing Cloud (2)
- Marketing Cloud Account Engagement (4)
- New Pardot Features (6)
- Opportunities (2)
- Optimization (3)
- 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 (7)
- Pardot Email Templates (9)
- HML (6)
- Pardot Events (16)
- Pardot External Actions (1)
- Pardot External Activities (4)
- Pardot Forms (27)
- Form Handlers (7)
- Pardot Integrations (21)
- 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 (19)
- Pardot Sandboxes (2)
- Pardot Segmentation (4)
- 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 (22)
- Salesforce and Pardot (29)
- 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 (483)
- Cheshire Impact (9)
- Greenkey Digital (47)
- Invado Solutions (37)
- Jenna Molby (9)
- Marcloud Consulting (6)
- Nebula Consulting (53)
- Pardot Geeks (38)
- Salesforce Ben | The Drip (235)
- SalesLabX (2)
- Slalom (2)
- 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-clear-a-dedupliction-error-from-the-sync-queue
Find more great Pardot articles at https://www.unfetteredmarketing.com/blog