Customize Your PPC Dashboard Key Phone Number List comparison table To create a table showing PPC metrics versus YOY, top activity, and top keywords, simply create a title that describes each report and add the relevant Phone Number List headings, as shown in the example below. Metrics and Dimensions Popular Activities Then you need to reference the cells containing the data in the single raw data table you just generated after customizing the Phone Number List configuration sheet and clicking "Run Report". To add the YOY comparison shown in the first table, use the following formula.
Format the cells as percentages, and Phone Number List conditional formatting rules to show positive (green) and negative (red) performance: For YOY comparison Rolling Monthly Performance Rolling Monthly Performance To create a Phone Number List monthly comparison report, create a table with one row for each month (13 rows in total) in the last 2 row headers (August 2017 in this example): In the month column: auto-populate the months prior to August 2017, as Phone Number List in this example giving the current month and the previous 13 months. You can generate trendlines below each section of the chart using sparklines that reference the dates in each column. Year-to-date revenue and forecast To create your spend, conversion, and revenue Phone Number Li