始める無料で始める

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.

この演習はコースの一部です

Google Sheetsで学ぶマーケティング分析

コースを見る

演習の手順

  • Add regular expressions in the cell G3 to match any campaign that has the source of Google.
  • Write a filter for the Cost column, with the condition for the filter using the regex in cell G3.
  • Wrap the filter with a SUM() to find the total spent on the source Google.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する