Get startedGet started for free

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

View Course

Exercise instructions

  • Swap out the series Clicks with Impressions.
  • Change the chart type to Scatter.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise