Aan de slagGa gratis aan de slag

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.

Deze oefening maakt deel uit van de cursus

Marketing Analytics in Google Sheets

Cursus bekijken

Oefeninstructies

  • In cells C2 to C28, modify the List of items data validation to include Sweaters and Tee Shirts in place of [Item 2] and [Item 3].
    • Be sure to use the following order: Mugs, Sweaters, Tee Shirts
  • Use the dropdowns to correct the all the flagged Tee Shirt Buyers cells in the Ad Group column.
  • Correct all of the Sweater Buyer cells.

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen