Search Seasonality Planner (Optimization Theory, v3.0, November 2026)
================================================================

Turn monthly search volume into a seasonal index, season-adjusted click targets and a publish-by month.

What it decides
  When demand for each keyword peaks, how much to scale traffic expectations month by month, and when to start production so content is ranking before the peak.

Files
  Search Seasonality Planner.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  Search Seasonality Planner - 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, Month number, Searches in month, 12-month searches
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Pull 12 months of volume: Export monthly search volume for each keyword. Use a full year so the annual total is complete.
  2. Enter one row per keyword-month: Each row is one keyword in one month (1 to 12), with that month's searches and the 12-month total.
  3. Add baseline clicks and lead time: Baseline clicks are your average monthly clicks today. Lead months is how far ahead you need to publish, typically 2 to 4.
  4. Plan from the Start month: Read the seasonal index chart, then schedule work by the Start month column, not the peak month.

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-seasonality-planner/
Part of the Keyword Research Toolkit: https://optimizationtheory.com/download-view/keyword-research-toolkit-6-seo-planning-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
