Template

Content Calendar Template

Plan, assign and track content from idea to published post, with target keywords and funnel stage on every row.

TemplateSpreadsheetBeginner

Description

A content calendar keeps publishing consistent and makes it obvious who owns each piece. Linking each row to its keyword and brief stops two posts from targeting the same search.

Use case

Use it for monthly or quarterly content planning, and as the shared status board between you, writers and the client.

Instructions

  1. Add ideas from your keyword map; one keyword per row.
  2. Set a realistic publish date, working back from review and approval time.
  3. Tag the funnel stage so the mix covers awareness, consideration and decision.
  4. Update status every week and link the brief and draft in the row.
  5. After publishing, add the live URL and a date to review performance.

Preview

Column headers with example rows. Replace the examples with your client’s data.

Example rows use a fictional client. Replace them with real data from your tools.

Calendar
RowPublish dateTitleTarget keywordFunnel stageFormatOwnerStatusBrief linkNotes
22026-11-03How to choose a dog harnessdog harness size guideConsiderationGuideWriter ADraftingBrief #12Add sizing table
32026-11-10Best toys for teething puppiespuppy teething toysAwarenessList postWriter BBriefedBrief #13Check stock with client
42026-11-17Grain-free vs regular dog foodgrain free dog foodConsiderationComparisonClient reviewIdeaNeeds vet quote

Download

A CSV file that opens in Google Sheets, Excel or Numbers. Keep the header row, delete the example rows and add your own.

Download template (CSV)

My notes

Keep private notes next to anything you read or practice.

Log in to take notes