Salesforce (SFDC) Integration

Updated 3 months ago by Angelo Matheou

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:

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.

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


How did we do?