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

Click on the top right where your name is
In the menu that will open, 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 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

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)

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