Search Seasonality Planner

Keyword Research Toolkit, template 5 of 6

Search Seasonality Planner

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

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.

  • Excel workbook (.xlsx), opens in Google Sheets
  • PDF field guide, 9 to 11 pages
  • Blank and worked CSV templates
  • DataForSEO import script

Free, no email required. Version 3.0, updated November 2026.

Search Seasonality Planner.xlsx
J13fx=IF(H13="","",IF(H13<>"Ready","n.a.",E13*I13))

Start HereDashboardWorkspaceDelivery QAField Guide

The formula above is the real one from cell J13. Scroll it sideways to read the whole rule.

Connected to the DataForSEO API

This template is designed around one DataForSEO endpoint. Pull the data, convert it with one command, and the workbook does the rest.

Setup steps

DataForSEO Labs: Keyword OverviewSearch volume, monthly history, difficulty and intent for a list of keywordsdataforseo_labs/google/keyword_overview/live

Save the JSON responseThe full API response, kept as your source of truth.response.json

Run the import scriptOffline. No API calls, no credentials.dataforseo_import.py seasonality

Paste at A13Dashboard, checks and action list update instantly.Search Seasonality Planner.xlsx

Column map for this template:Filled by the APIAudit trail (automatic)You add

KeywordMonth numberSearches in month12-month searchesAverage-month clicksProduction lead monthsSource reference
5 of 7 input columns come straight from DataForSEO

What the search seasonality planner decides

Seasonal keywords punish late publishing. A ski jacket guide published in November catches the tail of the season; the same guide published in August has time to get crawled, indexed and climb before demand arrives. Yet most content calendars plan around the month a topic is popular, not the months before it.

This seasonal keyword planner calculates a seasonal index for every keyword-month (that month's searches ÷ the monthly average), scales your baseline clicks by it, and works backwards from each month by your lead time to show the month production should start. The Dashboard charts the index so you can see each keyword's season at a glance.

Who it's for

  • Ecommerce and retail SEOs with seasonal catalogs
  • Travel, events, education and tax-season businesses
  • Content leads building an annual calendar
  • Analysts explaining why traffic 'dropped' in a predictable month

Where it fits in your workflow

The search seasonality planner answers one question. These three templates answer the questions around it:

  • SEO Forecast Template: how much additional traffic and monthly contribution a portfolio of keyword clusters could add, with every assumption visible.
  • SEO Content Calendar Template: what's published, what's in production, what's overdue, and how many production hours remain against your capacity.
  • Keyword Prioritization Template: which keywords deserve your next hours of work, ranked by the monthly profit each could add per hour invested, with every assumption visible and editable.

What's inside the download

One ZIP with the workbook, a 7-column input template (blank and filled), the PDF field guide and an offline script that converts saved DataForSEO responses into the input CSV. The workbook has five tabs.

Workspace. The working table. 7 input columns, 4 calculated columns, room for 1,000 rows. Dropdowns, Yes/No fields and range checks catch bad inputs as you paste.
Start Here. What it decides, a four-step setup and the colour key.
Dashboard. KPI cards, charts, a ranked Top 10 and an automatic action list.
Delivery QA. Pass, fail or exclude each validation step with evidence, owner and date.
Field Guide. Every field explained, plus each formula in plain English.

How the seasonal keywords calculation works

Seasonal index = monthly searches ÷ (annual total ÷ 12). An index of 1.80 means that month runs 80% above average. Season-adjusted clicks = baseline clicks × index. Start month = the peak month minus your lead months, wrapped around the calendar.

The key formula, exactly as it appears in the workbook

=IF(H13="","",IF(H13<>"Ready","n.a.",E13*I13))
Result column Plain-English formula What it tells you
Seasonal index Searches in month ÷ (12-month searches ÷ 12) Month searches divided by the 12-month average.
Season-adjusted clicks Average-month clicks × Seasonal index Average-month clicks multiplied by seasonal index.
Start month MOD(Month number-Production lead months-1,12)+1 Calendar month to start production, wrapping to the previous year when required.

How to use the search seasonality planner

  1. Pull 12 months of volumeExport monthly search volume for each keyword. Use a full year so the annual total is complete.
  2. Enter one row per keyword-monthEach 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 timeBaseline 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 monthRead the seasonal index chart, then schedule work by the Start month column, not the peak month.

The worked example in the Workspace tab. Clear the lime input cells, paste your CSV at A13 (values only) and every result recalculates.

Fill the search seasonality planner with DataForSEO

Every template in this library is built to run on DataForSEO data. This one uses DataForSEO Labs: Keyword Overview: search volume, monthly history, difficulty and intent for a list of keywords.

A helper command builds the input rows from saved API responses. The seasonality command expands each keyword's 12-month history into 12 rows and calculates the annual total. Add base clicks and lead months yourself.

  1. Request the dataSend this request with your DataForSEO API login (HTTP Basic auth).
    POST https://api.dataforseo.com/v3/dataforseo_labs/google/keyword_overview/live [ { "keywords": [ "your keyword 1", "your keyword 2" ], "location_code": 2840, "language_code": "en" } ]
  2. Save the full JSON responseSave the complete response, not just the task ID, next to the template folder.
  3. Convert it with the included scriptIt runs offline, makes no API calls and never sees your credentials.
    python3 Automation/dataforseo_import.py seasonality --input keyword-overview.json --output my-inputs.csv
  4. Add what the API can't knowAverage-month clicks, Production lead months
  5. Paste at A13Clear the demo rows, paste the CSV values at Workspace cell A13 and the dashboard updates.
Fills automatically from DataForSEO You add
Keyword, Month number, Searches in month, 12-month searches Average-month clicks, Production lead months

Source reference fills automatically with the task ID, endpoint, location, language, device and snapshot time, so every row is traceable. Before a big pull, estimate the cost with the DataForSEO pricing calculator. The same steps, plus an example request file, are in the download's Automation folder.

Worked example: Northbeam Outdoor

Every template ships filled with data from Northbeam Outdoor, a fictional outdoor-gear retailer that appears across all 40 workbooks, so you can see what useful output looks like before you add your own. This workbook has 24 example rows.

24Records
0Rows with input issues
24Keyword-month rows
2.69Peak seasonal index

The down jacket peaks in December at well over twice its average month, so production needs to start in October. Hiking boots run the other way, peaking in late spring.

Top 10 by season-adjusted clicks

# Keyword Season-adjusted clicks
1 mens down jacket 3,903
2 mens down jacket 3,191
3 waterproof hiking boots 2,683
4 waterproof hiking boots 2,683
5 waterproof hiking boots 2,439

Input fields

Keep the columns in this order when you prepare a CSV. A missing observation stays blank; use 0 only for a measured zero or a verified No. Fields marked DataForSEO can be filled automatically by the included script.

CSV field Column Meaning and rule Source
keyword Keyword Exact query in the selected country and language. DataForSEO: keyword
month Month number Calendar month 1 through 12. DataForSEO: month
monthly_searches Searches in month Search volume for this keyword-month from monthly_searches. DataForSEO: monthly_searches
annual_total 12-month searches Sum of the same 12 monthly values for this keyword. DataForSEO: annual_total
base_clicks Average-month clicks Assumed clicks in an average month, before seasonality. Your records
lead_months Production lead months Whole months needed before peak demand. Your records
source_ref Source reference Task ID, export filename and observation scope. Retain the untouched source response separately. Optional. DataForSEO: source_ref

Reading the result honestly

An index of 2 means twice the trailing 12-month average. It does not mean demand doubled year over year.

Limits. Historical patterns can shift. The annual total must cover the same 12 monthly observations.

Seasonal keywords mistakes to avoid

Using a single average month as the forecastFlat monthly targets make every winter look like a failure and every summer like a win. Report against the seasonal index.
Planning content in the peak monthBy the time demand peaks it's too late to rank. Use the Start month.
Mixing yearsKeep the 12 months from one continuous year so the annual total matches.

Tips from practice

  • Feed the index into the SEO forecast template's seasonality column.
  • Use the same index to explain month-over-month swings in reporting.
  • Pair with the content calendar template so due dates come from Start month automatically.

Frequently asked questions

What is search seasonality?

It's the predictable rise and fall of search demand for a keyword across the year, driven by weather, holidays, school terms and buying cycles.

How do I calculate a seasonal index?

Divide a month's search volume by the average monthly volume for the year. Above 1 is above-average demand; below 1 is below.

How far ahead should I publish seasonal content?

Usually two to four months before the peak, longer for competitive topics or new sites. That's what the lead months input controls.

Where can I get monthly search volume?

Google Keyword Planner, Google Trends (as a relative index), or the DataForSEO search volume endpoint, which returns 12 months per keyword.

Part of the Keyword Research Toolkit

Get all 6 Keyword Research templates in one ZIP, or the complete set of 40 SEO and GEO templates with the 401-page field handbook.

Download the Keyword Research Toolkit

See the complete SEO & GEO toolkit

Jourdan Rombough

Built by Jourdan Rombough, technical SEO and GEO consultant with 15+ years in search. About Jourdan or get an SEO plan.

More on digital marketing in our blog

See all posts