Annie Cushing's Blog - Analytics, AI, & Data Visualization Consul...

Three Regex Functions in Google Sheets
Continuing on with my series on the many marketing uses of regex (aka regular expressions), in this post I dive into the three regex functions in Google Sheets:
REGEXMATCH()

I’ve been doing a series on regular expressions (aka regex) and am now diving into their uses in sundry marketing tools we have at our disposal. In this video I demonstrate how to use regex in Search Console.
Google announced in February that it had added the ability to filter using regex in the Search results report (under Performance in the left navbar)....

If you work with data, you’ve encountered the need to filter your results. It’s like talking to your kids about the and : Little questions get little answers; big questions get…awkward.
Learn Regex the Easy Way
Similarly, little filter needs can be met with a simple contains option, but if you need to filter by multiple criteria, you’re gonna need to put on your big kid pants and learn regular expressions, aka regex. I created a comprehensive regex guide to...

I’ll admit it: I used to be a regexaphobe. When I was new to analytics, I remember someone sending me a snippet of regular expressions (AKA regex) to solve a goal setup conundrum I was working through. It looked like a foreign language to me. I was fascinated...