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
Exercise instructions
- Add the
Python Brand
campaign with the source ofGoogle
as a series. - Also add the
Python Brand
campaign with the source ofBing
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
