How much did each source spend?
Now that the IDs are created, you need to pull some data to send to the digital marketing director, except this time you need to rethink the regular expressions you will use to aggregate the metrics.
In this exercise, you will be finding the total cost of all the campaigns with Google as its source. Remember that the FILTER()
function, along with regular expressions, will help aggregate the data.
Diese Übung ist Teil des Kurses
Marketing Analytics in Google Sheets
Anleitung zur Übung
- Add regular expressions in the cell
G3
to match any campaign that has the source ofGoogle
. - Write a filter for the
Cost
column, with the condition for the filter using the regex in cellG3
. - Wrap the filter with a
SUM()
to find the total spent on the sourceGoogle
.
Interaktive Übung
Setze die Theorie in einer unserer interaktiven Übungen in die Praxis um
