This is the template itself: the columns to create, what goes in each one, the status values that drive review, and the tabs that keep a month readable. Copy it into a spreadsheet or a database tool and you have a working calendar in fifteen minutes. The aim is one place where a post’s idea, its draft, its approval and its result all live on the same row.
The core columns
Every row is one post. These are the columns that earn their place; resist adding more until you miss them.
| Column | What goes in it | Example |
|---|---|---|
| Post ID | Stable reference for linking and reporting | 2026-W12-03 |
| Publish date | The scheduled date | 2026-03-18 |
| Channel | One channel per row | |
| Pillar | Content pillar this fills | Educational |
| Hook | First line / scroll-stopper | “Most onboarding emails lose people on day 2.” |
| Body / draft | Full post text or a link to it | (draft) |
| Asset | Image, carousel or video, or a link | carousel-12.fig |
| Source | The page or asset it came from | /pricing |
| CTA | The single next step | Book a demo |
| Owner | Who drafts it | Mia |
| Status | Where it is in the pipeline | Approved |
| Result | One metric after publishing | 4.1% eng. |
One channel per row matters: the same idea on LinkedIn and Instagram is two rows, because the hook, asset and length differ. That keeps each row honest and your reporting clean.
The status values that run the pipeline
The Status column is the engine. Use a small, fixed set so anyone can read the sheet at a glance and a filter can show exactly what needs attention.
| Status | Meaning | Who acts next |
|---|---|---|
| Idea | Captured, not drafted | Drafter |
| Drafting | Being written | Drafter |
| In review | Awaiting approval | Reviewer |
| Changes | Sent back with notes | Drafter |
| Approved | Cleared to schedule | Scheduler |
| Scheduled | Queued in the tool | — |
| Published | Live | Analyst |
Filtering the sheet to In review is your reviewer’s to-do list; filtering to Approved is the scheduler’s. This is the spine of a social media approval workflow and it only works if the values stay short and disciplined.
A naming convention that scales
Give every post a Post ID built from year, week and a sequence number: 2026-W12-03. It sounds fussy until you have 300 posts. With it, you can link an asset file, a report row and a calendar entry without ambiguity, and “which post drove that spike” becomes a lookup instead of a hunt. Use the same stem for asset files (2026-W12-03-carousel.png) so the source and the creative never drift apart.
The three tabs
One flat sheet gets unreadable fast. Split it into tabs that each answer one question.
- Calendar — the month grid, colour-coded by pillar, for the at-a-glance view.
- Backlog — every Idea-status row, where topics wait before they earn a date. Feed it from your social media idea backlog .
- Archive — Published rows with their Result filled in, so the calendar stays light and your history stays searchable.
A post’s life is a move across tabs: Backlog to Calendar when it gets a date, Calendar to Archive once it is live and measured.
How the columns connect to a brief
The Hook, Source and CTA columns are a miniature brief living inside the calendar. For anything bigger than a single post, link the row out to a fuller social media content brief rather than stuffing the sheet. The rule: the calendar holds enough to schedule and review; the brief holds enough to write well.
Where Utin fits
The template is the easy part. Keeping every row filled, sourced and moving through statuses is the work. Utin scans your website and arrives with the Idea, Hook, Source and draft columns already populated, then moves rows through the same status pipeline automatically, so the sheet stays full instead of staring back at you empty. The structure above is exactly the model Utin uses; if you would rather it maintained the sheet for you, register interest in the pilot.