Data Studio
2.5K members online now
2.5K 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!