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:
- Unique Opens
- Open Rate
- 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!
Vicolo Buranelli, 2
41 Devonshire Street
80 S.W. 8th Street
33130 - Miami
United States of America