Hello everyone, I found this great formula which groups queries into segments but the code provided in the article is giving me an error in DataStudio. Can anybody please tell me how to close this formula? "END" apparently isnt being recognised by DS Formula
CASE
WHEN REGEXP_MATCH(Query,"(.*can.*|.*how.*|.*is |.*what.*|.*when.*|.*why.*)") THEN "HTD"
WHEN REGEXP_MATCH(Query,"(.*Pixe.*|.*Pixels.*|.*Pixelsmithstudios.*)") THEN "brand"
WHEN REGEXP_MATCH(Query,"(.*buy.*|.*shop.*|.*purchase.*") THEN "product"
ELSE "Other"
END <--- Not being recognised by DataStudio as a closer
[link] [comments]
from Search Engine Optimization: The Latest SEO News https://www.reddit.com/r/SEO/comments/f560un/formula_query_sc/>
No comments:
Post a Comment