Ad group impression share with a doughnut chart
Once again, the marketing manager at your agency simply does not like the look and feel of a pie chart. In addition, they feel like the percent make up of total Impressions
is more important than Cost
, which is what it currently reports.
Knowing all of the issues, you now need to modify the chart accordingly.
Note: Columns A through G are minimized in this exercise. From this exercise through the rest of the exercises in chapter 4, A:G
will remain hidden.
This exercise is part of the course
Marketing Analytics in Google Sheets
Exercise instructions
- In the pie chart, replace the series
Cost
withImpressions
from the aggregate table located in rangeK1:O4
. - Change the chart type from a pie chart to a doughnut chart.
- Analyze the
Bing
source data by switching toBing
in the source dropdown.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
