Get startedGet started for free

Using a bubble chart to determine the better source

The second requirement for the dashboard from the marketing director:

A chart that will show the relationship between clicks, goal completions, and impressions

The requirements hint at a bubble chart, since clicks, goal completions, and impressions seem to be closely related, and a bubble chart would do a great job at charting the relationships.

This exercise is part of the course

Marketing Analytics in Google Sheets

View Course

Exercise instructions

  • Modify the scatter chart by changing it into a bubble chart.
  • Using the table located in the range A1:F29, add Source to distinguish the Google and Bing data points.
  • Using the table located in the range A1:F29, add Impressions to determine the size of each bubble.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise