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