MailChimp

Creating the data source

MailChimp was born as an alternative to the expensive and complex email marketing tools on the market, and today it is among the most used tools in the world for this purpose.

With MailChimp you can build email layouts, segment lists and automate campaigns — and not only that: in recent years the platform has evolved to call itself an "All-in-one Marketing Platform", letting users promote their business through social media, landing pages, Facebook ads and Google Ads, on top of integrating with more than 300 business apps.

Adding the data source

To replicate MailChimp with the Kondado platform and have access to all this data in your database in a matter of minutes, start by adding the data source following the steps below:

1) Log in to your MailChimp account and, on the home page, follow the steps as shown below

Click on the top right, where your name is
In the menu that opens, click on "Account"

2) When you are on your account page, follow the steps as shown below

In the middle section, click on "Extras"
In the menu that opens, click on "API keys"

3) On the new page, you will see a list of your existing API Keys. Click on "Create a Key" as shown below

4) Once created, the new API Key will appear at the top of the list. Copy the value of the new API Key as shown below

5) Log in to the Kondado platform

6) On the Kondado platform, go to the add new data sources section and select the MailChimp data source

7) On the data source page, fill in the information as below

Name: The internal description of the data source, for example: "Email Trigger"
Username: Your mailchimp username (not your email!)
API key: The api key obtained in step (4)

Now just click SAVE to start receiving data from MailChimp in your Data Warehouse, Data Lake or spreadsheet

Pipelines

Relationship chart

Click to expand

E-mail activity

Replication type: Incremental

Main object

Per-email/subscriber activity of a campaign. Grain: one sent email.

Campo	Tipo
email_id	text	[en] Unique identifier of the email sent to a subscriber.
campaign_id	text	[en] Email campaign identifier.
list_is_active	boolean	[en] Whether the audience is active.
list_id	text	[en] Identifier of the campaign audience (list).
email_address	text	[en] Subscriber email address.

mailchimp_email_activity__activity

Individual activity events (open/click/bounce) per email. Child of email_activity.

Campo	Tipo
activity__action	text	[en] Subscriber action type (open, click, bounce).
activity__ip	text	[en] IP address of the subscriber action.
activity__timestamp	timestamp	[en] Date and time of the subscriber action.
list_id	text	[en] Identifier of the campaign audience (list).
campaign_id	text	[en] Email campaign identifier.
email_id	text	[en] Unique identifier of the email sent to a subscriber.

Reports

Replication type: Incremental

Main object

Mailchimp campaign reports: each row aggregates a campaign's metrics (sends, opens, clicks, bounces, e-commerce). Grain: one campaign.

Campo	Tipo
forwards__forwards_count	float	[en] Number of email forwards.
forwards__forwards_opens	float	[en] Opens resulting from forwards.
abuse_reports	float	[en] Number of abuse/spam complaints received.
facebook_likes__facebook_likes	float	[en] Facebook likes attributed to the campaign.
facebook_likes__unique_likes	float	[en] Unique Facebook likes.
facebook_likes__recipient_likes	float	[en] Likes from campaign recipients.
list_is_active	boolean	[en] Whether the audience is active.
send_time	timestamp	[en] Campaign send date and time.
list_name	text	[en] Audience (list) name.
industry_stats__open_rate	float	[en] Taxa de abertura benchmark (industry stats).
industry_stats__click_rate	float	[en] Taxa de cliques benchmark (industry stats).
industry_stats__unsub_rate	float	[en] Taxa de descadastro benchmark (industry stats).
industry_stats__abuse_rate	float	[en] Taxa de denuncia de abuso benchmark (industry stats).
industry_stats__bounce_rate	float	[en] Taxa de bounce benchmark (industry stats).
industry_stats__type	text	[en] Tipo benchmark (industry stats).
industry_stats__unopen_rate	float	[en] Taxa de nao-abertura benchmark (industry stats).
ecommerce__total_spent	float	[en] Total amount spent by buyers attributed to the campaign.
ecommerce__total_revenue	float	[en] Total revenue attributed to the campaign.
ecommerce__currency_code	text	[en] Currency of the e-commerce metrics.
ecommerce__total_orders	float	[en] Total number of orders attributed to the campaign.
id	text	[en] Campaign report identifier. E-mail activity > > campaign_id
unsubscribed	float	[en] Total number of unsubscribes generated by the campaign. E-mail activity > > list_id
list_id	text	[en] Identifier of the campaign audience (list).
preview_text	text	[en] Campaign preview text shown in the inbox after the subject line.
_type	text	[en] Campaign type (e.g., regular, plaintext, rss, variate, automation).
clicks__clicks_total	float	[en] Total number of clicks in the campaign.
clicks__last_click	timestamp	[en] Date and time of the last click.
clicks__unique_subscriber_clicks	float	[en] Unique subscribers who clicked.
clicks__unique_clicks	float	[en] Number of unique clicks.
clicks__click_rate	float	[en] Click rate (clicks / delivered).
opens__last_open	timestamp	[en] Date and time of the last open recorded for the campaign.
opens__unique_opens	float	[en] Number of unique subscribers who opened the campaign.
opens__open_rate	float	[en] Open rate (unique opens / delivered emails).
opens__opens_total	float	[en] Total number of opens for the campaign (including repeat opens).
emails_sent	float	[en] Number of emails sent in the campaign.
delivery_status__enabled	boolean	[en] Whether delivery tracking is enabled.
list_stats__open_rate	float	[en] Taxa de abertura benchmark (list stats).
list_stats__click_rate	float	[en] Taxa de cliques benchmark (list stats).
list_stats__unsub_rate	float	[en] Taxa de descadastro benchmark (list stats).
list_stats__sub_rate	float	[en] Audience (list) average subscribe rate: new subscribers gained per month.
subject_line	text	[en] Subject line of the campaign email.
bounces__hard_bounces	float	[en] Emails with hard bounce (invalid/permanent addresses).
bounces__soft_bounces	float	[en] Emails with soft bounce (temporary failure).
bounces__syntax_errors	float	[en] Emails with address syntax errors.
campaign_title	text	[en] Email campaign title.

mailchimp_reports__timeseries

Campaign engagement time series (opens/clicks per hour after send). Child of reports.

Campo	Tipo
timeseries__timestamp	timestamp	[en] Date and time of the time-series data point (hourly interval after send).
timeseries__emails_sent	float	[en] Number of emails sent during the time-series interval.
timeseries__recipients_clicks	float	[en] Number of recipient clicks during the time-series interval.
timeseries__unique_opens	float	[en] Number of unique opens during the time-series interval.
campaign_id	text	[en] Email campaign identifier.
list_id	text	[en] Identifier of the campaign audience (list).

Notes

Part of this documentation was automatically generated by AI and may contain errors. We recommend verifying critical information

Add MailChimp as a data source on Kondado

Connect your MailChimp account to Kondado to replicate email marketing data into your database or data warehouse in minutes.

1

Generate a MailChimp API key

Log in to MailChimp, click your name at the top right, go to Account > Extras > API keys, then click "Create a Key". Copy the new API key value that appears at the top of the list.

2

Add the MailChimp source on Kondado

Log in to the Kondado platform, navigate to the add new data sources section, and select the MailChimp connector.

3

Configure the connection credentials

Fill in the required fields: Name (an internal label such as "Email Trigger"), Username (your MailChimp username, not your email), and API key (the key copied in step 1).

4

Start replicating your marketing data

Once connected, Kondado will replicate MailChimp tables such as Reports, Timeseries, and Email Activity so you can analyze campaigns in your destination of choice.

Frequently asked questions

What MailChimp credentials do I need to connect to Kondado?▼

You need your MailChimp username (not your email address) and an API key generated from your MailChimp account under Account > Extras > API keys.

Which MailChimp data tables does Kondado replicate?▼

Kondado replicates key MailChimp objects including Reports (campaign performance metrics), Timeseries (hourly/daily send and engagement data), and Email Activity (individual subscriber actions such as opens and clicks).

Can I use MailChimp data in a BI tool or spreadsheet?▼

Yes. After replicating MailChimp through Kondado, you can send the data to any supported destination, including data warehouses, BI tools, or spreadsheets.

What kind of marketing insights can I get from MailChimp data?▼

You can analyze campaign open rates, click rates, bounce rates, unsubscribe rates, revenue from ecommerce integrations, subscriber engagement over time, and social media performance metrics like Facebook likes.

Does MailChimp only handle email marketing data?▼

No. Although it started as an email marketing tool, MailChimp now calls itself an "All-in-one Marketing Platform" and also manages social media posts, landing pages, Facebook ads, Google Ads, and integrations with over 300 business software solutions.

Written by

Thassyo Pereira·Published 2023-07-19·Updated 2026-06-01