Introduction
Content chaos is real: “What are we posting this week?” “Did we already post that?” “The client wants to change the caption again.” A content calendar eliminates this chaos by planning everything in advance.
This post shows you how to build a content calendar that works for you and your clients.
The content calendar template
Google Sheets template
| Date | Platform | Content Type | Topic/Caption | Visual | Status | Client Approval | Posted? | Link |
|---|---|---|---|---|---|---|---|---|
| Mon 8 Sep | Carousel | 5 Python tips | Canva graphic | Draft | Pending | No | — | |
| Tue 9 Sep | Text post | Freelancing lessons | None | Approved | Approved | No | — | |
| Wed 10 Sep | Reel | Quick tutorial | Video clip | In review | Pending | No | — | |
| Thu 11 Sep | Thread | AI tools roundup | Screenshot | Approved | Approved | Yes | [link] | |
| Fri 12 Sep | Story | Behind the scenes | Photo | Draft | — | No | — |
Status flow
Draft → In Review → Client Approval → Approved → Scheduled → Posted
Step 1: Plan the month
Week 1: Strategy
- Review last month’s performance (what worked, what didn’t)
- Identify themes for the month (product launch, seasonal, educational)
- Set content goals (e.g., “3 educational posts, 2 promotional, 1 behind-the-scenes per week”)
Week 2: Batch creation
- Write all captions for the month
- Create all graphics (use templates for consistency)
- Record all videos/reels
- Review and edit
Week 3: Client approval
- Send the content calendar to the client
- Client reviews and requests changes
- Make revisions
- Final approval
Week 4: Schedule and monitor
- Schedule approved posts (Buffer, Hootsuite, or native scheduling)
- Monitor engagement
- Respond to comments
- Note what worked for next month
Step 2: Content pillars
Every brand needs 3-4 content pillars (recurring themes):
Example for a web developer:
- Educational (40%): Tips, tutorials, how-tos
- Portfolio (25%): Recent work, case studies, before/after
- Behind the scenes (20%): Process, tools, workspace
- Promotional (15%): Services, availability, testimonials
Example for a restaurant:
- Food (40%): Dishes, specials, recipes
- Behind the scenes (20%): Kitchen, team, prep
- Community (20%): Events, customer stories, local partnerships
- Promotional (20%): Offers, new items, delivery
Step 3: Batch content creation
The batch workflow
- Monday: Write all captions for the week
- Tuesday: Create all graphics (use templates)
- Wednesday: Record all videos
- Thursday: Review and edit everything
- Friday: Send to client for approval
Time savings: Batching is 3x faster than creating one post at a time (less context switching).
Template library
Create reusable templates:
- Quote graphic (text on branded background)
- Tip carousel (5 slides, consistent format)
- Before/after (split image)
- Testimonial (customer photo + quote)
- Announcement (bold text + brand colors)
Use Canva, Figma, or Adobe Express for templates.
Step 4: Client approval process
The approval workflow
- Share the calendar (Google Sheet or Notion) with the client
- Client reviews — they comment on posts they want changed
- You revise — make changes based on feedback
- Client approves — mark as “Approved” in the calendar
- You schedule — schedule approved posts
Approval rules
- One round of revisions per post (included in your fee)
- 48-hour turnaround for client feedback
- No changes after scheduling — changes go to next month’s calendar
- Written approval — “Approved” in the calendar or email confirmation
The approval email template
Hi [Client],
Here’s the content calendar for [Month]. Please review and let me know if you have any changes by [Date].
[Link to calendar]
Notes:
- Posts marked “Draft” need your input
- Posts marked “In Review” are ready for approval
- Posts marked “Approved” will be scheduled as-is
Let me know if you have questions!
Best, [Your Name]
Step 5: Scheduling
Free scheduling tools
- Meta Business Suite — free for Facebook/Instagram
- LinkedIn — built-in scheduling
- Twitter/X — built-in scheduling
- Buffer — free (3 channels, 10 posts)
- Later — free (1 social set)
Scheduling best practices
- Schedule 1 week in advance (not the whole month — trends change)
- Post at optimal times (check platform analytics)
- Don’t schedule too far ahead (content can become outdated)
- Leave room for real-time posts (news, trending topics)
Step 6: Tracking performance
Metrics to track per post
- Reach — how many people saw it
- Engagement — likes, comments, shares, saves
- Clicks — link clicks (if applicable)
- Saves — (Instagram) indicates high-value content
Monthly report
| Metric | This month | Last month | Change |
|---|---|---|---|
| Total posts | 20 | 18 | +2 |
| Avg engagement rate | 4.2% | 3.8% | +0.4% |
| Total reach | 15,000 | 12,000 | +25% |
| Best performing post | [Link] | — | — |
| Worst performing post | [Link] | — | — |
What to do with the data
- Double down on what works (topics, formats, times)
- Stop what doesn’t work
- Test one new thing per month
- Share insights with the client in the monthly report
Common mistakes
- No content calendar — “I’ll post when I have time” = inconsistent posting
- Creating posts one at a time — batching is 3x faster
- No client approval process — clients change their mind after posting
- Posting without strategy — random posts don’t build an audience
- Not tracking performance — you don’t know what works
- Too many platforms — focus on 1-2 platforms, do them well
Key Concepts
- Content calendar = planned posts with dates, topics, and status
- Content pillar = recurring theme (educational, promotional, etc.)
- Batching = creating multiple pieces of content at once
- Approval workflow = client reviews and approves before posting
- Engagement rate = (likes + comments + shares) / reach
- Content mix = ratio of educational/promotional/entertaining posts
What to Try Next
- Manage multiple clients with systems
- Write SOPs for content creation
- Automate social media posts with scheduling
- Build a content calendar dashboard in Streamlit
FAQ
How far in advance should I plan content?
Plan 1 month ahead. Create content 1-2 weeks ahead. Schedule 1 week ahead. This gives you a buffer for changes and trending topics.
How many posts per week?
Quality over quantity. 3-5 high-quality posts per week is better than 10 mediocre ones. For most businesses: 3-4 posts/week on Instagram, 2-3/week on LinkedIn, 1-2/week on Twitter/X.
Should I use a content calendar tool or a spreadsheet?
Start with Google Sheets (free, flexible). Move to Notion or a dedicated tool (Buffer, Later, Hootsuite) when you manage 3+ clients. The tool doesn’t matter — consistency does. See Best Tools for Freelancers.