Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

Templates

Content Calendar Template

A content calendar template: pillar, topic, format, funnel stage, target query, channel plan, owner, deadlines, status and the measure each piece answers.
Templatebeginner9 min readUpdated

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.

FieldWhat to write
PillarThe content pillar the piece belongs to, using the names fixed in the strategy
Topic and working titleWhat the piece covers, the reader's question it answers and a working title
FormatArticle, guide, video, tool, newsletter issue or other, chosen for the question rather than habit
Stage and goalThe funnel stage the piece serves and the goal it contributes to
Target queryWhere search is a channel, the main query and its intent; otherwise "not a search piece"
Distribution planThe channels it goes out on and the repurposed versions planned
Owner and datesWriter, editor and the dates for brief, draft, review and publish
StatusIdea, briefed, drafting, review, scheduled, published or refresh
Measure and reviewThe 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 Intent, 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.

Illustrative example — not a real result

Fennimore Accountants: January to March content calendar

HeaderFennimore's plan for the quarter
Pillars and share of effortSelf-assessment made simple (50%), Running a freelance business (30%), Planning for the new tax year (20%)
CapacityOne 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 useLong guides for search, a fortnightly newsletter, short videos cut from guides
PublishPillarTopic, title and formatStage, goal and queryDistributionOwner, status, measure and review
6 JanSelf-assessment"What to gather before you file": checklist guideConsideration; organic leads; "self assessment documents needed" (informational)Newsletter lead item 8 Jan; three short videos over two weeksWriter: content marketer; editor: senior accountant. Published. Measure: guide-to-enquiry clicks. Review 6 April
13 JanSelf-assessmentRefresh: "Paying your tax bill in instalments" guideDecision; enquiries; "pay self assessment in instalments" (informational)Newsletter 22 JanContent marketer; refresh status, review by tax manager 9 Jan. Measure: organic clicks against December. Review 13 March
22 JanSelf-assessment"Last-week filing questions answered": newsletter issueRetention; existing clients; not a search pieceEmail onlyContent marketer; scheduled. Measure: replies and booked calls. Review 6 Feb
3 FebFreelance business"Do I need to register for VAT?": guide with a decision tableAwareness; audience growth; "do freelancers need to register for VAT" (informational)Newsletter 5 Feb; two short videos; LinkedIn summary postContent marketer; briefed. Measure: organic sessions from target query group. Review 3 May
17 FebFreelance business"Expenses you can and cannot claim": short video series (four parts)Consideration; audience growth; not a search pieceInstagram and LinkedIn weekly; newsletter round-up 5 MarchContent marketer; drafting. Measure: saves and profile visits. Review 31 March
3 MarNew tax year"Year-end checklist before 5 April": guideConsideration; leads; "tax year end checklist self employed" (informational)Newsletter 5 March and 19 March; one short videoContent marketer; editor: tax manager; idea. Measure: checklist downloads with email sign-up. Review 3 June
19 MarNew tax year"Switching accountants: what happens": guideDecision; enquiries; "how to change accountant" (commercial)Newsletter 19 March; retargeting audience for paid socialContent 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.

Terms used on this page

Frameworks

Where this page is used

Also related

Sources

  1. Creating helpful, reliable, people-first content — Google Search Central

Related