Campaign and ad group analysis with a bubble chart

The last request by the marketing manager is for the dashboard to relate all three metrics: Impressions, Clicks, and Cost.

In this case, the chart of choice is easy, the bubble chart is the best choice when the goal is to relate 3 metrics.

After completing the task, look closely at the chart and consider which ad group may need some support.

This exercise is part of the course

Marketing Analytics in Google Sheets

Exercise instructions

Use the Campaign Name column from the filtered table as the IDs for the points in the bubble chart.
Once again, using the filtered table, add Cost as the sizes of the points in the bubble chart.
Change the source type to Google using the source dropdown menu.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises