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 Windsor.ai and how Windsor.ai can help you create better reports.

Let’s dig in!

Table of content: 

1- Introduction to Google Data Studio MailChimp connector

2- Custom Windsor.ai connectors

3- Dashboard overview

4- Available metrics

5- Wrapping up

Introduction to Google Data Studio MailChimp connector

Windsor.ai’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 Windsor.ai that meets Google’s requirements.

 

Custom Windsor.ai connectors

Google Data studio Windsor.ai 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 Windsor.ai 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 Windsor.ai 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 Windsor.ai, 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

Name

Type

Description

Abuse Reports

NUMERIC

The number of abuse reports generated for this campaign.

Campaign ID

TEXT

A string that uniquely identifies this campaign.

Campaign Title

TEXT

The title of the campaign.

Campaign Type

TEXT

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

Click Rate

NUMERIC

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

Clicks Total

NUMERIC

The total number of clicks for the campaign.

Date

DATE

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

Emails Sent

NUMERIC

The total number of emails sent for this campaign.

Forward Count

NUMERIC

How many times the campaign has been forwarded.

Forwards Opens

NUMERIC

How many times the forwarded campaign has been opened.

Last Click

DATE

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

Last Open

DATE

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

List ID

NUMERIC

The unique list id.

List Is Active

TEXT

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

List Name

TEXT

The name of the list.

Open Rate

NUMERIC

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

Opens Total

NUMERIC

The total number of opens for a campaign.

Preview Text

TEXT

The preview text for the campaign.

RSS Last Send

DATE

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

Send Time

DATE

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

Subject Line

TEXT

The subject line for the campaign.

Unique Clicks

NUMERIC

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

Unique Opens

NUMERIC

The total number of unique opens.

Unique Subscriber Clicks

NUMERIC

The total number of subscribers who clicked on a campaign.

Unsubscribed

NUMERIC

The total number of unsubscribed members for this campaign.

Url

TEXT

The URL for the link in the campaign.

Url Campaign Id

TEXT

The campaign id.

Url Click Percentage

NUMERIC

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

Url Id

TEXT

The unique id for the link.

Url Last Click

DATE

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

Url Total Clicks

NUMERIC

The number of total clicks for a link.

Url Unique Click Percentage

NUMERIC

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

Url Unique Clicks

NUMERIC

Number of unique clicks for a link.

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

Step 1: Sign up to Windsor.ai

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 Windsor.ai to sign up.

Windsor.ai offers a 30-day free trial to allow you to see how convenient and efficient your marketing data report becomes when you use the Windsor.ai platform.

Step 2: Connect Windsor.ai with data studiowindsor.ai google data studio

Once you have registered an account with Windsor.ai, click on the “To use Windsor.ai 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 Windsor.ai 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 Windsor.ai 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 Windsor.ai 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 Windsor.ai gets access to your Google Account.

Click on allow.

Step 7: Grant MailChimp authorization to Data

authorize access windsor.ai mailchimp

After giving MailChimp by Windsor.ai 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 Windsor.ai onboarding page.

Step 8: Grant MailChimp authorization via Windsor.ai

Api key mailchimp

On the Windsor.ai onboarding page, you get access to all of the data sources on Windsor.ai. 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 Windsor.ai, click on the setting icon. The link you will click from Data Studio takes you directly to the MailChimp onboarding page on Windsor.ai.

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 Windsor.ai.

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 Windsor.ai 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 Windsor.ai 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 Windsor.ai custom connectors.

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

When you get on board with Windsor.ai, 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 Windsor.ai can help you create better reports

It would be quite time-consuming to create a template for your marketing report from scratch. Windsor.ai 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!

Windsor.ai 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 Windsor.ai.

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