On This Page
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:
Click PIPELINES in the Asset Palette.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select Mailchimp.
In the Configure your Mailchimp account page, click + ADD MAILCHIMP ACCOUNT.
Give Hevo access to your account by entering your Mailchimp credentials.
In the Configure your Mailchimp Source page, specify the following:
- Pipeline Name: A unique name for the Pipeline, not exceeding 255 characters.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.
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:
The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:
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.
|Automation Removed Subscribers||The
|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
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.
|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 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
A tag that is created and assigned to members is also considered a segment.
A segment with the type
|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 are updated each time a campaign is sent.
|Email Activity Reports||Member’s subscriber activity in a specific campaign.
Each activity is also accompanied by a timestamp.