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.
Diese Übung ist Teil des Kurses
Marketing Analytics in Google Sheets
Anleitung zur Übung
- 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.
Interaktive Übung
Setze die Theorie in einer unserer interaktiven Übungen in die Praxis um
