Content Calendar Template
Editorial calendar with pillar → cluster mapping, publish cadence, channel spread, and post-mortem review columns. Works in Notion, Airtable, or Sheets.
Most content calendars die because they were built as a list of dates instead of a system of record. This spec gives you the columns that make a calendar useful for planning, production, and the review afterwards, plus the pillar to cluster mapping that keeps individual posts working toward a search and authority goal. It works unchanged in Notion, Airtable, or a spreadsheet.
Reach for this when
- Publishing has become reactive and nobody can say what ships three weeks from now.
- You are mapping a quarter of content to a small number of topics you intend to own.
- More than one person writes, edits, or approves, and work stalls in handoffs.
- You want to review performance by topic and format, not by individual post.
The planning columns
These are filled before anything is written. They answer why the piece exists and what it is supposed to do.
- Title, working. Expect it to change.
- Pillar. The topic you intend to own. Three to five per year, no more.
- Cluster. The subtopic under that pillar, usually one search intent.
- Primary keyword or question, with the exact phrasing a reader would type or ask.
- Funnel stage: awareness, consideration, or decision.
- Audience segment, matched to the segments in your plan.
- Business goal this piece serves: rank, convert, enable sales, or retain.
- Format: article, video, carousel, newsletter, webinar, template, case study.
- Internal link targets, meaning the two or three existing URLs this piece should point to.
The production columns
These move the piece through the pipeline. Keep the status vocabulary short. Long status lists get gamed.
- Owner, the person accountable for the piece shipping.
- Contributor or subject matter expert, if a specialist input is needed.
- Status: idea, briefed, drafting, in review, approved, scheduled, published.
- Brief link, which should be the campaign brief or a short content brief, never a Slack thread.
- Draft due, review due, publish date. Three dates, not one.
- Asset needs: design, photography, video edit, developer time.
- Approval required from legal, compliance, or an executive, as a yes or no with a name attached.
The distribution columns
A piece is not done when it is published. Plan the second and third life of every asset in the same row.
- Channels this piece will run on, chosen at brief time and not after publishing.
- Repurpose plan: the derivative assets you will cut from it and who cuts them.
- Email placement: which newsletter issue or automated flow it lands in.
- Paid support: yes or no, with the budget if yes.
- Sales or partner enablement: is this something the team should be sending to prospects?
- Resurface date, typically 60 to 90 days out, for updating or re-promoting.
The review columns
These are the columns everyone skips, and they are the reason next quarter's calendar is better than this one. Fill them 30 days after publication.
- Published URL and the actual publish date, which will not always match the planned date.
- Primary metric at 30 days, chosen to match the goal in the planning columns.
- Secondary metric, usually engagement or conversions.
- Production hours actually spent, recorded honestly.
- Keep, update, or retire, as a decision with a date.
- One sentence lesson. This is the single most valuable cell in the sheet.
Pillar to cluster mapping
Pillars are the topics you want to be known for. Clusters are the specific questions underneath them. The mapping is what turns a publishing schedule into an authority strategy.
- Choose three to five pillars for the year, each tied to something you actually sell or advocate for.
- Write one substantial pillar page per pillar, the definitive piece on the topic.
- Plan six to twelve cluster pieces per pillar, each answering one specific question.
- Every cluster piece links up to its pillar page. The pillar page links down to every cluster.
- When a new idea arrives, assign it to a pillar or reject it. Ideas that fit no pillar are the ones that quietly consume the quarter.
Cadence that survives contact with reality
Cadence is a capacity decision, not an ambition. Set it against the hours you truly have, then defend it.
- Count real production hours available per week, after meetings and unplanned work.
- Estimate hours per format from your own past pieces, not from a benchmark article.
- Set the cadence at roughly 80 percent of capacity, so one sick week does not collapse the quarter.
- Keep two evergreen pieces finished and in reserve at all times.
- Publish on fixed days. Predictability compounds for both the audience and the team.
How to use it
- Create the table with the planning columns only, and fill a full quarter of rows before adding any other column. Planning first prevents a calendar that is really a to do list.
- Set your pillars, then tag every existing published piece with a pillar and cluster. Gaps in coverage will be obvious within an hour.
- Add production columns and create three views: by owner, by status, and by publish week.
- Run a 30 minute weekly editorial standup against the status view. Move blocked items, do not discuss ideas.
- Book a recurring 30 day review to fill the review columns. Without a calendar hold, this never happens.
- At quarter end, sort by primary metric, read the lesson column top to bottom, and let that shape the next quarter's mix.
Common mistakes
- Building the calendar around dates and campaigns rather than topics, which produces content nobody searches for after the campaign ends.
- Adding a status for every possible state. Seven statuses is a pipeline, fifteen is a filing system nobody updates.
- Planning distribution after publishing, which turns every strong piece into a single post instead of a dozen assets.
- Setting a cadence based on what a competitor publishes rather than on your real production capacity.