How to build a social media content calendar
A content calendar is a table with one row per post and eight columns — date, channel, pillar, hook, asset, caption status, owner and result — filled in a month at a time rather than a day at a time. The reason to build one is arithmetic rather than aesthetics: three channels at three posts a week is 36 posts a month, which costs about 15 hours done one at a time and about 8.6 hours done in batches, and this page works through both.
Start with the volume arithmetic, not the aesthetic
Before designing anything, count. Channels × posts per week × weeks = posts per month.
| Plan | Posts per month | At 25 minutes each |
|---|---|---|
| 1 channel, 3 posts a week | 12 | 5.0 hours |
| 3 channels, 3 posts a week | 36 | 15.0 hours |
| 3 channels, daily | 84 | 35.0 hours |
Thirty-five hours a month is most of a working week, every month, indefinitely. Most abandoned content calendars were abandoned here — not because the plan was wrong but because nobody costed it before committing. Pick the row you can still do in month seven.
The eight columns
| Column | Contents |
|---|---|
| Date | The publish date. One row per post per channel — a post that runs on two channels is two rows, because the caption and the crop differ. |
| Channel | Instagram, LinkedIn, TikTok, email, wherever. |
| Pillar | One of five fixed themes. This is the column that keeps the month balanced. |
| Hook | The first line, written out in full. Not a topic — the actual words. |
| Asset | Link to the image, video or draft, or the word "none". |
| Status | Idea → Written → Asset ready → Scheduled → Posted. |
| Owner | A name. Blank means nobody, and nobody will do it. |
| Result | One number you choose, filled in afterwards. See the last section. |
The hook column does the heavy lifting. A calendar listing topics — "customer story", "product tip" — still leaves the hardest 80% of the work undone on the day. A calendar with the first line already written turns posting into a ten-minute job.
Five pillars, and a month allocated across them
Pillars stop a feed becoming either all promotion or all filler. Five is the usual working number. For a small B2B product business, allocating 36 slots:
| Pillar | What it is | Slots |
|---|---|---|
| Teach | A single useful thing, explained completely | 12 |
| Proof | Results, before and after, customer stories | 8 |
| Point of view | Something you believe that your market argues about | 6 |
| Product | What it does, who it is for, what it costs | 6 |
| Behind the scenes | How the work actually gets done | 4 |
Write the allocation into the calendar before the ideas. Filling 36 blank rows produces a month of whatever came to mind; filling 12 rows marked Teach and 6 marked Product produces a month with a shape. And when a week slips, you can see exactly which pillar went missing.
Batching: where the 15 hours becomes 8.6
The 25-minutes-per-post figure is not the making — it is the restarting. Opening the app, deciding what to post, finding an image, writing, second-guessing, posting. Batching removes the deciding and the restarting from 35 of the 36 posts.
| Block | Work | Time |
|---|---|---|
| 1. Plan | Allocate 36 slots to pillars and write 36 hooks | 90 min |
| 2 & 3. Produce | Shoot, design or record every asset, two sittings | 240 min |
| 4. Write | 36 captions at about 4 minutes each, hooks already written | 144 min |
| 5. Schedule | Load the month | 45 min |
| Total | 519 min = 8.65 hours |
That is 6.35 hours a month saved, a 42% cut, for the same 36 posts. Over a year it is 76 hours. Whether that is worth anything depends on what your hour is worth — at £60 an hour it is £381 a month and £4,572 a year, and at £25 an hour it is £159 and £1,905. Use your own number, which is the point of the rate calculator linked below.
Repurposing: one idea, ten slots
Thirty-six original ideas a month is not sustainable and is not necessary. One substantial piece — a case study, a teardown, a long answer to a customer question — reliably yields around ten items:
- Six short-form clips or single-point posts, one per idea inside it
- Two text posts: the argument, and the one counter-argument
- One carousel or summary graphic
- One email
Four substantial pieces a month × 10 = 40 items, which covers 36 slots with four in reserve. That reframes the monthly task from "think of 36 things" to "do four pieces of real work", which is a job a small business can actually hold.
The result column, and the decision it lets you make
Pick one number per post and record it a week later. Not a dashboard — one number, and ideally one that touches your business: clicks to your site, replies, sign-ups. Reach and likes are the easiest to collect and the least useful, because a post can reach thousands of people who will never buy anything.
After three months you have 108 rows with a pillar and a result. Then a single SUMIFS per pillar answers a question you previously argued about:
=SUMIFS(Calendar[Result],Calendar[Pillar],"Teach")
Suppose Teach produced 62% of all site clicks from 33% of the posts, and Behind the scenes produced 3% from 11%. Next quarter's allocation writes itself: move four slots from Behind the scenes to Teach and re-measure. That loop — plan, post, record one number, reallocate — is the only part of social media that compounds, and it is impossible without the calendar because nobody can reconstruct three months of posts from memory.
Keeping it alive
Three rules that decide whether a calendar survives its second month. Keep an idea bank as a second tab — every stray thought goes there, and block 1 above starts by reading it, so you never face a blank page. Plan one month ahead, not three: a quarter planned in detail is a quarter of work thrown away the first time something changes. And leave four slots a month empty on purpose, for whatever is actually happening — a calendar with no room for the present tense reads like it was written by someone who left.
Arithmetic and general information only — not financial, tax, legal or investment advice. Your own figures, and your own accountant, decide what any of this means for you.
Do this sum for free
free freelance hourly & day rate calculator — work out what an hour of your own time is actually worth, then price the hours a posting schedule costs you. It runs in your browser and nothing you type is sent anywhere.
If you would rather not build it yourself
The Social Media Content Calendar ($29) is a built calendar with the pillar mix, batching schedule and reusable idea bank already in place, so a month is planned in one sitting rather than assembled a post at a time. One-time purchase, instant download.
Frequently asked questions
What should a social media content calendar include?
One row per post with eight columns: date, channel, pillar, hook, asset, status, owner and result. The hook column matters most — writing the actual first line in advance, rather than a topic, is what turns posting into a ten-minute job on the day.
How many hours a month does posting actually take?
Count it: channels × posts per week × weeks. Three channels at three posts a week is 36 posts a month, which is about 15 hours at 25 minutes each done one at a time, or about 8.6 hours in batches. Three channels posting daily is 84 posts and roughly 35 hours a month.
What are content pillars and how many should I have?
Pillars are fixed themes you allocate posts to before you have the ideas — for example Teach, Proof, Point of view, Product, and Behind the scenes. Five is a workable number. Allocating the slots first is what stops a month becoming all promotion or all filler.
How do I batch content creation?
Five blocks instead of 36 sittings: 90 minutes to allocate slots and write every hook, two sittings totalling four hours to produce the assets, about 144 minutes to write captions from the hooks, and 45 minutes to schedule. That is 8.65 hours against 15, for the same 36 posts.
How far ahead should I plan content?
One month. A quarter planned in detail is mostly thrown away the first time something changes, and leaving about four slots a month deliberately empty gives you room for whatever is actually happening.
Which metric should I record against each post?
One, chosen by you, ideally one that touches the business — clicks to your site, replies or sign-ups rather than reach or likes. After three months, a SUMIFS by pillar tells you which themes produced the result and which did not, which is the only basis for reallocating next quarter.