Test a string using REGEXMATCH

Marketing Analytics in Google Sheets

Luke Pajer

Digital Marketing Specialist

Recall the campaigns of interest...

Digital Marketing Table

Digital Marketing Table 2

Great for testing existence of a string within a string
- Returns a boolean (True or False)
Often used for filtering tables
- Creating subtables using FILTER()
Useful when aggregating specific categories
- SUM()
- AVERAGE()

=FILTER(range, REGEXMATCH(string to test, regular expression))

Filter with REGEXMATCH

=FILTER(range, REGEXMATCH(string to test, regular expression))

To get a sum of the total ad spend or total cost:

=SUM(FILTER(range to sum, REGEXMATCH(string to test, regular expression)))

To get the average CPC or Cost-per-Click:

=AVERAGE(FILTER(range to average, REGEXMATCH(string to test, regular expression)))

Marketing Analytics in Google Sheets