SEO Content Calendar Template
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.
=IF(K13="","",IF(K13<>"Ready","n.a.",IF(I13=1,"Published",IF(M13<0,"Overdue","In production"))))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.
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
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.
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
- Load the backlogAdd each item with a content ID, keyword, deliverable and owner.
- Set due dates from demandUse the seasonality planner's Start month and the roadmap to set realistic due dates.
- Update hours weeklyEnter completed hours and update the as-of date. Remaining hours roll up on the Dashboard.
- 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.
- 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" } ]
- Save the full JSON responseSave the complete response, not just the task ID, next to the template folder.
- 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
- Add what the API can't knowContent ID, Deliverable, Owner, Due date, Review date, Estimated hours, Completed hours, Published verified
- 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.
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
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.
Use it with these templates
Each template answers one decision. These are the ones that feed into, or follow from, the SEO content calendar template.
05Search Seasonality PlannerLabs: Keyword Overview
Turn monthly search volume into a seasonal index, season-adjusted click targets and a publish-by month.
19SEO Content Brief TemplateLabs: Keyword Overview
A content brief built for Google and AI answers: real questions, original evidence, sources and a three-step approval workflow.
20Content Audit TemplateOn-Page API
Score every URL by lost clicks, conversions and links, choose keep, refresh, merge or retire, and catch the risky calls.
40SEO Roadmap TemplateOn-Page API
Sequence 90 days of SEO and GEO work by weighted opportunity per hour, dependencies and acceptance criteria.
21Content Decay Analysis TemplateLabs: Ranked Keywords
Separate lost impressions, lower CTR and falling demand, so you refresh the pages that really decayed.
01Keyword Prioritization TemplateLabs: Keyword Overview
Rank every keyword by the profit it could add per hour of work, not by search volume alone.
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.
Further reading on Optimization Theory
Built by Jourdan Rombough, technical SEO and GEO consultant with 15+ years in search. About Jourdan or get an SEO plan.






