How to map data between HubSpot and Salesforce if the field already exists in HubSpot

Date Published: 09/11/2012
Author: Samuel Siskind

Overview

Mapping HubSpot properties to Salesforce fields requires just a few minutes of setup. We automatically create several mappings for you when the connector is installed, but there are circumstances where you would need to create a custom field mapping in the HubSpot - Salesforce Integration settings to map additional HubSpot properties or custom properties.

A. A field does not exist in HubSpot or Salesforce for the data.
B. A field that exists in HubSpot, but not in Salesforce.
C. A field that exists in Salesforce, but not in HubSpot.

Here is a list of the properties and fields that are mapped by default when you install the integration.

First Name
Last Name
Email
Company Name
Phone number
Salutation
Fax Number
Street Address
City
State/Region
Postal Code
Country
Job Title
Industry
Website URL
Email Opt Out is mapped to the standard hasoptedoutofemail field.
Description
Annual Revenue
Mobile Phone

Follow the steps in this guide to learn how to map additional property and field data for each alternative circumstance.

The most common fields that customers create based on HubSpot data are fields to sync with Analytics data contact properties. They can then build reports and lead views that use HubSpot analytics data in conjunction with Salesforce data.

 

A. A field does not exist in HubSpot or Salesforce for the data

If you would like to start capturing a new piece of information about your leads, and want that data to be shared across HubSpot and Salesforce then you should follow these instructions.

B. A field that exists in HubSpot, but not in Salesforce

If you are already capturing a piece of information about your leads in HubSpot that you want to be shared with Salesforce then you should follow these instructions.

1. Get the property key for the contact property

Go to Contacts > Contacts Settings.

User-added image


Scroll down on the Manage Contact Properties screen until you find the property you want to map to Salesforce and copy down its property key. In this example, the property key is birthyear.

52f42d90-99d2-41ac-bf4e-6400a9f38a9f.png


2. Create the field in Salesforce

Login to Salesforce and go to Setup.

2. Create the field in Salesforce

Go to Customize > leads > Fields

e1874be4-9108-40e0-a97f-ba1f42d9a22b.png

Click on the New button next to Lead Custom Fields & Relationships.

0898c9c9-1479-448c-b731-a8bc9ee81652.png

Choose the field type that best matches the HubSpot property type that you created. In this example, that would be a number field.

db279665-e18a-42d8-b6fa-226f989455d4.png

Click the Next button.

eaa7552a-7a9d-46b1-b396-e40cb7c60de4.png

Enter a field label for the Salesforce field that is similar or the same as your HubSpot contact property. In this example, we name the field Birth year again.

591e2195-954a-4938-80b6-b556f67b26b5.png

Click Next to continue creating the Salesforce field.

5ac7557b-ed1f-406f-8d78-f678799e6bcc.png

Choose the Salesforce profiles that can see this field. In most cases, you would want all profiles to be able to see this field.

c71a0a19-fa38-429d-a826-82aff158f5fd.png

Click Next to continue creating the Salesforce field.

0eee41eb-7c56-401e-89d2-ad2314ce0d8c.png

Add the field to your Lead Page Layouts so you can see the mapped data on Lead Pages.

886b4dd7-b78e-4e44-8e53-20df33ad1a20.png

Click the Save button to finish creating the Salesforce field.

3e829fe8-d7a6-44cc-bce1-8cc6a6507754.png


3. Create the field mapping

Go to the HubSpot section of Salesforce

3. Create the field mapping

Click on the HubSpot Settings tab. If that option is not in the top navigation click on the + link to select it from your full list of tabs.

827d33e6-6ba4-4bf6-b294-9d2ac5f48a0c.png

Click on the Go button.

28c51358-8dcb-42f6-bfe5-56c0fe23fdd5.png

Click on the HS-0000 object link.

84ebaa86-d18b-4f28-9e3c-1f9211790953.png

Click on the Sync Fields button under HubSpot Commands.

79486b19-f01a-452e-9cce-a49a9e7b0b8e.png

Scroll down to the HubSpot Fields section and click on the link to Go to List.

ef14bed9-c85c-4303-b2fe-29c6522541ba.png

Scroll down the page until you find the field mapping for your new Salesforce lead field and then click on the Edit Link.

36c74160-169b-41c3-be36-4e0f9f76a70c.png

The Force.com Field Name should already be set properly, but you'll need to enter the property key you saved from step 2 into the HubSpot Field Name input. The Allow HubSpot Updates picklist should be set to Always update so that Salesforce always has the most recent information from HubSpot. The Field Format in this example is DOUBLE since the property and field are both number fields. The Custom Field checkbox is checked off because this a custom HubSpot and Salesforce field.

Other Field Format options:

  • For text fields use STRING
  • For text areas use TEXTAREA
  • For dropdowns use PICKLIST
  • For phone numbers use PHONE
  • For email addresses use EMAIL
  • For URL's use URL
  • For checkboxes use BOOLEAN

When you are done editing the field mapping, click the Save button.

8c0462ec-9f37-4c54-99f0-f47f903d484d.png


C. A field that exists in Salesforce, but not in HubSpot

If you are already capturing a piece of information about your leads in Salesforce that you want to be shared with HubSpot then you should follow these instructions.

Note: Formula and Lookup fields in Salesforce cannot be mapped between HubSpot and Salesforce.


Was the content and structure of this article helpful? (If you are running into an issue in your account or have a specific question about your setup, please contact our Support team.)  Yes  No