Data Studio
6.4K members online now
6.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Bucketing Adwords metrics into new Dimension - Possible? Workaround?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Just started digging into some AdWords reporting in data studio - I can't seem to get around some of the auto aggregated metrics though - I would like to bucket value/conversion stats for keywords but can't find a workaround - Here't the custom dimension CASE I'm working with .  Any help appreciated!  

CASE

WHEN Conv. value / cost > 0  AND Conv. value / cost < 1 THEN "LOW"

WHEN Conv. value / cost >= 1 THEN "HIGH"

ELSE "NA" END