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.