Understanding click through rate with a scatter plot
A scatter chart will help understand how metrics relate to one another. For our purposes, let us plot impressions vs. clicks, which will not provide too much information, but will help lead us into another chart that will be incredibly informative. The bubble chart is the next stage, which is simply a scatter chart but with an added dimension, or weight, to the scatter dots.
This exercise is part of the course
Marketing Analytics in Google Sheets
Exercise instructions
- Swap out the series
Clicks
withImpressions
. - Change the chart type to
Scatter
.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
