Create Custom Channel Groupings in Google Data Studio using CASE statements

In this post I'll discuss how to create custom channel groupings in Google Data Studio using CASE statements.

Read more


Cover image for How to automatically adjust dimensions in google data studio

How to automatically adjust Dimensions in Google Data Studio

In this post I'll show you have to automatically adjust Dimensions in Google Data Studio.

What I mean by this is that I'll show you how to set up a custom Dimension that changes based on another dimension.

I have to admit I wasn't clever enough to think this up on my own, and saw the brilliant Mehdi Oudjida show the method on Twitter.

Read more


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


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