📱 Social Media Content Command Centre — Google Sheets Dashboard

Most businesses don't have a content problem. They have a systems problem. Content gets created in a panic, posted without strategy, and forgotten before the analytics are checked. Hashtags are recycled without knowing which ones perform. Growth is tracked by feel. Ideas evaporate between Sunday and Monday.

This dashboard changes all of that. Nine professional tabs give you a complete social media operating system — plan a full month in one batch session, track real engagement rates across all 8 platforms, manage 300 categorised hashtags, monitor every link click and conversion, and set quarterly growth goals that actually get reviewed.

The kind of infrastructure social media agencies charge thousands per month to operate. Yours forever. One payment.

---

WHAT'S INSIDE — 9 Professional Tabs

**📊 Dashboard — Live KPIs at a Glance

All your numbers in one place. Six live KPI cards pull data automatically from every other tab: total posts planned, published, scheduled, ideas ready to use, total link clicks, and overall CTR. A full platform growth snapshot shows followers, net growth, growth rate, and on-track status for all 8 platforms. A per-platform content status breakdown shows publish rate live — no manual updating required.

2. 📅 Content Planner — 52-Week Rolling Calendar

300 rows. One row per post. Every post gets a date, platform, content type, content pillar, hook (first line), full caption, visual asset reference, hashtag set name, status, and engagement score. Summary bar auto-counts posts by platform and by status and calculates your publish rate. Plan a full month in one Sunday batch session.

3. 💡 Idea Bank — 200-Row Content Vault

Never lose a content idea again. 200 rows with topic, pillar, format, platform, hook line, notes, status (Ready / In Progress / Used), and priority. Filter by "Ready" every Sunday to instantly populate your planner for the week. The professional's alternative to scattered notes app screenshots.

4. 📈 Analytics — Monthly Engagement by Platform

A dedicated section for each of the 8 platforms, every month. Track followers, posts, impressions, reach, likes, comments, shares, saves, profile visits, and link clicks. Engagement rate auto-calculates from your follower count. Annual totals auto-sum. The only way to know what content is actually working.

5. 📱 Platform Growth — 12-Month Follower History

Track follower count for all 8 platforms every month. Net growth, growth rate %, average monthly growth, and 12-month projection all calculate automatically. Set a goal and the On Track? column tells you instantly whether you're hitting it.

6. 🔗 Link Tracker — Clicks, Conversions & CTR

150 rows for every link you share. Track URL, campaign, platform, date, clicks, conversions, CTR (auto-calculated), and revenue. Know definitively which content drives real traffic — not just views.

7. #️⃣ Hashtag Library — 300-Row Manager

Pre-loaded with 50 real researched hashtags across Instagram, TikTok, LinkedIn, and YouTube — covering business, marketing, finance, e-commerce, digital products, content, productivity, and mindset. Each has platform, category, reach level, estimated post count, and set name for copy-paste use. 250 blank rows for your own additions.

8. 🎯 Goals & Strategy — Quarterly Planning

Brand foundation (name, tagline, audience, tone, UVP), 5 content pillars with percentage allocation, 12 editable quarterly goal examples, and a 7-day weekly posting schedule with best posting times. Set your strategy once. Execute it consistently every quarter.

9. 🏠 Start Here — Setup & Navigation

Step-by-step 10-minute setup guide, tab navigation with "use it when" instructions, and a full colour key. Up and running before your next coffee gets cold.

---

✅ HIGHLIGHTS

- ✔ 8 platforms — Instagram, TikTok, LinkedIn, YouTube, Pinterest, X/Twitter, Facebook, Threads

- ✔ 52-week content planner — 300 rows, all platforms, full status tracking

- ✔ 200-row idea bank with priority and status filtering

- ✔ Monthly analytics for every platform — engagement rate auto-calculated

- ✔ 12-month platform growth tracker with projection and goal tracking

- ✔ 150-row link tracker — CTR and conversions auto-calculated

- ✔ 500-row hashtag library — 50 researched hashtags pre-loaded

- ✔ Quarterly goals & strategy— pillars, brand voice, weekly schedule

- ✔ 517 pre-built formulas — zero errors, fully verified

- ✔ Works on free Google Sheets and Excel needed

- ✔ Lifetime access+ free future updates

- ✔ Instant download

---

📊 PLATFORMS COVERED

| Platform | Best Content Type | Key Metric |

|----------|------------------|------------|

| Instagram | Reels, Carousels, Stories | Engagement Rate, Reach |

| TikTok | Short Videos, Trends | Views, Shares, Growth |

| LinkedIn | Articles, Carousels | Impressions, Connections |

| YouTube | Long-form, Shorts | Views, Subscribers |

| Pinterest | Pins, Idea Pins | Link Clicks, Saves |

| X / Twitter | Threads, Replies | Impressions, Clicks |

| Facebook | Posts, Reels, Groups | Reach, Engagement |

| Threads | Conversations | Views, Replies |

---

👤 PERFECT FOR

- Small business owners managing their own social media

- Freelance social media managers handling multiple clients

- Coaches, consultants, and service providers building an audience

- Content creators across Instagram, TikTok, and YouTube

- E-commerce brands tracking which content drives real sales

- Marketing managers who need to report engagement to stakeholders

- Anyone who posts consistently but has no system to measure what works

---

⚡ INSTANT DOWNLOAD