Aggregate campaign cost using REGEXMATCH

The digital marketing director was so impressed with the speed at which you got the filtered campaigns to them that they decided to give you another task. This time, they are asking on behalf of the client for a quick rundown of the total spend for both the DataCamp Brand and Python Brand campaign.

Once again, FILTER() combined with REGEXMATCH() is the answer, but not the full answer. In this exercise, you will need to also apply a SUM() function in order to aggregate the total spend (Cost) of the two campaigns of interest.

Questo esercizio fa parte del corso

Marketing Analytics in Google Sheets

Visualizza il corso

Istruzioni dell'esercizio

Add a regular expression in cell H4 that will match the respective campaign listed in the cell G4 (i.e. Python campaigns).
In cell I4, write a filter for the Cost column, with the condition for the filter using the regex in cell H4. Don't forget to use REGEXMATCH()!
Wrap the filter with a SUM() to find the total cost for the DataCamp Brand campaign.

Esercizio pratico interattivo

Passa dalla teoria alla pratica con uno dei nostri esercizi interattivi

Inizia esercizio