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

Track owners, due dates and estimated vs completed hours, and flag overdue work automatically.

What it decides
  What's published, what's in production, what's overdue, and how many production hours remain against your capacity.

Files
  SEO Content Calendar Template.xlsx ............ the workbook (Start Here, Dashboard, Workspace, Delivery QA, Field Guide)
  SEO Content Calendar 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
  Full steps: HOW-TO-USE-WITH-DATAFORSEO.txt (also in the Automation folder), with example-request.json

Quick start
  1. Load the backlog: Add each item with a content ID, keyword, deliverable and owner.
  2. Set due dates from demand: Use the seasonality planner's Start month and the roadmap to set realistic due dates.
  3. Update hours weekly: Enter completed hours and update the as-of date. Remaining hours roll up on the Dashboard.
  4. Review overdue first: Overdue items appear in the action list. Reassign, rescope or re-date them.

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-content-calendar-template/
Part of the Content SEO Toolkit: https://optimizationtheory.com/download-view/content-seo-toolkit-6-audit-brief-and-testing-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
