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.

Este exercício faz parte do curso

Marketing Analytics in Google Sheets

Ver curso

Instruções do exercício

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.

Exercício interativo prático

Transforme a teoria em ação com um de nossos exercícios interativos

Começar o exercício