Skip to main content
Gainsight Inc.

Salesforce (SFDC) Integration

The Gainsight PX Salesforce Integration allows for copying data from Salesforce to Gainsight PX on the Account and User records. If a matching SFDC record is found for a given Gainsight PX record, then the chosen fields on the field mapping screen are copied from the Salesforce object to the matched Gainsight PX record.

Set Screen For Control Matching Logic

Displayed by clicking on the gear menu in the Salesforce Integration screen:

Matching Logic.png

Account Match Scenario

For all Gainsight PX account records:

  1. If account has been matched before and the account.sfdcId field matches the id that was matched previously, then
    • Gainsight PX will retain the previous match, skip remaining matching logic
  2. Otherwise:
    • The integration will find the SFDC account that matches the "best" by applying a weighted value to how well it matches on the criteria that are selected in the SFDC integration screen in the application.

If there are multiple SFDC accounts that match, the account with highest cumulative score is considered a match.

Matching Type Logic Weight Notes
sfdcId to Salesforce ID account.sfdcId equal to sfdcAccount.id 2.0  
Custom Field Matching Matching value in the two given fields 2.0 Fields must be of the same type, only strings and integral (whole number) numerics are supported.
Website Domain account.website domain equal to sfdcAccount.website domain 1.0  
Name account.name equal to sfdcAccount.name 1.0  
Recent user domain user.email domain equal to sfdcAccount.website domain 1.0 Retrieves 100 most recently seen users and extracts they domains from their email addresses.  If there is a mixture of email domains, the score is weighted by the portion of the users that have the same domain.

Contact Match Scenario

For all Gainsight PX user records

  1. If contact has been matched before and the user.sfdcContactId matches the id that was matched previously:
    • Gainsight PX will retain the previous match, skip remaining matching logic
  2. Otherwise:

Find the first matching contact by iterating through the matching criteria that are selected in the SFDC integration screen.  The first contact found that matches is chosen. 

The matching is done in the following order:

Matching Type Logic Notes
sfdcContactId to Salesforce Contact ID user.sfdcContactID equal to contact.id  
Custom Field Matching Matching value in the two given fields Fields must be of the same type, only strings and integral (whole number) numerics are supported.
Email user.email equal to contact.email If more than one matching email on SFDC, not considered a match
Phone user.phone equal to contact.phone If more than one matching phone on SFDC, not considered a match

Field Mapping

The field mapping allows you to map the field(s) in SFDC that you want to push to Gainsight PX.

Mapped Fields.png

Here are the supported field types:

-----------------

DATE_TIME types in PX can map to the following field types in SFDC
DATE, DATETIME, TIME
STRING types in PX can map to the following field types in SFDC
STRING, TEXTAREA, PICKLIST, MULTIPICKLIST, COMBOBOX, EMAIL, URL, ID, PHONE
NUMBER types in PX can map to the following field types in SFDC
INT, DOUBLE, PERCENT, CURRENCY
BOOLEAN types in PX can map to the following field types in SFDC
BOOLEAN

  • Was this article helpful?