Analyze your Jaguar I-Pace Trips in Google Data Studio
In this blog post I share how you can create a Google Data Studio Dashboard for your Jaguar I-Pace Trips. If you own a Jaguar fossil car, you will have to do some changes to…
Read MoreGoogle Data Studio
Blend MailChimp & Google Analytics in Google Data Studio
A while ago Data Blending became available in Google Data Studio. In this blog post I share how you can blend data from MailChimp and Google Analytics. This is a 4 step process: MailChimp Campaign setup…
Get MailChimp Subscribers (Member Count) in Google Sheets
One MailChimp number you really want to have in a dashboard, are the number of MailChimp Subscribers (or Member Count as it’s called in the MailChimp API 3.0 documentation). So here is a quick blog post about how…
Get MailChimp API 3.0 Campaign Data in Google Sheets
Since Google Data Studio doesn’t have a connector to the MailChimp API, you first have to get the data into Google Sheets, and then you have to connect Google Data Studio to that sheet. Since…
Calculate Average Transactions per Day in Google Data Studio
A while ago an eCommerce store told me that their goal was to increase sales to Z. To translate that goal into a day to day KPI, the easiest explanation was this: Today your Average Order Value…