Marketing Analytics in Google Sheets
Luke Pajer
Digital Marketing Specialist
string to test
, regular expression
)True
or False
)FILTER()
SUM()
AVERAGE()
=FILTER(range, REGEXMATCH(string to test, regular expression))
=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