In this post I’ll show you how to analyse sales data using Google BigQuery and Google Data Studio.Read More
In this post I’ll show you how to make a simple Ecommerce dashboard in Google Data Studio. This report gives you a quick overview of how your online store is performing.Read More
In Data Studio we can use CASE statements to create our own segments, but there is also the option to use pre-existing segments that we’ve created in Google Analytics.Read More
In a previous post I described how you can Track Accordion Clicks using Google Tag Manager. In this post I’ll show how you can measure accordion clicks in Google Data Studio.Read More
Customer Acquisition Cost is an important metric to understand the return on investment you’re getting from different marketing channels.
With some marketing channels you can see exactly how much it has cost to get a conversion. However, some other channels can be more complex. If a website visitor found your company’s blog post while searching on Google and then converted, how much did it cost to acquire that customer?Read More
Recently Google Data Studio introduced Optional Metrics. These allow you to pick and choose what metrics to display on each chart.Read More
In this post I’ll show you how to make Currency Exchange Rate report in Google Data Studio showing five years worth of data.
Before I begin I owe a big thank you to Lee Hurst, who helped me figure out how to fix some issues in Google Sheets.Read More
Google added a new feature recently, the ability to add Dynamic Page Links in Google Data Studio. This looks to be a great new feature, and makes linking between multi-page reports much easier.
Thanks to Pat Strickler for first spotting these and sharing the update on Twitter!Read moe
In this post I’ve created a Daily Analytics Dashboard in Google Data Studio. Although it shows the performance of the past week, I call it a ‘Daily Dashboard’ because its the type of dashboard I would like to check it with daily.
I wanted to make something that showed the performance of the website so far that day, and for the previous week.Read More