Salesforce

Salesforce provides solutions that help unify marketing, sales, commerce, IT, and service. This Salesforce V2 integration lets you create group-level properties from Salesforce data by setting specific Salesforce fields as group-level properties and importing that into Amplitude. This can be useful when analyzing information about accounts that exist in Salesforce.

Overview

By default, Amplitude has a built-in process that runs once a day to update group properties that have pickup dates matching the current date. Additionally, the integration offers the option of an hourly schedule if you prefer more frequent updates with finer granularity.

Mapping at a high level

Salesforce structures objects like accounts as tables, where each field represents a column. Amplitude imports data from Salesforce using a predefined schema mapping, which establishes a connection between Salesforce objects and Amplitude groups. Amplitude transforms each row of a into a group under a certain group type in an Amplitude project. There are 3 key concepts that together form a valid mapping:

Relation: defines which Salesforce object maps to which Amplitude group type
Group Name Field: a column of the table to use as the group identifier. Typically this column should identify a row in the table uniquely
Group Properties: a list of columns for Amplitude to import.

Detailed setup instruction

Part 1: Set up account-level reporting

Verify that you have account-level reporting set up in Amplitude.

Part 2: Grant Amplitude access to your Salesforce data

In Amplitude Data, navigate to Data Sources.
Select the Salesforce V2 tile.
To begin the authentication process, click Connect to. Once authenticated, Amplitude displays a valid email address associated with your Salesforce account.
Click on Next located at the top right corner to continue with the mapping setup.

Part 3: Mapping Setup

Review your mapping setup option
- Sync Cadence: This control the cadence of the sync job.
- Copy config: This allows you to copy the existing mapping config to the clipboard
- Export config: This downloads the current mapping config to your local machine (as a JSON file). This is useful when you want to recover a connection from the previous mapping config.
- Import config: This loads in the config file from the local machine and populates the UI.
To create a new mapping, click Set up new group mapping. This should populate a new mapping section. Inside the section, fill in the following parts:
- Relation (SFDC object to Amplitude Group Type)
- Group Name Field (SFDC field that uniquely identifies a group/row)
Once you finish the above settings, click Group Property Mapping to define a list of Salesforce fields which you want to import into Amplitude as Group Properties.
Note
To ensure the data quality, Amplitude performs various validations on the fly, this includes:
- Ensuring all required fields complete
- Ensuring a one-to-one relationship between SFDC field and Amplitude Group Property to avoid values being overwritten by each other.
The setup page displays the current validation failures, and prevents proceeding until you address them.
After you finish defining the mapping and all validations pass, click on the Next button to move forward with the final verification process.
Once the final verification passes, click the Save button to establish the connection. The established connection is available in the Source page with the name “Salesforce V2”.
If needed, you can easily update the mapping configuration at any time by locating the connection on the Source page and clicking on it. This allows you to make changes to the mapping setup for the Salesforce integration.