Mailchimp

Data Replication

For Teams Created	Default Ingestion Frequency	Minimum Ingestion Frequency	Maximum Ingestion Frequency	Custom Frequency Range (in Hrs)
Before Release 2.21	1 Hr	1 Hr	48 Hrs	1-48
After Release 2.21	6 Hrs	30 Mins	24 Hrs	1-24

Note: The custom frequency must be set in hours as an integer value. For example, 1, 2, or 3 but not 1.5 or 1.75.

• Historical Data: From Release 1.82, Hevo ingests your historical data using the Recent Data First approach. This enables you to have quicker access to your historical data.

  • For Pipelines created before Release 1.82: By default, Hevo replicates all the historical data present in your Mailchimp account.

  • For Pipelines created after Release 1.82: You can select the historical sync duration at the time of creating a Pipeline. Default duration: 3 Months.

• Incremental Data: Once the historical load is complete, all new and updated records for the List Members, Member Tags, and Tags objects are ingested as per the ingestion frequency. The remaining objects are ingested in Full Load mode.

Note: From Release 1.85, Hevo ingests only new and updated data for Full Load objects to optimize the quota consumption. This feature is currently available on request only. You need to contact Hevo Support to enable it for your team.

---

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:

Note:

• For Pipelines created from Release 1.99 onwards: Hevo supports the data ingestion of the email activity reports object for winning variate campaigns.
• All objects other than List Members, Member Tags, and Tags are Full Load objects.

Object	Description
Automations	Contains the details of a series of automation emails that are sent to subscribers when triggered by a specific date, activity, or event. Hevo also ingests information about emails and unsubscribers associated with each automation.
Automation Emails	Contains the details of all emails that are parts of an Automation, such as create time, update time, recipients, number of opens, and number of clicks.
Automation Removed Subscribers	Contains the details about members that have unsubscribed or have been removed from an Automation recipient list.
Campaigns	Contains the details of all the email templates that are designed to send 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.
Click Reports	Contains the details of the clicks on specific links within a campaign.
Click Reports Members	Contains the details of the subscribers who clicked on links within a campaign.
Email Activity Reports	Contains the details of any subscriber activity within a campaign. Each activity is accompanied by a timestamp.
Lists	Contains the details about where you store and manage all of your contacts. The lists table contains detailed statistics for each list present in your Mailchimp account.
List Abuse Reports	Contains the details of all the members from a particular list that have marked an email as spam, along with the timestamp of that action.
List Members	Contains the details about all the members in a specific mailing list.
List Segments	Contains the details of all subscribers who share common information in specific fields. A tag that is created and assigned to members is also considered a segment. This tag is indicated by the type static.
Member Tags	Contains the details of all the tags that are associated with a contact in your Mailchimp account.
Reports	Contains the details of all automation and campaign reports in your Mailchimp account. These 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.
Segment Members	Contains the details about members belonging to various segments.
Tags	Contains the details of all the tags used to organize your contacts into multiple categories.
Unsubscribes	Contains the details of list members who unsubscribed from a specific campaign.

---