Create Custom Channel Groupings in Google Data Studio using CASE statements

In this post I'll discuss how to create custom channel groupings in Google Data Studio using CASE statements.

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


How to build a Page Engagement dashboard in Google Data Studio

How to build a Page Engagement dashboard in Google Data Studio

I made this page engagement dashboard a while back, and thought I'd share it. It's based on Google Analytics data and aims to give you an overview as well as a breakdown of how your pages are performing.

Read more


Drilling Down into Data in Google Data Studio

Drill Down into Data in Google Data Studio

In this post I'll give some examples of how you can drill down into data using Google Data Studio. This means you can examine multiple dimensions in one chart, meaning you can have more interactive tables and charts in your reports!

Read more


A simple Google Analytics report template in Data Studio

A simple Google Analytics report template in Data Studio

In this post, I'll just be sharing a simple Google Analytics report template I created in Google Data Studio.

Read more


Cover image for How to automatically adjust dimensions in google data studio

How to automatically adjust Dimensions in Google Data Studio

In this post I'll show you have to automatically adjust Dimensions in Google Data Studio.

What I mean by this is that I'll show you how to set up a custom Dimension that changes based on another dimension.

I have to admit I wasn't clever enough to think this up on my own, and saw the brilliant Mehdi Oudjida show the method 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


Creating-an-Avengers-Dashboard-in-Data-Studio-Part-2

Creating an Avengers Dashboard in Google Data Studio: Part 2

If you liked my previous post about the Marvel Cinematic Universe, I hope you'll enjoy this follow-up blog post!

In this post I've put together some charts in Data Studio looking at the critical ratings and box office gross of the Avengers franchise and other Marvel Cinematic Universe movies.

Read more


Two Methods for displaying Year on Year Channel Data in Google Data Studio

Two Methods for displaying Year on Year Channel Data in Google Data Studio

In this blog post I'm going to show you two methods for displaying year on year Google Analytics Channel data in Google Data Studio.

The Data Studio report I've created is below.

Read more