Jason Stempel PPC Marketing Tutorial – Landing Page Performance Analysis

Learn to use Excel to dig into a Google Ad Words report and determine which of your clients landing pages are under performing and therefore need to be visited for some discovery and repair. Using Excel we will analyze our clients landing page conversion rates to help us and our client make informed marketing decisions related to the demand for their products and the performance of their products landing pages.

DOWNLOAD THE EXCEL SUPPORT FILE
https://docs.google.com/file/d/0Bx-hvUyzE3kiTm5qMXNoSzMtLUk/edit?usp=sharing

CHAPTERS
0) Introduction 0:01
1) Generate a destination url report in Google Ad Words 0:28
2) Create a pivot table in Excel 1:13
3) Calculate CTR, CPC, and Conv. Rate 6:17
4) Distill the data to extract value 9:08
5) Normalize the data 12:07
6) Take action: Test landing pages 14:37
7) Conclusion 16:54

Post Author: hatefull