CommencerCommencer gratuitement

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.

Cet exercice fait partie du cours

Marketing Analytics in Google Sheets

Afficher le cours

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.

Exercice interactif pratique

Passez de la théorie à la pratique avec l’un de nos exercices interactifs

Commencer l’exercice