Social media content calendar: a practical template for your business

Download a free social media content calendar CSV, with a four-week example and practical steps to plan, produce and measure content for your business

Related services Content & creative

A paper calendar grid with idea cards pinned to some days; a red thread links four of the cards into one storyline

The short answer

A content calendar is a shared table of what goes out, where, why and who prepares it; the template below is ready to use, with a filled-in example

  1. Plan a few weeks ahead, and post only as often as your team can keep up
  2. Give every post a job the customer question it answers and what the reader can do next
  3. Track each post from idea to published, with one owner
  4. Review once a month and keep what brought enquiries or sales

Both files are plain CSV: they open in Excel, Numbers or Google Sheets, with no sign-up

For most small teams, the hard part of social media is the hour between an idea and a finished post

The idea is there on Monday, the photo needs the one person who’s busy all week, the price in the caption needs checking, and by Friday the post quietly becomes next week’s post

A calendar helps with that hour: it shows what has to be made, who makes it and who needs to see it before it goes out

Below are the template, a filled-in four-week example, and the working decisions that keep it moving

What the calendar should do for you

  • Show the next few weeks in one place, so posts aren’t invented on the day
  • Tie each post to something customers ask and something you sell
  • Make the preparation visible: which photo, video or text is needed, who makes it and who signs it off
  • Leave a record you can learn from at the end of the month

Planning a month ahead doesn’t mean posting every day

The right frequency is the one your team can keep with posts worth reading; two good posts a week that actually go out beat a daily plan that collapses in the second week

The fields, and how to fill them in

The first nine fields are enough to run the calendar; add the optional ones when more people need to approve posts

Field Required How to fill it in
Week or date Yes The week you plan for, or the exact day if timing matters
Channel Yes Where it goes out: Instagram, LinkedIn, a newsletter, a Google Business Profile post
Purpose Yes Explain, prove, compare or invite to act
Customer question Yes The question this post answers, in the customer’s words
Format and idea Yes Carousel, short video, photo with text or a post, plus the idea in one line
Asset needed Yes The photo, clip or graphic, and whether it already exists
Next step and link Yes What the reader can do after it: reply, read more, book or buy
Owner and status Yes One person, and where the post is: idea, in production, in review, approved, published, reviewed
Result to check Yes The one number that tells you whether the post did its job
Publish time Optional Only if a time matters for your audience or an event
Caption draft Optional The text, once the idea is approved
Approved by Optional Useful when legal, a client or a manager signs off
Tracked link Optional The link with UTM tags, see the section on results

The “asset needed” column is the one we’d fill in first, because it shows early which posts depend on something nobody has made yet

Turn customer questions into posts

The most useful topics come from people who are close to buying: questions on sales calls, in emails and comments, in reviews, and the searches that bring people to your website

The questions just before a purchase tend to be about price, time and risk, so those are good ones to answer first

For each question, write down what the customer should understand after the post and what they can do next

That line connects the calendar to sales without turning every post into an advert

A month usually needs a mix: posts that explain how something works, posts that prove you can do it, posts that help people compare options, and the occasional clear invitation to buy or get in touch

Only the last kind should be judged on direct sales

Proof needs real material: if a post should show a customer’s result or words, get their permission first and write “needs approved material” in the asset field until you have it

A filled-in example

An illustrative planning example for a small bike repair shop that also sells e-bikes, posting twice a week on Instagram plus a monthly email; the ideas are invented, and the full file includes every field

Week Channel Customer question Format and idea Next step Result to check
1 Instagram How often does a bike need a service? Carousel: a simple service schedule by kilometres ridden Book a service online Service bookings from Instagram
1 Instagram What happens during a service? Short video: a mechanic walks through a standard check Save the post, reply with questions Saves and replies
2 Instagram How long will my bike be in the shop? Photo with text: typical turnaround and how to drop off Book a slot Bookings, questions in direct messages
2 Email Is it time to get my bike ready for spring? Short email: a three-point checklist and booking link Book a service Clicks to booking, bookings
3 Instagram Is an e-bike worth it for commuting? Carousel: commute costs compared, using your own prices Read the e-bike guide on the site Visits to the guide page
3 Instagram Which e-bike suits a hilly route? Short video: two models compared on the same hill Book a test ride Test ride bookings
4 Instagram Can I trust a repair shop with an expensive e-bike? Photo story about the workshop and certifications, with real details only Visit or book Profile visits, bookings
4 Instagram What do customers say after a service? Quote post from a real customer, shared with permission Book a service Bookings; skip the post until permission is given

Notice that only a few rows ask for a booking straight away; the service video is there to answer a question and earn a save, and judging it on bookings would mean dropping a useful post for the wrong reason

To adapt it, keep the columns and change the questions: a law firm would plan around the worries before a first consultation, an online shop around sizing, delivery and how products compare, a B2B service around cost, timing and how the work is done

Who makes what

In a small business, the person who knows the answer is rarely the person who posts

The mechanic knows why a service takes two days; the owner or a marketer turns that into a caption

What works better than waiting for the expert to “write something” is collecting raw material while the work happens: a few photos of a job, a 30-second voice note, the question a customer asked at the counter

The post owner then shapes it, and the expert only checks the facts

Approval is the other place posts get stuck

Agree in advance what actually needs a sign-off, such as prices, claims, anything about a named customer and anything legal, and let the owner publish the rest

A post that waits a week for an approval nobody needed has already used the team’s time, with nothing published to show for it

When there isn’t enough time

Something will slip in a busy month, so decide in advance what gives way:

  • Post less often rather than lower the quality; keep the posts that answer buying questions
  • Turn one piece of material into several posts: the same job can become a photo, a short video and a line in the newsletter
  • Keep a small bank of posts that are never out of date, ready for weeks when nothing new gets made
  • Drop the channel that brings nothing you can measure, and give its time to the one that does

From idea to published

  1. Idea: add it to the calendar with the customer question and purpose filled in
  2. Preparation: the owner gathers or makes the asset and drafts the caption
  3. Review: someone checks facts, prices, permissions and the link
  4. Publishing: it goes out on the planned date, by hand or with your scheduling tool
  5. Review of results: a week or two later, note the result in the calendar

A short weekly look at the next two weeks keeps the plan moving

Anything stuck in production for more than a week is a sign the plan is bigger than the team’s time, and the earlier you shrink it, the less it hurts

Check results against the post’s job

Match the measure to the purpose: an explaining post can count saves and replies, an offer post should count clicks to the page and the enquiries or sales that follow

Reach, likes and saves show that people noticed; on their own they don’t show sales, so keep those two kinds of numbers apart

For links to your website, add UTM tags so your analytics shows which campaign sent the visit; that tells you where visits came from, and it can’t prove that one post caused a sale

At the end of the month, mark each post keep, change or drop, and plan the next month starting from the ones you keep

If you are still deciding whether social content should be your first priority at all, marketing strategies for small businesses has a matrix for that choice, and Implement’s services include content and creative when you want help making it

Want help planning and making the content?

Tell us what your business does, where you post now and what keeps the content from happening, and we’ll talk through a plan your team can keep up with

Discuss your content on Telegram

More from the blog

View all articles