A social media content calendar is a shared plan that lists every post you will publish: the date and time, the network, the format, the caption, the image or video, the content pillar it belongs to, who owns it and whether it is approved. To create one, audit what you already post, choose 3 to 5 content pillars, set a cadence you can keep on each network, build a template with those columns, fill one week, get it approved and recycle the posts that worked.

By the end of this guide you'll have a working template, two filled examples to copy from and a 30-minute weekly routine that keeps the calendar alive past week 3.

What a social media content calendar is (and what it is not)

A social media content calendar is the single source of truth for what goes out, where and when. It sits between your strategy (who you're talking to and why) and your scheduler (the tool that actually publishes).

It is not a list of ideas. An idea list has no dates, no owners and no status. A calendar does. That difference is why most "calendars" that are really idea dumps stop getting used.

What to put in your calendar: the template

Here is a copyable social media content calendar template. Paste it into Google Sheets, Notion or Airtable and each header becomes a column. The second row shows a filled example.

What each column is for:

1. Date and Time. Use your audience's time zone, not yours. If you're unsure which hours to pick, our best times to post on social media guide has starting points per network.
2. Network. One row per network, even for the same idea, because each network gets its own version.
3. Format. Reel, carousel, single image, text, thread, PDF document, short video. This is what stops you from posting 5 photos in a row.
4. Pillar. The content theme (more on this in step 2). It lets you see the mix at a glance.
5. Hook / first line. It decides whether anyone reads the rest, so give it its own column.
6. Caption. The full text, or a link to a doc if it's long. Respect the limits: X allows 280 characters, Threads 500, LinkedIn 3,000, Instagram 2,200. Instagram now caps hashtags at 5 per post.
7. Asset. A file name or link to the image or video. Never "TBD" on the day before.
8. Link / CTA. What you want people to do, plus a UTM tag if you track website clicks.
9. Owner. One person, not "team".
10. Status. Idea, Drafted, In review, Approved, Scheduled, Published. Six states, no more.
11. Notes. Approval comments, alt text, "boost with $20", "reuse in March".

After a post goes out, add two more columns if you have the time: a link to the live post and one headline metric (saves, clicks or comments, whichever matches the goal). Those two columns power step 7.

How to create a social media content calendar in 7 steps

Step 1: Audit what you already have

Before you plan new posts, look at the last 90 days.

1. Open each network's native analytics (Instagram Insights, LinkedIn Page analytics, TikTok Studio). LinkedIn's content analytics measure how your updates perform, and the report can be exported.
2. Export or screenshot your top 10 posts by the metric that matters to you (saves and shares for Instagram, comments for LinkedIn, watch time for TikTok).
3. Write down what those 10 have in common: format, topic, length, time of day.
4. Note which networks you post on but get nothing from. Those are candidates to drop or post less. Before you drop or add one, check broad reach: in the US, 84% of adults use YouTube, 71% use Facebook and 50% use Instagram, according to the Pew Research Center social media fact sheet (November 2025).

The result is a short list, something like: "carousels that teach one thing beat product photos 3 to 1; LinkedIn posts from the founder beat Page posts". That list feeds your pillars.

Step 2: Pick 3 to 5 content pillars

Content pillars for social media are the 3 to 5 recurring topics your account is known for. Fewer than 3 gets repetitive. More than 5 and nobody remembers what you stand for.

A simple formula that works for most small businesses:

• Education: teach something your customer wants to know.
• Behind the scenes: people, process, the workshop, the messy parts.
• Proof: reviews, results, before and after, customer stories.
• Offer: products, services, events, with a clear CTA.
• Community (optional): local news, partners, reposts, questions.

Give each pillar a target share of your posts. A reasonable starting mix is 40% education, 25% behind the scenes, 20% proof and 15% offer. If more than 1 in 5 posts is a sales pitch, engagement usually drops, and you'll see it in the audit.

Step 3: Set a realistic cadence per network

This is where most calendars go wrong. People copy an aggressive "post twice a day" chart, keep it up for 2 weeks and quit. The better question is: what is the lowest cadence that still grows the account, and can you keep it for 3 months?

Here is what the research says, next to what we'd actually recommend for a small team:

Where those numbers come from:

• Buffer's analysis of 2.1 million Instagram posts from 102,000 accounts (Buffer, 2025) found that going from 1 to 2 posts a week to 3 to 5 more than doubled the follower growth rate and gave about 12% more reach per post.
• Buffer's posting frequency guide (Buffer, 2026) puts LinkedIn and TikTok at 2 to 5 posts a week.
• The Rival IQ 2026 benchmark report, covering 150 brands in each of 18 industries, found Instagram at 3.7 posts a week and Facebook at 3.0, the lowest in the report's 6-year history. Brands are posting less, not more.
• Hootsuite's recommendations (Hootsuite blog, 2025) go higher (1 to 2 posts a day on Facebook and LinkedIn), but Hootsuite calls them a theoretical approach and says quality comes before quantity.

Two strong posts a week beat seven weak ones.

Step 4: Set up the template and your status workflow

1. Create a new Google Sheet (or Notion database) and paste the header row from the template above.
2. Add a dropdown to Network, Format, Pillar and Status (in Sheets: select the column, then Data > Data validation > Dropdown).
3. Add conditional formatting so each pillar gets a color. When a week turns one color, you'll spot it.
4. Freeze the header row and the Date column.
5. Add a second tab called "Ideas" with just two columns: idea and pillar. Anything that isn't dated lives here, not in the calendar.
6. Add a third tab called "Key dates" and list holidays, launches, local events and seasonal moments for the next 3 months.

That's a free Google Sheets calendar that covers most of what paid tools do for planning. It just can't publish.

Step 5: Fill one week first

Don't plan a month on day one. Plan 7 days, publish them, see how long it took. Then plan the next week with that number in mind.

1. Drop in fixed dates from the "Key dates" tab.
2. Place your cadence slots (for example Tue, Thu, Sat on Instagram).
3. Assign a pillar to each slot so the week matches your mix.
4. Pull ideas from the "Ideas" tab into each slot.
5. Write hooks first, then captions, then brief the visuals.
6. Leave 1 slot in every 5 to 10 open for reactive content: news, a trend, a great customer photo.

If you're stuck on captions, a free AI caption generator gives you 3 or 4 drafts to edit from, which is faster than a blank cell.

Step 6: Get it approved

Even a solo business owner benefits from a second pair of eyes. For teams and agencies, approval is where calendars stall, so set rules:

• One approver per account, named in the sheet.
• A fixed deadline: the week is sent Thursday, feedback is due Friday at noon.
• Comments go in the Notes column or on the post itself, never in a separate chat thread.
• Status moves to Approved only when the approver says so.

Before you send the week, run a quick check on each post. The free post review tool flags weak hooks, missing CTAs and length problems before the client sees them.

Step 7: Recycle what worked

Every 4 weeks, sort your published rows by the headline metric.

1. Mark the top 20% with a "Winner" tag.
2. For each winner, write down one new angle: a different format (carousel to Reel), a different network (Instagram carousel to LinkedIn PDF) or an updated fact.
3. Put the new version back in the "Ideas" tab with a date at least 8 weeks out.
4. Mark the bottom 20% and ask why. Wrong format, wrong time or wrong topic.

Most of your followers didn't see the original, so recycling is free cadence.

Example 1: one week for a local coffee roaster

Here's a full week for Ridgeline Coffee, a small roaster with a café and an online shop. They post on Instagram (3 a week), Facebook (3 a week, mostly reusing Instagram content) and TikTok (2 a week). Pillars: Brew better at home, From the roastery, Regulars, and This week's beans.

Total: 8 posts, 5 of them original pieces of content. With batching (film Monday's and Friday's TikToks in one session, shoot all photos on Tuesday), this takes about 3 to 4 hours a week.

Example 2: an agency running 5 clients

An agency's social media content calendar is the same template with one extra column: Client. The trick is to keep one master view and filter it per client, not to maintain 5 separate sheets that drift apart.

A realistic week for a 2-person agency with 5 local clients:

• Brightside Dental (Instagram 3, Facebook 3): pillars are patient stories, oral care tips, team, offers.
• Harbor Fitness (Instagram 4, TikTok 3): pillars are workouts, member wins, coach tips, class schedule.
• Oakwood Realty (Facebook 3, LinkedIn 2, Instagram 3): pillars are listings, local guide, market update, agent profiles.
• Tidewater Brewing (Instagram 3, Facebook 2): pillars are new releases, events, behind the tanks, food pairings.
• Keller Accounting (LinkedIn 3, Facebook 1): pillars are tax deadlines, plain-English tips, client stories.

That's 41 posts a week. At roughly 20 to 25 minutes per post for writing, design and scheduling, it's 14 to 17 hours, before comments and reporting.

How the week runs:

1. Monday: publish, review last week's numbers, add winners to each client's Ideas tab.
2. Tuesday and Wednesday: plan and draft next week for all 5 clients, batch by task (all captions, then all designs), not by client.
3. Thursday: send each client their filtered week for approval.
4. Friday: apply feedback by noon, schedule everything, and send a one-line summary per client.

A 30-day starter calendar

Starting from zero? This 30-day social media content calendar fits almost any small business at 3 posts a week on your main network.

• Day 1: Introduce yourself: who you are, who you help, one photo of you or the team.
• Day 3: Your most-asked customer question, answered.
• Day 5: Behind the scenes: how your product or service is made.
• Day 8: A customer review, quoted with permission.
• Day 10: A mistake customers make and how to avoid it.
• Day 12: Your best-selling product or service, with a clear CTA.
• Day 15: A day in the life of someone on your team.
• Day 17: A quick tip carousel (3 to 6 slides).
• Day 19: A before and after, or a result.
• Day 22: A local shout-out: a neighbor business, event or partner.
• Day 24: A myth in your industry, busted.
• Day 26: An offer or event, with a deadline.
• Day 29: Your top post of the month, reworked in a new format.

Fill the gaps with Stories, replies and comments on other accounts. At the end of the 30 days, run step 7 and build month 2 from what worked.

Where to keep your calendar: Google Sheets, Notion, Trello or a scheduler

Any of these can hold a social media content calendar. The right one depends on how many people touch it and whether you want it to publish.

Our honest take: start in Google Sheets. When copying captions from the sheet into each network starts eating an hour a week, move to a scheduler with a calendar view so planning and publishing live in one place. A dedicated Instagram scheduler or LinkedIn scheduler also previews formats a spreadsheet can't, such as carousels and PDF document posts.

How agencies run client approvals on the calendar

Approvals are where agency calendars slow down: feedback arrives in 4 channels and Tuesday's post goes out Friday. Five rules fix most of it.

1. Send the whole week at once. One message, one link, every post with its image and caption. Never drip posts one by one.
2. Give a deadline and a default. "Please review by Friday at noon. Anything without comments by then goes out as planned." Put that sentence in the contract.
3. Collect feedback in one place. Comments on the post itself, not in email, text and WhatsApp.
4. Offer three options per post: approve, comment, or ask for a change. Nothing else.
5. Track turnaround. If a client takes 4 days every week, move their review day earlier.

SocialScheduler, our own tool, builds this into the calendar: the agency can approve in the app, the client can approve, comment or ask for a change from an email link without logging in, or the account can run on full autopilot. Whatever tool you use, the rule that matters most is the default in step 2.

Why content calendars die after 3 weeks (and how to keep yours alive)

Most calendars are full for 2 weeks, half full in week 3 and abandoned by week 5. The causes repeat:

• The cadence was a wish, not a plan. You set 7 posts a week and have time for 3. Fix: plan to your real capacity, from the step 5 test.
• Too many columns. A 25-column sheet nobody fills in is worse than a 10-column one everyone uses.
• No owner. "The team" doesn't write posts. Every row needs one name.
• Ideas and dates are mixed. The calendar fills with half-thoughts. Keep ideas in their own tab.
• No reactive room. When news breaks, the plan gets thrown out entirely instead of flexing. Keep 1 in every 5 to 10 slots open.
• Nobody looks at results. Without step 7, the calendar never gets easier, so it feels like a chore forever.

The fix is a fixed, short routine. Here's how to manage a social media content calendar in 30 minutes a week:

1. 5 minutes: check last week's posts went out; mark anything missed.
2. 10 minutes: log one metric per post and tag winners.
3. 10 minutes: fill next week's slots from the Ideas tab and key dates.
4. 5 minutes: send for approval.

Book it as a recurring meeting with yourself, same day, same time.

How AI planning changes the weekly routine

The steps above don't change with AI. What changes is who writes the first draft: an AI tool proposes the week from your pillars, past results and key dates, and you edit and approve.

In practice that shifts your time from writing to judging:

• Before: 3 to 4 hours per client per week drafting captions and briefing visuals.
• After: 30 to 60 minutes reviewing drafts, fixing the ones that miss the voice and approving the rest.

Two cautions: AI drafts are only as good as the brief (give it your pillars, 5 of your best past posts and words you never use), and keep a human on approvals until the drafts are consistently on target.

This is how SocialScheduler works: each Sunday it plans the week for each client, writes posts in the client's voice, designs images, carousels and short videos, schedules them for the hours that client's audience is online and sends a Monday report under the agency's name. A planned week costs 10 AI credits and the Free plan includes 20 a month, so you can test it on one client. See pricing for the Business and Agency plans.

What to do next: copy the template into a Google Sheet today, run the 90-day audit, and fill just one week. Publish it, time how long it took, and build week 2 from that number. After a month, you'll know exactly how much content you can keep up, and that number is the real foundation of your calendar.