Jason Stempel PPC Marketing Tutorial – Manage Your PPC Budget Like A Pro

LEARN HOW TO
— Build a professional PPC budget tracker from scratch.
— Adjust your ad spend at any time during the budget period so that it stays on course to maximize the advertising spend without going over.
— Make a case for asking your client for additional funds when your count is performing exceptionally well.

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

CHAPTERS
00) Introduction 00:01
01) The Pretend Scenario 01:30
02) Auto Formatting The Basic Columns In Excel 03:20
03) Entering Weekly Campaign Performance Data From Google Ad Words 06:15
04) Adding Some Pretend Data & Formatting Columns 07:37
05) Calculating Current Sums 09:48
06) Calculating Future Projections 12:33
07) Contrasting Q2 & Q1 Performance To Find Clues About The Increased Spend 16:31
08) Option A: Get The Ad Spend Back On Track So It Doesn’t Exceed The Budget 19:01
09) Option A: Adjusting The Daily Campaign Budgets In Excel 20:42
10) Option B: Calculate & Present The Benefit Of Exceeding The Budget 25:03
11) Conclusion 29:15

Post Author: hatefull