See All Videos

Data Studio – Regex Match vs Regex Contains

By Brett
September 10, 2020

When creating tables and graphs in Data Studio, you will likely need to add filters. In this video, we quickly review the difference between Regex Match and Regex Contains when adding a filter.

View Transcript

If you are adding a filter to visualization in Data Studio, it might be a bit confusing if you go in and say, include or exclude. Say include, we’ll select a field of campaign, and then you have these different options of Equals To, Contain, Starts With, RegEx Match, and RegEx Contains. So, the difference here is, in the given example here is, RegEx Match is very literal. You have to say everything that would be included, even stuff that might be dynamic. Then you have to use RegEx syntax, like period and star versus RegEx Contains is a little more greedy. So you could just have say, I wanted to just remove anything with data over instinct, the DOI. I can just put that in there for RegEx Contains in a way to capture all the different campaign names with that in it, versus the RegEx Match I would actually want to do period, star and then period, start at the beginning and end. So that way it would catch not only DOI, but anything before and after as well. Thank you. And please subscribe to learn more about Google Analytics, Data Studio, and other Google products.

Still need help?

GET IN TOUCH
About the Author
Brett uses analytics to help clients put all the pieces together—from identifying KPIs to finding the right data to measure those KPIs and then collecting that data. He’s been in digital marketing for 8+ years and brings analytics leadership to the Anvil team. If he’s not drilling into data, he’s probably hanging with his kids or maybe playing some D&D.
More from this author
Ready to start a project?
let's work together