In part 1 of this tutorial learn to use Excel to dig into a Google Adwords report. Learn which days and times your clients ads are converting and which days and times your clients budget is being spent on a lot of wasteful clicks that aren’t converting.
DOWNLOAD THIS TUTORIALS .CSV FILE
1) Generating the Google Ad Words report 1:09
2) Make a pivot table for conversions 2:13
3) Cleaning up the data and formatting columns 3:43
4) Make a pivot table for clicks 5:24
5) Contrast conversion and click data 7:19