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

Regex Match and Filters in Data Studio

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello, 

 

I'm trying to extract part of a url and rename it "Friday, March 31" and then use it in a filter in Data Studio. 

Formula:

CASE WHEN REGEXP_MATCH(Page, '/2017/2017-03-31/') THEN "Friday, March 31" ELSE "Other" END

 

It's only returning "Other" in the filter. Am I using the right formula?

 

Thanks, 

Kate