Pardot Knowledge Base

How do Pardot default fields map to SugarCRM?

Last Updated: Apr 26, 2016 | Print this Article


The following field mappings for individual records (prospects and leads/contacts) and accounts are set up automatically when you verify your SugarCRM connector.  By default, SugarCRM will be the master for all of these fields except for the proprietary Pardot fields (score, grade, Pardot campaign, etc.), referrer fields, and Google Analytics fields created when you install the connector package. However, you can choose to make Pardot the master for most other fields and change most of the default mappings if you’d like (exclusions are indicated below).  Please see our Default Fields article for more information.

Default Prospect Field Mapping

Pardot Default Field Sugar Field
First Name First Name
Last Name Last Name
Email¹ Email1
Company¹ Account Name
Campaign¹ Pardot Campaign (pi_campaign_c)
Score¹ Pardot Score (pi_score_c)
Grade¹ Pardot Grade (pi_grade_c)
Assigned User¹ Assigned User
Notes¹ Pardot Notes (pi_notes_c)
Recent Interaction --
First Activity (from Prospect Activities section)¹ Pardot First Activity
Last Activity (from Prospect Activities section)¹ Pardot Last Activity
Website (Only when creating new leads) SugarCRM v6 or higher: Website Older versions of SugarCRM: Description
Job Title Title
Department Department
Country Primary Address Country
Address One Primary Address Street
Address Two Primary Address Street
City Primary Address City
State Primary Address State
Territory --
Zip Primary Address PostalCode
Phone PhoneWork
Fax PhoneFax
Source LeadSource
Annual Revenue --
Employees --
Industry --
Do Not Email Pardot Removed from All Emails (pi_do_not_email_c)
Do Not Call --
Years in Business --
Comments¹ Pardot Comments (pi_comments_c)
Salutation Salutation
Prospect Opted Out¹ Pardot Opt Out (pi_opt_out_c)
Created At¹ Pardot Created Date
Last Activity (from Prospect Activities section)¹ Pardot Last Activity
Prospect Referrer¹ Pardot First Referrer
Prospect Referrer Query¹ Pardot First Referrer Query
Prospect Referrer Type¹ Pardot First Referrer Type
Google Analytics Campaign¹ ² Google Analytics Campaign
Google Analytics Medium¹ ² Google Analytics Medium
Google Analytics Source¹ ² Google Analytics Source
Google Analytics Content¹ ² Google Analytics Content
Google Analytics Term¹ ² Google Analytics Term
¹Pardot’s proprietary fields (Pardot Campaign, Score, Grade, etc.), the referrer fields, Prospect Opted Out, and the Google Analytics Connector fields map to SugarCRM fields that are read-only; thus, they are the only non-custom fields that are considered the master over SugarCRM fields by default and cannot be remapped to sync with other fields in SugarCRM. The Assigned User, Recent Interaction, and Email fields also cannot be edited to make Pardot the master or remapped to another field in SugarCRM. ²The Google Analytics fields are included in the installer package, but will only display on prospects if the Google Analytics Connector is verified in Pardot.

Default Account Field Mapping

Pardot Account Field SugarCRM Account Field
Annual Revenue annual_revenue
Billing Address One billing_address_street
Billing Address Two  --
Billing City billing_address_city
Billing Country billing_address_country
Billing State billing_address_state
Billing Zip billing_address_postalcode
Description description
Fax phone_fax
Industry industry
Name name
Number  --
Number of Employees employees
Ownership ownership
Phone phone_office
Rating rating
Shipping Address One shipping_address_street
Shipping Address Two  --
Shipping City shipping_address_city
Shipping Country shipping_address_country
Shipping State shipping_address_state
Shipping Zip shipping_address_postalcode
SIC Code sic_code
Site  --
Ticker Symbol ticker_symbol
Type account_type
Website website

Need more? Start a conversation with other Pardot users in our Success Community