SEO Content Calendar Template

Content SEO Toolkit, template 5 of 6

SEO Content Calendar Template

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

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

  • 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.

SEO Content Calendar Template.xlsx
N13fx=IF(K13="","",IF(K13<>"Ready","n.a.",IF(I13=1,"Published",IF(M13<0,"Overdue","In production"))))

Start HereDashboardWorkspaceDelivery QAField Guide

The formula above is the real one from cell N13. 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 import --template 23

Paste at A13Dashboard, checks and action list update instantly.SEO Content Calendar Template.xlsx

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

Content IDKeywordDeliverableOwnerDue dateReview dateEstimated hoursCompleted hoursPublished verifiedSource reference
2 of 10 input columns come straight from DataForSEO

What the SEO content calendar template decides

An SEO content calendar isn't a list of publish dates. It's a capacity plan: how many hours each piece takes, how many are done, and whether the work will land before the date that matters, especially for seasonal topics.

This SEO content calendar template tracks each content item with its keyword, deliverable, owner, due date, an as-of date, estimated and completed hours, and published status. It calculates remaining hours and days to due date, and labels each item Published, In production or Overdue.

Who it's for

  • Content managers running a production pipeline
  • SEOs coordinating writers, designers and developers
  • Agencies reporting delivery to clients
  • Small teams balancing new content with refreshes

Where it fits in your workflow

The SEO content calendar template answers one question. These three templates answer the questions around it:

  • Search Seasonality Planner: 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.
  • SEO Content Brief Template: which sections of a page are ready to publish, and what each unfinished section needs next: writing, fact-checking or editor approval.
  • Content Audit Template: what to do with each existing page (keep, refresh, merge or retire) and which decisions would throw away conversions, links or a merge destination.

What's inside the download

One ZIP with the workbook, a 10-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. 10 input columns, 4 calculated columns, room for 250 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 content calendar template calculation works

Remaining hours = estimated − completed (never negative). Days to due = due date − as-of date. Status = Published if published, Overdue if days to due is negative, otherwise In production.

The key formula, exactly as it appears in the workbook

=IF(K13="","",IF(K13<>"Ready","n.a.",IF(I13=1,"Published",IF(M13<0,"Overdue","In production"))))
Result column Plain-English formula What it tells you
Remaining hours MAX(0,Estimated hours-Completed hours) Uncompleted planned hours.
Days to due date Due date-Review date Calendar days from fixed review date to due date.
Schedule status IF(Published verified=1,"Published",IF(Days to due date<0,"Overdue","In production")) A publication flag requires actual release verification.

The results you will see

PublishedOverdueIn production

Green meets the checks, red needs fixing first, amber needs a human decision and blue marks an opportunity. Rows with missing or out-of-range inputs are held back in the Input check column until they're fixed, so a half-filled row never sneaks into a total.

How to use the SEO content calendar template

  1. Load the backlogAdd each item with a content ID, keyword, deliverable and owner.
  2. Set due dates from demandUse the seasonality planner's Start month and the roadmap to set realistic due dates.
  3. Update hours weeklyEnter completed hours and update the as-of date. Remaining hours roll up on the Dashboard.
  4. Review overdue firstOverdue items appear in the action list. Reassign, rescope or re-date them.

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 SEO content calendar template 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.

DataForSEO supplies the URL or query list and the audit trail; you add the measurements listed below.

  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 import --template 23 --input response.json --output my-inputs.csv
  4. Add what the API can't knowContent ID, Deliverable, Owner, Due date, Review date, Estimated hours, Completed hours, Published verified
  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 Content ID, Deliverable, Owner, Due date, Review date, Estimated hours, Completed hours, Published verified

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 10 example rows.

10Records
0Rows with input issues
63Remaining production hours
2Overdue items

Two example items are overdue, including a day-hike checklist that's tied to a seasonal window. The Dashboard shows 63 production hours still outstanding.

Top 10 by remaining hours

# Content ID Remaining hours
1 C-104 16.0
2 C-110 12.0
3 C-108 10.0
4 C-107 10.0
5 C-102 6.0

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
content_id Content ID Stable identifier for the planned deliverable. Your records
keyword Keyword Exact query in the selected country and language. DataForSEO: keyword
deliverable Deliverable Specific new page, refresh, comparison or original research task. Your records
owner Owner Person accountable for the next action. Your records
due_date Due date Agreed publication or handoff date. Your records
as_of Review date Fixed planning date for this review. Your records
estimated_hours Estimated hours Total expected production hours. Your records
completed_hours Completed hours Hours of the planned work already completed. Your records
published Published verified 1 after the live URL and final QA are checked. 1 = Yes, 0 = No. 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

A completed effort estimate does not mean the content was published. The publication flag is a separate verification.

Limits. Keyword demand informs selection. DataForSEO cannot supply owner, production capacity or publication approval.

Content calendar template mistakes to avoid

Planning by publish date onlyWithout hours, you can't see whether the plan fits the team's capacity.
Not updating the as-of dateOverdue status depends on it. Update it each time you review the calendar.
Mixing refreshes and new pieces without labelsUse the deliverable field so refresh work isn't invisible.

Tips from practice

  • Pull refresh items from the content audit and decay templates.
  • Group by owner to spot overloaded people.
  • Keep a separate copy per quarter for clean reporting.

Frequently asked questions

What is an SEO content calendar?

A schedule of content to create or update, tied to target keywords, owners and deadlines, and ideally to production capacity.

How far ahead should I plan content?

At least a quarter, and further for seasonal topics that need publishing two to four months before peak demand.

Can I use this in Google Sheets?

Yes. Upload the XLSX to Google Drive and open it in Google Sheets.

How do I track content capacity?

Estimate hours per item, record completed hours, and compare total remaining hours with the team's available hours.

Part of the Content SEO Toolkit

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

Download the Content SEO 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