Aggregate ad group cost-per-click using REGEXMATCH

As a digital marketing professional, you are tasked with determining the effectiveness of the three ad groups - Mugs, Sweaters, and Tee Shirts. You know from experience that average cost-per-click (CPC) is a very good indicator of ad group performance.

Your team decides that they want to keep the new Mugs ad group no matter what, so you would like to see what the average CPC would be, depending on the ad groups chosen.

This exercise is part of the course

Marketing Analytics in Google Sheets

View Course

Exercise instructions

Add regular expressions in cells H3 and H4 that will match the respective ad groups listed in cells G3 and G4.
- Your expressions should match the first or the second ad group.
Write a filter for the CPC column, with the condition for the filter using the regex in cell H3 (combined with REGEXMATCH()).
Wrap the filter with an AVERAGE() to find the average CPC for the Mugs and Tee Shirts ad groups.
Repeat steps 2 and 3 to get the average CPC for the Mugs and Sweaters ad groups.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise