Combining-Events-using-CASE-statements-

How to combine events using a CASE statement in Google Data Studio

Let's say we want to combine certain event completions in Google Data Studio.

We might try and use the same formulas that we use for combining goal completions together into custom metrics.

Read more


Google Tag Manager PDF downloads

How to track PDF downloads using Google Tag Manager

What's the best way to track PDF downloads on your website?

I'd recommend using Google Tag Manager to create a custom event, and then tracking the event in Google Analytics.

Read more


Website Visitors Dashboard in Google Data Studio

Example of a Website Visitors Dashboard in Google Data Studio

I wanted to share a Google Data Studio report I created, that is designed as a dashboard that can be checked regularly to see how your website is performing relative to the previous month as well as the previous year.

Read more


Blending data in google data studio

How to Blend Data in Google Data Studio

In this post I'll give a basic overview of how to blend data in Google Data Studio. Blending data is a very useful feature that will help you combine different data sets for your dashboard.

Below I'll give a basic step by step example of how to combine two different data sources.

Read more


How to create Custom Regions in Google Data Studio using CASE statements

How to create Custom Regions in Google Data Studio using CASE statements

The CASE statement in Google Data Studio allows users to create new categories and dimensions.

"CASE statements let you create new fields that use conditional logic to determine the field values. CASE is most often used to create new categories or groupings of data." - Data Studio Help

Read more


How to create a Currency Conversion dashboard in Google Data Studio

How to create a Currency Conversion dashboard in Google Data Studio

To illustrate how the currency feature works, I will show how to use Google Sheets and Google Data Studio to create a currency dashboard.

Google Sheets has many useful functions. One of these is it's currency conversion formula that allows users to get a live conversion rate between different currencies.

Read more


How to integrate Typeform, Google Sheets and Google Data Studio

How to integrate Typeform, Google Sheets and Google Data Studio

Below is a Typeform survey. Feel free to fill it in. The results of this survey are automatically sent to a Google sheet. They are then sent to a Google Data Studio report, which you will see if you scroll down.

Read more