By Spark Linky · Reviewed
What a LinkedIn content calendar needs
Each column answers one planning question. Keep the list short. A calendar with twelve fields gets abandoned by the second week.
| Column | What to write | Example |
|---|---|---|
| Date | The day the post goes live, not the day you drafted it | Tue 1 Dec |
| Topic | One idea, named in a few words | Why vague project briefs cost time |
| Post type | Lesson, how-to, story, or opinion | Lesson |
| Hook | Your working first line, which you can change later | "Most scope creep starts in the first email." |
| Goal | What you want this post to do | Start conversations with operations leads |
| Status | Where the post stands today | Idea, Draft, In review, Scheduled, Published |
A goal describes intent. It is not a promise. Pick one goal per post so you can later tell whether a post type is doing the job you assigned it.
Copyable template
Paste this into any spreadsheet app, or copy the header row into a new note:
Date,Topic,Post type,Hook,Goal,Status
,,,,,If you prefer a Markdown table in a document, use the same six headers and leave the rows blank. A filled-in version looks like this:
Date,Topic,Post type,Hook,Goal,Status
Tue 1 Dec,Why vague project briefs cost time,Lesson,"Most scope creep starts in the first email.",Start conversations with operations leads,ScheduledIf your posts come from articles, videos, or PDFs you already have, add a seventh column called Source. It keeps the link between the idea and the material it came from.
How to fill it in, step by step
1. Set a rhythm you can keep. Choose days, not hours. The worked example below uses Tuesday, Thursday, and Saturday. That is a starting point for planning, not a LinkedIn rule. Pick a number you can write for without rushing, because a steady schedule matters more than a busy first week.
2. Choose two or three themes for the month. A theme is a broad area you want to be known for, such as "project scoping" or "running client handoffs." Themes give your topics a shared thread, which makes the month easier to write and easier for readers to follow.
3. Fill in topics before anything else. Write one topic per date, then assign a post type. Do not write the hook yet. A good topic is specific enough to draft from. "Leadership" is a category. "Why I stopped sending weekly status emails" is a topic.
4. Draft the hook as a placeholder. Write a working first line for each row so you can see the whole month's openings side by side. If several hooks start the same way, change the wording now. If you are stuck, the free LinkedIn hook generator offers 21 opening lines for any topic, and the LinkedIn post templates page has examples of post structures.
5. Write one goal per post. Goals such as "start replies from team leads" or "give prospects something to save" help you judge a post by what it was meant to do. Without a goal, every post gets judged by likes, which tells you little about the topic.
6. Move each row through its status. Use the same five statuses every time: Idea, Draft, In review, Scheduled, Published. A stale status is the most common reason a calendar stops being trusted. Update it when a post moves, not at the end of the month.
Rotate lessons, how-tos, stories, and opinions
Rotating post types stops a month from becoming a string of similar posts. Each type does a different job for the reader.
| Post type | What it does for the reader | Example topic for a consultant |
|---|---|---|
| Lesson | Shares one thing you learned, with the reason it matters | A missed handoff taught us to write a checklist |
| How-to | Gives steps someone can follow today | Turning meeting notes into a client recap |
| Story | Shows a specific situation, what happened, and what changed | The kickoff I skipped once, and what it cost |
| Opinion | Takes a clear position that some readers will want to answer | Status emails are a weak substitute for a check-in |
A simple default pattern is lesson, how-to, story, opinion, repeated. It gives you no two of the same type back to back. Treat the pattern as a default. Swap a post when something timely comes up, but move the swapped post to an open slot instead of deleting it from the plan.
Worked example: a December plan (hypothetical)
This example is hypothetical. It describes a solo operations consultant planning three posts a week. It is not based on a real customer, and the goals are intentions, not forecasts.
| Date | Topic | Post type | Hook (draft) | Goal | Status |
|---|---|---|---|---|---|
| Tue 1 Dec | Why vague project briefs cost time | Lesson | Most scope creep starts in the first email. | Start conversations with operations leads | Scheduled |
| Thu 3 Dec | Three questions before accepting a project | How-to | Before you say yes, ask these three questions. | Give prospects something to save | Scheduled |
| Sat 5 Dec | The kickoff I skipped once | Story | I skipped a kickoff once. The project slipped a month. | Show candour about mistakes | In review |
| Tue 8 Dec | Fixed-price work is not the safe option | Opinion | Fixed-price projects look safer than they are. | Invite debate in comments | Draft |
| Thu 10 Dec | Turning a handoff into a checklist | Lesson | A handoff without a checklist is a guess. | Reach operations managers | Draft |
| Sat 12 Dec | A one-page project summary, step by step | How-to | Most project summaries run five pages too long. | Earn saves and shares | Draft |
| Tue 15 Dec | A client who changed direction in week two | Story | In week two, the client rewrote the whole brief. | Show how you handle change | Idea |
| Thu 17 Dec | Status emails are a weak substitute for a check-in | Opinion | Stop sending status emails nobody reads. | Start replies from team leads | Idea |
| Sat 19 Dec | The short weekly check-in that replaced reports | Lesson | We swapped a weekly report for a short check-in. | Attract founders with delivery problems | Idea |
| Tue 22 Dec | Turning meeting notes into a client recap | How-to | Your meeting notes are closer to a recap than you think. | Earn profile visits from prospects | Idea |
| Thu 24 Dec | Open slot for a timely or reactive post | (open) | (open) | Keep room for news | Open |
| Sat 26 Dec | What I would keep from this year's projects | Story | Looking back, one habit paid for itself. | Build familiarity with readers | Idea |
| Tue 29 Dec | Why I am planning fewer, better projects next year | Opinion | More projects is not the same as more growth. | Invite replies from peers | Idea |
Three things to notice:
The month rotates all four post types, so readers see a mix rather than a run of tutorials. At three posts a week, the rotation continues across week boundaries.
The 24 December row is deliberately empty. If something timely comes up, it has a home and nothing else moves.
The statuses are a snapshot from the planning week. Early-month posts are further along than late-month ones, which is what you want.
Turn the plan into posts that go out on time
A calendar only helps if each row becomes a scheduled post on its date. Spark Linky's content board and scheduler handle that handoff. The board has four columns: Ideas, drafts in progress, posts waiting on review, and scheduled posts. The scheduler adds a calendar view, publishing slots, and first comments.
The table shows how each part of the template maps onto the product:
| Calendar field or status | What happens in Spark Linky |
|---|---|
| Idea | The post sits in the Ideas column of the content board |
| Draft | The draft is in progress. Run the post score, which checks the hook, clarity, structure, ending, and voice fit before you post |
| In review | The post waits in the review column. Team approvals route drafts through a review step |
| Scheduled | Brand rules are checked first, and every post is checked before it can be scheduled. The post then appears in the calendar at its publishing slot |
| Date | You connect your LinkedIn account, then choose the date and time |
| Hook and goal | Keep these in your working brief and review them before scheduling |
The scheduling steps are short. Connect the LinkedIn account you want to publish from. Choose a date and time. Schedule content that has already been approved. Optionally add a first comment or a relevant link. The LinkedIn scheduling feature covers the calendar and slot setup in more detail.
Two limitations matter for planning. LinkedIn is the only supported social network. Company page publishing is not yet supported, because it is pending LinkedIn's approval for page access. If your calendar includes company page posts, keep those rows in a separate tracker for now.
When a board or calendar tool can replace the spreadsheet
A spreadsheet is the right tool until the work outgrows it. These are the usual switch points:
| Situation | Spreadsheet | Board or calendar tool |
|---|---|---|
| You post a few times a month, on your own | Enough | Optional |
| You batch ideas and want a steady publishing rhythm | Gets messy once rows multiply | Calendar and publishing slots keep the rhythm |
| A colleague or manager must approve posts | Passing a file back and forth | A review column and team approvals |
| You turn links, videos, or PDFs into post ideas | Manual copy and paste | Content repurposing turns those sources into post ideas |
| You want results to shape next month's plan | Manual data entry | Post analytics and a weekly report |
Spark Linky's content board is described as best for anyone running more than a few posts a week, alone or with a team. That is a useful threshold: once you are tracking more than a handful of posts through review, a board tends to save more time than it costs to set up.
Common mistakes to avoid
Planning topics with no goal. Without a goal, you cannot tell whether a post did its job, and every post ends up judged on reactions alone.
Writing hooks last. Hooks written under deadline tend to sound alike. Draft them while you plan so you can see the whole month at once.
Letting statuses go stale. When nobody updates the calendar, the same post gets written twice.
Filling every slot. A month with no open slot has nowhere for a timely post to go.
Treating benchmarks as targets. Industry averages describe other accounts. Use them to sense-check a plan, not to promise results. Judge your own posts against your own earlier posts over several months.
FAQ
How many posts should a monthly LinkedIn calendar include?
Plan the number you can write well. This guide uses three slots a week only as an example, and LinkedIn does not require a fixed number. Spark Linky's content board is described as suited to anyone posting more than a few times a week, which is a practical point to revisit when the spreadsheet starts to feel crowded.
Should I use a spreadsheet or a calendar tool?
A spreadsheet works well for a solo writer posting a few times a month. Move to a board or calendar tool when reviews, multiple writers, or scheduled publishing start to slow you down. The switch is worth making when your status column needs constant updating.
Can I plan company page posts with this template?
Yes. The spreadsheet template can track both personal-profile and company-page posts. For company-page publishing, check the current capabilities of your publishing tool; company-page publishing in Spark Linky is pending LinkedIn approval.
How far ahead should I plan?
Plan topics, post types, and goals for the whole month, then draft in batches each week. Leave at least one open slot so timely posts have room. Revisit the plan after the first two weeks, because the early results will show whether your themes and goals are right.
How do I know whether the calendar is working?
Compare each post against its goal, not just its reactions. Spark Linky's LinkedIn analytics show post performance, and the weekly report summarises which posts did best and which angles to continue. Treat early numbers as signals, not guarantees, and look at patterns across several months.
Does Spark Linky publish to networks other than LinkedIn?
No. LinkedIn is the only supported social network, so the calendar in this guide is built for LinkedIn posts.
Conclusion
A LinkedIn content calendar is a short table with six honest columns, a rotation of four post types, and one open slot each month. Copy the template above, fill in the first week's rows today, and keep the statuses current. When the spreadsheet starts to slow you down, move the same rows onto a board. You can explore the content board to see how ideas move through review to scheduled posts, or start the seven-day free trial.