Connect your data to Claude in 1 minute. No code needed Try it now

Connect Mailchimp to Data Studio

Send Mailchimp campaigns, audience (list of contacts), audience activity and 7 more data types to Data Studio on a schedule. Pick the audience, pick columns, filter by date and narrow it down by status. Refresh as often as every 15 minutes.

capterra
star star star star star

4.9/5

Mailchimp report Data source: Mailchimp
Build Data Studio reports on Mailchimp data that Coupler.io keeps up to date.
Trusted by 200K+ users worldwide
Tradezella
Stanford
Webtoon
Getir
Stellar
Anker
ParentSquare
Bac 50
Benzinga
Matterport

How to connect Mailchimp and Data Studio

6 steps. You can preview the Mailchimp data in Coupler.io before anything reaches Data Studio.

Step 1 of 6

Connect Mailchimp

Sign in to Mailchimp and authorize Coupler.io. There's no API key to copy.

Sign in with Mailchimp

Step 2 of 6

Choose what to export

Pick the Mailchimp data you want in Data Studio.

Show 2 more data types Show fewer data types
AudienceNot setSelect audience to import data for.

Step 3 of 6

Fine-tune the export

Optional settings for this Mailchimp export.

Created after dateAny dateSpecify the data entity creation date to export data added after this date (e.g. after 2020-01-01 09:00).
Created before dateAny dateSpecify the data entity creation date to export data added before this date (e.g. before 2020-01-01 09:00).
Sent since dateAny dateSpecify date to export data about campaigns sent after this date (e.g. after 2020-01-01 09:00).
Sent before dateAny dateSpecify date to export data about campaigns sent before this date (e.g. after 2020-01-01 09:00).
Show 2 more fields Show fewer fields
StatusNot set
Advanced filtersNot set

Step 4 of 6

Pick columns

Keep only the columns you need, so the report stays easy to work with.

ColumnsNot setSpecify the names of the columns and their order by entering each of them in a new line.

Step 5 of 6

Connect Data Studio

Click Generate Data Source and authorize Data Studio and Coupler.io with the same Google account. After the first run, open the report and add your Mailchimp fields.

Date range dimensiondateOptional. A DATE or DATETIME column for date filters
Report/data source URLhttps://lookerstudio.google.com/reporting/abc123Optional, in Advanced settings. Links an existing report
Fields groupingOffOptional. Groups fields named [Group]: [Field]

Step 6 of 6

Choose a write mode and schedule

Every run either replaces or appends the data in Data Studio. Run it as often as every 15 minutes.

Write mode

Each run overwrites the data set with a fresh snapshot of Mailchimp data.

Get the most of Mailchimp to Data Studio integration

Gather data icon

Gather data

Export data from numerous apps and sources into a single destination. Blend data from different apps to get a single source of truth.
Understand data icon

Understand data

Preview, transform, sort, and filter data for better clarity in just a few clicks in the Coupler.io interface. Take your data analytics to the next level.
Automate data icon

Automate data

Access data that is always up to date by enabling the automatic data refresh on a schedule as often as every 15 minutes and using triggered automation.
Act on data icon

Act on data

Visualize your data by quickly connecting to data visualization and BI tools. Build insightful dashboards in a breeze and make better decisions.
Mailchimp to Data Studio questions

10 data types, including Campaigns, Audience (list of contacts), Audience activity, Audience clients and Audience growth history.

You sign in to Mailchimp and authorize Coupler.io. There's no API key to copy.

Yes. Filter by created date or sent date to load the period you need.

Yes. Pick the columns you need, and only those reach Data Studio.

Yes. Available filters include status. You can also add your own filter conditions.

Through the Coupler.io community connector. Authorize Coupler.io and Data Studio with the same Google account, then add the Mailchimp data source to a report.

Coupler.io and Data Studio refresh separately, and Data Studio refreshes data sources every 12 hours by default. Lower its data freshness setting if you refresh Mailchimp more often.

On a schedule you choose, from monthly down to every 15 minutes, depending on your Coupler.io plan.

Yes. Add more sources to the same data flow, for example GoHighLevel or Google Ads, and join or append them before the data reaches Data Studio.

High five for scrolling till the very end!
See you in the app!