AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.8K members online now
1.8K members online now
Ask questions about Data Studio
Guide Me

Creating a dimension field from CASE statement

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello all,


I'd like to create a custom dimension using a CASE statement but I can't figure out the correct formula. 


What I'm trying to do is create tiers for my CPC data. Basically what I want to do is create different tiers where tier 1 has CPC = $0.00-$0.09, tier 2 has CPC = $0.10-$0.19, tier 3 has CPC = $0.20-$0.29, etc. 


I want this to be a dimension and not a metric, because I want to use a filter control with these different tiers so I can look and see which tiers are performing the best. 


Does anyone have any suggestions as to what formula I would write to create these tiers? Thank you for your help!