Mailchimp: Import Audiences
Importing user and activity data from Mailchimp results in new users or existing user profiles supplemented with Mailchimp campaign data. You can use this data to build and refine your existing Lytics audiences to power better, cross-channel campaigns.
Integration Details
- Implementation Type: Server-side.
- Implementation Technique: REST API, Webhooks.
- Frequency: Batch every 12 hours.
- Resulting data: User profiles and raw event data.
This integration utilizes Mailchimp APIs to receive user and activity data. On each run of the job, it will:
- Check if webhooks are set up in the Mailchimp account.
- If any webhooks are found, user events such as subscription changes and profile updates will be received in Lytics via webhooks, reformatted on ingestion, and available in the
mailchimp_subscribersstream. - Query for campaigns tied to the lists that you've configured.
- For each campaign found, the job will:
- Reflect all subscription changes on the
mailchimp_subscribersstream. - Add new activity data to the
mailchimp_activitystream.
- Reflect all subscription changes on the
Fields
The following fields are included in the default mapping of the mailchimp_subscribers stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
| cc | mc_countrycode | Mailchimp Last Country Code | string |
| email(email_address) | email unique id | string | |
| emaildomain(email_address) | emaildomain | Email Domain | string |
| euid | mc_euid unique id | MailChimp User ID | string |
| first_name | mc_first_name | Mailchimp First Name | string |
| last_name | mc_last_name | Mailchimp Last Name | string |
| latitude | mc_latitude | Mailchimp Latitude | string |
| longitude | mc_longitude | Mailchimp Longitude | string |
| map(listid, liststatus) | mc_subscriber_statuses | Mailchimp Subscriber Statuses | map[string]value |
| map(listid, tags) | mc_tags | Mailchimp Tags | map[string]value |
| member_rating | mc_rating | Mailchimp Rating | string |
| region | mc_region | Mailchimp Last Region | string |
| set(cc) | mc_countrycodes | Mailchimp Country Codes | []string |
| set(group) | mc_groups | Mailchimp Groups | []string |
| set(leid) | mc_leids | Mailchimp Email ID (LEID) | []string |
| set(listid) | mc_listids | Mailchimp Lists | []string |
| set(region) | mc_regions | Mailchimp Regions | []string |
| timezone | mc_timezone | Mailchimp Time Zone | string |
The following fields are included in the default mapping of the mailchimp_activity stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
| action | mc_action | Mailchimp Action | string |
| count(action) | mc_clickct | Mailchimp Click Count | int |
| count(action) | mc_hardbouncect | Mailchimp Hard Bounce Count | int |
| count(action) | mc_openct | Mailchimp Open Count | int |
| count(action) | mc_sendct | Mailchimp Send Count | int |
| count(action) | mc_subct | Mailchimp Subscribe Count | int |
| count(action) | mc_unsubct | Mailchimp Unsubscribe Count | int |
| date(timestamp) | mc_send_ts | Mailchimp Send Time | date |
| email(email) | email unique id | string | |
| email_type | mc_emailtype | Mailchimp Email Type | string |
| emaildomain(email) | emaildomain | Email Domain | string |
| epochms() | mc_hardbounce_ts | Mailchimp Hard Bounce Time | date |
| epochms() | mc_sub_ts | Mailchimp Subscribe Time | date |
| epochms() | mc_unsub_ts | Mailchimp Unsubscribe Time | date |
| last_status | mc_laststatus | Mailchimp Last Status | string |
| map("email", epochms()) | last_channel_activities | Last Activity By Channel | map[string]time |
| map(experience_id, 1) | mc_conversions | Converted on Mailchimp Experience | map[string]int |
| map(experience_id, 1) | mc_impressions | Reached with Mailchimp Experience | map[string]int |
| max(epochms()) | last_active_ts | Last Active on Any Channel | date |
| max(epochms()) | mc_lastclick_ts | Mailchimp Last click | date |
| max(epochms()) | mc_lastopen_ts | Mailchimp Last Open | date |
| min(epochms()) | mc_firstclick_ts | Mailchimp First click | date |
| min(epochms()) | mc_firstopen_ts | Mailchimp First Open | date |
| set("email") | channels | All Channels Used | []string |
| set(bounce_reason) | mc_bouncereason | Mailchimp Hard Bounce Reason | []string |
| set(campaign_title) | mc_campaigntitles | Mailchimp Campaign Names | []string |
| set(campaignid) | mc_campaignids | Mailchimp Campaign Ids | []string |
| set(listid) | mc_listids | Mailchimp Lists | []string |
| set(unsub_action) | mc_unsubaction | Mailchimp Unsubscribe Action | []string |
| set(unsub_reason) | mc_unsubreason | Mailchimp Unsubscribe Reason | []string |
| set(utm_campaign) | utm_campaigns | List Of Campaigns Referred From | []string |
| set(utm_content) | utm_contents | List Of Contents Referred From | []string |
| set(utm_medium) | utm_mediums | List Of Mediums Referred From | []string |
| set(utm_source) | utm_sources | List Of Sources Referred From | []string |
| set(utm_term) | utm_terms | List Of Terms Referred From | []string |
| set(variant_title) | mc_variant_titles | Mailchimp Variant Titles | []string |
| set(variantid) | mc_variantids | Mailchimp Variant Ids | []string |
| url | mc_email_url | Mailchimp Url | string |
| valuect(action) | mc_actionct | Mailchimp Action Count | map[string]intsum |
| valuect(campaignid) | total_clicks_by_campaign | The number of clicks for a campaign | map[string]intsum |
| valuect(campaignid) | total_opens_by_campaign | The number of opens for a campaign | map[string]intsum |
| valuect(hash(urlmain(url))) | hashedurls | Hashed Urls Visited | map[string]intsum |
| valuect(hourofday()) | mc_hourlyclick | Mailchimp Clicks By Hour | map[string]intsum |
| valuect(hourofday()) | mc_hourlyopen | Mailchimp Opens By Hour | map[string]intsum |
NOTE: Lytics can import any and all custom fields from Mailchimp, but this stream does not automatically map these fields. If you would like to map the imported custom fields to Lytics user fields, please contact Support for assistance.
Configuration
Follow these steps to set up and configure an import job for Mailchimp in the Lytics platform. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information.
- Select Mailchimp from the list of providers.
- Select the Import Audiences from the list.
- Select the Authorization you would like to use or create a new one.
- Enter a Label to identify this job you are creating in Lytics.
- (Optional) Enter a Description for further context on your job.
- Complete the configuration steps for your job.
- From the Lists to Import input, select lists available to be imported from Mailchimp are located in the left column. Lists added to the right column will be imported to Lytics.
- (Optional) Toggle Show Advanced Options.
- (Optional) Select the One Time Subscriber/Unsubscriber Sync checkbox, to set to true to re-import a list's subscriber and unsubscriber data only. This will not pull activity data and will not keep your subs/unsubs synced.
- (Optional) In the Import List Members Data Since this Date text box, enter members whose data has changed from this date onwards will be imported. Leaving blank will import all the members. Use
yyyy-mm-ddformat (ex: 2015-08-13). - (Optional) Select the Check to import activity data checkbox, to set to true to import activity data.
- (Optional) In the Import Email Activity Data Since this Date text box, enter activities from this date onwards will be imported. Leaving blank will import 30 days old email activities from today. Use
yyyy-mm-ddformat (ex: 2015-08-13). - Click Start Import.
