Import Wizard
Add records from any Salesforce object to Campaign Monitor via a list view, report, SOQL or Salesforce campaign.
Map Salesforce fields to Campaign Monitor custom fields to allow segmentation or personalization.
Import wizard video overview
Creating an import
Please note that Salesforce limits, report imports to 50,000 records, if you have more than this try using the SOQL, campaigns or list view approach. List view import is not available in Salesforce Professional.
Select the subscriber list you want to work with by going to the Subscriber list tab. Then click the Label of the list i.e. SL-0001.
Now click Import wizard then click the New import button.
The wizard will appear asking you to select between a Salesforce campaign, report, list view or SOQL statement.
The next screen depends on what you have selected, you will be asked to choose:
a. List view - an object and a list view.
b. Report - a folder and a report.
c. Campaign - a Salesforce campaign and a status (you can also choose all statuses).
d. SOQL - an editor that you can enter your query in and validate it.Next map Salesforce fields to Campaign Monitor custom fields. If you already have custom fields in Campaign Monitor, these will appear. If not you can create them from this screen. If you choose to map a Salesforce contact or lead ID we will use this to match records instead of an email address.
The wizard allows you to immediately start the import, set up a schedule for future runs or both. If you choose to schedule you can select one, more or all run times. On the same screen there is advanced settings, learn more in the tip below.
Once submitted a subscriber import record will be created and visible on the import wizard section. Here you will be able to monitor the status of the import, see scheduling information, and view the results of a completed import. Every time an import runs it will add any new subscribers and update custom field mappings.
Duplicates emails
Linking emails to Salesforce
Advanced settings
Replace subscribers
Create your import as described above.
In the final step you will have the option to run or schedule the import.
Click on the Advanced section to expand.
Select Replace subscribers.
Clear blank values
Create your import as described above.
In the final step you will have the option to run or schedule the import.
Click on the Advanced section to expand.
Select Clear blank values.
Re-subscribe delete subscribers
Go to the Campaign Monitor admin app and select our General settings tab.
Now click on Options.
Enable Re-subscribe delete subscriptions via import wizard and this will apply to import wizard schedules going forward.
Updating an import
Select the subscriber list you want to work with by going to the Subscriber list tab. Then click the Label of the list i.e. SL-0001.
Now click Import wizard.
Click on the Dropdown arrow on the far right of the import you wish to Edit.
Click Edit.
Deleting an import
Select the subscriber list you want to work with by going to the Subscriber List Tab. Then click the Label of the list i.e. SL-0001.
Now click Import wizard.
Click on the Dropdown arrow on the far right of the import you wish to Delete.
Click Delete.
View import results
Select the subscriber list you want to work with by going to the Subscriber list tab. Then click the Label of the list i.e. SL-0001.
Now click Import wizard.
Click on the Dropdown arrow on the far right of the import you wish to View.
Click Results.
