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

How do I make a filter using RegEx Match be case sensitive

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

These pages all exist in my GA data

/you/

/You/

/YOU/

However, I only want to report on this page

/you/

 

I have written a few RegEx's and not a single one has worked. I have tried

(?i)/you/

/[y]ou/

/[y][o]u/

/[a-z][a-z]o/

but each has shown all of the above pages.

 

How do you make Data Studio be case sensitive without having to create additional filters set to exact (which is case sensitive) that excludes the capital letter matches.

1 Expert replyverified_user

How do I make a filter using RegEx Match be case sensitive

Top Contributor
# 2
Top Contributor

regexs in GA are not case-sensitive, sorry

A good practice is to either use filters in GA to force data to lower case or use an ETL to achieve the same process before linking data into Data Studio

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan

How do I make a filter using RegEx Match be case sensitive

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

GA is case-insensative by default yes, but most of what  have read has been that you can for case sensitivity.

http://www.lunametrics.com/regex-book/Regular-Expressions-Google-Analytics.pdf
http://online-metrics.com/regular-expressions/
http://www.analyticsmarket.com/blog/regular-expressions-for-google-analytics

 

However, this doesn't seem to be the case for Data Studio.

How do I make a filter using RegEx Match be case sensitive

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

Seems there is an update to this question. Now it's possible to use the (?i) flag :-)

 

From the help page of REGEX_MATCH

 

Regular expressions are case-sensitive by default. You can make the match case-insensitive using the (?i) flag:

REGEXP_MATCH(field_expression, '(?i)a.*') matches both "abc123" and "ABC123"