How to Translate Survey Responses using Google Sheets

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 you can use some Google Sheets formulas to translate survey responses.

Read more


How to create Trigger Groups in Google Tag Manager

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;

But I'll give you a very simple example - with doggos!

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


How to display Google Form results in Data Studio

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!

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


Using Google Data Studio’s new Hierarchy feature to Drill Down into Regions and Cities

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.

Read more


Creating an Avengers Dashboard in Data Studio Part 1

Creating an Avengers Dashboard in Google Data Studio: Part 1

Since Avengers: Endgame is almost upon us, I thought why not look back at the previous Marvel Cinematic Universe movies using Google Data Studio.

Since 2008, Marvel has released 21 films featuring their iconic superhero characters. I thought that for the first dashboard, I'd take a look at each film individually.

Read more


How to create a Twitter Dashboard in Google Data Studio

How to create a Twitter Dashboard in Google Data Studio

In this post I'll show you how to make a Twitter Dashboard in Google Data Studio. This dashboard I created shows who's been tweeting about the term#DataStudio.

Read more


How to calculate Conversion Rates in Google Data Studio

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;

Read more