It All Started With An Idea

Keeping Projections Simple: Data

Hi all #ppc folks & #media #advertising folks: today I had a client ask for simple projections to increase spend. I have a sheet that I used for my e-commerce days and converted to a CPA simple projection document. I use data for all my decisions, it does not make them accurate, it (the data) gives me the most information to make the best guess. So I hope this helps you too.

Link here (please make a copy to edit): https://lnkd.in/gaUk_zhU

It has multiple scenarios on it, that first starts with historical and uses those points to aid projections based off of Display metrics or Search metrics. If used properly it can help you determine quickly if there is value in doing the media from a return on investment perspective.

Link here (please make a copy to edit): https://lnkd.in/gaUk_zhU

Details of dock:

1: its a simple projection document for display / search

2: it can be converted to ecomm, today it was converted from ecomm to lead/event based

3: it considers basic KPIs

4: green highlights are the only cells you should edit

About the author

John M. Williams — Founder, It All Started With An Idea. Senior paid media specialist with 15+ years and $350M+ in managed ad spend across Google, Meta, LinkedIn, and Amazon. Creator of Buddy, the open-source AI Google Ads agent. Hero Conf 2025 + 2026 speaker.

More about John · LinkedIn ↗ · GitHub ↗

Working notes

More from the blog.

Read the blog  Get a free audit