Documentation / Product / Integrations / Mailchimp

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

This integration utilizes Mailchimp APIs to receive user and activity data. On each run of the job, it will:

  1. Check if webhooks are set up in the Mailchimp account.
  2. 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_subscribers stream.
  3. Query for campaigns tied to the lists that you've configured.
  4. For each campaign found, the job will:
    1. Reflect all subscription changes on the mailchimp_subscribers stream.
    2. Add new activity data to the mailchimp_activity stream.

Fields

The following fields are included in the default mapping of the mailchimp_subscribers stream:

Source FieldLytics User FieldDescriptionType
ccmc_countrycodeMailchimp Last Country Codestring
email(email_address)email unique idEmailstring
emaildomain(email_address)emaildomainEmail Domainstring
euidmc_euid unique idMailChimp User IDstring
first_namemc_first_nameMailchimp First Namestring
last_namemc_last_nameMailchimp Last Namestring
latitudemc_latitudeMailchimp Latitudestring
longitudemc_longitudeMailchimp Longitudestring
map(listid, liststatus)mc_subscriber_statusesMailchimp Subscriber Statusesmap[string]value
map(listid, tags)mc_tagsMailchimp Tagsmap[string]value
member_ratingmc_ratingMailchimp Ratingstring
regionmc_regionMailchimp Last Regionstring
set(cc)mc_countrycodesMailchimp Country Codes[]string
set(group)mc_groupsMailchimp Groups[]string
set(leid)mc_leidsMailchimp Email ID (LEID)[]string
set(listid)mc_listidsMailchimp Lists[]string
set(region)mc_regionsMailchimp Regions[]string
timezonemc_timezoneMailchimp Time Zonestring

The following fields are included in the default mapping of the mailchimp_activity stream:

Source FieldLytics User FieldDescriptionType
actionmc_actionMailchimp Actionstring
count(action)mc_clickctMailchimp Click Countint
count(action)mc_hardbouncectMailchimp Hard Bounce Countint
count(action)mc_openctMailchimp Open Countint
count(action)mc_sendctMailchimp Send Countint
count(action)mc_subctMailchimp Subscribe Countint
count(action)mc_unsubctMailchimp Unsubscribe Countint
date(timestamp)mc_send_tsMailchimp Send Timedate
email(email)email unique idstring
email_typemc_emailtypeMailchimp Email Typestring
emaildomain(email)emaildomainEmail Domainstring
epochms()mc_hardbounce_tsMailchimp Hard Bounce Timedate
epochms()mc_sub_tsMailchimp Subscribe Timedate
epochms()mc_unsub_tsMailchimp Unsubscribe Timedate
last_statusmc_laststatusMailchimp Last Statusstring
map("email", epochms())last_channel_activitiesLast Activity By Channelmap[string]time
map(experience_id, 1)mc_conversionsConverted on Mailchimp Experiencemap[string]int
map(experience_id, 1)mc_impressionsReached with Mailchimp Experiencemap[string]int
max(epochms())last_active_tsLast Active on Any Channeldate
max(epochms())mc_lastclick_tsMailchimp Last clickdate
max(epochms())mc_lastopen_tsMailchimp Last Opendate
min(epochms())mc_firstclick_tsMailchimp First clickdate
min(epochms())mc_firstopen_tsMailchimp First Opendate
set("email")channelsAll Channels Used[]string
set(bounce_reason)mc_bouncereasonMailchimp Hard Bounce Reason[]string
set(campaign_title)mc_campaigntitlesMailchimp Campaign Names[]string
set(campaignid)mc_campaignidsMailchimp Campaign Ids[]string
set(listid)mc_listidsMailchimp Lists[]string
set(unsub_action)mc_unsubactionMailchimp Unsubscribe Action[]string
set(unsub_reason)mc_unsubreasonMailchimp Unsubscribe Reason[]string
set(utm_campaign)utm_campaignsList Of Campaigns Referred From[]string
set(utm_content)utm_contentsList Of Contents Referred From[]string
set(utm_medium)utm_mediumsList Of Mediums Referred From[]string
set(utm_source)utm_sourcesList Of Sources Referred From[]string
set(utm_term)utm_termsList Of Terms Referred From[]string
set(variant_title)mc_variant_titlesMailchimp Variant Titles[]string
set(variantid)mc_variantidsMailchimp Variant Ids[]string
urlmc_email_urlMailchimp Urlstring
valuect(action)mc_actionctMailchimp Action Countmap[string]intsum
valuect(campaignid)total_clicks_by_campaignThe number of clicks for a campaignmap[string]intsum
valuect(campaignid)total_opens_by_campaignThe number of opens for a campaignmap[string]intsum
valuect(hash(urlmain(url)))hashedurlsHashed Urls Visitedmap[string]intsum
valuect(hourofday())mc_hourlyclickMailchimp Clicks By Hourmap[string]intsum
valuect(hourofday())mc_hourlyopenMailchimp Opens By Hourmap[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.

  1. Select Mailchimp from the list of providers.
  2. Select the Import Audiences from the list.
  3. Select the Authorization you would like to use or create a new one.
  4. Enter a Label to identify this job you are creating in Lytics.
  5. (Optional) Enter a Description for further context on your job.
  6. Complete the configuration steps for your job. mailchimp config
  7. 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.
  8. (Optional) Toggle Show Advanced Options.
  9. (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.
  10. (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).
  11. (Optional) Select the Check to import activity data checkbox, to set to true to import activity data.
  12. (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-dd format (ex: 2015-08-13).
  13. Click Start Import.