Bucketing Adwords metrics into new Dimension - Possible? Workaround?
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!
WHEN Conv. value / cost > 0 AND Conv. value / cost < 1 THEN "LOW"
WHEN Conv. value / cost >= 1 THEN "HIGH"
ELSE "NA" END