Dropdowns for source and campaign name
With all of your skills in preparing data and visualizing data from the tables your marketing agency uses, you have now been tasked with building an easy-to-understand dashboard.
The marketing manager at your agency would like any dashboard you create to be able to be filtered by both the Source
and the Campaign Name
. The first step you must take is to add these as dropdowns to your sheet, to be used as filters as the dashboard progresses.
Este exercício faz parte do curso
Marketing Analytics in Google Sheets
Instruções do exercício
- Replace
item 1
withBing
anditem 2
withGoogle
in the data validationList of items
in cellH2
. - Select
Google
from the dropdown. - Modify the
List from a range
data validation range in cellH3
to include all campaign names. - Leave the dropdown for campaign names blank for now.
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
