How to use Conditional Formatting in Google Data Studio

How to use Conditional Formatting in Google Data Studio

Today I'll take a first look at the recently launched Conditional Formatting in Google Data Studio.

Read more


A Top Content report in Google Data Studio

How to make a Top Content report in Google Data Studio

In this post I'll show you how to make a top content report in Google Data Studio. This report shows you how the top pages on your site perform, based on your choice of sessions, users, page views, bounce rate or average time on page.

Read more


How to Compare Google Analytics segments in Data Studio

How to Compare Google Analytics segments in Data Studio

In this post I'll show you how you can compare Google Analytics segments in Google Data Studio.

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


Humans of Data Studio (2)

Humans of Data Studio

Some fun with Data Studio, making a Humans of New York style report with a face, a location and a quote.

Read more


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


Using the Extract Data connector in Google Data Studio

Using the Extract Data connector in Google Data Studio

In this post I'll look at the Extract Data connector in Google Data Studio.

After posting a poll on Twitter, it seems not too many people actually use the extract data function.

I'll show you the steps to follow to extract the data, as well as how it can impact the speed of your reports.

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


Worlds worst data studio report

The World's Worst Data Studio Report

I'm always looking at ways to improve the look and feel of my Data Studio reports.

In this case wanted to do the exact opposite and make one that was hideously ugly and impractical.

Read more


See what Days of the Week people visit your site using Google Data Studio

See what Days of the Week people visit your site using Google Data Studio

Ever wondered what day of the week people are visiting your site? This report I created using Google Data Studio lets us know that.

In this post I'll show you how to create a report letting you see what Days of the Week people are visiting your website.

Read more