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
5.1K members online now
5.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Can't find new Custom Dimension

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I just created a new custom dimension while working with AdWords data but can't select it . Does not show in search of dimensions, but when I go to "Create New Dimension" it shows at the top of the list and has no errors.   Haven't seen this issue before - seems like a caching issue?  I tried update but no luck - Anyone have a quick solution so I can refresh the dimension selector? 

Thanks! Lee H. 

Can't find new Custom Dimension

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Ok , found out reason why - I originally had it returning numbers , but then switched to text output - it was in the Metrics section and does not work.  Ive done this before but I'm getting caught up on the CASE statement  - Any thoughts? 

CASE

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

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

ELSE "NA" END