Building an SEO forecast does not need to mean creating a complicated spreadsheet from scratch.
This free SEO forecast template helps you estimate how keyword ranking improvements could affect organic traffic, conversions, revenue and SEO ROI over the next 12 months.
The spreadsheet includes editable assumptions, keyword-level forecasting, three growth scenarios, revenue projections and forecast-vs-actual tracking.
Use it for:
- SEO proposals
- client forecasting
- in-house SEO planning
- content investment decisions
- traffic projections
- SEO revenue forecasts
- SEO ROI estimates
- monthly forecast tracking
The template is designed for Excel and can also be adapted for Google Sheets.
No account is required. Replace the example data with your own keywords and assumptions.
SEO forecasts are planning estimates, not guarantees. Rankings, clicks, conversions and revenue can differ from the forecast because search demand, competition, SERP features, algorithms and implementation quality can change.
What Is Included in the SEO Forecast Template?
The workbook contains seven sections that work together.
1. Read Me
The first tab explains how to use the spreadsheet.
It shows which cells should be edited and how the other sheets connect.
The basic workflow is:
Assumptions → Keywords → Traffic → Conversions → ROI → Actual Results
If you are new to SEO forecasting, start here before changing any formulas.
2. Assumptions & CTR Curve
The Assumptions tab contains the main variables used throughout the forecast.
You can edit:
- conversion rate
- value per conversion
- monthly SEO investment
- forecasting period
- current organic traffic
- CTR assumptions by ranking position
- monthly growth ramp
- scenario multipliers
Orange cells are designed to be edited.
The workbook includes a starter CTR curve so the model works immediately, but you should replace those assumptions with your own data when possible.
If your website already receives search traffic, Google Search Console can help you calculate a CTR curve based on your actual performance.
Why CTR Matters in an SEO Forecast
Search volume is not the same as traffic.
A keyword with 10,000 monthly searches does not automatically generate 10,000 visitors.
A basic SEO traffic forecast uses:
Projected Clicks = Search Volume × Expected CTR
If a keyword receives 5,000 monthly searches and the expected CTR is 8%:
5,000 × 8% = 400 estimated monthly clicks
The CTR assumption therefore has a major effect on the forecast.
For quick individual keyword calculations, you can also use our Keyword Traffic Forecaster.
3. Keyword Opportunities
The Keyword Opportunities tab is where most of your keyword-level forecasting happens.
For every keyword, enter:
- keyword
- monthly search volume
- current ranking position
- target ranking position
- search intent
- priority
- optional notes
The spreadsheet then calculates:
- current estimated CTR
- target CTR
- current estimated clicks
- projected clicks
- incremental traffic opportunity
Example
Suppose a keyword has:
- Monthly search volume: 5,000
- Current position: 15
- Target position: 5
The spreadsheet looks up the CTR assumption for both positions.
If:
Current CTR = 1.5%
and:
Target CTR = 6.5%
then:
Current clicks = 5,000 × 1.5% = 75
Projected clicks = 5,000 × 6.5% = 325
Potential incremental traffic:
325 − 75 = 250 additional monthly clicks
Repeat this calculation across your keyword portfolio and the spreadsheet combines the opportunities into the broader forecast.
If you are unsure whether a target ranking is realistic, check it first with the Ranking Potential Estimator.
Do Not Assume Every Keyword Will Rank #1
One of the easiest ways to make an SEO forecast unrealistic is to set position one as the target for every keyword.
Target positions should consider:
- current rankings
- search intent
- content quality
- competition
- backlinks
- domain strength
- SERP features
- internal linking
- technical SEO
For some keywords, moving from position 14 to position 7 may already be a strong result.
Forecasting realistic improvements generally produces a more useful planning model than assuming maximum rankings.
4. 12-Month Traffic Forecast
The Traffic Forecast sheet turns your keyword opportunities into a monthly projection.
It creates three scenarios:
Conservative
Assumes slower progress and a lower share of the total keyword opportunity.
Use this scenario when:
- the site is new
- competition is strong
- resources are limited
- implementation may be slow
Expected
Represents the central planning scenario.
This should use the assumptions you consider most realistic.
Aggressive
Models stronger-than-expected performance.
It may assume:
- faster ranking improvements
- higher traffic capture
- better implementation
- more successful content
- stronger link acquisition
The spreadsheet gradually applies the forecast across 12 months instead of assuming every ranking improvement happens immediately.
That is important because SEO growth normally occurs over time.
Why Use Multiple SEO Forecast Scenarios?
A single number can give a false impression of certainty.
For example:
“SEO will generate 20,000 visits.”
sounds like a guarantee.
A more useful forecast might say:
| Scenario | Month 12 Traffic |
|---|---|
| Conservative | 14,000 |
| Expected | 18,500 |
| Aggressive | 23,000 |
This helps stakeholders understand the range of possible outcomes.
The goal is not to predict Google perfectly.
The goal is to understand what different levels of SEO performance could mean for the business.
For a deeper explanation, read our guide to SEO traffic forecasting.
5. Conversions, Revenue & SEO ROI
Traffic alone does not explain whether an SEO campaign makes financial sense.
The Conversions & ROI tab connects projected traffic with business results.
The model uses:
Projected Conversions = Organic Traffic × Conversion Rate
Then:
Projected Revenue = Conversions × Value per Conversion
And:
SEO ROI = (SEO Return − SEO Cost) ÷ SEO Cost × 100
Example SEO Revenue Forecast
Imagine the forecast predicts:
8,000 monthly organic clicks
Your conversion rate is:
2.5%
Expected conversions:
8,000 × 2.5% = 200
If the average conversion is worth:
$250
Projected monthly revenue:
200 × $250 = $50,000
If monthly SEO investment is:
$8,000
the spreadsheet can compare the estimated return with the campaign cost.
For a standalone calculation, use our SEO ROI & Revenue Forecaster.
Revenue Is Not the Same as Profit
Be careful when interpreting ROI.
If you run an ecommerce store, gross revenue should not automatically be treated as profit.
For a more conservative model, consider using:
- gross profit per sale
- contribution margin
- lead value
- expected lifetime value
- profit per customer
Choose the metric that makes sense for your business.
6. Forecast vs Actual
A useful SEO forecast should not be created once and forgotten.
The Forecast vs Actual tab lets you enter your real monthly performance after the campaign begins.
Track:
- forecast clicks
- actual clicks
- traffic variance
- forecast revenue
- actual revenue
- revenue variance
- notes
This lets you answer questions such as:
- Are rankings improving faster than expected?
- Is CTR lower than forecast?
- Is traffic growing but conversions underperforming?
- Did seasonality affect search demand?
- Should the next forecast use different assumptions?
Example
Forecast:
10,000 organic clicks
Actual:
8,700 clicks
Variance:
−1,300 clicks
Instead of simply calling the forecast wrong, investigate why.
Possible reasons include:
- ranking targets were too aggressive
- search volume declined
- CTR assumptions were too high
- SERP features reduced organic clicks
- content was published late
- competitors improved
- implementation was incomplete
Then adjust the next forecast.
7. SEO Forecast Dashboard
The final tab provides a simple dashboard showing the most important forecast outputs.
It includes:
- baseline monthly traffic
- expected Month 12 traffic
- projected 12-month revenue
- projected 12-month ROI
- traffic scenario chart
- monthly revenue chart
This makes the template easier to use in:
- client presentations
- strategy meetings
- internal planning
- SEO proposals
- monthly reporting
How to Use the SEO Forecast Template
Here is the recommended process.
Step 1: Download the Spreadsheet
Download the free Excel workbook and save a working copy.
Keep an untouched original copy in case you want to reset your forecast later.
Step 2: Update the Main Assumptions
Open the Assumptions tab.
Replace:
- conversion rate
- value per conversion
- SEO cost
- current traffic
with numbers relevant to your website or client.
Do not rely on the example assumptions for a real business forecast.
Step 3: Review the CTR Curve
The workbook includes starter CTR assumptions.
For an established website, consider creating your own CTR curve using Search Console.
For example, calculate the average CTR of your non-branded queries at:
- position 1
- position 2
- position 3
- positions 4–5
- positions 6–10
- positions 11–20
First-party data is usually more useful than assuming every website receives the same CTR.
Should You Include Branded Keywords?
Usually, forecast branded and non-branded traffic separately.
Brand searches can be affected by:
- paid advertising
- PR
- offline campaigns
- social media
- existing customers
- brand awareness
If your goal is to forecast the impact of SEO activity, non-branded keyword growth often provides a clearer view.
Step 4: Add Your Keywords
Open Keyword Opportunities.
Replace the example rows with your own data.
For each keyword, enter:
Keyword
Search Volume
Current Position
Target Position
Intent
Priority
Try to include realistic opportunities rather than every keyword found in a keyword research tool.
A useful starting point is often:
- keywords already in positions 4–10
- keywords in positions 11–20
- high-value keywords in positions 21–30
- relevant new content opportunities
Step 5: Review Incremental Traffic
The spreadsheet calculates estimated current and future clicks.
Pay attention to:
Incremental Clicks
This represents the additional monthly traffic opportunity from reaching the target position.
Do not treat total projected clicks as entirely new traffic when the page already receives clicks.
Step 6: Review the Three Traffic Scenarios
Open Traffic Forecast.
Compare:
- Conservative
- Expected
- Aggressive
Ask whether the expected scenario still looks realistic when viewed month by month.
If Month 3 growth looks unreasonable, adjust the scenario ramp on the Assumptions tab.
Step 7: Add Conversion and Revenue Data
Open Conversions & ROI.
Check:
- projected conversions
- revenue
- SEO cost
- net return
- ROI
These calculations can help connect search performance to business outcomes.
Step 8: Track Actual Results
Once implementation starts, update the Forecast vs Actual tab every month.
Do not rewrite the original forecast to make it match reality.
Keep the original assumptions and compare them with actual performance.
That is how you learn which assumptions need improvement.
SEO Forecast Template Example
Imagine an SEO campaign targeting 50 keywords.
Current estimated organic traffic from those keywords:
3,000 clicks per month
Expected traffic after achieving the target rankings:
6,500 clicks per month
Incremental opportunity:
3,500 additional monthly clicks
The forecast may distribute that growth like this:
| Month | Expected Organic Clicks |
|---|---|
| 1 | 3,100 |
| 2 | 3,300 |
| 3 | 3,600 |
| 4 | 3,950 |
| 5 | 4,300 |
| 6 | 4,650 |
| 7 | 5,050 |
| 8 | 5,400 |
| 9 | 5,750 |
| 10 | 6,000 |
| 11 | 6,250 |
| 12 | 6,500 |
This does not mean Google will follow that exact curve.
It gives the team a measurable expectation to compare with actual results.
SEO Forecast Template for New Websites
New websites present a different forecasting problem because there may be little or no historical traffic.
In this situation, rely more heavily on:
- keyword research
- competitor rankings
- search volume
- realistic target positions
- content publishing schedule
- backlink plans
- conservative timelines
Avoid assuming that a new domain will immediately achieve top-three rankings.
For a new website, you might model:
Months 1–3: crawling, indexing and early visibility
Months 4–6: initial ranking improvements
Months 7–9: stronger top-20 and top-10 rankings
Months 10–12: larger gains from successful pages
The actual timeline can vary significantly.
SEO Forecast Template for Existing Websites
Existing websites have more useful first-party data.
Use:
- Google Search Console
- analytics
- current keyword rankings
- historical organic traffic
- conversion data
- actual revenue or lead value
A strong model for an established site can combine:
Existing traffic baseline + ranking improvements + new content opportunity
This is generally more useful than forecasting solely from generic keyword search volume.
How Search Console Improves an SEO Forecast
Google Search Console can provide:
- clicks
- impressions
- CTR
- average position
- query data
- landing page data
- country data
- device data
You can use this information to replace generic assumptions.
For example, instead of using an industry CTR estimate for position five, calculate how your own website historically performs around position five.
This can make the forecast more relevant to your specific site.
What This SEO Forecast Template Does Not Predict
No spreadsheet can know exactly what Google will do.
This template does not guarantee:
- future rankings
- algorithm changes
- competitor activity
- future search volume
- AI Overview visibility
- SERP layouts
- conversions
- revenue
- backlinks
- campaign execution
Those factors introduce uncertainty.
The spreadsheet helps organize assumptions and calculate scenarios. It does not remove uncertainty from SEO.
Common SEO Forecasting Mistakes
Using Search Volume as Traffic
Search volume represents searches, not guaranteed visits.
Apply an expected CTR.
Assuming Every Keyword Ranks #1
This usually produces inflated forecasts.
Use realistic target positions.
Ignoring Existing Traffic
Calculate incremental opportunity rather than treating all projected clicks as new traffic.
Using One Scenario
Build ranges instead of relying on one outcome.
Ignoring Seasonality
Search demand can change throughout the year.
Using Generic CTR Forever
Replace generic assumptions with your own Search Console data as it becomes available.
Forgetting Conversions
More traffic does not automatically mean more revenue.
Forecasting Revenue Without Cost
Include SEO investment when evaluating return.
Never Comparing Forecast vs Actual
The forecast becomes more useful when you learn from the differences.
Who Is This SEO Forecast Spreadsheet For?
The template can be used by:
SEO Freelancers
Use it to explain potential traffic and ROI to clients.
SEO Agencies
Build conservative, expected and aggressive scenarios for proposals.
In-House SEO Teams
Estimate the potential impact of SEO projects before requesting resources.
Content Teams
Model traffic opportunity from planned content.
Ecommerce Businesses
Connect organic traffic forecasts with conversion rates and order value.
SaaS Companies
Translate organic traffic growth into trials, leads or customers.
Website Owners
Understand the potential upside of improving existing rankings.
Excel SEO Forecast Template vs Google Sheets
The template is provided as an Excel .xlsx workbook.
Excel is useful when:
- working with larger keyword lists
- building complex formulas
- keeping local copies
- working offline
Google Sheets can be useful when:
- collaborating with a team
- sharing a forecast with clients
- updating data together
- working entirely in the browser
You can upload the .xlsx file to Google Drive and open it in Google Sheets, though you should verify formulas and charts after conversion.
How Often Should You Update an SEO Forecast?
There are two different updates to consider.
Actual Performance
Update actual results every month.
Forecast Assumptions
Perform a deeper review approximately quarterly or when something significant changes.
Examples:
- major algorithm update
- large site migration
- major content launch
- significant change in conversion rate
- SERP layout change
- new competitor
- major change in search demand
Avoid changing assumptions every week simply because rankings fluctuate.
Can You Use the Template for Client SEO Forecasting?
Yes.
For client work, clearly document:
- data sources
- CTR assumptions
- ranking assumptions
- conversion assumptions
- SEO costs
- scenario definitions
Avoid presenting the expected scenario as a guaranteed commitment.
A client forecast should communicate:
What could happen if the assumptions are achieved.
It should not imply:
This exact traffic or revenue result is guaranteed.
Frequently Asked Questions
What is an SEO forecast template?
An SEO forecast template is a spreadsheet or model used to estimate future organic traffic, conversions, revenue and ROI based on variables such as search volume, rankings, CTR and conversion rates.
Is this SEO forecast template free?
Yes. The Excel template is free to download and can be used for SEO planning.
Can I use this template in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. Check that formulas and charts have imported correctly.
How does the template calculate SEO traffic?
At keyword level, the basic calculation is:
Search Volume × Expected CTR = Projected Clicks
The workbook compares current and target positions to estimate incremental traffic.
How does the template calculate SEO ROI?
The workbook combines projected traffic, conversion rate, value per conversion and SEO costs.
A simplified ROI formula is:
(SEO Return − SEO Cost) ÷ SEO Cost × 100
Are the CTR values guaranteed?
No. The included CTR curve is a starter assumption. Actual CTR differs by keyword, intent, SERP layout, brand recognition, device and other factors.
Should I replace the CTR assumptions?
Yes, especially if you have enough Google Search Console data to build a CTR curve based on your own site.
Can I forecast SEO for a new website?
Yes, but uncertainty is higher because there is less historical data. Use conservative ranking and timeline assumptions.
Can the spreadsheet predict Google rankings?
No. It models what could happen if particular ranking targets are achieved. It does not predict Google’s ranking algorithm.
How far ahead should I forecast SEO?
The included model covers 12 months. This is useful for many campaigns, but uncertainty generally increases the further ahead you forecast.
Download the Free SEO Forecast Template
Build your own SEO forecast using keyword opportunities, ranking scenarios, traffic projections, conversions, revenue and ROI.
Free SEO Forecast Template Includes:
- keyword opportunity model
- editable CTR curve
- 12-month traffic forecast
- conservative scenario
- expected scenario
- aggressive scenario
- conversion forecast
- revenue forecast
- SEO ROI calculation
- forecast-vs-actual tracking
- dashboard and charts
After downloading, replace the example data with your own keywords and assumptions.
You can also use our free tools alongside the spreadsheet:
- Keyword Traffic Forecaster — estimate clicks from rankings and search demand.
- Ranking Potential Estimator — evaluate realistic ranking scenarios.
- SEO ROI & Revenue Forecaster — calculate potential revenue and ROI.
- SEO Traffic Forecasting Guide — learn the full forecasting process.
The purpose of an SEO forecast is not to promise an exact result. It is to make the assumptions behind an SEO strategy measurable so that you can compare expectations with what actually happens.