开始使用免费开始使用

Check the checkboxes

In this exercise, you are challenged with trying to find which Campaign-Ad Group sets are inactive. The method of doing this is by looking at the Number of Ads built. The logic is that if there are no ads built, then no ads can show, thus resulting in the status of Inactive.

This is a very common task for a digital marketing professional. This process is the equivalent of taking inventory. It will also reveal which Campaign-Ad Group pairs still need some work.

本练习是课程的一部分

在 Google Sheets 中进行营销分析

查看课程

练习说明

  • Add a Checkbox data validation to the cells on the Inactive column.
  • Use custom cell values to set the value for checked and unchecked boxes:
    • Set the checked box custom cell value to be Inactive.
    • Set the unchecked box custom cell value to be Active.
  • Mark all ad groups without ads as Inactive.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习