Documentation / Product / Integrations / Mailchimp

Mailchimp: Import List

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 workflow, 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 workflow 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
email_addressemail unique idEmailstring
euidmc_euid unique idMailChimp User IDstring
email_addressemaildomainEmail Domainstring
ccmc_countrycodeMailchimp Last Country Codestring
ccmc_countrycodesMailchimp Country Codes[]string
first_namemc_first_nameMailchimp First Namestring
groupmc_groupsMailchimp Groups[]string
last_namemc_last_nameMailchimp Last Namestring
latitudemc_latitudeMailchimp Latitudestring
leidmc_leidsMailchimp Email ID (LEID)[]string
listidmc_listidsMailchimp Lists[]string
longitudemc_longitudeMailchimp Longitudestring
member_ratingmc_ratingMailchimp Ratingstring
regionmc_regionMailchimp Last Regionstring
regionmc_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
emailemail unique idstring
channelsAll Channels Used[]string
emailemaildomainEmail Domainstring
urlhashedurlsHashed Urls Visitedmap[string]intsum
last_active_tsLast Active on Any Channeldate
last_channel_activitiesLast Activity By Channelmap[string]time
actionmc_actionMailchimp Actionstring
actionmc_actionctMailchimp Action Countmap[string]intsum
bounce_reasonmc_bouncereasonMailchimp Hard Bounce Reason[]string
campaignidmc_campaignidsMailchimp Campaign Ids[]string
campaigntitlemc_campaigntitlesMailchimp Campaign Names[]string
actionmc_clickctMailchimp Click Countint
urlmc_email_urlMailchimp Urlstring
email_typemc_emailtypeMailchimp Email Typestring
mc_firstclick_tsMailchimp First clickdate
mc_firstopen_tsMailchimp First Opendate
mc_hardbounce_tsMailchimp Hard Bounce Timedate
actionmc_hardbouncectMailchimp Hard Bounce Countint
mc_hourlyclickMailchimp Clicks By Hourmap[string]intsum
mc_hourlyopenMailchimp Opens By Hourmap[string]intsum
mc_lastclick_tsMailchimp Last clickdate
mc_lastopen_tsMailchimp Last Opendate
last_statusmc_laststatusMailchimp Last Statusstring
listidmc_listidsMailchimp Lists[]string
actionmc_openctMailchimp Open Countint
mc_send_tsMailchimp Send Timedate
actionmc_sendctMailchimp Send Countint
mc_sub_tsMailchimp Subscribe Timedate
actionmc_subctMailchimp Subscribe Countint
mc_unsub_tsMailchimp Unsubscribe Timedate
unsub_actionmc_unsubactionMailchimp Unsubscribe Action[]string
actionmc_unsubctMailchimp Unsubscribe Countint
unsub_reasonmc_unsubreasonMailchimp Unsubscribe Reason[]string
campaignidtotal_clicks_by_campaignThe number of clicks for a campaignmap[string]intsum
campaignidtotal_opens_by_campaignThe number of opens for a campaignmap[string]intsum
utm_campaignutm_campaignsList Of Campaigns Referred From[]string
utm_contentutm_contentsList Of Contents Referred From[]string
utm_mediumutm_mediumsList Of Mediums Referred From[]string
utm_sourceutm_sourcesList Of Sources Referred From[]string
utm_termutm_termsList Of Terms Referred From[]string

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 of a Mailchimp List in the Lytics platform.

  1. Navigate to the Integrations page and select Mailchimp. mailchimp logo 215
  2. Select Workflows from the menu on the left.
  3. Select Import List from the list of workflows.
  4. Select the Authorization you would like to use.
  5. From the Lists to Import input section, select the lists you would like to import.
  6. Click on the Show Advanced Options tab to expand the advanced configuration
  7. From the One Time Subscriber/Unsubscriber Sync checkbox, check to re-import a list's subscriber and unsubscriber data only. This will not pull activity data and will not keep your subscribers/unsubscribers synced.
  8. From the Import List Members Data Since this Date input, members from this date onwards will be imported. Leaving blank will import all the members. Use YYYY-MM-DD format (e.g. 2015-08-13).
  9. From the Import Email Activity Data Since this Date input, activities from this date onwards will be imported. Leaving blank will import 30 days old email activities from today. Use YYYY-MM-DD format (e.g. 2015-08-13).
  10. Click Start Import. mailchimp config

Passing Mailchimp Identifier for Identity Resolution

You may want to pass a unique Mailchimp identifier from links within your email. This will help Lytics identify users across data streams and merge their email and web activity. For more information about dynamically passing this parameter, see Mailchimp's documentation on creating unique URLs for subscribers.

The easiest way to pass a unique identifier from Mailchimp click-through links into Lytics is to use the Mailchimp EUID identifier. This identifier is mapped automatically by the Lytics integration. To add the EUID into your email click-through URLs for identity resolution, modify the URLs in your outbound emails to include the EUID parameter.

www.yourcompanyURL.com/campaign-page?euid=*|EUID|*

NOTE: The Lytics JavaScript tag must be installed on your site, and the import workflow will need to be active.

Collecting Data via Webhooks

Some Mailchimp data is collected through webhooks. Deleting or changing the settings could stop Lytics' collection of this data. For more information about webhooks read Mailchimp's documentation.