How To Map Lookup Fields in Pardot

BY CELINE NEWSOME AND MIKE CREUZER 

Have you tried to map an important Salesforce field in Pardot, only to realize it’s not available in the Pardot field mapping dropdown list? Yeah, me too. The most common reason for this…It’s a dang lookup field in Salesforce, and Pardot doesn’t like lookup fields. 

If you’re wondering what a lookup field is, it’s when a field value is being sourced from another field or object.

Side note: User lookup fields are an exception here. Salesforce user lookup fields can be mapped to Pardot CRM User type fields.

If you’re still thinking you need that field in Pardot even though standard functionality won’t allow it, lucky for you, we have three solutions so you can still create and map the field you need in Pardot.

1. Create a Flow or Process Builder in Salesforce

This solution is great when you want to automatically trigger a record sync as field values change.

Step 1: Create a custom text field on the desired object in Salesforce

Step 2: Create criteria in Process Builder for the object of interest (see screenshot below)

Step 3: Define the criteria for the action group (see screenshot below)

Step 4. Create and map your new field in Pardot

Viola! Problem solved. 

2. Custom Formula Field

Formula Fields can grab any specific field in the lookup object and pull its data into a new field that you can map in Pardot.  A couple things to note about using a formula field as your solution:

  • This isn’t a great option when your lookup fields change frequently, because formula fields do not trigger a sync.
  • Avoid confusion when looking at another field on the object by making this field hidden for all users except the Pardot Connector User.

Step 1: Create a Lookup Field on your object of choice (Lead/Contact/Account)

Step 2: Create a new Formula Field on the same object

Step 3: Create a formula for “Insert Field” and pick the field on the Lookup Field object (see screenshot below)

Step 4: Save the formula

Step 5. Create and map your new field in Pardot

Viola, again! Another solution.

3. Custom Object

This could be the solution when you can’t use a default object, meaning you don’t have a one-to-one data relationship but you want to use complex filtering within Pardot. 

Custom Objects are available in Pardot Advanced Edition and Available for an additional cost in Pardot Plus Edition

For this solution we would be pulling in the ‘Individual’ Salesforce object into Pardot. Pardot can run automation around a custom object in your CRM that is not a Pardot default object. The custom object must be tied to a Pardot prospect record through a prospect ID. You can create and sync a custom object from any queryable object that is linked to a contact, lead, or account in your CRM.

Step 1: Create a Custom Object in Pardot (Custom Objects must be enabled in your account first)

Step 2: Use criteria in Pardot to pull the data in a list. To use this field as a custom object, we need to ‘relate’ the value back to the prospect. This is done with the “Prospect Custom Object” related with properties.

Step 3: Click Run Rules and use your list as you normally would.

And, there you have it, our final voila! 

Have you found another solution to map lookup fields into Pardot? Comment below and share.

Leave a Reply