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
Exercise instructions
- Modify the scatter chart by changing it into a bubble chart.
- Using the table located in the range
A1:F29
, addSource
to distinguish theGoogle
andBing
data points. - Using the table located in the range
A1:F29
, addImpressions
to determine the size of each bubble.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
