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.

Diese Übung ist Teil des Kurses

Marketing Analytics in Google Sheets

Kurs anzeigen

Anleitung zur Übung

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.

Interaktive Übung

Setze die Theorie in einer unserer interaktiven Übungen in die Praxis um

Übung starten