In this video tutorial, we walk through key building blocks of regular expressions using the incredibly powerful REGEXEXTRACT function in Google Sheets. To follow along, make a copy of this Sheet. Topics covered:
A little bit of regex knowledge can go a long way. Regular expressions are supported in all major programming languages, and they are also available as a text/field matching option in many Google products including Analytics, Data Studio, and Tag Manager. For example:
A few resources mentioned in the video:
And here’s a post I wrote a while back about searching-and-replacing in Sheets with regular expressions.
Bot traffic in GA4 is really frustrating. Our Head of Analytics Nico Brooks takes us…
Welcome to May! We highlight key digital marketing updates over the past month across analytics,…
Custom Insights in GA4 is great for monitoring & alerting on important metrics for changes.…