What is the data wizard?
The Data Wizard allows you to bulk import data from Salesforce to Mailchimp.
The import can use Reports, List views, SOQL queries or Salesforce campaigns as the source.
During the wizard, you can map Salesforce fields to Mailchimp merge fields. And you can assign tags or groups to your contacts. Additionally, the entire import can be scheduled to run automatically, making it easy to keep your Mailchimp audience up to date.
Key features include:
- Work with any Salesforce object.
- Map Salesforce fields to Mailchimp merge fields.
Add people to groups or tags.
Schedule to automate the process.
How to use the data wizard
Data Wizards are created per audience, and consist of an import source, mappings, and configuration like schedule, tags and groups.
The following may be used as an import source. We offer more information on each on the data source overview:
- List Views (demo below)
- Salesforce Report in tabular view
- SOQL query (advanced)
- Salesforce Campaign
Wizards have their own separate mapping from the Field Mappings. The fields included on the source (report or list view columns, SELECT statements or campaign member fields) are what will be available to map in the wizard. These mappings are applied every time the import runs.
Note: The import will not overwrite existing information with blank values, to avoid data loss.
The data wizard creates new members with a Subscribed status, unless the audience has Double Opt-In enabled in Mailchimp. Make sure your source excludes any emails that shouldn’t be subscribed.
Unsubscribed records will never be reactivated.
If your import includes archived records, the “Filter Archived Records” setting on the last page of the wizard controls how they are handled.
If Double Opt-In is enabled on the audience in Mailchimp, new and reactivated emails are created with a Pending status, not Subscribed. Mailchimp sends each of them a confirmation email. Please see the managing pending members FAQ.
