# Content Calendar Pro

## Overview
A high‑level hub that gives you quick access to the core parts of the workflow. Use the links below to jump to the database you need most often.

> 💡 Tip: Pin this page to your sidebar for one‑click access to your entire content pipeline.

- **[Content Calendar](#content-calendar)**
- **[Content Ideas](#content-ideas)**
- **[Asset Library](#asset-library)**
- **[Publishing Workflow](#publishing-workflow)**
- **[Analytics Dashboard](#analytics-dashboard)**

---

## Content Calendar
The master schedule where every piece of content lives from idea to publication. This table should be imported as a Notion **Table** database.

| Title | Type | Platform(s) | Owner | Status | Publish Date | Tags | SEO Score |
|-------|------|-------------|-------|--------|--------------|------|-----------|
| 10 Tips for Remote Work | Blog Post | Web | Alice | Draft | 2024‑07‑05 | #remote #productivity | 78 |
| Summer Instagram Reel | Reel | Instagram | Bob | Scheduled | 2024‑07‑10 | #summer #reel | — |
| Monthly Newsletter – July | Newsletter | Email | Carol | Review | 2024‑07‑15 | #newsletter | — |
| Podcast: Scaling Startups | Podcast | Spotify, Apple | Dave | In Production | 2024‑07‑20 | #startup #growth | — |
| LinkedIn Thought Piece | Article | LinkedIn | Eve | Published | 2024‑07‑01 | #leadership | 85 |

> 💡 Tip: Use **Status** to drive automation (e.g., move cards to a “Ready to Publish” view when status = “Scheduled”).

### Views to create in Notion
1. **Calendar View** – shows `Publish Date` on a calendar.
2. **Board View** – grouped by `Status` (Draft, Review, Scheduled, Published).
3. **Filtered View** – only items where `Publish Date` is within the next 7 days.

---

## Content Ideas
A place to capture raw ideas, assign priority, and later push them into the Content Calendar. Import this as a **Table** database.

| Idea | Category | Priority | Owner | Created | Tags |
|------|----------|----------|-------|---------|------|
| AI tools for content creators | Blog Post | High | Alice | 2024‑06‑20 | #AI #tools |
| Behind‑the‑scenes TikTok series | Video | Medium | Bob | 2024‑06‑22 | #tiktok #bts |
| Quarterly industry report | PDF | Low | Carol | 2024‑06‑25 | #report #industry |
| Guest interview with Jane Doe | Podcast | High | Dave | 2024‑06‑27 | #interview #guest |
| LinkedIn poll on remote work tools | Post | Medium | Eve | 2024‑06‑28 | #poll #remote |

> 💡 Tip: Add a **Priority** select (High, Medium, Low) to quickly surface the most urgent ideas.

### Suggested workflow
1. Capture idea → assign **Owner**.
2. When ready, change **Category** to match a Content Calendar entry and drag the row into the Calendar database (or use Notion’s “Copy to” action).

---

## Asset Library
Store all media assets (images, videos, documents) with metadata so you can locate them instantly when building a piece of content. Import as a **Table** database.

| Asset Name | Type | Source | License | Linked Content | Uploaded |
|------------|------|--------|---------|----------------|----------|
| Summer_Sunset.jpg | Image | Unsplash | Free | Instagram Reel, Blog Post | 2024‑06‑15 |
| Podcast_Intro.mp3 | Audio | In‑house | Owned | Podcast: Scaling Startups | 2024‑06-10 |
| Brand_Guidelines.pdf | Document | Internal | Owned | All | 2024‑05‑30 |
| Remote_Work_Infographic.png | Image | Canva | Paid | Blog Post, Newsletter | 2024‑06‑18 |
| Intro_Video_Clip.mp4 | Video | StockFootage | Paid | YouTube, LinkedIn | 2024‑06‑12 |

> 💡 Tip: Use the **Linked Content** relation to connect assets directly to rows in the Content Calendar for one‑click access.

---

## Publishing Workflow
A step‑by‑step checklist that lives inside each content item (via a **Relation** to a “Tasks” sub‑database). Below is the template you should duplicate for every new piece of content.

| Task | Owner | Due Date | Completed |
|------|-------|----------|-----------|
| Draft copy | Owner | 2 days before Publish Date | ☐ |
| Internal review | Editor | 1 day before Publish Date | ☐ |
| SEO audit | SEO Lead | 1 day before Publish Date | ☐ |
| Asset upload | Designer | 1 day before Publish Date | ☐ |
| Schedule / Publish | Owner | Publish Date | ☐ |
| Post‑publish promotion | Social Lead | Publish Date + 1 day | ☐ |
| Performance review | Analyst | Publish Date + 7 days | ☐ |

> 💡 Tip: Turn the **Completed** checkbox into a Notion formula that shows a green checkmark when true, giving you a visual progress bar on the main calendar view.

---

## Analytics Dashboard
A read‑only view that aggregates key performance indicators (KPIs) from published content. Import as a **Table** database; later link it to your analytics tool (e.g., Google Data Studio) via Notion’s embed block.

| Title | Platform | Publish Date | Views | Click‑Through Rate | Engagement |
|-------|----------|--------------|-------|--------------------|------------|
| 10 Tips for Remote Work | Web | 2024‑07‑01 | 4,532 | 3.2% | 12% |
| Summer Instagram Reel | Instagram | 2024‑07‑10 | 12,104 | 5.8% | 22% |
| Monthly Newsletter – July | Email | 2024‑07‑15 | 2,876 | 18.5% | 9% |
| Podcast: Scaling Startups | Spotify | 2024‑07‑20 | 3,210 | 4.1% | 15% |
| LinkedIn Thought Piece | LinkedIn | 2024‑07‑01 | 1,987 | 2.9% | 8% |

> 💡 Tip: Add a **Rollup** property that pulls the latest KPI from the linked analytics source, so you always see up‑to‑date numbers without leaving Notion.

---

## How to import into Notion
1. **Create a new page** in your Notion workspace where you want the template.  
2. Click the three‑dot menu → **“Import”** → select **“Markdown & CSV”**.  
3. Upload this `.md` file. Notion will render the headings and plain tables.  
4. For each table you want as a database:  
   - Click the table → **“Turn into database”** → choose **“Table”**.  
   - Adjust property types (e.g., change “Publish Date” to **Date**, “Owner” to **Person**, “Tags” to **Multi‑select**).  
5. Set up the recommended **Views** (Calendar, Board, Filtered) as described in each section.  
6. Create the **Relation** fields between the Content Calendar, Asset Library, and Analytics Dashboard as needed.  
7. Duplicate the **Publishing Workflow** task template for each new content item (use the “Duplicate” button on the sub‑database).  

Your Content Calendar Pro is now ready to drive a full‑funnel content production process!