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.…

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! I’ll show you some examples of how to use the Drill Down function in…

List of Blog posts shared by Google Analytics

I’ve put together a list of my Blog posts shared by Google Analytics on social media. A big thank you to Google Analytics for all the shares! I’ve put together a list of the shared posts below. Looking at Search Console Queries and Landing pages in Data Studio A post about how to compare queries…

Displaying AI Generated Faces in Data Studio

There’s a fantastic new website called “This Person Does Not Exist” that displays AI generated faces. Take a look below. The person above is not real, and has never been real. They might look like your aunty / uncle / sister / brother / nephew / niece / grandparent / parent / friend but they…

Creating Custom Search Query Categories using CASE statements in Data Studio

In this post I’ll show a method for creating custom Search Query Categories. This method involves creating custom categories using CASE statements. Google Data Studio announced yesterday that they had added some new text functions. One of them was; CONTAINS_TEXT — Returns true if the specified text is found in the field or expression, otherwise returns…

Looking at the X-Men franchise in Google Data Studio

The film Dark Phoenix was recently released to mediocre reviews and dismal earnings at the box office. It’s release, and subsequent failure to capture the imaginations of audiences or critics, most likely spells the end for the X-Men franchise under 20th Century Fox. Hopefully the X-Men franchise has a phoenix-like resurrection of its own under…

One Map, many Metrics in Google Data Studio

One feature that might be useful in Data Studio is the ability to switch metrics while viewing a geo-map. So for example, taking a look at the number of sessions worldwide, then switching seamlessly to the number of goal completions worldwide. While it isn’t possible to do this, one way to get around it is…

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! https://twitter.com/PatStrickler/status/1131949760179519488 In this post I’ve give you a…

A Data Studio of Ice and Fire

Since we’re in the final stretch of Game of Thrones, I thought I’d find a dataset and have a play around in Google Data Studio. I found some good episode data on Kaggle, so used that for the second page of the report. Below is the dashboard – hope you enjoy! If you liked this…

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…

How to Translate Survey Responses using Google Sheets

In this blog post I’ll show you how to translate survey responses using Google Sheets! Let’s assume you have a survey running in which the responses may be in multiple languages. What’s the easiest way to quickly and simply translate them to a language you’re more comfortable with? In this post I’ll show you how…

How to create Trigger Groups in Google Tag Manager

In this post I’ll give a very simple example of the new Trigger Groups feature in Google Tag Manager. For a more substantial and thorough look at Trigger Groups check out; Trigger Groups blog post by Simo AhavaTrigger Groups video by Measureschool But I’ll give you a very simple example – with doggos! Let’s say…

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. List…

How to display Google Form results in Data Studio

In this post I’ll show you how to display Google Form results in Data Studio. Google Forms are very useful for informal market research, gathering opinions on social media and deciding where to go for the office Christmas party! Displaying Google Form results in Google Data Studio is relatively straightforward, and allows you to choose…

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. https://twitter.com/Helpfullee/status/1116074403903754242 This function allows you to Drill Down or Drill Up…

How to calculate Conversion Rates in Google Data Studio

In this post I’ll give you a quick example on how to calculate Conversion Rates in Google Data Studio. Thanks to Lee Hurst (aka Helpful Lee) I know that the correct formula to calculate a conversion rate is; SUM (converted leads) / SUM (total leads) I had made the mistake of using the formula: converted…

How to add Images to a table in Google Data Studio

In this post I’ll show how you can add images to a table in Google Data Studio. I need to thank Lee Hurst @Helpfullee for introducing me to this method. I came across it in his excellent Data Studio Resource finder. If you’re interested in this topic you should take a look at ClickInsight’s very…

Three New Features launched for Google Data Studio in March 2019

Google Data Studio is constantly evolving and improving, with new features launched regularly. This week I noticed three new features worth mentioning. They are; Version HistoryScheduled Email DeliverySharing Report Link 1. Version History Users of Google Tag Manager may be familiar with it’s very useful version history. It enables you to make changes without fear,…

How to embed a YouTube video in Google Data Studio

In this short post, I’ll show you how to embed a YouTube video in a Google Data Studio report. In a follow up blog post, I’ll give more examples of embedding external content. Below is the video I want to embed in my Data Studio report. https://www.youtube.com/watch?v=sIlNIVXpIns I’m sure we can all agree it’s great…

Filtering Data using a Geo Map Region in Google Data Studio

In this post I’ll show you a simple method for Filtering Data using a Geo Map Region in Google Data Studio. I’d like to thank Lee Hurst (@Helpfullee) for giving me the idea to try out filtering by using geographic regions. Below is the Data Studio I reported. It shows users from Canada that visited…

Sending Emails using Excel

In this post, I won’t go through a step by step guide on how to send emails using Microsoft Excel. This is because the spreadsheet template I would like to share was created for a very specific purpose, and is unlikely to be useful to the average blog reader. What I’d like to do instead…

Visualizing Geographic Data using Google Data Studio

I’ll provide some examples of how to visualize Geographic data using Google Data Studio. I’ll use a table listing the world’s tallest buildings. Here’s an example of how the table is structured: RankBuildingCityCountryHeight (m)Height (ft)FloorsBuilt1Burj KhalifaDubaiUnited Arab Emirates8282,71716320102Shanghai TowerShanghaiChina6322,07312820153Abraj Al-Bait Clock TowerMeccaSaudi Arabia6011,97112020124Ping An Finance CentreShenzhenChina5991,96511520175Lotte World TowerSeoulSouth Korea554.51,8191232016 Now let’s see if we can…

How to track YouTube video views using Google Tag Manager

Today I’ll be sharing a method to track YouTube video views using Google Tag Manager. This method is used for tracking embedded YouTube videos on your website. Let’s start by embedding a YouTube video, like the one below. https://youtu.be/JbSNL0ds5sE Now, let’s go through the steps necessary to measure video views on your site. How to…

Adding a Facebook Pixel to your website using Google Tag Manager

Facebook’s Pixel allows us to target users who have visited our website with adverts on Facebook. I’ve based my method of installing on the procedure outlined in the excellent Measureschool video below. https://www.youtube.com/watch?v=TkaERODqV3w&t=1740s Facebook also has a guide on how to track and install Pixels. How to install a Facebook Pixel on your website using…

How to Blend Data in Google Data Studio

Blending data is a great feature of Google Data Studio. Below I’ll give a basic step by step example of how to combine two different data sources. For this example, I created two separate worksheets in Google Sheets. Customer ListJanuary SalesCustomer NameCustomer NameUnique IDUnique IDDate of BirthDate of PurchaseFavourite ColourWhat Customer boughtMode of Transport The sheets share…