Connect MailChimp to Google Data Studio in 10 Easy Steps

mailchimp data studio dashboard

MailChimp is the world’s largest email marketing platform, helping millions of businesses send fantastic email campaigns.

It’s simple to use and offers many features to help you get your message out there.

You can create beautiful email campaigns, create custom templates to make your campaigns look amazing, and track your results using its analytics features.

So, since MailChimp has analytics features, why do you need a google data studio mailchimp connection, you might ask?

One reason is the convenience it provides to get all of your data into one report, including data from Google Analytics, Facebook Ads, Microsoft Advertising, etc.

When you successfully connect to Google Data Studio, you can create an all-in-one report visualization, integrating data from your different data sources.

The more efficient your reporting on Google Data Studio, the better you can evaluate the data and discover insights to help your email marketing campaigns and boost sales.

This blog post will show you how to connect MailChimp to Google Data Studio in 10 Easy Steps via and how can help you create better reports.

Let’s dig in!

Table of content: 

1- Introduction to Google Data Studio MailChimp connector

2- Custom connectors

3- Dashboard overview

4- Available metrics

5- Wrapping up

Introduction to Google Data Studio MailChimp connector’s Google Data Studio MailChimp connector is a great tool that you can use to seamlessly bring your MailChimp email marketing campaigns data into Google Data Studio for proper report visualization and analysis.

Google Data Studio, on the other hand, is a robust data analysis and visualization tool that you can explore and interact with data.

However, it can be challenging to connect to different data sources and comprehensively visualize data without a custom connector.

To make data analysis and visualization easier, Google released several custom connectors for Data Studio.

These allow you to connect to different data sources, including Google Sheets, Google Ads Manager, Google Cloud Storage, Google Analytics, etc.

But suppose you want to bring in data from sources such as Salesforce, or Facebook Ads, which is not a Google application, into Google Data Studio.

In that case, you will need a custom connector like that meets Google’s requirements.


Custom connectors

Google Data studio connectors

There are many connectors on the market, but what makes a custom connector stand out is the fact that it is designed specifically for a given application, often using custom designs and processes.

A Custom Connector such as is a software that allows a data source’s API to connect to a flow and send data into a Google Data Studio report for easy visualization and analysis based on user-defined criteria.

You can use Custom connectors with various applications compatible with iOS and Mac platforms.

There are several ways to use custom connectors; for instance, you may use it to sync data from your MailChimp email list into Google Data Studio for analysis or automatically update a Google Sheet.

Dashboard Overview

Data studio Mailchimp template

The image above is an overview of a connected MailChimp to Google Data Studio via, showing campaign type, open rate, CTR, and unique subscriber clicks, among other essential data metrics.

This Mailchimp Data Studio report helps you visualize your Mailchimp campaign data in Google for easy reporting and analysis.

We have added three pages to it.

  • Lists
  • Regular Campaigns
  • Unsubscribes

To keep the dashboard simple, we’re only using a few of the available dimensions available in our connector. The whole list of supported metrics and dimensions is down below.

Available metrics and dimensions in this dashboard




Abuse Reports


The number of abuse reports generated for this campaign.

Campaign ID


A string that uniquely identifies this campaign.

Campaign Title


The title of the campaign.

Campaign Type


The type of campaign (regular, plain-text, ab_split, rss, automation, variate, or auto).

Click Rate


The number of unique clicks divided by the total number of successful deliveries.

Clicks Total


The total number of clicks for the campaign.



The Date (copy of send_time, but this represents date only with no time)

Emails Sent


The total number of emails sent for this campaign.

Forward Count


How many times the campaign has been forwarded.

Forwards Opens


How many times the forwarded campaign has been opened.

Last Click


The date and time of the last recorded click for the campaign in ISO 8601 format.

Last Open


The date and time of the last recorded open in ISO 8601 format.

List ID


The unique list id.

List Is Active


The status of the list used, namely if it’s deleted or disabled.

List Name


The name of the list.

Open Rate


The number of unique opens divided by the total number of successful deliveries.

Opens Total


The total number of opens for a campaign.

Preview Text


The preview text for the campaign.

RSS Last Send


For RSS campaigns, the date and time of the last send in ISO 8601 format.

Send Time


The date and time a campaign was sent in ISO 8601 format.

Subject Line


The subject line for the campaign.

Unique Clicks


The total number of unique clicks for links across a campaign.

Unique Opens


The total number of unique opens.

Unique Subscriber Clicks


The total number of subscribers who clicked on a campaign.



The total number of unsubscribed members for this campaign.



The URL for the link in the campaign.

Url Campaign Id


The campaign id.

Url Click Percentage


The percentage of total clicks a link generated for a campaign.

Url Id


The unique id for the link.

Url Last Click


The date and time for the last recorded click for a link in ISO 8601 format.

Url Total Clicks


The number of total clicks for a link.

Url Unique Click Percentage


The percentage of unique clicks a link generated for a campaign.

Url Unique Clicks


Number of unique clicks for a link.

To connect MailChimp to Google Data Studio via, follow the steps below.

Step 1: Sign up to

Start free trial

I will assume that you already have a Google account and a MailChimp account.

If you don’t have an account, quickly open a Gmail account and an account with MailChimp, and then head over to to sign up. offers a 30-day free trial to allow you to see how convenient and efficient your marketing data report becomes when you use the platform.

Step 2: Connect with data google data studio

Once you have registered an account with, click on the “To use with data studio click here” option.

Also, make sure you are logged in with the Google username in Data Studio that you want to use.

Step 3: Set up your Google account for MailChimp Google Data Studio

Google account mailchimp

After you click on “use with data studio,” this action will redirect you to Google Data Studio Connector Gallery.

If you have not set up your Google account, a prompt will appear on Google Data Studio asking you to complete your account setup, as shown in the image above.

At this stage, you can choose or change the Google account you want to use for the marketing data report.

Step 4: Create a new Data Studio report

 Data studio create data source

Once you have chosen the Google account you want to use, a new page opens up in Data Studio, where you can create a new Data Studio report.

Click on create and then on data source as shown on the image above.

Step 5: Add Google Data Studio MailChimp Connector

google data studio mailchimp

After clicking on “create” and on “data source” on Data Studio, the Google Data Studio Connector Gallery page opens up. Search for Mailchimp by connector and click on it.

Step 6: Authorize the Connector

Mailchimp account authentication

The next step is to authorize the connector to access the Google account you want to use when you sign up for the free trial.

Once you click on authorize, a Google authorization prompt pops up requesting that you sign in to your Google account.

allow acces mailchimp account

After you sign in, a new prompt pops up requesting that MailChimp by gets access to your Google Account.

Click on allow.

Step 7: Grant MailChimp authorization to Data

authorize access mailchimp

After giving MailChimp by access to your Google Account, you need to provide MailChimp with authorization to connect to Data.

Click on the blue authorization button as shown in the image above.

Clicking on authorize opens up a new window that takes you to the onboarding page.

Step 8: Grant MailChimp authorization via

Api key mailchimp

On the onboarding page, you get access to all of the data sources on Here, you can then grant access to Google Analytics, Linkedin Page, or any data sources that you want to use.

To view other data sources on, click on the setting icon. The link you will click from Data Studio takes you directly to the MailChimp onboarding page on

You’ll be required to input an API Key to grant access to this page. Without an API key, you won’t be able to import data from MailChimp into Data Studio via

You can create a secret API key in your Mailchimp account.

Step 9: Connect your MailChimp data to your Google Data Studio report.

Data destination google data studio

After granting access, a new page opens up that requires you to select the data destination. And since we are connecting MailChimp to Data Studio, select Google Data Studio as the data destination and click connect on the Google Data Studio page that opens up.

Step 10: Add your MailChimp data to your Data Studio report

add fields google data studio

Once you are connected, it is easy to use the template for MailChimp and get all the data into the Data Studio and create a report.

Once you have the data in Data Studio, you can customize it with whatever metrics and dimensions you want and then click “create report.”

Mailchimp data studio template

This “create report” action then pulls in the data in the Data Studio for easy visualization, reporting, and analysis that you can share or collaborate with your team on.

Wrapping Up

Now that you have seen how easy it is to connect MailChimp to Google Data Studio in just a few minutes, let’s take a few seconds to discuss why you should get on board with this now and how can help you create better reports.

I mentioned earlier that connecting MailChimp to Google Data Studio provides convenience.

As a Data analyst, Data scientist, or digital marketer, getting all of your data in one place makes it easier to create meaningful reports, visualizations, and analyses that can better inform you and your team on performance, providing insights for improvement.

Using Google Data Studio via makes achieving that easy.

Connecting platforms that are not an application by Google, such as Facebook Ads, Salesforce, Stripe, and Twitter Ads, to Google Data Studio

would require a custom connector that meets Google requirements, such as custom connectors.

For example, to get MailChimp to Google Data Studio, you need the MailChimp connector.

When you get on board with, it is easier for you to customize, collaborate, and share reports with your team and management. For instance, let’s assume it’s been seven days since you launched a new email campaign to your organization’s recent email subscribers.

Now your CMO wants to get a report on the performance of the campaign in the last week in a live, interactive dashboard, and your CEO wants to see the basic metrics, but in PDF form.

Google Data Studio allows you to do both. You will be able to easily customize your reporting and share the information with each person based on the agreed criteria.

How can help you create better reports

It would be quite time-consuming to create a template for your marketing report from scratch. makes it easier by offering a variety of templates that allow you to create reports in just a few simple steps.

Once you have successfully connected MailChimp to Data Studio, all that is required of you is to select the template that suits your needs. In the case described, you will select Google Data Studio Mailchimp template.

This Google Data Studio Mailchimp template helps you get a one-page overview of your email campaign’s performance. Further, you can customize the metrics and dimensions you want within the template.

You can build templates with custom metrics and blend other data sources into your report.

For example, you could build a dashboard using MailChimp data and also blend in email session data from Google Analytics in the same report.

You can also add your organization’s logo and have a nice-looking report that is ultimately yours.

Just select the data source, copy and use it easily! offers a 30-day free trial, so you can get to see how convenient it is using MailChimp Google Data Studio.

To get started, please visit

To get other channels connected and visualised please check out our Template Gallery.