How to connect MailChimp to Google Data Studio

The more efficient and effective your reporting, the sooner you can analyze the data and discover insights to improve your marketing and grow your sales.

What are the advantages of using MailChimp data in Google Data Studio, instead of just using MailChimp’s built-in analytics? 

The first reason is that Data Studio reports are easily customizable and shareable. Let’s say you have a CMO who wants to see every single bit of data in a live, interactive dashboard. And let’s also imagine you have a CEO that wants to see just the basic metrics in a PDF. Data Studio allows you to customize your reporting to exactly the information you want to show and how you want to share it. 

Another advantage of using MailChimp data in Supermetrics is that it allows you to build your own custom dimensions, custom metrics and add in additional data sources to your report. For example, you could build a dashboard using MailChimp data and also include email session data from Google Analytics in the same report. 

These are just two examples of why we recommend using Supermetrics to dive in deeper to your Email marketing campaigns from MailChimp.

Step 1: Sign up to Supermetrics for Data Studio

You first need to sign up to Supermetrics.  Supermetrics allows a free trial period, so you can test out whether it adds value to your marketing team or not.

Step 2: Create a new Data Studio report and choose MailChimp as your Data Source

The first step is creating the actual Data Studio report is to create a new report. You then need to choose ‘MailChimp by Supermetircs’ as your data source Click ‘Select’ to choose it as your data source.

Step 3: Allow Data Studio and Supemetrics to connect

The next step is to authorize Data Studio to connect to MailChimp. Data Studio requires your authorization to connect to any third party data source. Click ‘Authorize’ to continue.

Step 4: Allow Data Studio to connect to MailChimp

Once you’ve authorized Data Studio to connect to the MailChimp Supermetrics source, you’ll need to authorize MailChimp to connect to the data. Click ‘Authorize’ again.

Step 5: Connect Supermetrics to your MailChimp account

You’ll then need to login to your MailChimp account. Enter your email address / username and password and click login to continue.

You’ll then be asked to confirm which account you’ll be using. Below you can see the MailChimp account selected is ‘africa@gmail.com’. Once you see your own account there you can click ‘Ok, let’s continue’.

Step 6: Choose the Parameters of your MailChimp data

So before you add data to your report, you’ll be asked to choose which Parameters you want to add to your report. This will depend on your needs and what you need to measure, so spend some time discussing with your team what the objectives are from your Data Studio report. You have the option of choosing the Campaign or list, the reporting timezone, and Query type of your data. Once you’ve settled on what type of parameters you want for your data, click Next.

Step 7: Connect your MailChimp data to your report.

You’ll then be asked to click ‘Connect’ to add this data source to your Google Data Studio report.

Next, you will be asked whether or not you want to ‘Allow parameter sharing’. Click Allow.

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

Then you will see all the MailChimp data that will be added to your report. Take some time to look through the different dimensions and metrics that will be added. This will give you some ideas on what type of report you can build.

The final step is to add the data to the report. Simply click ‘Add to report’ and you’re done!

Step 9: Create your Google Data Studio report!

Finally, your MailChimp Data is in Google Data Studio! This gives you the freedom to create your report using your MailChimp data. Google Data Studio gives you the freedom to design different charts and tables to show the information that is important to your team. It also allows for collaboration, and is easily shareable as a live report or in PDF format. 

Image credit: Supermetrics

How to connect Facebook Ads to Google Data Studio

Connecting your Facebook Ads data to Google Data Studio allows you to customize the reporting to suit your business’ unique needs.

The more efficient and effective your reporting, the sooner you can analyze the data and discover insights to improve your marketing and grow your sales.

Unfortunately Google does not have an out of the box connector in which to pull Facebook Ads data into Google Data Studio and the only current way to achieve this is through a third party service such as Supermetrics.

Step 1: Sign up to Supermetrics for Data Studio

The first step to visualizing and analyzing your Facebook Ads data in Google Data Studio is to sign up to Supermetrics

Step 2: Create a new Data Studio report and choose Facebook Ads as your Data Source

Next, we can open up Google Data Studio and create a new report. We will then be asked to choose our data source for the report. We can select ‘Create new Data Source’. 

We can choose the ‘Facebook Ads by Supermetrics’ connector as our data source and click ‘Select’. 

If it’s your first time connecting Facebook Ads as a Data Studio data source, you’ll need to authorize Data Studio to connect. 

You’ll likely see two ‘Authorise’ buttons, one for Data Studio and one for Facebook Ads.

On the left it says that ‘Data Studio requires authorisation to use this community connector’. Click the Authorise button, and follow the instructions.

Step 3: Allow Data Studio and Supemetrics to connect

The next step is to connect your Google account to Supermetrics. As shown below, choose the Google account you wish to connect to Supermetrics. 

You’ll then be told that ‘Supermetrics wants to access your Google Account. You can click ‘Allow’.

Step 4: Allow Data Studio to connect to Facebook Ads

Once you’ve authorized Data Studio to connect to Supermetrics, you’ll need to authorize Facebook Ads to connect .

Once you click ‘Authorise’ you’ll be taken to a Supermetrics Login for Facebook Ads screen. You’ll need to click ‘Continue with Facebook’. 

You then log into your Facebook account using your email or phone number and password.

You’ll then see a screen saying that ‘Supermetrics would like to access your Facebook ads and related stats’. Click ‘Ok’ to continue. 

Step 5: Add your Facebook Ads data source to Google Data Studio.

Finally, after all the authorizing and clicking we can add our data. However, before we add our data we need to choose some options around the Parameters of our data.

How you choose these parameters will be up to you and the type of visualization you’d like to build in Data Studio. I’d recommend checking the option to allow the parameters to be modified in the reports.

You’ll then see all the different dimensions and metrics in your Facebook Ads data source!

The final step for adding your data is to click ‘Add to report’!