Try our plataform
MailChimp

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 it is possible to build email layouts, segment lists, automate shots and not only that, in recent years the platform has evolved to call itself an "All-in-one Marketing Platform", giving the possibility to the user to promote your business also through social media, landing pages, Facebook ads and Google Ads, in addition to having pipeline with more than 300 business software.

With so many features, the amount of insights that the generated data can give marketing teams is countless.

Adding the data source

To replicate MailChimp with 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

  1. Click on the top right where your name is
  2. In the menu that will open, click on “Account”

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

  1. In the middle section, click on “Extras”
  2. In the menu that will open, click on “API keys”

3) On the new page, you will see a list of your existing API Keys. Click on “Create a Key”

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

5) Login to Kondado platform

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

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

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

Pipelines

Relationship Chart

Gráfico de relacionamento entre tabelas

Reports

Main Object

Field Type

forwards__forwards_count

float

forwards__forwards_opens

float

abuse_reports

float

facebook_likes__facebook_likes

float

facebook_likes__unique_likes

float

facebook_likes__recipient_likes

float

list_is_active

boolean

send_time

timestamp

list_name

text

industry_stats__open_rate

float

industry_stats__click_rate

float

industry_stats__unsub_rate

float

industry_stats__abuse_rate

float

industry_stats__bounce_rate

float

industry_stats__type

text

industry_stats__unopen_rate

float

ecommerce__total_spent

float

ecommerce__total_revenue

float

ecommerce__currency_code

text

ecommerce__total_orders

float

id

text

unsubscribed

float

list_id

text

preview_text

text

_type

text

clicks__clicks_total

float

clicks__last_click

timestamp

clicks__unique_subscriber_clicks

float

clicks__unique_clicks

float

clicks__click_rate

float

opens__last_open

timestamp

opens__unique_opens

float

opens__open_rate

float

opens__opens_total

float

emails_sent

float

delivery_status__enabled

boolean

list_stats__open_rate

float

list_stats__click_rate

float

list_stats__unsub_rate

float

list_stats__sub_rate

float

subject_line

text

bounces__hard_bounces

float

bounces__soft_bounces

float

bounces__syntax_errors

float

campaign_title

text

timeseries

Field Type

timeseries__timestamp

timestamp

timeseries__emails_sent

float

timeseries__recipients_clicks

float

timeseries__unique_opens

float

campaign_id

text

list_id

text

Email Activity

Main Object

Field Type

email_id

text

campaign_id

text

list_is_active

boolean

list_id

text

email_address

text

activity

Field Type

activity__action

text

activity__ip

text

activity__timestamp

timestamp

list_id

text

campaign_id

text

email_id

text

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·Published 2023-07-19·Updated 2026-04-25