how to build a content calendar for social media

a social media content calendar is a list of your posts placed on dates. each row has the network, the format, the shoot day, the post day, the status, the caption and a link. to plan one, start from how many posts you finish in a week. put the post days on the calendar first, then work backwards to the shoot days, and after that you only fill in captions and update statuses.

say you run a sourdough baking account and post on Instagram, TikTok and YouTube. the account is made up, and the rest of this guide uses it for every example. here the bread sets the schedule: dough mixed on Friday night gets baked on Saturday, so most filming happens on one weekend day and the posts go out across the next week.

the short version

• one row is one post on one network, with seven columns: network, format, shoot day, post day, status, caption and link.
• every post gets two dates, because the day you film is rarely the day it goes live.
• color the rows by status, so one look tells you what still needs work.
• plan two weeks day by day and keep only topics for the month after.
• one idea can go to three networks, but each network gets its own row, cut and caption.

content calendar vs content plan vs content strategy

the three words get mixed up, and they answer different questions. a strategy says who the account is for and what it talks about. a plan lists the posts you'll make, and a calendar puts those posts on dates, so you can see what happens on Tuesday.

for the sourdough account, the strategy might be "home bakers who have killed at least one starter". the plan is the list of topics for the next few weeks, such as flat loaves, the poke test and scoring. the calendar says the flat loaf reel goes up on Instagram on Monday and gets filmed the Saturday before.

if you're starting with a single week, the weekly content plan guide walks through it step by step. this guide covers two weeks or more on several networks.

columns a content calendar needs

seven columns cover most accounts run by one person. shoot day and post day get their own section below. every extra column is one more thing to fill in for every post, so add one only when something keeps going missing.

network

write one network per row, so a video that goes to Instagram and TikTok takes two rows. the two copies usually end up with different captions, covers and post days.

format

the format tells you how much work a post takes. an Instagram carousel can be made at your desk from photos you already have. a reel needs filming and editing, and a long YouTube video can take a full weekend. formats also differ between networks, so pick from each network's own list.

status and color

status shows where each post is stuck, and five values are enough. color the rows by status, since status is what changes every day. this set works in Google Sheets or Excel with conditional formatting:

• idea, grey. the topic exists, nothing else does.
• shoot, yellow. it's on the list for the next filming day.
• edit, blue. the footage exists and needs cutting, a sound and a cover.
• ready, green. it's edited and captioned, so on post day there's nothing left but to publish.
• posted, no color, so finished rows fade into the background.

if you take brand deals, add one more value for posts waiting on the brand's approval. otherwise they get counted as ready when they can't go out yet.

test it on Wednesday: look at the next three days. any row that isn't green by the evening before its post day needs a decision: film it tonight, move it or drop it.

caption

write the caption into the row, or at least its first line. on Instagram and TikTok a long caption gets cut off under the video until someone taps "more", so that first line works like a second hook.

link

before the post goes out, the link column holds a reference: a video you want to learn from or a sound you plan to use. after it goes out, replace it with the link to your own post.

why a post needs two dates

a post has a shoot day and a post day because they almost never fall on the same day. a calendar with only post dates hides the filming, and filming is the part that runs out of time.

for the sourdough account, a loaf takes the better part of two days. the starter gets fed on Friday morning, the dough is mixed in the evening and proofs overnight, and the bake happens on Saturday. most of the filming happens on Saturday, and the posts go out over the next week.

when both dates sit in the same row, two problems show up early:

• a post with a post day and no shoot day. if the Friday reel has no filming date, it gets filmed on Friday night or not at all.
• too little time between the two dates. a reel filmed on Saturday and due on Sunday morning means editing late on Saturday. a day in between gives you time to edit and to notice that a shot is missing.

two dates also make batching visible. sort the calendar by shoot day, and all the Saturday rows sit together. that's your shot list for the bake, and the guide to batch content creation covers how to run a day like that.

how far ahead to plan a content calendar

plan two weeks day by day, and keep a lighter list beyond that. a detailed plan for week five usually gets rewritten before it arrives, because a trend shows up or a shoot falls through.

a split that holds up:

• the next two weeks. every post has a network, a format, both dates and a status. the shoots for the first week are booked.
• the month after. topics only, with no dates yet.
• fixed dates, as soon as you know them. brand deadlines, launches and holidays go on the calendar the day you hear about them, even if that's months ahead.

holidays are where planning ahead pays off most. for the sourdough account, holiday bread posts in late November and December mean holiday bakes filmed in early November and recipe tests in October.

once a week, move what didn't go out, pull two or three topics from the month list into the empty slots and book the next shoot.

posting on several networks without copying the same post everywhere

the same idea can work on all three networks. the same file with the same caption often won't, because each network has its own lengths, formats and habits.

for the sourdough account, one Saturday bake turns into several posts:

• an Instagram reel, 30 seconds of scoring the loaf with a voiceover and a caption that explains the pattern.
• a TikTok video from the same footage, cut shorter, with the finished loaf in the first second and a one-line caption.
• an Instagram carousel of five photos from the bake: the starter, the dough, the score, the crust and the crumb.
• a YouTube long video of the whole bake, filmed over Friday and Saturday and posted the following week once it's edited.

that's one shoot and four rows, each with its own format, caption and post day. spread over the week, someone who follows you on two networks won't see the same video twice in one afternoon.

reposting the same video is fine when it fits both networks. Instagram has told creators it recommends fewer reels that are visibly reposted from other apps, so export a clean copy from your editor instead of saving the TikTok with its watermark.

when you're short on time, pick one network as the main one and plan shorter versions for the others. a calendar that says "same as Instagram" in every TikTok row means TikTok gets leftovers anyway, so plan it that way on purpose.

a sample two-week content calendar

the sourdough account's calendar for two weeks is below, one line per day. the pace is five posts a week, plus one long YouTube video every other week. the statuses are what you'd see on Wednesday evening of the first week.

week 1

• Monday, Instagram reel. why my loaf came out flat. shoot: last Saturday. status: posted. caption: done. link: the post.
• Tuesday, TikTok video. the poke test in 20 seconds. shoot: last Saturday. status: posted. caption: done. link: the post.
• Wednesday, Instagram carousel. a starter feeding schedule in six slides, made on Monday evening from old photos. status: posted. caption: done. link: the post.
• Thursday, TikTok video. one recipe, three flours. shoot: last Saturday. status: ready. caption: done. link: a reference video.
• Friday, Instagram reel. three scoring patterns for beginners. shoot: last Saturday. status: edit. caption: first line only. link: a reference video.
• Saturday, no post. the bake for week two gets filmed on Friday evening and Saturday, along with the footage for the YouTube video.
• Sunday, no post. you edit the week two videos and write their captions.

week 2

• Monday, Instagram reel. the overnight proof, sped up. shoot: Saturday of week one. status: shoot. caption: not yet. link: a reference sound.
• Tuesday, TikTok video. a reply to the comment "why is my crumb gummy?". shoot: Monday of week two. status: idea. caption: not yet. link: the comment.
• Wednesday, Instagram carousel. five mistakes from my first ten loaves, made on Tuesday evening. status: idea. caption: not yet. link: none.
• Thursday, YouTube long video. a full bake day, from starter to crumb. shoot: Friday and Saturday of week one. status: shoot. caption: the description gets written during editing. link: none.
• Friday, Instagram reel. scoring with a razor or a kitchen knife. shoot: Saturday of week one. status: shoot. caption: not yet. link: a reference video.
• Saturday, TikTok video. the same razor and knife test, cut to 15 seconds with the result first. shoot: same footage as Friday's reel. status: shoot. caption: not yet. link: none.
• Sunday, no post. the slot stays open for a trend or for anything that slipped.

read the list by shoot day and a weak spot shows up. four posts in week two depend on one Saturday, so if the bake fails, the calendar has to change by Sunday. that's why week two also has a carousel and a comment reply. neither of them needs the bake.

FAQ

is a content calendar the same as a posting schedule

mostly, yes. a posting schedule lists when posts go live. a content calendar adds the shoot day, the format and the status, and you need those when you make every post yourself.

what if a post misses its date

move it once, to the next free slot on the same network. if it misses again, send it back to the idea list. when the same post moves every week, the calendar stops telling you anything useful.

should a content calendar live in a spreadsheet or an app

a spreadsheet is free and takes any column you want. an app makes sense once you want shoot reminders on your phone.

how do you start a content calendar

open your profile on each network and write down your posts from the last two weeks, one row per post. then find the shoot day for each one in your camera roll. you'll see your real pace and the usual gap between filming and posting, and that's the first draft of your calendar.

read next: reel script template with structure and example, batch content creation for a week of content in a day. more about the app is on the home page.