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

Invalid Formula Case

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi Guys,

 

Anyone knows why I´m not able to add a calculated field with Case formula, I´m getting "invalid formula", we did in other pc and it worked, I already create a new connection with search console but it doesn't works.

 

This is the formula:

 

CASE
WHEN REGEXP_MATCH(Query, "(.*falabella.*|.*fallabella.*|.*falabela.*|.*fallabela.*)") THEN "brand"
ELSE "non brand"
END

Re: Invalid Formula Case

Explorer ✭ ☆ ☆
# 2
Explorer ✭ ☆ ☆

That formula worked fine for me 

 Screen Shot 2018-08-11 at 17.55.07.png