Import MailChimp Automations in Google Data Studio

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.

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.

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

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:

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 []

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.

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.

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!