Home > Destinations > Data Studio (ex Looker Studio) > Mailchimp

Connect Mailchimp to Data Studio (ex Looker Studio)

Connect Mailchimp to Data Studio (ex Looker Studio) and and build automated dashboards without CSV exports, spreadsheets, or manual API setup.

Looker Studio
Power BI
Google Sheets
BigQuery
Snowflake

Used by the world's leading companies

Why do agencies use Catchr for Mailchimp reporting in Data Studio (Looker Studio)?

Catchr lets media buyers and agencies stop rebuilding Mailchimp reports by hand: the data lands in Data Studio ready to chart, for every ad account you manage.

No manual csv export
‍

Stop downloading files from Mailchimp every time a client report, spreadsheet, or dashboard needs fresh numbers.

Connected in minutes

Your first Mailchimp report can be live in a few minutes. Authorize your Mailchimp account, pick your ad accounts, and your data source is ready.

Built for agencies with many Emailing accounts

Pull several Emailing accounts into one data source, then filter by account to build a report per client or brand in the same Data Studio file.

Mailchimp to Looker Studio pricing

Choose your plan by the number of platforms and accounts you report on.

Starter

For freelancers and small teams.

$ 24 /mo

Billed monthly · cancel anytime

Platforms3
Accounts10
Start free trial

Growth

For agencies managing more clients.

$ 239 /mo

Billed monthly · cancel anytime

Platforms10
Accounts100
Start free trial

Scale

For teams reporting at scale.

$ 599 /mo

Billed monthly · cancel anytime

Platforms25
Accounts500
Start free trial

How to connect Mailchimp to Data Studio with Catchr?

To connect Mailchimp to Looker Studio (Data Studio), open the Catchr connector, authorize your Mailchimp account, select the ad accounts you want to report on, then create your report.

1. Open the Catchr Mailchimp connector in Looker Studio

Click the connector link to open it inside Looker Studio. You will be asked to authorize the connector before creating your data source.

2. Authorize Looker Studio (Data Studio) and Catchr

Choose the Google account you use for Looker Studio and authorize Catchr to create a secure Mailchimp data source.

3. Connect your Mailchimp account

Sign in with your Mailchimp account that has access to the accounts you want to report on. Make sure your user has the right Mailchimp permissions.

4. Select your Mailchimp accounts

Choose one or several Emailing accounts, depending on the report you want to build.

5. Create your Data Studio report

Click Create report, then add charts, scorecards, tables, filters, and date controls using your Mailchimp metrics and dimensions.

6. Customize your dashboard

Use Emails Sent, Open Rate, Click Rate, Clicks Total, E-commerce - Total Revenue, E-commerce - Total Orders, List Member Count, Bounce rate, Campaign Title, Campaign Subject Line, Campaign Type, Campaign Send Time, Date, Member Source, Automation title, Automation Status and many more.

Mailchimp metrics and dimensions available in Data Studio

Access 85 metrics and 105 dimensions from Mailchimp connectors including Emails Sent, Open Rate, Click Rate, Clicks Total, E-commerce - Total Revenue, E-commerce - Total Orders, List Member Count, Bounce rate, Campaign Title, Campaign Subject Line, Campaign Type, Campaign Send Time, Date, Member Source, Automation title, Automation Status and more.

85

Available metrics

105

Available dimensions

Build better Mailchimp dashboards in Data Studio (ex Looker Studio)

Use Catchr to create dashboards that show what is working, what is wasting budget, and where performance is changing.

Client reporting for agencies

Create clean Looker Studio dashboards for each client with with Emails Sent, Open Rate, Click Rate, Clicks Total, E-commerce - Total Revenue, E-commerce - Total Orders, List Member Count, Bounce rate always up to date.

Budget pacing

Compare daily spend with the monthly budget of each campaign, so overspend shows up mid-month instead of on the invoice.

Review what drives results across

Compare to see where budget, traffic, or revenue is improving and where performance is dropping.

Compare with your other channels

Combine with your others marketing to understand performance across your full acquisition journey.

Keep an eye on Mailchimp performance

Track Mailchimp Emails Sent, Open Rate, Click Rate, Clicks Total, E-commerce - Total Revenue, E-commerce - Total Orders, List Member Count, Bounce rate in refreshable Data Studio dashboards so you can spot changes before they become reporting problems.

Customer testimonials

What our customers say about us.

85 %
Faster
Reporting time

After three years of use, Catchr has become essential for both our teams and our clients. So far, it has been our best solution for compiling and analyzing data from different advertising platforms. It’s easy to set up, and the customer service is responsive and excellent.

Valentin Keravel
CEO, Laio – Agency

With Catchr’s automated API, we can finally collect and centralize all advertising data, connect it with booking information, and calculate the real ROAS for our restaurant clients. It gives them full visibility, more autonomy, and the ability to optimize campaigns to maximize ROI.

Corentin Largeron
Freelance
30
hours saved

The solution is a real game changer, providing optimal time savings for our data reporting. The major strength of the solution is their highly responsive and professional support.

Corentin Largeron
CEO at The Browz – Agency

Mailchimp to Data Studio (ex Looker Studio): FAQ

Answers to common questions about connecting data to spreadsheets, dashboards, AI assistants, and reporting tools with Catchr.

How can I connect Mailchimp to Looker Studio?

Connect your Mailchimp account in Catchr, open the Catchr Mailchimp connector in Looker Studio and create a data source. Build a campaign table with sends, opens, clicks and unsubscribes. Select a completed campaign first so you can check the imported figures against its Mailchimp report before sharing the dashboard.

Which Mailchimp metrics can I report on?

Catchr includes emails sent, total and unique opens, total and unique clicks, hard and soft bounces, and unsubscribes. It also exposes campaign, audience and link information. Choose fields from the reporting level you need: a campaign summary and a link-level table answer different questions.

Why are Mailchimp opens or clicks missing from my report?

Mailchimp needs the relevant tracking enabled to record those statistics. Check the original campaign and its tracking settings before troubleshooting the dashboard. A connector cannot recreate engagement that was never tracked. Also confirm that the selected date range includes the campaign you want to analyze.

What is the difference between total clicks and unique clicks?

Total clicks include repeated activity. Unique metrics reduce repeat counting, but Mailchimp distinguishes unique links and unique subscribers, so select the field that matches your question. To assess how many recipients engaged, use a subscriber-based metric; to compare destinations within an email, use the link-level report.

Why did my open rate change after enabling bot filtering?

Mailchimp can filter Apple privacy opens and automated clicks in its reports. A filtered report may therefore show lower engagement than an unfiltered view of the same campaign. Check the filtering status on both sides before comparing, and use clicks and conversions alongside opens when evaluating results.

How can I monitor delivery problems in Looker Studio?

Show hard bounces, soft bounces and unsubscribes beside sends for each campaign. Use rates as well as counts to make large and small sends comparable. Investigate campaigns where these indicators rise together, and check the audience and delivery report in Mailchimp before deciding what caused the change.

Can I compare Mailchimp campaigns with website traffic?

Yes. Add GA4 to compare email engagement with visits and website outcomes. Use consistent campaign tags on links. Mailchimp clicks and GA4 sessions are different measurements, so compare trends and tagged campaigns rather than expecting the two totals to be identical.

Why do older Mailchimp campaign results keep changing?

Recipients can open or click a message after the send date. A campaign summary may accumulate that activity, so a later refresh can update an older campaign's figures. Compare campaigns at a similar age, such as a fixed number of days after sending, when judging which message performed better.

Still have a question?

Our team is always here to answer any questions you may have about our data connector.