How to Forecast Amazon PPC Spend & Revenue Before You Spend a Dollar  [The PPC Den Podcast]

Today Michael welcomes back Priscilla Wagner of Relentless B2C, Marine Corps veteran, and quite possibly the most spreadsheet-brained guest in Badger Nation. She’s been on the show for the visibility death spiral, for classifying keywords by how they actually behave instead of by raw console numbers, and for the custom Excel bidding system Michael still talks about. This time she’s opening up her forecasting model.

The idea: auditing an account that’s already running is the easy version. The data is sitting right there. Forecasting is the hard version, because you’re projecting spend and revenue off keywords that have zero performance history attached to them. As Michael puts it, the digital marketer in all of us wants to launch big and find out fast but sitting down to plot it out first is what real businesses do.

Priscilla walks through the entire build. Tiering roughly 90 competitors by relevancy using Helium 10 and Claude. Bucketing keywords into core, expansion, branded, and broad discovery. Pulling current impression share straight out of the Search Query Performance report, then picking a lift target that’s “big enough to read, small enough to test.” She also shares the variable Michael had never seen anyone put in a forecast before: click-through rate and conversion rate decay, because your CTR cannot possibly hold steady as your impression bucket multiplies.

And there’s a real case study in here. One client’s forecast surfaced a buy box problem before a single ad went live so the recommendation wasn’t a campaign structure, it was “stop selling to resellers first.”

We’ll see you in The PPC Den!