Salesforce: Automatic Customer Data Import
The Automatic Customer Data Import is our fancy name for how you can sync information from Salesforce into the AdvocateHub. This information can then be used for segmentation inside of your AdvocateHub.
You can pull this Salesforce information for any advocates who exist in your Salesforce as contacts, and it will stay updated with a nightly sync.
This article will walk through setting this feature up. To be able to do this, you'll have to have first installed our AppExchange Package in Salesforce. If you haven't done this yet, this Installation Guide will be a huge help!
There are 4 parts to this process:
Creating Custom Profile Fields
To begin, you must create a Custom Profile Field which will represent the Salesforce field you want to pull information from. These will be displayed as a "Custom Profile Field" field in an advocates profile (visible to administrators only). You'll then be able to target things in the hub based on this information.
To add Custom Profile Fields, follow these steps (see screenshot below):
- Go to Settings > System > Custom Profile Fields.
- Click Add Custom Profile Field.
- Name the Custom Profile Field (does not have to be the same as the SFDC field you'll match it to). For example: Demographic
- Click Save.
Note: Our toolbar layout changed! The instructions in these mini videos are still accurate, but you'll notice the old toolbar displayed at the top. In addition, at the very beginning, accessing Settings is different. Instead, click on the cog wheel and select Settings:
Mapping Salesforce Fields to your Custom Profile
- Go to Integrations > Manage (Salesforce) > Settings tab > Automatic Customer Data Import.
- Click on + Add Mapping.
- In the left drop-down menu, choose one of the new Custom Profile Fields you made.
- Continuing with the previous example, we'll select: Contact - Industry
- In the right drop-down menu, choose the appropriate Salesforce field that will sync to this AdvocateHub Custom Profile Field.
- In our own Salesforce instance, we track industry on the Account, so we will select: Account - Industry
- Create any additional mappings for Custom Profile Fields you've created and would like to segment by, and then Save.
- (Optional) If you would like to add additional custom fields, you may watch this Salesforce tutorial.
Adding a Query to Trigger the Data SyncBack to top
AdvocateHub__Date_Added_To_AdvocateHub__c != null
2. (Optional) If you want to automatically invite advocates through Salesforce, tick the optional checkbox. This box is used to invite new advocates into the hub based on the query above it. If you keep the query as is and tick this box, you can manually add a date to Salesforce contacts as a way to automatically invite them to the hub.
The other way you can use this checkbox is by creating another field on Salesforce contacts as a way to invite many Salesforce contacts at once. Here's one example of one way you could use this:
- You can create a custom field in Salesforce called "Invited to AdvocateHub" and make it a checkbox field.
- You enter a query that looks something like this into step 1: "Contact.Invited_to_AdvocateHub__c = True" (this would mean the import works only for SFDC contacts who have previously been invited to the Hub).
- You update Salesforce contacts you want to invite by adding a check-mark to this new Salesforce field.
- Click Save.
Testing it out
To confirm everything is set up correctly, you can manually trigger a sync to confirm data is flowing from Salesforce correctly.
- Click Run Import Now (this will start a sync between the AdvocateHub and Salesforce to update all advocates who are matched up with Salesforce contacts).
- Wait a few minutes, and refresh the page. Continue to refresh until you see the text above the Import button show Import Complete as of the current date and time. (The more Advocates you have in your hub, the longer the sync will take to finish)
- When the sync is completed, go to your Advocates page, find an advocate who exists in Salesforce. Click on the pencil icon beside their name and click Edit.
- Click on the Custom Profile Field tab.
You should now see the fields you just added filled in with data. If all the fields are now populated, it was a success!
Continuing from our example where we mapped Industry, we can see the sync worked correctly!
Note: Please note that for Name, Email, Title and Company fields, data from Salesforce will be pulled on the first import only and not subsequent updates, so that changes to these fields made by your members will not be overwritten.
Note: Please note that if the Salesforce Contact record does not have an email address then they will NOT be imported. If you have duplicate Contact records with the same email addreess in Salesforce, only the first one will be imported.