Every marketing manager, stakeholder and business owner eventually has to walk into a budget meeting and defend an SEO spend with a number attached to it, not a vague promise about “long term visibility.”
I’ve had that exact conversation more times than I can count, and the good news is that forecasting SEO revenue isn’t guesswork if you build the model properly. It’s genuinely calculable, provided you’re honest about the assumptions feeding into it.
I’m Myles, Director at Essheo. I spent years forecasting and defending growth budgets for a business that scaled past £65 million in turnover, managing PPC spend alongside SEO the entire time, so building a credible revenue model isn’t new territory for me. This post walks through exactly how I’d build that forecast if I were sitting on your side of the table.
What Data Do You Actually Need Before Forecasting Anything?
Before building any projection, you need a specific set of inputs, and skipping any one of them tends to produce a forecast that looks precise but isn’t actually trustworthy.
The Core Inputs Every Forecast Requires
A proper SEO forecast requires four core inputs, keyword search volume, organic click through rate at your target ranking position, resulting organic traffic, and organic conversion rate. Miss any one of these and you’re not forecasting revenue, you’re forecasting traffic and hoping the rest follows, which is exactly how overly optimistic projections happen.
Pulling Your Own Historical Data First
Start by exporting twelve to twenty four months of organic traffic, rankings, and CTR data directly from Google Search Console and Analytics. This matters more than reaching for an industry average CTR curve, because your own site’s actual click through rate at each ranking position is a far more accurate predictor of your specific results than a generic benchmark pulled from an unrelated industry.
Calculating Your Average Order Value
To connect traffic forecasts to revenue, calculate your average order value using organic transactions specifically, dividing total revenue from organic transactions by the number of organic transactions over the past six months. This single number is what turns a traffic projection into an actual revenue projection your finance team can work with.
What’s the Actual Formula for Forecasting Revenue?
Once you have the inputs above, the calculation itself is a straightforward chain, though each link in that chain needs to be grounded in real data rather than assumption.
The Revenue Forecasting Chain
The formula runs in sequence, traffic equals search volume multiplied by click through rate at your target position, leads equal traffic multiplied by conversion rate, and revenue equals leads multiplied by close rate multiplied by average customer value. Return on investment is then calculated as revenue minus cost, divided by cost, multiplied by 100.
Why Capture Rate Needs to Vary by Query Type
One detail that separates a credible model from an overly simplistic one is applying a different capture rate depending on query type, discounting more aggressively for informational queries that are increasingly absorbed by AI Overviews, and discounting less for commercial and transactional queries where clicks still flow reliably to the website.
Using a single blanket capture rate across every keyword hides exactly the nuance that matters most in a modern forecast, particularly given how much AI Overviews have changed click behaviour on certain query types.
Building Low, Expected, and High Scenarios
Rather than presenting a single number, a properly built forecast presents a range, typically a best case, a likely case, and a worst case scenario, sometimes with an additional stretch goal if ambitions genuinely allow for it.
This range is what makes a forecast defensible in front of a CFO or finance director, because it demonstrates the model accounts for genuine uncertainty rather than presenting false precision.
How Should You Account for Ranking Position and Timeline?
Search volume alone tells you almost nothing useful, what matters is realistically estimating where you can rank and how long reaching that position will actually take.
Setting Credible Target Positions
For each keyword, assign a realistic target position based on your current domain authority and the strength of competitors already ranking there, and when genuinely uncertain, forecast one to three positions below your actual ambition rather than assuming the best case outcome by default.
Overestimating your own competitive strength is the single most common way an SEO forecast ends up disappointing stakeholders later.
Applying Your Own CTR Curve by Position
Map each target position to a click through rate using your own Search Console derived curve wherever you have the data, and only fall back to a published industry curve for keywords or intents where no first party data exists yet.
This is a meaningfully more accurate approach than assuming a generic top of page CTR applies uniformly across your entire keyword set.
Building in a Realistic Ramp, Not a Straight Line
SEO growth doesn’t arrive in a straight line, so a credible forecast spreads projected gains across a realistic timeline, typically a slow first quarter, genuine acceleration through months four to nine, and a plateau afterward as the initial wave of quick wins tapers off into steadier, more incremental compounding growth.
What ROI Benchmarks Should You Use to Sense Check Your Model?
Once you’ve built your own forecast, it’s worth checking it against genuine industry benchmarks, not to replace your own data, but to catch a model that’s wildly optimistic or unnecessarily conservative.
Average E-commerce SEO ROI Benchmarks
E-commerce brands achieve an average SEO ROI of 317%, alongside a 4.17x return on ad spend equivalent, typically over a twelve to eighteen month period. Separate benchmarking data breaks this down by time horizon and industry vertical specifically, which is worth reviewing if your category has genuinely different competitive dynamics to the average.
Why Break-Even Timing Matters for Budget Planning
Most credible e-commerce SEO forecasts place the break-even point somewhere around nine months into a consistent campaign, with the return continuing to climb well beyond that point as rankings and content compound. If your own model breaks even significantly earlier than this without a very specific reason, it’s worth revisiting your assumptions before presenting it internally.
How Do You Keep the Forecast Honest Over Time?
A forecast built once and never revisited becomes decreasingly useful and increasingly embarrassing the further reality drifts from the original projection. Treating it as a living model rather than a one off document matters enormously.
Revisiting the Model Every Month
Forecasts should be revisited monthly, comparing actual performance against the original projection and adjusting the model based on what’s genuinely happening rather than what was originally assumed.
This monthly discipline is what allows you to catch a forecast that’s drifting off course early, rather than discovering a full year later that the assumptions never matched reality.
Filtering Out Low Volume Noise
When pulling query data from Search Console, drop any query with fewer than roughly ten impressions, because low volume terms frequently show misleadingly high click through rates at position one that would distort the overall model if included at face value.
Small data hygiene steps like this one are what separate a forecast that holds up to scrutiny from one that falls apart the moment someone asks a detailed question about it.
Segmenting for AI Overview Presence
Segment your keyword set specifically by whether AI Overviews are present on that query, because click through rate behaves meaningfully differently on queries where an AI Overview appears compared to those where it doesn’t.
A forecast built before this segmentation became standard practice is likely to overstate expected clicks on informational terms specifically, so it’s worth revisiting older models with this lens applied.
Ready to Build a Forecast You Can Actually Defend Internally?
We build genuine, defensible revenue forecasts into every strategy we create at Essheo, grounded in your own historical data rather than generic industry assumptions, because a number you can’t defend in a budget meeting isn’t actually useful to you.
Our clients have generated over £45 million in combined revenue over the last two years, and every senior practitioner on our team brings 8+ years of experience each, ranking against genuinely tough competition including household names like MoneySuperMarket, GoCompare, and uSwitch.
If you’re a marketing manager or stakeholder who needs a credible SEO revenue forecast to justify next year’s budget, I’d rather build that model with you properly than hand you a generic template.
Book a strategy call with me and I’ll walk through exactly what a realistic forecast looks like for your specific business, your category, and your current traffic.