Apply dynamic filter to dashboard

Everything is almost set. In order to make this dashboard ready for your marketing manager and clients to use, you just need to link the doughnut chart to the filtered table.

This exercise is part of the course

Marketing Analytics in Google Sheets

Exercise instructions

Using the filtered data table, modify the label component of the doughnut chart to be the ad group column.
Change the doughnut chart value component to be the impressions column of the filtered data.
Set the source dropdown to Google and the campaign dropdown to pandas Brand.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises