When I learned that someone had Reversed Engineered the Jaguar InControl API, I thought it would be fun to see if I could connect Google Sheets to the API, and download the trips from my Jaguar I-Pace for…
Read More
This is a follow up to the blog post How to Download your Jaguar InControl Trips to Google Sheets. In this blog post I explain what information you get about your trips, which part of the…
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…
Tracking Internal Link Clicks as Google Analytics Events isn’t something new, and there are many reasons for doing so: Prioritizing of content blocks on front page Ordering of Menu Links based on popularity or sales…
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…
The solution I’m describing in this blog post started with several cases where Enhanced Ecommerce Product Values (Product Name, Category etc.), had to be tracked in DoubleClick as Custom Variables. This means that the data…
Google Optimize is my favourite tool for A/B testing. One reason is the integration with Google Analytics. Another reason is that a good Google Tag Manager implementation gives you a really flexible toolset for Google Optimize targeting….
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…
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…
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…