Templates / Content calendar

Content calendar template

The column structure, then four weeks of filled rows so you can see what a realistic month actually looks like before you commit to one.

Most content calendars die in week three. Not because the team stopped caring, but because the calendar only tracked what to publish and never tracked who owed what by when.

This template adds the two columns that keep it alive: draft due, which is always earlier than publish date, and owner, which is always a person and never a team.

Below the column list you get four filled weeks for a made up project management app selling to small agencies. Copy the structure, keep the cadence, swap the topics for yours.

How to use it

01Create a sheet and paste the header row from the first block into row one. Freeze row one.
02Fill the publish date column for the next four weeks first, before you have any topics. An empty dated row is a prompt. A topic with no date is a wish.
03Work backwards on draft due: publish date minus five working days for blog posts, minus two for social, minus three for the newsletter.
04Assign every row to a named person. If a row has no owner, delete the row or find the owner today.
05Fill the repurpose column at the same time you plan the original. One blog post should feed at least two other slots that month.
06Review every Friday for fifteen minutes: move slipped rows, mark done rows, and add the next week so the calendar never has fewer than three weeks ahead of it.

The template

Header row. Copy this into row one.

Ten columns. Each one earns its place. Adding an eleventh is usually how the calendar starts getting ignored.

What goes in each column

Read this once, then never again. The definitions are what keep two people filling the sheet the same way.

Publish date: the day it goes live. A real date, never a week number.

Channel: blog, newsletter, LinkedIn, Instagram, YouTube, email campaign, podcast. One channel per row.

Working title: a full sentence, not a topic. Weekly project reviews is a topic. How to run a weekly project review people do not dread is a title.

Owner: one named person. Not marketing, not the agency.

Draft due: the date the finished draft lands for review, always before publish date.

Audience: which persona this is for. If you cannot name one, the piece is for nobody.

Primary keyword: the search term for search pieces. Write none for social and newsletter rows rather than leaving it blank.

Call to action: the single thing you want the reader to do. One per row.

Repurpose into: where this piece goes next. Fill it now, not after publishing.

Status: Idea, Briefed, Drafting, In review, Scheduled, Live, Killed.

Week 1. Theme: running better project reviews

Filled example for a project management app sold to small agencies. Two blog posts, two social, one newsletter.

Week 2. Theme: client reporting

Same rhythm, new theme. Notice the guest post row with a longer lead time.

Week 3. Theme: onboarding a new client

This is the week the email campaign runs, so social volume drops on purpose.

Week 4. Theme: capacity and the monthly recap

End of month gets one forward looking piece and one look back. Keep the recap short or it becomes a chore.

The monthly rhythm underneath those four weeks

If you copy nothing else, copy the shape.

Two blog posts a week: one opinion or how to on Monday, one template or checklist on Thursday.

One newsletter a week on Wednesday, built from the Monday post so it costs you thirty minutes, not three hours.

Two to three social posts a week, all of them cut from that week blog posts. Nothing written from scratch.

One bigger swing a month: a guest post, a campaign, a webinar, a research piece.

One theme per week. Four themes a month. Every piece in a week points at the same reader problem.

One recap at month end, which is also your check that the calendar was real.

Status values and what they mean

Shared definitions stop the weekly review turning into a status interrogation.

Idea: dated and owned, nothing written. Fine to sit here for two weeks, not four.

Briefed: the writer has a brief with the angle, audience and keyword agreed.

Drafting: someone is writing it right now.

In review: draft is done and waiting on a named reviewer. Put the reviewer name in the cell.

Scheduled: loaded into the tool with the publish date set.

Live: published, links checked.

Killed: deliberately dropped. Keep the row, do not delete it. Killed rows tell you what you keep over planning.

Friday review, fifteen minutes

The whole maintenance cost of the calendar.

Move anything that slipped to a new date rather than leaving it in the past. A calendar with overdue rows stops being read.

Mark last week rows Live and paste the URL in the working title cell.

Add one new week so you always have at least three weeks planned ahead.

Look at the owner column. If one person owns more than half of next week, rebalance now.

Kill anything that has been an Idea for a month. It is not happening.

Where this usually goes wrong

Tracking publish date but not draft due. The draft is what slips, and without its own column nobody notices until publish day.
Assigning rows to a team instead of a person. Everyone assumes someone else has it.
Planning six months out. Anything past four weeks changes before you get there, and the time spent planning it is gone.
Filling the repurpose column after publishing, which means never. Decide the second use while the piece is still being planned.
Adding columns until the sheet needs horizontal scrolling. Ten columns fit on a screen, and a calendar nobody can see at a glance is a calendar nobody opens.

Common questions

How far ahead should a content calendar be planned?

Four weeks in detail, with themes sketched for the two months after that. Detail past four weeks tends to get rewritten before it ships.

Should social posts live in the same calendar as blog posts?

Yes, if you want repurposing to actually happen. Seeing the Monday blog and the Tuesday social post in adjacent rows is what makes the connection obvious. Split them only when different teams own them and neither will look at the other sheet.

What is a realistic publishing cadence for a small team?

The example above assumes one writer and one social owner. If you have less than that, cut to one blog post a week and keep the newsletter. Cadence you can hold beats cadence you announce.

Where does keyword research fit into this?

Before the calendar, not inside it. Do a research pass, pick the terms worth writing for, then drop one term per search focused row. Creaiter can run the keyword research and drop the terms straight into the plan, but the calendar still needs a human deciding the order.

Related templates

Content brief Social media calendar

Start free