List of items
Each paid search campaign has a number of Ad Groups, where Ad Groups are normally split into product offerings or themes. For the purposes of this exercise, the ad groups are built around the products offered by the fictitious ecommerce site - mugs, tee shirts, and sweaters. Since these are less likely to change and there are only 3 of them, a List of items
should be used, as a List from range
tends to be better suited for larger and often changing lists.
In this exercise, you are tasked with modifying the List of items
data validation settings. The ad group Mugs
has already been done for you.
Learn more about Google Ads Ad Groups.
Este exercício faz parte do curso
Marketing Analytics in Google Sheets
Instruções do exercício
- In cells
C2
toC28
, modify theList of items
data validation to includeSweaters
andTee Shirts
in place of[Item 2]
and[Item 3]
.- Be sure to use the following order:
Mugs
,Sweaters
,Tee Shirts
- Be sure to use the following order:
- Use the dropdowns to correct the all the flagged
Tee Shirt Buyers
cells in theAd Group
column. - Correct all of the
Sweater Buyer
cells.
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
