Setting the Signal Vine Customer ID as the Salesforce Contact ID

This article is for you if you already have contacts in Signal Vine, but are now setting up a Salesforce integration and want to change your data source for those contacts. The Salesforce sync will only work for contacts whose customer_ids in Signal Vine match their contact_id in Salesforce.

Step 1: Export your Signal Vine contacts

Navigate to the Programs tab, then click Export Contacts. Make sure the correct Program is highlighted on the left. This will email you a list of all of your data for the selected Program. 

Step 2: Export the Appropriate Salesforce Contacts

You will be using some Excel tricks to match up the Salesforce contact_id with the Signal Vine contact, so export a list from Salesforce that matches as close to possible the Signal Vine contacts. You could export everyone, but that would probably be overwhelming. In this file, make sure to include:

1. 18 digit contact ID

2. First and last name

3. Contact's phone number

Step 3: Match the Salesforce ID with the Signal Vine contact

You can go about this a few ways, but the most straightforward will usually be doing a VLOOKUP in Excel. Your lookup value will probably be based on the phone number you have in Signal Vine. You will want to copy and paste the 18 digit Salesforce ID into your file that you will re-import into Signal Vine. 

Step 4: Import back into Signal Vine

The final step is re-importing your file with the Salesforce ID in the customer_id column. You can remove all columns except signalvine_id and customer_id. If you still want to keep the value you previously used as the customer_id, you can move it to a different field and update via the import. The file you import should look like this:

To import back into Signal Vine, navigate to the Programs tab at the top, then Import Contacts. After you upload the file, be sure to select "Update existing contacts."

Now that you've set the Customer ID in Signal Vine as the Salesforce Contact ID, data will start to sync based on the field mapping you have configured in SV Sync or SV Messaging. If you haven't set up field mapping yet, as soon as you enable it the data will start syncing.