This is part 1 of a two part tutorial.
In part 1 learn to use Excel to analyze a Google Ad Words campaign to learn which ad position is performing the best. We will analyze keyword positions for click through rate, conversion rate, and cost per conversion so that we can determine the most effective and efficient position to bid towards.
DOWNLOAD THIS TUTORIALS .CSV FILE
1: Creating the report in Google Ad Words 0:58
2: Consolidating the average position 2:15
3: Inserting calculated fields for our KPI’s 4:36
4: Highlight performance with conditional formatting 7:11
5: Position performance analysis 8:33