SEO Forecast Template (Optimization Theory, v3.0, November 2026)
===========================================================

Project added clicks and contribution per keyword cluster with CTR, attainment and seasonality you can defend.

What it decides
  How much additional traffic and monthly contribution a portfolio of keyword clusters could add, with every assumption visible.

Files
  SEO Forecast Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  SEO Forecast Template - Field Guide.pdf  the illustrated guide
  Input-Template-blank.csv ..... column headers in paste order
  Input-Template-example.csv ... the worked example (Northbeam Outdoor, fictional data)
  HOW-TO-USE-WITH-DATAFORSEO.txt step-by-step: request, save, convert, complete, paste
  Automation/ .................. import script, example request, field mapping (python3 Automation/dataforseo_import.py --help)

Built to run on DataForSEO
  Source: DataForSEO Labs: Keyword Overview
  Fills automatically: Keyword, Monthly searches
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Deduplicate into clusters: One row per cluster, using the primary keyword's volume or the cluster's combined volume, never both.
  2. Set baseline and target CTR: Baseline from Search Console; target for the position you can credibly reach.
  3. Apply attainment and seasonality: Attainment discounts the gain (0.5 to 0.7 is sensible). Seasonality scales a specific month (1.0 = average).
  4. Present ranges, not points: Copy the sheet for conservative and stretch scenarios by changing attainment and target CTR.

Works in Microsoft Excel, Google Sheets (upload, then open with Sheets) and LibreOffice Calc.
Paste values only at Workspace cell A13. Lime cells are inputs; blue cells are formulas.

Full tutorial: https://optimizationtheory.com/download-view/seo-forecast-template/
Part of the SEO Business & Delivery Toolkit: https://optimizationtheory.com/download-view/seo-business-toolkit-10-forecasting-and-delivery-workbooks/
All 40 templates: https://optimizationtheory.com/download-view/free-seo-geo-toolkit-40-spreadsheets-and-field-guides/

Free to use in your own and client work. Please don't resell the templates themselves.
Built by Jourdan Rombough, optimizationtheory.com
