How to Track Accordion Clicks using Google Tag Manager

How to Track Accordion Clicks using Google Tag Manager

In this post I'll show a method to track Accordion clicks in Google Tag Manager. This will allow you to see what sections within an accordion users are expanding and looking at.

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


Measure Video Views on a page in Google Data Studio

Measure Video Views on a page in Google Data Studio

In this post I'll show you how to measure video views on your website using Google Data Studio.

It's worth mentioning from the start that before we can measure the views in Google Analytics and then display this data in Google Data Studio, we need to add the YouTube video tracking in Google Tag Manager.

First up, the videos!

Read more


Making a Long Term Search Console report in Google Data Studio

Making a Long Term Search Console report in Google Data Studio

In this post I'll show you how to make some charts from a long term Search Console report in Google Data studio.

This report takes data from Google Search Console and displays in ways that might be tricky, or take some time to set up in Search Console.

Read more


Looking at Search Console Queries and Landing pages in Data Studio

Looking at Search Console Queries and Landing pages in Data Studio

In this post I'll show how to look at Search Console Queries and Landing pages and how they are related. We can do this by creating a Google Data Studio report.

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