What this template is for
Use the calendar to plan and run an editorial programme across formats and channels: articles and guides, newsletter issues, short videos, tools and downloadable resources. It is usually planned a quarter ahead in pillars and series, filled in detail a month ahead, and reviewed weekly as pieces move from idea to published. A team of one benefits as much as a large team, because the calendar is where the strategy's priorities are defended against whatever request arrived most recently; the guide to working as a marketing team of one shows how the calendar fits a sole marketer's weekly rhythm alongside one front door for requests.
Three neighbouring documents do related jobs. The content brief template briefs one piece in depth; the calendar row links to its brief once one exists. The SEO content operations playbook runs the search backlog and the refresh queue; the calendar takes the items chosen from that backlog each month and gives them dates and owners. The social content calendar guide plans social posts one by one; the content calendar records which pieces will be cut down for social and leaves the post-level schedule to that sheet. Broadcast email has its own email marketing calendar, which can draw newsletter content from this one.
The calendar is also where quality is planned rather than hoped for. Google's guidance on creating helpful, reliable, people-first content asks whether content is made primarily for people rather than to attract search visits. A row that starts from the reader's question and names who will write and review the piece is easier to hold to that standard than a row that starts from a keyword.
The template
One row per piece. Each field below becomes a column in the sheet or a property on the work item.
| Field | What to write |
|---|---|
| Pillar | The content pillarOne of a small set of recurring themes that a brand's content is planned around. the piece belongs to, using the names fixed in the strategy |
| Topic and working title | What the piece covers, the reader's question it answers and a working title |
| Format | Article, guide, video, tool, newsletter issue or other, chosen for the question rather than habit |
| Stage and goal | The funnel stage the piece serves and the goal it contributes to |
| Target query | Where search is a channel, the main query and its intent; otherwise "not a search piece" |
| Distribution plan | The channels it goes out on and the repurposed versions planned |
| Owner and dates | Writer, editor and the dates for brief, draft, review and publish |
| Status | Idea, briefed, drafting, review, scheduled, published or refresh |
| Measure and review | The one metric that judges the piece and the date it is reviewed |
A row that cannot be given a pillar, a stage and an owner is not ready to be scheduled. Keep such ideas in a separate idea list until they can.
How to fill each section
Pillar
Use the pillar names exactly as the strategy fixes them, so the calendar can be filtered and counted by pillar. The content pillars and calendar guide explains how pillars are derived from the business's strategy and why slots should follow the share of effort each pillar was given. Counting rows by pillar each month is the simplest check that the calendar carries the strategy rather than whoever asked loudest.
Topic and working title
State the reader's question first and the working title second. The question is what the piece must answer; the title will change. The content briefs guide covers how the question, the audience and the angle are developed once the row moves to briefed. Check the topic against existing content before scheduling it, because a new piece on a covered topic often belongs in the refresh queue instead.
Format
Choose the format from the question, not from habit: a step-by-step question suits a written guide, a comparison suits a table-led page, a quick demonstration suits a short video, a calculation suits a tool. The content pillars guide recommends mapping each pillar to a small set of formats the team can sustain, and the calendar should only use those.
Stage and goal
Record the stage of the buying journey the piece serves and the goal it contributes to, such as audience growth, leads or customer retention. The content goals and KPIs guide explains goals by funnel stage and why a piece judged against the wrong stage looks like a failure. A quarter of rows all at the same stage is worth noticing before it is published.
Target query
Where search is a channel, record the main query and its Search IntentThe goal behind a search query: to learn, to find a site, to compare or to act., read from the results page rather than guessed. The search intent guide explains how to read intent and match the format to it, which feeds back into the format field. Where a piece is for the newsletter or social only, say so; forcing a query onto a piece that does not serve one bends it out of shape.
Distribution plan
List the channels the piece goes out on and the derivatives planned from it: a newsletter section, short clips, a carousel, a summary post. The repurposing guide explains how one source asset becomes several formats and why derivatives should be sequenced over weeks rather than released on the same day. Plan the derivatives when the row is created, so the production time is counted.
Owner and dates
Name the writer and the editor, and set dates for brief, draft, review and publish. Working backwards from the publish date shows whether the piece is realistic, and puts the review where the reviewer can make it. The work management and marketing calendars guide explains why the calendar works best as a view of the work system, so that a changed date on the work item changes the calendar too.
Status
Use a fixed set of statuses and move each row through them: idea, briefed, drafting, review, scheduled, published, refresh. The refresh status brings old pieces back onto the calendar when they need updating. The content governance guide covers the roles, approvals and review dates that sit behind the statuses, and the inventory where published pieces are tracked.
Measure and review
Name the one metric that will judge the piece, matched to its stage and goal, and a date to review it. The measuring content performance guide explains how to separate engagement from outcomes and how a monthly content review uses these measures. Set the review date far enough out for the measure to move; search pieces in particular take time to find their audience.
Filled example
Below, a quarter of the calendar is completed for an invented business. The figures, dates and names are illustrative.
Fennimore Accountants: January to March content calendar
| Header | Fennimore's plan for the quarter |
|---|---|
| Pillars and share of effort | Self-assessment made simple (50%), Running a freelance business (30%), Planning for the new tax year (20%) |
| Capacity | One content marketer (60 hours a month for content) and two accountants reviewing (4 hours a month each). Refresh reserve: 10 hours a month |
| Formats in use | Long guides for search, a fortnightly newsletter, short videos cut from guides |
| Publish | Pillar | Topic, title and format | Stage, goal and query | Distribution | Owner, status, measure and review |
|---|---|---|---|---|---|
| 6 Jan | Self-assessment | "What to gather before you file": checklist guide | Consideration; organic leads; "self assessment documents needed" (informational) | Newsletter lead item 8 Jan; three short videos over two weeks | Writer: content marketer; editor: senior accountant. Published. Measure: guide-to-enquiry clicks. Review 6 April |
| 13 Jan | Self-assessment | Refresh: "Paying your tax bill in instalments" guide | Decision; enquiries; "pay self assessment in instalments" (informational) | Newsletter 22 Jan | Content marketer; refresh status, review by tax manager 9 Jan. Measure: organic clicks against December. Review 13 March |
| 22 Jan | Self-assessment | "Last-week filing questions answered": newsletter issue | Retention; existing clients; not a search piece | Email only | Content marketer; scheduled. Measure: replies and booked calls. Review 6 Feb |
| 3 Feb | Freelance business | "Do I need to register for VAT?": guide with a decision table | Awareness; audience growth; "do freelancers need to register for VAT" (informational) | Newsletter 5 Feb; two short videos; LinkedIn summary post | Content marketer; briefed. Measure: organic sessions from target query group. Review 3 May |
| 17 Feb | Freelance business | "Expenses you can and cannot claim": short video series (four parts) | Consideration; audience growth; not a search piece | Instagram and LinkedIn weekly; newsletter round-up 5 March | Content marketer; drafting. Measure: saves and profile visits. Review 31 March |
| 3 Mar | New tax year | "Year-end checklist before 5 April": guide | Consideration; leads; "tax year end checklist self employed" (informational) | Newsletter 5 March and 19 March; one short video | Content marketer; editor: tax manager; idea. Measure: checklist downloads with email sign-up. Review 3 June |
| 19 Mar | New tax year | "Switching accountants: what happens": guide | Decision; enquiries; "how to change accountant" (commercial) | Newsletter 19 March; retargeting audience for paid social | Content marketer; idea. Measure: enquiry form starts from the page. Review 19 June |
Weekly review on Mondays: rows due in the next fortnight checked, slipped rows moved, the week after next locked. Monthly: rows counted by pillar against the 50/30/20 split; the refresh reserve allocated from the SEO backlog.
Common mistakes
- A calendar sized to ambition. A plan that assumes more hours than the team has collapses within weeks. Count capacity first and fit the rows to it.
- Keywords before questions. A row that starts from a search term rather than a reader's question produces content made for search engines. Write the question first.
- No pillar on the row. Pieces that cannot be tied to a pillar drift the calendar away from the strategy. Keep them on an idea list until they fit.
- Every piece at one stage. A quarter of awareness pieces with no decision-stage content leaves interested readers nowhere to go. Check the stage spread when filling the month.
- Distribution as an afterthought. Repurposed versions planned after publication rarely get made. Plan them with the row and count their hours.
- Refreshes left off the calendar. A calendar of new pieces only lets the existing library decay. Reserve capacity for refreshes and give them rows.
- A separate spreadsheet nobody updates. A calendar maintained by hand alongside the work system goes stale. Make it a view of the work items.
- No measure or review date. A piece without a measure cannot be judged, and one without a review date never is. Fill both when the row is created.
The content brief each row links to, and the email calendar that newsletter content feeds, are in the templates library.
