How to Connect Mailchimp to Google Data Studio

February 16, 2021

Although Mailchimp already offers analytics inside their platform, there are many reasons why you might want to get Mailchimp data into Google Data Studio. The most obvious of these is that you can get all of your data into one report, combining Google Analytics data with your Mailchimp email marketing data.

You can then use Google Data Studio to create powerful report visualizations, merging data from all of your different data sources. In this article, we will show you exactly what you need to do to get started doing that. Read on to find out how you can get your Mailchimp email marketing data into Google Data Studio - in less than 5 minutes to boot.

Custom Connectors

Before we get into the details, let’s first understand the concept of custom connectors for Google Data Studio. By default, Google Data Studio provides a handful of connectors that allow you to bring in data - some examples of these are Google Analytics or Google Sheets. But once you want to bring in data from somewhere besides a Google application, you need to rely on a custom connector.

A custom connector is essentially a small software service that connects to a data source’s API and pulls that data into a Google Data Studio report based on whatever criteria the user sets.

Custom connectors are built by people in the Google Data Studio community who want to expand the options of data sources that people can bring into Data Studio and most are paid rather than free software, since it takes quite a bit of effort to build up to the specifications that Google demands.

You can browse all of the different custom connectors that have been approved by Google in their connector gallery here.

Google Data Studio Connector Gallery

Step 1: Pick the Custom Connector that’s best for you

Depending on the data source, there may be multiple connectors available - so you should be sure to research the different options. For Mailchimp, there are essentially 3 different options: Supermetrics, Power My Analytics, and our own Custom Connector that we created here at Epilocal.

Obviously we are biased, but here’s the key points that we think separate the three different connectors:

  • Power My Analytics is a data-warehouse solution, which means they take your Mailchimp email marketing data to their server first before sending it to Google Data Studio. This makes sense if you have lots of data sources you want to blend together before the data gets to your Google Data Studio report - but if that’s not the case for you, this is probably too heavyweight of a solution.
  • Supermetrics is more lightweight but still aimed at users who are looking to combine several different data sources. Their pricing is steep for one data-source at €49 / month and only begins to make sense if you can take advantage of their Pro-plan which is €126 / month for 33 data sources.
  • Our Mailchimp Data Studio Connector is meant to be the lightest weight solution of all - we charge just a flat-rate of $15 / month or $120 / year. We don’t move your data to our server the way Power My Analytics does and we aim to be more affordable than Supermetrics for people who have less complex data needs. One disadvantage compared to the others is that we don’t yet offer a free trial, but we do offer 30-day no questions asked refunds.

Going forward in this article, we will show you how to connect your data with our Epilocal Mailchimp Data Studio Connector. However, if you think one of the other connectors will be more suited to your needs, no hard feelings - and there are other tutorials out there that will show you how to set them up.

Step 2: Get your License Key for the Epilocal Mailchimp Data Studio Connector

As we mentioned before, the Epilocal Mailchimp Data Studio Connector doesn’t take your data to our own server as an intermediary, so there is no additional account you need to sign up for. You just need to get a license key that will enable you to set-up Mailchimp as a data source in Google Data Studio.

When you buy a subscription on this page, you will receive an email from Gumroad that has your license key inside of it. Keep this close-by for the next steps.

Gumroad Email with License Key

Step 3: Add the Custom Connector as a new data-source in Google Data Studio

Now that you have your license key email, you will open up Data Studio and create a new data-source.

Add New Data Source

This will bring you to the Google Data Studio Connector Gallery. Then you just need to find the Mailchimp by Epilocal connector and click on it.

Connector in Gallery

Step 4: Set-up the Connector

Once you add the Mailchimp by Epilocal connector, you will be prompted to set it up. The steps are pretty easy and there are clear instructions at every step.

First, you will give the connector permission to access your Google account. If you have multiple Google email accounts, pick the one that you use for working in Data Studio.

Google Authorization

Next, you will be prompted to enter your Epilocal license key. Just copy and paste the code that you had received from the Gumroad email previously and click submit.

Enter License Key

Finally, you just need to connect your Mailchimp account to Data Studio. To do this, you will be prompted to login to your Mailchimp account using your usual username and password.

Connect Mailchimp Account

After this step, you should see the “Connect” button in the upper right corner of Data Studio turn blue - your set-up is now complete and you just press this button to add your Mailchimp data as a data-source.

Step 5: Start using your Mailchimp data in Data Studio reports

Once your connector is set-up you will be able to browse all of the different dimensions and metrics that are available. Each one has a description so you can get an idea of what fields you might want to use in your report.

Data Studio Fields

Now you can either start from a blank slate and begin building your own Data Studio report using Mailchimp data, or you can start with our free template to get you going.

Free Data Studio Template

Wrap-up

And that’s it - that’s all it takes to connect Mailchimp to your Google Data Studio account using the Mailchimp connector by Epilocal. You can now use all of Data Studio’s powerful visualization features on your Mailchimp email marketing data as well as mix and match with other sources such as Google Analytics or Google Ads.

Want more analytics tips for small publishers?

We are planning additional content coming soon so be sure to subscribe to our mailing list.