How to map Growth in Google Analytics sessions by Country in Data Studio

Google Data Studio has always had the ability to add in a comparison column to tables, but not to map out a change in values on a map. Ideally I would want to be able to see which countries have seen the highest rates of growth over a period of time. This is a method that worked for me and hopefully it will be useful for you too!

Read more


How to use DATE_DIFF in Google Data Studio to work out Sessions per Day

How to use DATE_DIFF in Google Data Studio to work out Sessions per Day

So one thing I've wanted to do for a while is to determine how many sessions each blog post has had since they were published. Since the URLs of my blog posts contain the date they were published, I tried to work this out using regex and some other methods. It got a bit messy and wasn't very accurate.

Read more


Change Bubble Size and Colour in a Google Data Studio Map using Parameters

Change Bubble Size and Colour in a Google Data Studio Map using Parameters

In this post I'll show how you can change Bubble Size and Colour in a Google Map in a Data Studio report. This method using two parameters to let you switch between which metrics are displayed on the map.

Read more


How to change Google Map metrics using a Parameter in Data Studio

How to change Google Map metrics using a Parameter in Data Studio

In this post I'll show you a method for how to change Google Map metrics using a Parameter in Google Data Studio.

Read more


Use Parameters to change Column Dimensions in Google Data Studio

Use Parameters to change Column Dimensions in Google Data Studio

In this post I'll show a method for using Parameters to change Column Dimensions in Data Studio.

Read more


How to switch Google Map dimensions using a Parameter in Data Studio

How to switch Google Map dimensions using a Parameter in Data Studio

So in this post I'll share a method for switching Google Map dimensions using a Parameter in Google Data Studio. Parameters were recently introduced in Data Studio and have many use cases!

Read more


How to create a simple Forecast Parameter in Google Data Studio

How to create a simple Forecast Parameter in Google Data Studio

In this post I'll give an example of how to create a simple Forecast Parameter in Google Data Studio, which recently added Parameters to their product. This is a big improvement, and I'm still figuring out how to use them properly.

Read more


Use a Constant Value to make a Goal dashboard in Google Data Studio

Use a Constant Value to make a Goal dashboard in Google Data Studio

So in this post I'll show you how to create a Constant Value in Google Data Studio, and give you a practical example of how you can use a constant value to create a Goal dashboard.

Read more


Create Revenue Targets in Google Data Studio using CASE statements

Create Revenue Targets in Google Data Studio using CASE statements

I had been looking for a way to create Revenue Targets in Google Data Studio, and tested out a method using CASE statements that works. So thought I'd share it!

Read more