LoslegenKostenlos loslegen

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.

Diese Übung ist Teil des Kurses

Marketing Analytics in Google Sheets

Kurs anzeigen

Anleitung zur Übung

  • 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.

Interaktive Übung

Setze die Theorie in einer unserer interaktiven Übungen in die Praxis um

Übung starten