Build an SEO content calendar by starting with your keyword map and topic clusters, not with dates. Rank topics by business value and effort, set a cadence you can sustain, reserve slots for refreshing old pages, assign an owner and deadline to every item, and review results monthly. A spreadsheet with the right columns is enough.
Planning from evidence matters because most pages never earn search traffic: Ahrefs found that 96.55% of the roughly 14 billion pages in its index get zero organic traffic from Google, and it points to missing search demand, no backlinks and mismatched intent as the main reasons (Ahrefs).
Most content calendars I see are lists of dates attached to ideas somebody had in a meeting. They look organised, and they quietly fail, because the ideas were never tested against search demand, the dates ignore how long good work takes, and nobody planned time to maintain what already exists. An SEO content calendar fixes this by putting evidence first and dates second. Here is how I build one, and the decisions you should make before you open a spreadsheet.
What an SEO content calendar is for
A general editorial calendar answers “what are we publishing and when?” An SEO calendar has to answer harder questions as well. Which search need does each piece serve? How does it connect to pages we already have? Who will refresh it, and when? What does success look like for it?
It has three jobs. First, it keeps your publishing tied to demand, so you do not spend a month writing about subjects nobody searches for. Second, it keeps related pieces together, so a topic grows into a connected set of pages instead of scattered posts. Third, it makes maintenance visible, which is the job most calendars forget.
Start from the keyword map and the clusters
The calendar is downstream of two documents. The first is your keyword map, which assigns one primary topic to each URL so that pages do not compete. If you do not have one, my guide to keyword mapping shows how to build it. The second is your cluster plan: a pillar or hub page plus the supporting posts that answer its sub-questions. I explain that structure in the hub guide on topical authority.
With those in hand, the calendar becomes a sequencing exercise rather than an ideas contest. List every gap on the map: a keyword with no page, a cluster with a thin hub, a question your customers ask that you have not answered. Then rank the gaps with a simple score.
- Business value. How close is this topic to something you sell, on a scale of one to three?
- Demand evidence. Is there real search interest, judged from your keyword tool, Search Console queries and the questions customers send you? Score one to three.
- Effort. How much research, expert time and design does it need? Score one for heavy and three for light.
- Cluster fit. Does it strengthen a hub you are already building? Score one to three.
- Add the scores and sort. Take the top of the list first, but keep a mix of quick wins and heavier pieces.
The numbers are mine, and they are only a way to force a conversation. Change them to suit your business. What matters is that every item has a reason to be there.
Rather have an expert do this for you?
Hand it over and get back to running your business.
Set a cadence you can actually sustain
Publishing frequency is not a ranking factor you can dial up. Quality, coverage and consistency count, and consistency means a rhythm you can keep for a year, not a burst you cannot. I size the cadence from capacity with three questions.
- How many hours does one finished piece take from brief to publication, including expert review, edits, design and internal linking? Be honest. A solid piece of around 1,500 to 2,000 words rarely takes a single afternoon. For how to decide the right scope, see blog post length.
- How many hours per month do you have? Divide by the answer above.
- How much of that must go to maintenance? I normally protect a share of the month for refreshes before counting new posts.
| Team situation | Sensible approach |
|---|---|
| One person, part-time on content | Aim for a small number of strong pieces per month, built around one cluster at a time. |
| Small team with a writer and an editor | Run two clusters in parallel and keep a weekly refresh slot. |
| Subject experts are the bottleneck | Batch interviews and reviews, and publish after review windows close. This is especially relevant for health, money and legal pages. |
| Agency or freelance support | Agree the brief and review process first. Volume without briefs creates sameness. |
Plan for seasonality and lead time
If demand for your topic rises at certain times, such as exam results, tax deadlines, Ramadan, Eid, summer travel or the wedding season, publish before the peak, not during it. Pages need time to be crawled, indexed and linked to. I usually plan seasonal pieces to go live some weeks ahead of the expected rise, and I update them every year so the same URL builds history.
To find the timing, use Google Trends. Its figures are relative: each data point is divided by the total searches for the place and period, then scaled from 0 to 100. That is enough to compare when interest climbs and falls year after year, though not to estimate absolute search volume. Pair it with your own Search Console history to see when your pages began to gain impressions in previous years.
Also place long-lead assets early. A piece built on original data, as in original research content, needs weeks for design and collection, so start it long before its slot.
Reserve slots for refreshing existing pages
New posts are only half the plan. Google’s SEO Starter Guide advises checking in on previously published content and updating it as needed, or even deleting it if it is no longer relevant. I turn that into recurring calendar blocks.
- A weekly or fortnightly refresh slot for pages losing impressions. My article on content decay explains how to spot them.
- A quarterly review of top pages for accuracy, broken links and outdated examples.
- An annual pass on seasonal pages, done ahead of their peak.
- A plan for repurposing winners into new formats, which I cover in content repurposing for SEO.
When I audit a calendar, the sign of a healthy one is that refreshes appear as named items with owners, not as an intention to “get to it later”.
The spreadsheet columns that matter
You do not need a special platform. A shared spreadsheet or a simple board will work. What counts is that each row carries enough information for anyone on the team to act without asking questions.
| Column | What goes in it | Why it earns its place |
|---|---|---|
| Working title and slug | The planned headline and final URL | Keeps the map and the calendar in sync |
| Primary keyword and intent | One keyword and its intent type | Prevents two posts targeting the same query |
| Cluster and role | Hub, supporting post or standalone | Shows how the piece links into the structure |
| Type | New, refresh, merge or repurpose | Makes maintenance visible |
| Brief link | Link to the content brief | Nobody starts without one |
| Owner, reviewer | Named people | Removes “someone will do it” |
| Draft, review and publish dates | Three dates, not one | Shows where work stalls |
| Internal links to add | Pages to link to and from | Stops new posts being orphaned |
| Seasonal window | Peak months, if any | Drives when you publish |
| Success measure and review date | The metric and when you will check it | Closes the loop |
Ownership and workflow
A calendar without an owner is a wish list. Give each item one accountable person, even if several people contribute. I run a simple status flow and require each stage to have a clear exit condition.
- Idea: mapped to a keyword and cluster, with a score.
- Briefed: brief written and approved by whoever owns the topic.
- Drafting: writer has everything needed, including source material and expert contact.
- Review: accuracy, intent and links checked by a second person.
- Scheduled: published or queued, with internal links added to older pages.
- Measuring: a date set to review performance.
Within a cluster, I normally publish the hub or the most central supporting post first, so later posts have somewhere to link. If a supporting post must come first for timing reasons, link to the hub slot as soon as it exists and revisit the older post.
Measuring what the calendar produces
Check each item at the review date you set, usually after a few months, since search results take time to settle. Look at impressions and queries in Search Console, clicks, internal links gained, and the business action the page was meant to support, such as enquiries or sign-ups. I judge the calendar as a whole by cluster, not post by post, because a single post often depends on its neighbours. Then feed what you learn back into the next scoring round: topics that attracted impressions deserve follow-ups, and formats that stalled deserve rethinking. I never promise a result from a publishing schedule alone.
Questions people ask about an SEO content calendar
How far ahead should I plan?
Plan about a quarter in detail and a year loosely. The detailed quarter keeps work moving. The loose year captures seasonal peaks and long-lead projects, and you revise it as data comes in.
How often should I publish?
As often as you can maintain quality. There is no frequency that Google rewards in itself. A modest cadence of well-briefed, reviewed posts and regular refreshes will beat an ambitious schedule that you drop after two months.
Should the calendar include old posts?
Yes. Refreshes, merges, redirects and removals belong in the same plan as new content, with owners and dates, because they often return more per hour than a new post.
What tool should I use?
Use whatever your team will open every week. A shared spreadsheet covers most needs. Move to a board or project tool only when handovers or approvals become hard to track.
If you would like help turning a keyword map into a calendar that covers new content, refreshes and internal linking, that is part of my on-page optimisation services. You can ask for a free audit and I will review your current plan first.
More in this series (Content strategy and writing): start with Topical Authority: The Ultimate Guide to Dominating Your Niche, then explore:
- How to Write an SEO Content Brief (Free Template Structure)
- Pillar Pages: How to Plan and Write One That Ranks
- Comparison Pages: How to Write X vs Y Content That Ranks
- FAQ Page SEO: When FAQs Help and How to Write Them
- Original Research Content: How to Publish Data People Cite
- Blog Post Length for SEO: How Long Should a Post Be?
- Information Gain in SEO: How to Add Something New
- YMYL Content: How to Write Health, Money and Legal Pages Safely
Request received
Thank you! Saad will contact you within the next 24 hours.
Keep an eye on your phone and inbox.