Field mappings

  • Update Campaign Monitor custom fields.
  • Update Salesforce records.
  • Works with the create Salesforce records option.

Field mapping vs import wizard

Our integration offers two ways to update custom fields with Salesforce data.  The easiest option is to use our import wizard which combines importing records and mapping custom fields in one simple flow. It also allows you to work with any Salesforce object.

If you are working with contact or lead records and prefer to use another of our options to import you'll need to setup custom field mappings which is explained below.

Field mappings

To choose which data is synced between Campaign Monitor's custom fields and Salesforce contact and lead records:

  1. In Salesforce go to the Campaign Monitor app.

  2. Click on the Subscriber List tab and select the list you want to work with.

  3. Click on Field Mappings. Below are instructions depending on which direction you want mappings to go.

Map Salesforce to Campaign Monitor

To sync Salesforce contact and lead records to Campaign Monitor custom fields:

  1. Click Edit this unlocks the page.

  2. If you have custom fields already in Campaign Monitor these will appear. If you need to create a new mapping click on the New Campaign Monitor Field.

  3. Choose contact or lead and then choose a field from the pick list and then click Select. By default the direction will be set to Salesforce to Campaign Monitor.

  4. A field of the same data type and name will be automatically created in Campaign Monitor.

  5. Repeat this process if necessary and when finished click Save.

Map Campaign Monitor to Salesforce

You can map Campaign Monitor custom fields to Salesforce. Fields mapped in the direction of Campaign Monitor to Salesforce are tied to the primary sync, which runs every hour by default. This means that the integration will update Salesforce mapped fields with the values stored in Campaign Monitor every time the primary sync runs.

Field mappings will overwrite field values held in Salesforce when mapped in the direction of Campaign Monitor for Salesforce.

  1. Click Edit this unlocks the page.

  2. If you have custom fields already in Campaign Monitor these will appear. If you need to create a new mapping click on the New Campaign Monitor Field.

  3. Choose Contact or Lead and then choose a field from the pick list and then click Select. By default the direction will be set to Salesforce to Campaign Monitor. To change this click on the Drop Down link and click Edit.

  4. A field of the same data type and name will be automatically created in Campaign Monitor.

  5. Repeat this process if necessary and when finished click Save.

Click apply field mapping to other Subscriber Lists to use the same field mapping for another Campaign Monitor subscriber list.

Bi-directional Sync

Bi-directional syncing of custom fields is not currently supported due to a limitation in Campaign Monitor API.  There is, however, a workaround.  You can use custom field mappings in the direction of Campaign Monitor to Salesforce to update Salesforce every hour by default.

You can then use our import wizard to update Campaign Monitor.  The import wizard can be scheduled to run as often as every hour of every day.

It is worth noting there is no conflict resolution in this solution.  Custom field mappings will update Salesforce every hour (by default), the import wizard will update Campaign Monitor according to the schedule a user has set.

Full refresh of mapped fields

Perform a full refresh on the mapped fields by checking the retrospective save box and pressing save. This will bulk update any mapped fields from Salesforce to Campaign Monitor.

First & last name updates in Salesforce

In certain cases you might want to separate first and last name fields in Campaign Monitor. This is accomplished by creating custom fields in Campaign Monitor.  You can do this either in Campaign Monitor directly, using the import wizard, or via field mappings. By breaking the fields out you have greater control when injecting content in your template emails.

Conversely when passing back data from Campaign Monitor to Salesforce you might also want to use this method. This is because Campaign Monitor API only has a full name field we can pass back to Salesforce. If you have chosen to create Salesforce records we will attempt to split that field into first and last name. However this can prove unreliable should a person have a middle name, or double barrelled last name.

For this reason if you have chosen to update Salesforce records (not create new ones) based on Campaign Monitor data we will not update a person's name in Salesforce if changed. This is to ensure data in Salesforce is not incorrectly updated.

A good work around is to create custom fields for first and last name on your Campaign Monitor list and map these to Salesforce via To set these up in Campaign Monitor and to get more information on the problem please click here.

In this article