This article explains how to pull Customer Records from Mailchimp into Distil.
If you haven't already created a connection between Distil and Mailchimp, then you'll need to do this first.
Remember that Mailchimp stores Customer Records in Audiences (formally Lists). Each Mailchimp Audience is a list in its own right: there is no single Customer list in Mailchimp. If a Customer Record is stored in two lists, then this is two unique Customer Records with their own attributes and subscribed status.
Select Customer Data Sources
To pull your Mailchimp Audiences into Distil, navigate to your Mailchimp Connection in Distil via Settings > Integrations. From the list in the panel on the left, select the Mailchimp Integration from which you would like to pull Customer records. Distil displays the compatible data sources it has found in Mailchimp for this connection. If you've just created the connection and there are no data sources listed, click Refresh List in the top menu bar.
Under Customer data sources (the first column), you should see a list of the Audiences you have in Mailchimp. You can enable or disable Customer data as a data source by clicking the slider.
Distil connects to Customer data in Mailchimp, and not Product, Content or Purchase History data. So you will see No data sources of this type available under the other data types. This is normal for connections to Mailchimp.
Click on an Audience to see details such as sync status, number of records and a list of Attributes. Click the slider to enable or disable this Audience as a data source.
Once Distil has finished importing and automatically tying the identities of the Customer records together, then you can view the data for each Mailchimp Audience in your Single Customer View in its own tab under Customer Data Studio > Segments > Data.
For each Customer Record, Mailchimp holds values for a set of Standard fields. In addition, as a Mailchimp user you can create custom fields for each Mailchimp Audience as explained in this Mailchimp article. Mailchimp calls these custom fields: Merge Fields.
When pulling Customer data from Mailchimp, for each Customer and Audience Distil will bring in values for Mailchimp Standard Fields, and also Merge Fields. Because the number of Merge Fields can vary for each Audience, the number of Attributes you will see under Data Sources may be different for each Audience.
If you have already pushed Customer data from Distil into Mailchimp including Distil Attributes such as Customer Tracking IDs, then these Attributes and their values will be pulled back into Distil as Merge Fields.
Remember that you can view the data for each Mailchimp Audience in your Single Customer View in its own tab under Customer Data Studio > Segments > Data.
The following is a list of Mailchimp Standard Fields that are pulled into Distil for each Mailchimp Audience. While we try to keep this list up to date, we recommend that you get the latest list from Mailchimp.
|Email ID||Mailchimp's unique ID for this Customer record. Note that if a Customer is stored in two Audiences, then this means there will be two unique Customer records with their own individual IDs.|
|Email Address||Customer's email address.|
|Unique Email ID||An identifier for the email address, used by Mailchimp.|
|Email Type||The preferred format of email communication for this Customer: HTML or text.|
The Customer's current subscription status:
|Unsubscribed Reason||A subscriber’s reason for unsubscribing.|
|Member Merge Fields||An individual merge var and value for a member.|
|Subscriber Interests||The key of this object’s properties is the ID of the interest in question.|
|Average Open Rate||A subscriber’s average open rate.|
|Average Click Rate||A subscriber’s average clickthrough rate.|
|Signup IP||IP address the subscriber signed up from.|
|Signup Timestamp||The date and time the subscriber signed up for the list in ISO 8601 format.|
|Opt-in IP||The IP address the subscriber used to confirm their opt-in status.|
|Opt-in Timestamp||The date and time the subscribe confirmed their opt-in status in ISO 8601 format.|
|Member Rating||Star rating for this member, between 1 and 5.|
|Last Changed Date||The date and time the member’s info was last changed in ISO 8601 format.|
|Language||If set/detected, the subscriber’s language.|
|VIP||VIP status for subscriber|
|Email Client||The list member’s email client.|
|Location - Latitude||The location latitude.|
|Location - Longitude||The location longitude.|
|GMT Offset||The time difference in hours from GMT.|
|DST Offset||The offset for timezones where daylight saving time is observed.|
|Country Code||The unique code for the location country.|
|Timezone||The timezone for the location.|
|Marketing Permission ID||The ID for the marketing permission on the list.|
|Marketing Permission Text||The text of the marketing permission.|
|Marketing Permission Enabled||If the subscriber has opted-in to receive marketing information.|
|Last Note ID||The most recent Note added about this member. The note id.|
|Last Note Created Time||The date and time the note was created in ISO 8601 format.|
|Last Note Author||The author of the note.|
|Last Note||The content of the note.|