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

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
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
article

A three-scenario method for forecasting organic search traffic from Search Console data

Ruslan Nazarov
Zenodo (CERN European Organization for Nuclear Research)
Web visibility and informetrics
article

A three-scenario method for forecasting organic search traffic from Search Console data

Ruslan Nazarov
article en

Abstract

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.

Zenodo (CERN European Organization for Nuclear Research)
Web visibility and informetrics
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.

Laika access coming soon