Mailchimp

Hevo can replicate your Mailchimp data to your data warehouse using Mailchimp’s API.

For creating Pipelines using this Source, Hevo provides you a fully managed BigQuery data warehouse as a possible Destination. This option remains available till the time you set up your first BigQuery Destination irrespective of any other Destinations that you may have. With the managed warehouse, you are only charged the cost that Hevo incurs for your project in Google BigQuery. The invoice is generated at the end of each month and payment is recovered as per the payment instrument you have set up. You can now create your Pipeline and directly start analyzing your Source data. Read Hevo Managed Google BigQuery.


Configuring Mailchimp as a Source

Perform the following steps to configure Mailchimp as the Source in your Pipeline:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select Mailchimp.

  4. In the Configure your Mailchimp account page, click + ADD MAILCHIMP ACCOUNT.

  5. Give Hevo access to your account by entering your Mailchimp credentials.

  6. In the Configure your Mailchimp Source page, specify the following:

    Test&Continue

    • Pipeline Name: A unique name for the Pipeline, not exceeding 255 characters.
  7. Click TEST & CONTINUE.

  8. Proceed to configuring the data ingestion and setting up the Destination.


Data Replication

Historical Data: All historical data present in your Mailchimp account is ingested when you create the Pipeline.

Incremental Data: Mailchimp data is ingested at an hourly basis which is the minimum supported frequency. You can modify the frequencyusing the Change Schedule option in the Pipeline Summary in the Pipelines Detailed View.


Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination:


Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Object Description
Automations The automations table contains information of all Automations belonging to your Mailchimp account.
In Mailchimp, automations allow you to build a series of emails that are sent to subscribers when triggered by a specific date, activity, or event.
Information about Emails and Unsubscribers associated with each automation is also ingested by Hevo.
Automation Emails An automation email is an email that is part of an automation.
An automation can consist of multiple emails.
The automation_emails table contains details of each automation email such as create time, update time, recipients, number of opens, number of clicks and so on.
Automation Removed Subscribers The automation_removed_subscribers table contains details about members that have unsubscribed or have been removed from an Automation recipient list.
Campaigns Campaigns in Mailchimp allow you to design email templates that can be sent to a mailing list.
Hevo ingests data of all campaigns associated with your Mailchimp account and stores them in the campaigns table.
Subscriber activity in a specific campaign as well as unsubscriber reports are also extracted for each campaign.
Lists Lists also known as your audience in Mailchimp are used to store and manage your contacts.
The lists table contains detailed statistics for each list present in your Mailchimp account.
List Abuse Reports Reports of members from a particular list that have marked an email as spam accompanied by a timestamp of the action are stored in the list_abuse_reports table.
List Members The members table contains detailed information about all members belong to your mailing lists.
List Segments Segments are a section of a list that includes only those subscribers who share specific common field information.
Information regarding segments of a list are stored in the segments table.
A tag that is created and assigned to members is also considered a segment.
A segment with the type static indicates a tag.
Segment Members The segment_members table contains details about members belonging to various segments.
Reports Mailchimp’s campaign and automation reports analyze clicks, opens, subscribers’ social activity, e-commerce data, and more.
A report is generated for each campaign that is part of your account and stored in the reports table.
Reports are updated each time a campaign is sent.
Email Activity Reports Member’s subscriber activity in a specific campaign.
The email_activity_reports contains detailed information regarding any member activity.
Each activity is also accompanied by a timestamp.
Unsubscribes The unsubscriber_reports table contains information about list members who unsubscribed from a specific campaign.

Limitations

None.

Last updated on 26 Jul 2021