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.
Working with list views
To update the SOQL statment contained in the wizard you simply need to edit the import and click next to page through, finally click save or save and import. This will update the SOQL statement.
Duplicates emails
Linking emails to Salesforce
1. Make sure your source - report, list, SOQL contains a Salesforce Contact or Lead ID.
2. Via the import wizard map the Salesforce Contact or Lead ID to the Salesforce ID field on the mapping screen.
3. When the import wizard runs a subscriber list membership record will be created in Salesforce. This will be linked to a contact or lead based on the ID rather than the email address.
Picklist Values
Advanced settings
Replace - Set records that are not in the import source to deleted.
Re-subscribe - Set records that are in the import source to active (only if they are deleted). Clear values - If a Salesforce field is blank the corresponding mapped field in Campaign Monitor will be updated to blank.
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.
The replace option will not work if either the "Disable Salesforce account, contact and lead triggers" option or the "Don 't sync members of this list to Salesforce" option is enabled. This is because the replace option relies on the data that is stored within Salesforce to determine which subscribers are safe to set to the status of 'Deleted'. If the data is not up to date (because of the above or due to a failed sync), then the replace option will be ignored.
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.
Instant import wizard
This can be useful where you need to push custom object information across to Campaign Monitor in near-real time (only lead and contacts are supported via Subscriber rules).
The Instant Import Wizard is a powerful approach but should be used with caution given that it's best to avoid running too many Import Wizard jobs (I.e. select objects to base the process builder action on that change infrequently - i.e. when a subscriber signs up).
Create Segments for Import
- To enable the feature, please go to our options page by clicking this link general settings.
- In the bottom section called Other, you will see an option Enable Import Wizard Segments. Please enable this.
- Start the import wizard as you would usually but on the last screen, scheduling, click the Advanced Settings section to expand it.
- An option to Create a Segment will appear at the very bottom. We will automatically suggest a segment name but feel free to change it.
- Once the import has been completed, a new multi-select picklist will be created in Campaign Monitor. And all members of the import will have the value selected. A new Campaign Monitor segment will be created matching the value you made within the import wizard.
Import wizard vs Subscriber rules
Import wizard
- Works with any Salesforce object.
- You can import any email field.
- Inbuilt field mappings.
- Runs as a specific user.
- Can run every hour of every day.
Subscriber rules
- Only works with contacts and leads.
- Limited to the standard email field.
- Can be combined with field mappings.
- Runs as user who triggered the rule.
- Triggers instantly.
