BaşlayınÜcretsiz Başlayın

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.

Bu egzersiz

Marketing Analytics in Google Sheets

kursunun bir parçasıdır
Kursu Görüntüle

Egzersiz talimatları

  • Replace item 1 with Bing and item 2 with Google in the data validation List of items in cell H2.
  • Select Google from the dropdown.
  • Modify the List from a range data validation range in cell H3 to include all campaign names.
  • Leave the dropdown for campaign names blank for now.

Uygulamalı interaktif egzersiz

İnteraktif egzersizlerimizden biriyle teoriyi pratiğe dökün

Egzersizi başlat