GUIDE
How to create a social media content calendar
A content calendar answers three questions: what do you publish, where and when? That sounds obvious. Without a plan, though, social media usually happens on the side, between two meetings, and it is the first thing to go when the week fills up.
The steps below work for freelancers as well as for small teams and agencies. The template mirrors them one to one, but you can also start with pen and paper.
1. Set a goal before you collect topics
Do you want inquiries, job applications, newsletter sign-ups or simply more awareness? The goal decides which posts you need. If you want inquiries, show more often how working with you looks and what it brings. If you want awareness, you need posts people like to share or save.
Write the goal down in one sentence and make it measurable, for example: “By the end of the quarter, we get two inquiries per month through LinkedIn.” Read that sentence again every time you plan.
2. Pick channels you can actually keep up
Being everywhere sounds good and almost always fails for lack of time. Start with one or two channels where your audience really spends time. Business customers are often on LinkedIn, consumers more on Instagram or Facebook. People actively looking for a solution find your blog through Google.
Add another channel only once the first two have run for a few weeks without a struggle.
A topic does not have to be created from scratch for every channel. One blog article becomes a LinkedIn post, a carousel and a newsletter issue. Plan these spin-offs right away, and one good topic carries a whole week.
3. Define three to five content pillars
Content pillars are the recurring themes you talk about. They keep every post from starting at zero and give you a healthy mix. A split like this one works well:
- Tips and know-how: expertise that actually helps your audience.
- Behind the scenes: how you work and who is behind it.
- Results and voices: proof that your offer works.
- Offer: what you sell, clear and without pressure.
- Conversation: questions, polls and replies to comments.
Give each pillar a target share. A useful rule of thumb: at most one post in five sells directly. The template checks whether your plan matches these shares.
4. Plan a frequency you can sustain
Three posts a week for a whole year do more than daily posts for a month followed by silence. Be honest about your time each week. A text post often takes half an hour, a carousel or a short video easily two hours.
Set fixed days, such as Tuesday and Thursday for LinkedIn. Fixed days turn planning into a routine, and you spot gaps early.
5. Sketch the year with occasions
Holidays, seasons and dates like Black Friday give you material for posts, but they are optional. Use only occasions that fit your offer. A local contractor has different topics in spring than an online shop in December.
Plan one goal and one or two focus topics per month. Then you know in March that May has several long weekends and that it pays to finish posts in advance.
6. Collect ideas in one fixed place
The best topics rarely come up at your desk. They come from everyday work: a customer question on the phone, a comment under a post, a mistake you keep seeing. Write such ideas down right away, in a place you open when you plan.
In the template's idea bank, each idea gets a source, a pillar and a priority. When you plan the week, you start with the most important ones.
7. Fill the weekly plan: hook, format, call to action
Every post gets its own row in the content calendar. Three fields decide how well it works:
- Hook: the first sentence. It decides whether someone keeps reading. Specific beats general, so “Three questions we ask before every project” instead of “Tips for better projects”.
- Format: text, image, carousel, short video or article. Choose the format by content, not by trend. Step-by-step instructions fit a carousel, a look behind the scenes fits a short video.
- Call to action (CTA): what should the reader do at the end? Comment, save, visit your website? One clear call per post is enough.
Plan two to four weeks ahead. Further rarely pays off because current topics come up in between.
8. Agree on status and approvals
As soon as more than one person is involved, every post needs a status: idea, in progress, approval, scheduled, published. That way everyone sees at a glance where something is stuck. In the template, the status is colored automatically and overdue dates turn red.
Also agree on who approves and by when. An approval that sits for three days throws the whole plan off.
9. Review monthly and adjust
Twenty minutes once a month is enough: how many posts went out, on which channels, for which pillars? Which three brought the most reactions or inquiries? Do more of what works and drop what nobody misses.
The template's dashboard counts posts per channel, status and month. Reach and engagement come from the platforms' own analytics.
Common mistakes
- Too many channels at once. One channel that runs regularly beats four that are half maintained.
- Talking only about your offer. If you only sell, you lose attention.
- Treating the plan as an obligation. It is a tool: when a current topic matters more, move a post.
- No backup. Keep two or three evergreen posts ready for weeks when nothing goes to plan.