始める無料で始める

Putting it all together

Let's clean up a digital marketing data set using Data Validation!

In this exercise, we will take this table, which reports on two different digital marketing sources, and apply Data Validation to fix any issues. This data set was filled in by multiple digital marketing professionals.

As we learned earlier, this means that there may be a few issues, as data entry is almost never perfect. The challenge here will be to apply different types of Data Validation that we have learned throughout this chapter to pin-point any issues with the data.

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

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

コースを見る

演習の手順

  • Create a list of items dropdown for the Source column, with Google and Bing (in this order) as the dropdown values.
  • Fix the Source column errors.

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

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

演習を開始する