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

"Could not parse formula" error in Google data studio

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello all, 

 

I'm trying a formula CASE WHEN to change the names my AdWords campaigns in Google Data Studio to be more understandable for other to analyse. However when I try to parse the formula, it always gives me the message "Could not parse formula". 

 

The formula is: 

CASE WHEN REGEXP_MATCH(Campaign, "Choice - BE - FR - Branding") THEN “[BE-FR] search branding” WHEN REGEXP_MATCH(Campaign "Choice - BE - NL - Branding") THEN “[BE-NL] search branding” WHEN REGEXP_MATCH(Campaign "Choice - BE - FR - Remarketing") THEN “[BE-FR] display remarketing” WHEN REGEXP_MATCH(Campaign "Choice - BE - NL - Remarketing") THEN “[BE-NL] display remarketing” WHEN REGEXP_MATCH(Campaign "Choice-BE-NL-Thema") THEN “[BE-NL] search theme branding” WHEN REGEXP_MATCH(Campaign "Choice - BE - FR - Thema") THEN “[BE-FR] search theme branding” WHEN REGEXP_MATCH(Campaign "Choice - BE - FR - Needs") THEN “[BE-FR] search non-branding” WHEN REGEXP_MATCH(Campaign "Choice-BE-NL-Needs") THEN “[BE-NL] search non-branding” WHEN REGEXP_MATCH(Campaign "Choice - BE - FR - GSP") THEN “[BE-FR] Gmail Sponsored promotions” WHEN REGEXP_MATCH(Campaign "Choice - BE - NL - GSP") THEN “[BE-NL] Gmail Sponsored promotions” ELSE “”END

 

Could it be that the formula is simply too long? 

Thanks for helping!