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

Note: For Pipelines created with this Source, Hevo provides you a fully-managed BigQuery data warehouse Destination if you do not already have one set up. 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 .

Setup Instructions

Follow the steps below to set up a pipeline with Mailchimp as a source:

  1. Select Pipelines in the left pane and click Create Pipeline to create a pipeline.

  2. Select Mailchimp as a source type to continue.

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

  4. Enter a unique name for your pipeline.

  5. Select the destination where you want to replicate your Mailchimp data or click on New Destination to create a new Destination. Check out Destinations for the detailed walkthrough on steps needed for adding new Destination.

Hevo ingests the following data from your Mailchimp account

  • 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.

Things to know:

  • All historical data present in your Mailchimp account will be ingested by Hevo.
  • Each pipeline in Hevo has a frequency at which it ingests data. Mailchimp data is ingested at an hourly basis which is the minimum supported frequency. This frequency can be configured using the Change Schedule option if required.
Last updated on 20 Oct 2020