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
https://docs.google.com/file/d/0Bx-hvUyzE3kiQ1hYdVdfTlJHQ3M/edit?usp=sharing

CHAPTERS
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

source

3 COMMENTS

LEAVE A REPLY