Get startedGet started for free

Plotting campaign click-through-rates with a line chart

You finally get to the last trend that your marketing director needs for their report and you realize that the chart needs to be overhauled.

Before you dive into the chart, you realize that the campaign IDs you created are being used in this chart, which will make your life easier, as you will want to plot all 4 trends.

This chart will quickly become messy when adding all 4 CTR trends, but visualizing all the CTRs will help the reader understand how well or poor each source performed over the 6 month time frame.

This exercise is part of the course

Marketing Analytics in Google Sheets

View Course

Exercise instructions

  • Add the Python Brand campaign with the source of Google as a series.
  • Also add the Python Brand campaign with the source of Bing to the chart.
  • Change the chart type to a Line chart.

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise