Most blogs do not fail because of bad writing. They fail because nobody decided, in advance, what gets published and when. A content calendar fixes that, and you do not need an expensive platform to build one.
This guide shows you exactly how to create a content calendar for a blog, covering a full quarter (90 days) of posts. It is written for solo marketers and small teams, so every recommendation is tied to the number of writing hours you actually have, not the hours a 12-person content department has.
By the end you will have a spreadsheet with topic buckets, assigned keywords, publish dates and a status column you can glance at on a Monday morning. Everything here can be set up in about 90 minutes.
What a Content Calendar Is (and What It Is Not)
A content calendar is a single, dated list of what you are publishing, who is writing it, which keyword it targets and where it currently sits in the production pipeline.
It is not:
- A brainstorm dump. Ideas without dates are a backlog, not a calendar.
- A social media scheduler. Social posts are distribution, blog posts are the asset. Keep them on separate tabs.
- A strategy document. Your strategy decides the topic buckets. The calendar just enforces them.
The difference matters because the most common failure mode is a beautiful, color-coded board with 60 ideas and no commitment to a single publish date.
Before Step 1: Calculate Your Real Writing Capacity
Almost every content calendar template on the internet starts with topics. That is backwards. Start with hours, because your cadence is a budget, not an ambition.
Count the hours you can genuinely protect each week for writing, editing, sourcing images and uploading. Be honest and subtract meetings, client work and holidays. Then use this table:
| Protected hours per week | Realistic cadence | Posts per 90 days | Typical post length |
|---|---|---|---|
| 1 to 3 hours | 2 posts per month | 6 | 1,200 to 1,500 words |
| 4 to 6 hours | 1 post per week | 12 to 13 | 1,500 to 2,000 words |
| 8 to 10 hours | 2 posts per week | 24 to 26 | 1,500 to 2,000 words |
| 15 hours or a small team | 3 posts per week | 36 to 39 | 1,200 to 2,500 words |
Rule of thumb: a researched, keyword-targeted 1,500-word post takes a competent writer 4 to 5 hours end to end, including outlining, drafting, editing, images and CMS formatting. If your calendar assumes two hours, your calendar is fiction.
Pick the row that matches your reality, then reduce it by one notch for your first quarter. Publishing six solid posts beats scheduling twenty and shipping four.
Step 1: Choose 4 to 5 Topic Buckets
Topic buckets (also called content pillars) are the recurring themes your blog owns. They stop your calendar from becoming a random assortment of posts and they make keyword research dramatically faster. There is more on it in Content planning tool.
How to pick them
- List the 3 to 5 problems your product or service solves.
- Add one bucket for the beginner-level questions your sales team or support inbox answers every week.
- Add one bucket for proof: case studies, benchmarks, original data, teardowns.
- Stop at five. More buckets means less depth and weaker topical authority.
Give each bucket a share of the calendar
Decide the percentage split before you write a single title. A workable default for a small B2B or SaaS blog:
| Bucket | Purpose | Share of posts | Out of 13 posts |
|---|---|---|---|
| How-to and tutorials | Search traffic, beginner capture | 40% | 5 |
| Comparisons and alternatives | High intent, close to conversion | 20% | 3 |
| Templates and tools | Link magnets, email signups | 20% | 3 |
| Proof and opinion | Brand, differentiation, shares | 20% | 2 |
Write these percentages at the top of your spreadsheet. When someone suggests a post that fits no bucket, you now have a polite reason to park it.
Step 2: Build a Topic Bank and Assign One Keyword per Post
Now fill each bucket with roughly twice as many ideas as you need. For a 13-post quarter, aim for 25 to 30 ideas. Overshooting means a sick week or a shifted priority does not leave a hole in the schedule.
Where to source ideas fast
- People Also Ask and autocomplete: type your bucket name into Google and harvest the questions. Each one is a potential H2 or a standalone post.
- Your own search console: filter for queries where you rank positions 8 to 25 with impressions but low clicks. Those are posts waiting to be written or improved.
- Competitor gaps: list the five sites that outrank you and note the topics they cover that you do not.
- Sales and support transcripts: the exact phrasing customers use is usually the exact phrasing they search.
- Community threads: Reddit, niche forums and LinkedIn comments surface problems keyword tools miss.
The one-keyword rule
Assign a single primary keyword to each post and never reuse it. Two posts targeting the same term will compete with each other and split your internal links. (via https://designatwork.com)
For each idea, record:
- Primary keyword (exact phrase people type)
- Monthly search volume (any free tool is fine, you need relative size, not precision)
- Search intent: informational, commercial, transactional or navigational
- Target format: step-by-step guide, listicle, comparison, template, case study
- The internal link target: which money page this post should point to
That last column is the one most teams skip, and it is the one that turns traffic into pipeline.
Sequence by difficulty, not by excitement
Put your easiest wins first. Long-tail, low-competition terms published in month one start ranking while you work on the harder head terms in month three. A practical order:
- Weeks 1 to 4: long-tail how-to posts with clear intent
- Weeks 5 to 8: comparison and template posts that convert
- Weeks 9 to 13: one or two bigger pillar pieces plus refreshes of older posts
Step 3: Set a Publishing Cadence You Can Defend for 12 Weeks
Take the cadence from your capacity table and lock the day. Consistency of day matters less for Google than it does for your own habit formation and for email subscribers, but both benefit.
Practical cadence rules
- Pick a fixed publish day. Tuesday or Wednesday works well for B2B. Choose one and keep it for the whole quarter.
- Build a two-week buffer. Your first published post should be drafted two weeks before it goes live. This single habit removes 90% of calendar stress.
- Leave one empty slot per month. Label it “flex”. Use it for a reactive post, a product announcement, or simply to catch up. If nothing comes up, pull a post forward from the backlog.
- Schedule refreshes, not just new posts. Reserve one slot per month to update an existing article. Updating a post that ranks on page two is usually faster and higher return than writing a new one.
- Account for the quiet weeks. If you are planning October to December, remember that late December publishing rarely performs. Shift those slots to early January instead.
Step 4: Map 90 Days Onto a Simple Grid
Open Google Sheets or Excel. One row per post. Do not create a pretty month-view grid with merged cells, because you cannot sort or filter it.
The columns you actually need
| Column | What goes in it | Example |
|---|---|---|
| Publish date | Fixed day, set for all 13 weeks | 14/10/2026 |
| Status | Dropdown, see step 5 | Drafting |
| Working title | Can change before publishing | How to Audit a Blog in One Afternoon |
| Bucket | One of your 4 to 5 pillars | How-to |
| Primary keyword | One per post, never duplicated | blog content audit |
| Volume / intent | Rough monthly searches and intent type | 720 / informational |
| Format | Guide, listicle, comparison, template | Step-by-step guide |
| Owner | Name of the person drafting | Sarah |
| Draft due | Publish date minus 10 days | 04/10/2026 |
| Internal link target | The page this post should push to | /pricing |
| CTA | What the reader should do next | Download audit checklist |
| Doc link | URL of the draft | Google Doc link |
| Live URL | Filled in after publishing | /blog/blog-content-audit |
Thirteen columns. Resist adding more. Every extra field is a field someone will forget to fill in.
A filled example for the first four weeks
| Date | Bucket | Working title | Primary keyword | Owner | Status |
|---|---|---|---|---|---|
| Week 1 | How-to | How to Create a Content Calendar in 5 Steps | how to create a content calendar | Sarah | Scheduled |
| Week 2 | Templates | Free Editorial Calendar Template for Google Sheets | editorial calendar template | Sarah | Drafting |
| Week 3 | Comparison | Notion vs Trello vs Sheets for Content Planning | content calendar tools | Marc | Outlined |
| Week 4 | Flex | Reserved slot | To be decided | Marc | Idea |
Step 5: Track Status, Not Just Dates
A date column tells you what is late. A status column tells you why. Use a data validation dropdown with a small, fixed set of values:
- Idea sits in the backlog, keyword not yet validated
- Approved keyword assigned, slot booked
- Outlined H2 structure and angle agreed
- Drafting writer is working on it
- In review draft complete, waiting on edit
- Scheduled loaded in the CMS with images and meta description
- Published live
- Needs update published more than 12 months ago or losing rankings
Add conditional formatting so each status gets a color. You should be able to tell the health of your quarter in three seconds from across the room.
The weekly 15-minute review
A calendar nobody opens is a calendar nobody follows. Book a recurring 15-minute slot, same day every week:
- Move every row forward one status, or note the blocker
- Confirm next week’s post is at least “In review”
- Check Search Console for any post from the last quarter that has jumped into positions 5 to 15, and flag it for an update
- Add any new idea to the backlog tab, never directly into the schedule
The monthly 45-minute review
- Compare planned versus published. If you hit under 70%, lower the cadence rather than promising to try harder.
- Check bucket balance. Drifting toward 80% how-to posts is a common and quiet failure.
- Pull the top three and bottom three posts by traffic and ask what separates them.
- Top up the backlog so it always holds at least six approved ideas.
Five Mistakes That Kill Content Calendars
- Planning twelve months ahead. Search intent, products and priorities shift. Plan 90 days in detail, keep a rough list of themes for the two quarters after that.
- No owner per row. “The team” is not an owner. A name is.
- Mixing social and blog in one tab. Different cadence, different volume, different approval flow. Separate tabs, linked by a campaign column if needed.
- No buffer. Publishing the day the draft is finished guarantees that one bad week breaks the streak.
- Never scheduling updates. After two or three quarters, refreshing existing posts typically delivers more traffic per hour than new ones.
Which Tool Should You Use?
Honest answer: the one you will open every Monday. Here is how the realistic options compare.
| Tool | Best for | Cost | Main drawback |
|---|---|---|---|
| Google Sheets | Solo marketers and teams up to 5 | Free | No automatic reminders |
| Notion | Teams who want briefs and calendar in one place | Free tier available | Easy to over-engineer the database |
| Trello or Asana | Teams who think in pipelines | Free to low | Weak for keyword data and reporting |
| Airtable | Larger libraries with many filters | Free tier, paid for volume | Record limits on the free plan |
| Dedicated content platforms | Teams of 10 or more with approval chains | Paid | Overkill below that size |
If you are starting today, start in Sheets. Migrate only when the spreadsheet genuinely hurts, which for most small teams is somewhere past 100 posts per year.
Your 90-Minute Setup Checklist
- Calculate protected weekly hours and pick a cadence (10 minutes)
- Write down 4 to 5 topic buckets with percentage splits (15 minutes)
- Fill a backlog tab with 25 to 30 ideas (25 minutes)
- Assign one primary keyword, intent and format per idea (20 minutes)
- Create 13 dated rows, drop in your strongest ideas, leave one flex slot per month (10 minutes)
- Add the status dropdown and conditional formatting (10 minutes)
- Book the weekly 15-minute review in your calendar as a recurring event (2 minutes)
That is the whole system. The spreadsheet is not the hard part. Opening it every week is.
FAQ
What is the best tool for creating a content calendar?
For most solo marketers and teams under five people, Google Sheets is the best tool because it is free, sortable, filterable and instantly shareable. Notion and Airtable are better when you want briefs, assets and the calendar in a single linked database. Dedicated content marketing platforms only start paying for themselves when you have multiple approval layers and dozens of posts in flight.
Is there a free template for a content calendar?
Yes, and plenty of them. Google Sheets, Notion and Canva all host free community templates. The faster route is usually to build your own with the 13 columns listed above, because free templates often contain 30 columns you will never fill. Copy the structure, delete anything you cannot commit to updating weekly.
How do I create a content calendar in Google Sheets?
Create one row per post with columns for publish date, status, working title, bucket, primary keyword, owner, draft due date and live URL. Use Data then Data validation to create a dropdown for status and for bucket, then apply conditional formatting so each status has a color. Add a second tab called “Backlog” for unscheduled ideas and a third called “Published” for archived rows. Freeze the top row so headers stay visible when you scroll.
Can I make a content calendar in Canva?
You can, and it looks great for a visual monthly overview or for sharing with a client. The limitation is that a Canva design cannot be sorted, filtered or searched. A practical hybrid is to keep the working calendar in Sheets and export a Canva visual once a month for stakeholder updates.
How far ahead should a content calendar be planned?
Plan 90 days in full detail with dates, keywords and owners. Keep a looser list of themes for the following two quarters. Planning a full year in detail almost always wastes effort because priorities, products and search demand shift faster than that.
How many blog posts should I publish per month?
Match it to your hours, not to a benchmark. Roughly two posts per month for 1 to 3 weekly hours, four posts for 4 to 6 hours, eight posts for 8 to 10 hours. Consistency at a low volume outperforms bursts of high volume followed by three silent months.
What should I do when I miss a publishing date?
Do not try to double up the following week. Shift the post into your next flex slot and push everything else forward by one. If you miss two dates in a quarter, that is noise. If you miss four, your cadence is wrong and you should drop one level in the capacity table.
Should blog posts and social posts share the same calendar?
Keep them on separate tabs in the same file. Blog posts have a weekly or biweekly rhythm and a long production cycle. Social posts have a daily rhythm and a short one. A shared campaign or theme column lets you link the two without forcing them into the same grid.