開始使用免費開始

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.

本練習屬於課程

Google Sheets 的行銷分析

檢視課程

練習說明

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

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習