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.
Learn how to automatically generate documentation for Google Tag Manager with a Colab-based tool. Simplify…
Updates in Google organic search--algorithm update & AI Overview sources--as well as Google Ads changes…
Updates from the world of marketing analytics: GA4 to add benchmarking & plot rows; new…