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.
To ćwiczenie jest częścią kursu
Marketing Analytics w Google Sheets
Instrukcje do ćwiczenia
- Replace
item 1withBinganditem 2withGooglein the data validationList of itemsin cellH2. - Select
Googlefrom the dropdown. - Modify the
List from a rangedata validation range in cellH3to include all campaign names. - Leave the dropdown for campaign names blank for now.
Interaktywne ćwiczenie praktyczne
Przekształć teorię w praktykę dzięki jednemu z naszych interaktywnych ćwiczeń
Rozpocznij ćwiczenie