A three-scenario method for forecasting organic search traffic from Search Console data
This working paper describes a reproducible way to forecast organic search traffic (clicks) for a website over the next 6 to 12 months using only a Google Search Console export and a spreadsheet. It covers building a baseline from month-over-month growth, adding seasonality, estimating traffic from planned content with the site's own click-through rates, producing conservative, expected and optimistic scenarios, back-testing the forecast on hidden months, and reporting assumptions and limitations. The record contains the method as a Markdown document and a spreadsheet template (CSV) with the formulas. The numbers in the template are synthetic and only show the arithmetic; they are not client data or benchmarks. A longer step-by-step walkthrough of the same approach: how to forecast traffic growth from SEO.
Authors
- Ruslan Nazarov
Publication Details
- Journal
- Zenodo (CERN European Organization for Nuclear Research)
- Published
- 2026-11-19
- DOI
- https://doi.org/10.5281/zenodo.24381268
- Primary Topic
- Web visibility and informetrics
- Type
- article
- Field-Weighted Citation Impact
- 0.00