Social Media Content Calendar

What this is

A monthly content calendar spreadsheet for planning, scheduling and tracking social media posts on Instagram, LinkedIn, Twitter/X and YouTube. It suggests content types, lists the best posting times for Indian audiences, and gives you a content pillar framework to plan around.

What is inside

Tab 1: Monthly Calendar

• 30-day grid with columns per platform
• Content type (carousel, reel, story, text post, video, poll)
• Caption/hook draft column
• Hashtag set column
• Status (planned, drafted, designed, scheduled, published)
• Performance notes

Tab 2: Content Pillars

• 5 content pillar categories with descriptions
• Recommended mix ratio (e.g., 40% educational, 20% behind-the-scenes, 20% promotional, 10% engagement, 10% trending)
• Example post ideas for each pillar

Tab 3: Best Times (India)

• Optimal posting times by platform and day of week
• Based on aggregated Indian audience data
• Morning, afternoon, and evening slots

Tab 4: Hashtag Sets

• Pre-built hashtag groups by industry
• Mix of high-volume and niche hashtags
• Ready to copy-paste per post

Tab 5: Monthly Analytics

• Track followers, reach, engagement rate, link clicks per platform
• MoM comparison
• Top performing posts log

How to use it

1. Define your 5 content pillars in Tab 2.
2. Plan the month in Tab 1, aiming for the recommended pillar mix.
3. Create content in batches of 5-7: write the captions, then design the creatives.
4. Schedule with your tool of choice: Buffer, Later, or each platform’s native scheduler.
5. Track performance in Tab 5 at month-end.

Version history

Version	Date	Notes
2.0	June 2026	Added YouTube column, hashtag sets, analytics tab
1.0	January 2026	Initial release (Instagram + LinkedIn only)