Key Takeaways
- A well-structured SEO forecast built on verified first-party data and realistic CTR assumptions can be directionally accurate within a range of 20-30% for 12-month projections.
- Beyond 12 months, forecast uncertainty compounds significantly because of algorithm changes, competitive shifts and changes in search behavior.
- A worked example: 4,000 additional monthly sessions at a 2.1% conversion rate is 84 conversions, and at a £3,500 average value that is £294,000 in annualized incremental revenue.
- Where a conversion rate has ranged between 1.7% and 2.5% over 12 months, model both ends rather than forecasting from the midpoint alone.
Most SEO budgets are approved or rejected on the basis of what happened last quarter, not what is likely to happen next year. That is a planning problem as much as a performance problem. When you cannot show a credible projection of what organic search will deliver, in traffic, leads, or revenue, you are asking decision-makers to fund something on faith. SEO forecasting replaces that faith with structured, evidence-based projections that can be stress-tested, revised, and held accountable to real outcomes.
Want a second opinion on how this applies to your own site? Start with Indexed's SEO audit and strategy.
The short answer: an SEO forecast multiplies four numbers for every keyword you target: monthly search volume, the click-through rate you expect at the position you expect to reach, your organic conversion rate, and the value of a conversion. Subtract what you already get today, spread the gain over a realistic ramp, and present the result as a conservative, expected, and stretch range. The rest of this guide shows how to do that step by step, with a worked example, a spreadsheet layout, and the tools that can do part of the work for you.
What Is SEO Forecasting, and Can You Predict SEO Results?
SEO forecasting is the practice of projecting future organic search performance (traffic, rankings, conversions, or revenue) using historical data, keyword-level search volumes, click-through rate (CTR) modeling, and assumed ranking trajectories. It is not a guarantee. It is a structured estimate with defined inputs and testable assumptions.
So can you predict SEO results? You can predict a range with reasonable confidence, but not a single number. Nobody controls Google's rankings, competitors' activity, or how the results page will look next year. What you control is the quality of your inputs and how honestly you state your assumptions. A well-built forecast does not say "you will rank first for this term in three months." It says "if rankings for this keyword set move from around position 8 to around position 3, and our CTR assumptions hold, expect a traffic uplift of roughly this size." That distinction matters when you are presenting to a CFO or a board.
The difference between a forecast and a target
A target is what you want to achieve. A forecast is what the data suggests is plausible given a set of inputs. Good SEO strategy needs both: targets to drive effort, and forecasts to calibrate whether those targets are realistic. When an SEO team simply declares a traffic number without a model behind it, credibility erodes the first time the number is missed.
Two forecasting methods, and why you usually need both
- Trend-based (time-series) forecasting extends your existing organic traffic forward, accounting for trend and seasonality. It answers "where are we heading if we keep doing what we are doing?" It needs history and cannot see the effect of new work.
- Keyword-based (opportunity) forecasting models specific keywords moving to specific positions. It answers "what would this new work add?" It is the method behind most revenue cases and the one this guide focuses on.
A complete forecast adds the two together: a baseline from the trend, plus incremental gains from the keyword model.
The Inputs That Drive a Credible SEO Forecast
A forecast is only as reliable as the data feeding it. There are four core inputs that every meaningful organic forecast requires.
Historical organic performance
Your own Google Search Console data is the most accurate record of how your site performs in search: clicks, impressions, average position, and CTR by query and page. Google's Analytics help notes that Search Console keeps data for the last 16 months, so export and store it regularly if you want longer history. The Performance report tables also show a maximum of 1,000 rows and omit some rare or anonymized queries, so for larger sites pull data through the Search Console API. If you are new to the report, our guide to the Search Console data that matters covers the basics.
Keyword-level search volume and seasonality
Third-party tools such as Ahrefs and Semrush estimate how many searches a term receives each month. Treat these as estimates, not counts: Ahrefs, for example, describes its search volume as a monthly figure averaged over the last 12 months. That averaging is exactly why seasonality matters. A forecast built on the annual average for a term that spikes in December will be wrong in most months of the year, so apply a monthly seasonality index to each keyword or cluster.
Position-to-CTR curves
The relationship between ranking position and click-through rate is not linear, and it varies by query type, device, and the presence of SERP features such as AI Overviews, featured snippets, or local packs. A single flat CTR curve across every query type is one of the most common errors in basic forecasting models. More on this below.
Conversion rates and revenue attribution
Traffic projections are the starting point, not the endpoint. To translate them into revenue, you need verified conversion rates from organic sessions, segmented by landing page type or intent stage where possible, and an average order value or lead value. These figures should come from your own analytics, not industry benchmarks. Our SEO ROI measurement framework explains how to set this up so the forecast and the later reporting use the same numbers.
How to Forecast SEO Traffic and Revenue: Step by Step
This is the method we use when building a forecast for a client's revenue case. Each step produces a column or a tab in the spreadsheet described in the next section.
- Step 1: Set the baseline. Export 16 months of Search Console data and split branded from non-branded queries. Project the non-branded baseline forward for 12 months using a trend function, so you know what you would get without new work.
- Step 2: Build the keyword set. List the keywords the planned work targets, grouped into clusters that one page can realistically rank for. Our guide to prioritizing keywords by business value helps decide which clusters belong in a revenue forecast.
- Step 3: Record current and target positions. Use your Search Console average position as the current figure. Set target positions by looking at who ranks now, how strong those pages are, and how much work is planned. Be specific: "position 4 by month 9" beats "top 3."
- Step 4: Apply a CTR curve. Look up the expected CTR at the current and target position for each keyword, using your own observed curve where you have one and a SERP-type adjustment where AI Overviews or other features appear.
- Step 5: Calculate added clicks. For each keyword: monthly volume × seasonality index × (target CTR minus current CTR). Only the increase counts, because the baseline already includes today's clicks.
- Step 6: Apply a ramp. Rankings move gradually. Spread the gain over the months it will realistically take, rather than assuming full value from month one.
- Step 7: Convert to revenue. Multiply added clicks by organic conversion rate, then by close rate (for lead generation), then by average order or contract value.
- Step 8: Build scenarios. Repeat steps 4 to 7 with conservative and stretch assumptions so the output is a range, not a single number.
A worked example
Take a hypothetical B2B software company selling accounts payable automation. It plans new and rewritten pages for four commercial keywords. The CTR assumptions below are illustrative for this example only; replace them with the curve from your own Search Console data.
| Position | Assumed CTR (example only) |
|---|---|
| 1 | 25% |
| 2 to 3 | 12% |
| 4 to 5 | 6% |
| 6 to 10 | 2% |
| 11 to 20 | 0.5% |
Applying those assumptions to each keyword, with monthly volume shown in brackets:
| Keyword (monthly volume) | Now: position, clicks | Target: position, clicks | Added clicks per month |
|---|---|---|---|
| accounts payable automation (3,600) | 12, 18 | 4, 216 | 198 |
| invoice processing software (2,900) | 8, 58 | 3, 348 | 290 |
| ap automation software (1,300) | 6, 26 | 2, 156 | 130 |
| how to automate invoice approval (900) | 15, 5 | 5, 54 | 49 |
| Total | 107 | 774 | 667 |
At full ramp, the plan adds about 667 clicks a month. For simplicity, treat each click as a session (in practice, analytics sessions and Search Console clicks never match exactly). Suppose the company's commercial pages convert just over 2 in every 100 organic sessions into demo requests, roughly 1 in 5 demos closes, and the average contract is worth $12,000 a year. These conversion and close rates are illustrative inputs; your own verified analytics figures should replace them:
- 667 sessions × 2.0% = 13.3 demo requests a month
- 13.3 demos × your close rate = estimated new customers a month
- 2.7 customers × $12,000 = about $32,000 of new annual contract value added each month, or roughly $384,000 a year at full run rate
Now apply the ramp. If nothing moves in months 1 to 3, gains build gradually through months 4 to 9, and approach their ceiling only in months 10 to 12, the first year captures well under half of the full run-rate value. Year-one revenue from this plan is closer to $149,000 than $384,000. Showing both numbers, and why they differ, prevents the most common argument in month six: "where is the traffic you promised?"
Conservative, expected, and stretch scenarios
A single number invites a single question: "what if you're wrong?" Answer it before it is asked by changing the assumptions that carry the most uncertainty. Here the conservative case assumes only half of the ranking gains happen and conversion is weaker; the stretch case assumes some pages beat their targets and pick up extra long-tail queries.
| Scenario | Added clicks per month | Conversion and close rate | Annual run-rate revenue |
|---|---|---|---|
| Conservative | 334 (50% of target gains) | 1.6%, 15% | about $115,000 |
| Expected | 667 | 2.0%, 20% | about $384,000 |
| Stretch | 834 (125% of target gains) | 2.4%, 25% | about $720,000 |
The stretch case is more than six times the conservative case. That spread is not a flaw in the model; it is an honest picture of uncertainty, and finance teams used to scenario planning will trust it more than a single figure. Base the conservative and stretch conversion rates on the actual range you have seen over the past 12 months, not on round numbers.
How to Build an SEO Forecast in a Spreadsheet
You do not need specialist software to build a credible forecast. A spreadsheet with three tabs covers most cases.
Tab 1: baseline trend
Paste monthly non-branded clicks from Search Console, one row per month. In Google Sheets, the FORECAST function projects future values from a linear regression of your existing data. In Excel, the Excel Forecast Sheet feature uses exponential smoothing (ETS) with automatic seasonality detection and a 95% confidence interval by default; Microsoft advises having at least two full seasonal cycles of history for seasonality to be meaningful. A linear trend ignores seasonality, so for seasonal businesses ETS is the better default.
Tab 2: CTR curve
Build a lookup table of position against CTR. If your site has enough impressions, calculate it from your own Search Console query data: group queries by rounded average position and divide total clicks by total impressions for each group, using non-branded queries only. Add a second column for SERPs with AI Overviews or other heavy features, with lower values.
Tab 3: keyword model
One row per keyword, with these columns:
- Keyword, cluster, and target URL
- Monthly search volume and a 12-month seasonality index
- SERP type (clean, AI Overview, featured snippet, local pack, heavy ads)
- Current position and target position, plus the month the target is expected
- Current CTR and target CTR, pulled from Tab 2 with a lookup formula
- Added clicks: volume × seasonality × (target CTR minus current CTR) × ramp percentage for that month
- Conversion rate, close rate, and value per conversion
- Added revenue for each month and scenario
Keep every assumption in its own cell rather than hard-coded in formulas. When a stakeholder asks "what if conversion is only 1.5%?", you change one cell and the whole model updates while they watch.
Forecasting for an Established Site vs a New Site
Established sites: start from Search Console
If your site has at least a year of organic traffic, your own data should drive almost every input. Use Search Console for the baseline trend, your own CTR curve, and current positions. Separate branded queries first: Search Console's Performance report includes a branded and non-branded queries filter (not available for sites with low impressions), and you can also use a regex filter on your brand name variants. Branded demand is driven by marketing and reputation, not SEO work, and our piece on how branded traffic hides weak SEO performance explains why mixing it in distorts the picture. Your past rate of ranking improvement is also the best guide to how fast new pages will climb.
New sites: borrow, then calibrate fast
A new site has no baseline, no CTR curve, and no track record of ranking speed, so every input is borrowed and uncertainty is higher. To keep the forecast honest:
- Target keywords a new domain can realistically rank for, rather than the head terms competitors own. Our guide to keyword research for new websites covers how to pick them.
- Use conservative CTR values and conservative target positions, and allow a longer ramp than you would for an established domain.
- Use competitor pages as a reference point. Ahrefs' Traffic potential metric, for instance, is based on the organic traffic of the current #1 result for a topic, which gives a ceiling rather than an expectation.
- Treat the first three to six months as calibration. Replace borrowed CTR and ranking-speed assumptions with your own data as soon as it exists, and say up front that you will.
SEO Forecasting Tools and What Each One Does
Tools fall into three groups: data sources, general forecasting functions, and SEO platforms with a built-in forecast. None of them removes the need to check assumptions. Each vendor publishes its own pricing on its website.
| Tool | What its forecasting feature does | Best for |
|---|---|---|
| Google Search Console | No forecast, but supplies clicks, impressions, CTR, and position by query and page | Baseline and your own CTR curve |
| Google Sheets and Excel | Sheets' FORECAST uses linear regression; Excel's Forecast Sheet uses ETS with seasonality and confidence intervals | Baseline trend and full keyword models |
| Prophet (open source) | Time-series forecasting with yearly, weekly, and daily seasonality and holiday effects, in Python and R | Analysts forecasting large or seasonal datasets |
| Ahrefs | Traffic potential estimates the traffic of the current #1 page for a topic | Sizing the ceiling for a keyword cluster |
| Semrush | Potential Traffic, an AI-driven estimate of traffic your domain could earn for a keyword or tracked set | Domain-specific opportunity sizing |
| SEOmonitor | Non-brand traffic forecast with up to five scenarios, conversions, revenue, and a Google Ads cost equivalent | Agencies building client business cases |
| seoClarity | Forecasting tool using Search Console CTR, conversion rate, and order value, with ranking-change scenarios | Enterprise teams with large keyword sets |
| Advanced Web Ranking | Traffic projections for up to 24 months, translated into conversions and revenue, tracked against actuals | Ongoing forecast versus actual tracking |
Sources for each feature: Prophet on GitHub, Semrush Potential Traffic, SEOmonitor Forecast overview, seoClarity SEO forecasting tool, and Advanced Web Ranking SEO forecasting. Note that the platform forecasts use proprietary models; Semrush, for example, states that its Potential Traffic figure assumes you do the necessary optimization work and only applies at the position its algorithm expects. Use them to sense-check a spreadsheet model, not to replace one.
Why Your CTR Assumptions Are Probably Wrong
The standard approach to CTR modeling borrows from published click-through rate studies that aggregate data across millions of queries. Those averages are useful for orientation, but they can badly misrepresent what is happening in your specific search landscape.
SERP features compress organic CTR unevenly
A position-one ranking for a query that triggers an AI Overview, a featured snippet, a knowledge panel, and shopping ads delivers materially less click-through than a position-one ranking on a clean results page. If your forecast does not account for this at the keyword level, it will systematically overstate traffic potential for competitive informational queries. Our analysis of AI Overviews and organic clicks looks at how large that effect can be.
How to build a more honest CTR model
Rather than applying a single industry CTR curve, segment your keyword universe by SERP type. Run each target keyword through a live search and categorize it: clean organic SERP, AI Overview present, featured snippet present, or heavily monetized (ads above the fold). Apply different CTR curves to each category. For keywords where your domain already ranks and has impression data in Search Console, use your own observed CTR at each position rather than an external benchmark: this is almost always more accurate.
What Makes SEO Forecasts Go Wrong
Most forecasts that miss do so for a handful of predictable reasons:
- Treating search volume as a fact. Third-party volumes are modeled estimates averaged over a year. Cross-check them against impressions in Search Console for keywords you already rank on.
- Adding up keywords that one page will rank for. A single page usually ranks for many related queries, so forecasting each variant as if it needed its own page inflates the work and can double count. Model clusters, and watch for keyword cannibalization where two pages compete.
- Assuming rankings arrive on day one. Without a ramp, a 12-month forecast front-loads value that only arrives in the second half of the year.
- Blending branded and non-branded traffic. This makes the baseline look stronger and the SEO contribution harder to isolate.
- Ignoring SERP changes. AI Overviews, new ad layouts, and other features can lower CTR at every position for a query, even when your ranking holds.
- Using benchmark conversion rates. An industry average says nothing about your pages, your offer, or your sales team. Fix tracking before forecasting revenue.
- Not planning for algorithm updates. A core update can reset rankings across a whole category. Keep a conservative scenario that reflects a flat or down year.
- Never checking the forecast against actuals. A model nobody revisits cannot improve, and the next forecast inherits the same errors.
Presenting the Revenue Case
This is where SEO forecasting becomes a boardroom-ready document rather than an internal planning tool. The bridge between traffic and revenue requires three verified numbers: organic conversion rate, average transaction or lead value, and, if applicable, a sales close rate for organically generated leads. Present the assumptions alongside the output, so decision-makers challenge the inputs rather than the conclusion. For what senior stakeholders tend to look for, see how boards evaluate SEO performance.
Accounting for investment cost
A revenue projection without a cost side is a sales pitch, not a forecast. Include the SEO investment (agency fees, content production, technical development) and calculate an estimated payback period for each scenario. Even a rough payback figure ("this investment should break even in month 9 under the expected scenario") gives decision-makers the framing they need to approve or defer.
How Often to Revisit and Update Your Forecast
A forecast built once and never updated quickly becomes fiction. Ranking positions change, search volumes shift seasonally, and Google algorithm updates can materially alter CTR across entire query categories. A sensible review cadence involves checking actual performance against forecast assumptions monthly, and rebuilding the model from scratch quarterly.
What to track against the forecast
Each month, compare three things: actual average positions against forecast positions (are rankings improving at the assumed rate?), actual clicks against forecast clicks (is your CTR model holding?), and actual conversions against forecast conversions (has anything changed in the funnel?). If any of these diverge significantly, diagnose the cause before adjusting the forecast: a divergence is often a signal worth investigating rather than simply correcting for.
When to rebuild rather than adjust
If a major Google algorithm update lands, if you launch a significant site redesign, or if you enter a new product category, your historical baseline may no longer be a reliable predictor of future performance. In these cases, rebuilding the forecast from current data is more honest than applying adjustments to a model that no longer reflects your site's situation.
FAQ
What is the formula for SEO forecasting?
For each keyword: monthly search volume × seasonality index × (CTR at target position minus CTR at current position) × ramp percentage gives added clicks. Multiply added clicks by organic conversion rate and value per conversion (and by close rate for lead generation) to get added revenue. Sum across keywords and run the calculation for conservative, expected, and stretch assumptions.
How accurate can an SEO forecast realistically be?
A forecast built on verified first-party data and realistic CTR assumptions can be directionally accurate over 12 months, though uncertainty grows with the planning horizon. Beyond 12 months, algorithm changes, competitive shifts, and changes in search behavior compound. Present forecasts as ranges rather than point estimates, and revisit assumptions quarterly.
What is the best SEO forecasting tool?
For most teams, a spreadsheet fed by Search Console data is the most transparent option, because every assumption is visible and adjustable. Platform forecasts from tools such as SEOmonitor, seoClarity, or Advanced Web Ranking save time for agencies and large keyword sets, and keyword tools like Ahrefs and Semrush help size opportunities. Use the platform output as a cross-check on your own model.
Should I include branded search in my SEO forecast?
Model branded and non-branded traffic separately. Branded traffic is driven largely by offline activity, PR, and word of mouth: it is not primarily an SEO deliverable. Blending it into your forecast inflates the apparent impact of SEO and makes it harder to isolate the return on your investment.
How do AI Overviews affect SEO forecasting?
AI Overviews reduce organic CTR for certain query types, particularly informational queries where the overview answers the question on the results page. Identify which target keywords trigger AI Overviews and apply a discounted CTR assumption to those terms. Ignoring this leads to systematically overstated traffic projections for information-led content strategies.
What to Do This Week
If you have never built a formal SEO forecast, or your current one is a traffic target without a model behind it, take these five steps this week:
- Export 16 months of Search Console data by query and page, segmented by device, and split branded from non-branded queries. This is your baseline.
- Identify your top 20 non-branded keywords by impressions and check each one in a live search in your target market to categorize the SERP type. Note which trigger AI Overviews or featured snippets: these need separate CTR assumptions.
- Pull your organic conversion rate from your analytics platform for the past three months, segmented by landing page category. If this is not set up, that is the first fix: no conversion data means no revenue forecast.
- Build a conservative, expected, and stretch model in a spreadsheet using your verified inputs. Even a basic version (volume × CTR × conversion rate × value) is more credible than a headline number with no workings.
- Present the forecast with assumptions visible, not just the output. Showing the inputs lets decision-makers challenge assumptions rather than conclusions, which leads to a more productive conversation about what it would take to hit a revenue target.
Related Reading
- SEO ROI: How to Calculate and Maximize Your Return
- The Cost of Delaying SEO Investment | Why Inaction Is a Risk
- Ultimate Guide to Keyword Research
- What Is Topical Authority and How Do You Build It?
- Why Does SEO Still Matter in 2026?
Related research
Original data from Indexed, referenced above or relevant to it:
Written by
Anjan LuthraManaging Partner, Indexed
Anjan Luthra is Managing Partner at Indexed. He has spent over a decade inside high-growth companies building organic search into their primary acquisition channel, and writes about SEO strategy, AI search, and revenue attribution.
What to read next
One email a week
How to turn search into revenue.
One idea a week from live client work: what we changed, what it was worth, and what you can take from it.
One email a week. Unsubscribe in one click.