Managing Orphaned Contacts: Pardot Creates Salesforce Contacts Without Accounts

Share this article...

When a Prospect first syncs to Salesforce, the Pardot Salesforce Connector will create a Lead, which then continues through your organisation’s lead lifecycle. This is known as “Pardot Reverse Syncing”. In reality, this is not always suitable.

Some organisations don’t use the Lead object for a number of reasons – maybe you are one of them? The Pardot Salesforce Connector settings can be changed to create Contacts instead of Leads; while this may fit a specific Salesforce use case, it creates an additional challenge: ‘Orphaned’ Contacts.

What are Orphaned Contacts? What Happens when Pardot Reverse Syncing is Enabled?

When the Pardot Salesforce Connector is changed to create Contacts instead of Leads, which account will these Contacts be connected to?

Contacts can be created without being associated to an account. Extending the parent-child metaphor used when describing data relationships*, these Contacts without a ‘Parent’ can be described as orphaned.

*This Parent-Child relationship is Account = Parent, Contact = Child.

This happens because Pardot cannot create Accounts. Salesforce Accounts are synced to Pardot, and are called ‘Prospect Accounts’ – these are read-only, so Pardot cannot create, edit, or delete Prospect Accounts. This is why the Connector will send the contact to Salesforce and just hope for the best.

On a side note: we know that when the Connector creates Leads without a value in the ‘Company’ field, it appears as [[Unknown]].

How to Manage Orphaned Contacts

There’s the challenge: you will have many Contacts floating around your org without being properly connected to their correct account.

What’s even scarier, is that the go-to Contact report in Salesforce is the standard ‘Contacts and Accounts’. I’m going to call upon my friend, Stacy, who explained the ‘Contacts and Accounts’ report type limitations so well:

“What if you have Contacts where there is no Account? And I hear you! “But Stacy!” you say, “The Account field is required on the page layout, of course, the Account field is filled out on all Contacts!” But, are you really sure? You should probably run a report on the Contact object, where Accounts = Blank to check out your data. You may be surprised…

Oh wait – you can’t! There is no report for just the Contacts object, only Contacts & Accounts, or Contacts & something else! Oh, the horror!”

As seen in: 5 Salesforce Lead & Contact Hacks Every Admin Should Know

So, here are the steps you need to follow:

Step 1: Create Custom Report Type

The first step is to create the custom report type that will show Contacts.

Step 2: Create Salesforce Report

Create the Salesforce Report, and use a filter:

Account name — equals — [leave blank]

Add any other columns you may find useful, such as contact owner or created date.

Step 3: Schedule the Salesforce Report

You can schedule the Salesforce Report to be sent via email to users on a day and time you specify (note: you need to switch back to Salesforce Classic to do this). The right frequency for your situation will depend on the volume of new Contacts being created by your Pardot Salesforce Connector; for a moderate volume, you could perhaps have the report emailed to the Admin’s inbox once a week. That weekly task would involve manually associating the Orphaned Contacts to their account.

Bonus Tip: Capture Company

You can put preventative measures in place to help the situation. Ask for ‘Company’ on forms, so that Salesforce has something to match on; however, it’s not a fail-safe policy, because variations in the company name will put a wedge in the process running smoothly.

Summary

The reality is that many organisations don’t follow the standard Lead conversion process that Parodt is designed to handle, which means that enabling ‘reverse syncing’ is a good option to create Contacts instead of Leads. However, you need to have a process for managing the Orphaned Contacts, and be able to reunite them with the correct account. Of course, this solution requires ownership – for someone, likely your Salesforce Admin – to take charge of reuniting Orphaned Contacts to their Accounts. This is the advice I would give clients for managing this challenge in the long term.

One thought on “Managing Orphaned Contacts: Pardot Creates Salesforce Contacts Without Accounts

  1. Avatar

    This is SO handy. I have had this issue in the past and never thought to add a report type to identify them. Thank you!

Leave a Reply