# Social Media Content Planner

## Dashboard Overview
A quick‑glance page that shows today’s tasks, upcoming posts, and key metrics.

| Metric | This Week | Goal |
|--------|-----------|------|
| Scheduled Posts | 12 | 15 |
| Published Posts | 8 | 10 |
| Engagement Rate | 4.2% | 5% |
| New Followers | 120 | 150 |

> 💡 Tip: Pin this Dashboard to your sidebar for instant access to your content pipeline.

## Content Calendar (Database)
Track every piece of content from idea to publication.

| Title | Platform | Format | Status | Publish Date | Owner | Tags |
|-------|----------|--------|--------|--------------|-------|------|
| 5 Quick Breakfast Hacks | Instagram | Reel | Scheduled | 2024‑07‑02 | Alex | #food #tips |
| Monthly Blog Recap | LinkedIn | Article | Draft | 2024‑07-05 | Maya | #blog #recap |
| Spring Sale Promo | Facebook | Image | Published | 2024‑06‑28 | Sam | #sale #spring |
| Podcast Episode 12 | Twitter | Thread | Idea | 2024‑07-10 | Jamie | #podcast #launch |
| Behind‑the‑Scenes Tour | TikTok | Video | In Review | 2024‑07-03 | Alex | #bts #company |

> 💡 Tip: Use Notion’s “Group by Platform” view to see each channel’s workload at a glance.

## Content Ideas Hub
A place to capture raw ideas, trends, and inspiration.

| Idea | Source | Platform(s) | Priority | Notes |
|------|--------|-------------|----------|-------|
| User‑generated recipe contest | Instagram comments | IG, TikTok | High | Run in August |
| AI‑generated meme series | Reddit r/memes | Twitter, FB | Medium | Test engagement |
| Industry stats infographic | Statista report | LinkedIn | Low | Quarterly update |

> 💡 Tip: Add a “Save to Notion” web‑clipper button to quickly dump ideas from the web.

## Asset Library
Store images, videos, copy snippets, and brand assets.

| Asset Name | Type | Link | Used In |
|------------|------|------|---------|
| Brand Logo PNG | Image | https://example.com/logo.png | All posts |
| Intro Jingle MP3 | Audio | https://example.com/jingle.mp3 | TikTok videos |
| Caption Template – Promo | Text | — | Spring Sale Promo |
| Stock Photo – Coffee | Image | https://example.com/coffee.jpg | Breakfast Hacks |

> 💡 Tip: Enable “Public Access” on shared assets folder for easy collaboration with freelancers.

## Publishing Workflow
Step‑by‑step process to move content from idea to live post.

1. **Idea Capture** – Add a new row in **Content Ideas Hub**.  
2. **Brief Creation** – Duplicate the row into **Content Calendar**, fill platform, format, and assign owner.  
3. **Asset Gathering** – Link required files from **Asset Library**.  
4. **Draft** – Owner creates draft in the appropriate tool (Canva, Buffer, etc.) and updates **Status** to *Draft*.  
5. **Review** – Change **Status** to *In Review*; tag reviewers in the **Comments**.  
6. **Schedule** – Once approved, set **Publish Date**, change **Status** to *Scheduled*.  
7. **Publish** – On the date, click “Publish” button in Notion (linked to Buffer) and set **Status** to *Published*.  
8. **Analyze** – After 24 h, fill **Engagement** fields (likes, shares, comments) in the row.

> 💡 Tip: Automate step 7 with Zapier or Make.com to push scheduled rows to Buffer.

## Reporting & Analytics
Weekly and monthly views to measure performance.

| Period | Platform | Posts | Avg Reach | Avg Engagement | Follower Growth |
|--------|----------|-------|-----------|----------------|-----------------|
| Week 27 | Instagram | 5 | 3,200 | 4.5% | +45 |
| Week 27 | LinkedIn | 2 | 1,800 | 3.2% | +20 |
| July (so far) | All | 12 | — | — | +120 |

> 💡 Tip: Export this table monthly as CSV and import into Google Data Studio for visual dashboards.

## How to import into Notion
1. In Notion, click **Import** → **Markdown & CSV**.  
2. Select this `.md` file from your computer.  
3. Notion will create pages for each `##` heading automatically.  
4. For every table (e.g., **Content Calendar**, **Asset Library**), click the three‑dot menu on the table block → **Turn into → Database – Table**.  
5. Adjust property types:  
   - **Publish Date** → Date  
   - **Status** → Select (Idea, Draft, In Review, Scheduled, Published)  
   - **Owner** → Person  
   - **Tags** → Multi‑select  
6. Set up desired views (Calendar, Board by Status, Gallery by Platform) using the **Add a view** button on each database.  
7. Duplicate the **Dashboard Overview** page into your workspace’s sidebar for quick access.  

Your Social Media Content Planner is now ready to streamline ideation, production, and analysis across all channels. Happy planning!