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.
ChatGPT traffic in the GA house! Plus new features in GA4 and understanding GTM first-party…
This article details the process of building two BigQuery tables for path analysis, with a…
Preview five great dashboards for SEO reporting and analysis, and find the one that works…