Import MailChimp Automations in Google Data Studio

November 16, 2018 - Written by

Few months ago I wrote an article focused on how to import Mailchimp Campaign data in Google Data Studio.

Now, thanks to your requests and to achieve a full implementation, I just build a new script useful to import the MailChimp Automations’ data into Google Data Studio.

How can we do this? Please follow the next steps.

Find MailChimp Automation’s ID

First of all, you have to create a new MailChimp API Key.

Please follow the path MailChimp Login > Account > Extras > API Keys > Create a Key to create and grab the key.

api keys mailchimp

Now we need to grab the Automations ID created in MailChimp. In order to do this, visit the MailChimp Playground page and insert your API Key into the  search box.

MailChimp API Playground

In the second page find “Automations” and click on it.

MailChimp API Playground Automations

Now you have access to all your automations. Click on the first Automation in order to grab the MailChimp Automations’ ID, as showed in the following screenshot:

MailChimp API Playground Automations singleID

Repeat the previous steps for each automation you have set in your account.

Import Mailchimp Automations data in Google Spreadsheet

At this point we need to create a bridge between MailChimp and Google Data Studio using another Google product: Spreadsheet.

First step: create a new file and go to Tools > Script Editor

Second step: download and copy the MailChimp automations in Data Studio into the Script Editor

Third step: insert the MailChimp API Key into the var API_KEY and put the Automations ID into the var workarr. Remember, insert the Automations ID into the []

Google Spreadsheet Automations MailChimp

Fourth step: click on Save and then click on Run (the play button)

Fifth step: accept all the authorization requests

Now your Google SpreadSheet starts to be filled with the MailChimp Automation data as:

  • Title
  • Subject
  • Opens
  • Unique Opens
  • Open Rate
  • Clicks
  • Subscribers Clicks
  • Click Rate

You can set an automation to get fresh data using the script triggers. In the script editor click on Modify > Trigger current project > Add Trigger and choose when you want to start the update.

Google Spreadsheet Automations MailChimp triggers

Import Google Spreadsheet data in Google Data Studio

The most easy part of the project is to connect the Google Spreadsheet file as a source in Google Data Studio and select which dimensions and metrics you want to represent.

Import Google Data Studio Interface

Adding more info in Google Data Studio

If you want to understand the whole mail customer journey you can merge the MailChimp data with the post click information set in Google Analytics using the Google Data Studio’s blending feature. 

Isn’t it cool, what do you think? Any suggestions are welcome!

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

  • Analytics Boosters
    Italy

    Vicolo Buranelli, 2
    31100 Treviso
    Italy


  • Analytics Boosters
    United Kingdom

    22 Long Acre, Covent Garden
    London - Greater London
    WC2E 9LY
    United Kingdom


  • Analytics Boosters
    United States

    80 S.W. 8th Street
    33130 - Miami
    Florida
    United States of America


CONTACTS

Contact us