How to Measure Accordion Clicks in Google Data Studio

How to Measure Accordion Clicks in Google Data Studio

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


Measure-Customer-Acquisition-Cost-by-Channel-in-Google-Data-Studio (1)

Measure Customer Acquisition Cost by Channel in Google Data Studio

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


Make a Compact Data Studio Report using Optional Metrics and Drill Downs

Make a Compact Data Studio Report using Optional Metrics and Drill Downs

Recently Google Data Studio introduced Optional Metrics. These allow you to pick and choose what metrics to display on each chart.

Read more


How to create a five year Currency Exchange Rate report in Google Data Studio

How to create a five year Currency Exchange Rate report in Google Data Studio

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


Displaying AI Generated Faces in Data Studio

Displaying AI Generated Faces in Data Studio

There's a fantastic new website called "This Person Does Not Exist" that displays AI generated faces.

Read more


How to add Dynamic Page Links in Google Data Studio

How to add Dynamic Page Links in Google Data Studio

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 more


A Daily Analytics dashboard in Google Data Studio

A Daily Analytics dashboard in Google Data Studio

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


An overview of all Google Data Studio Chart types in 2019

An overview of all Google Data Studio Chart types in 2019

In this post I'll give a run down of all the different Google Data Studio chart types in 2019.

Google Data Studio is constantly changing and improving, and it is adding new features all the time!

So this can serve as a overview of the different default Google Data Studio chart types in 2019.

Read more


Using Google Data Studio’s new Hierarchy feature to Drill Down into Regions and Cities

Using Google Data Studio's new Hierarchy feature to Drill Down into Regions and Cities

There's been lots of exciting new features added for Data Studio in the past few days! One of the new features launched for Data Studio include a Hierarchy feature.

Many of them have been launched at the Google Cloud Next conference in San Francisco.

Read more


Creating an Avengers Dashboard in Data Studio Part 1

Creating an Avengers Dashboard in Google Data Studio: Part 1

Since Avengers: Endgame is almost upon us, I thought why not look back at the previous Marvel Cinematic Universe movies using Google Data Studio.

Since 2008, Marvel has released 21 films featuring their iconic superhero characters. I thought that for the first dashboard, I'd take a look at each film individually.

Read more