# YouTube Video Production Suite

## Dashboard / How to use  
All‑in‑one workspace for creators who want to turn a spark of an idea into a published video with data‑driven SEO, polished thumbnails, and performance insights—without juggling multiple tools.  

**Quick start (2‑minute setup)**  
- Duplicate the template (Share → Duplicate as template).  
- Open **Video Ideas Hub** → add your first idea.  
- Run the **AI SEO** button on the new row to generate keywords & tags.  
- Move the idea to **Production Pipeline** → assign a task owner.  
- Set a publish date in **Publishing Schedule** and watch the automated analytics roll in after launch.

---

## Video Ideas Hub  
Capture every video concept the moment it appears. This database fuels the rest of the workflow.

| **Title** (Title) | **Category** (Select) | **Priority** (Select) | **Created** (Date) | **Status** (Select) | **Notes** (Text) |
|---|---|---|---|---|---|
| How to Edit YouTube Shorts Fast | Tutorial | High | 2026‑06‑01 | Idea | Need script outline |
| 10 Hidden Features of Photoshop | Listicle | Medium | 2026‑06‑02 | Idea | Research competitors |
| My First 30‑Day Challenge Recap | Vlog | Low | 2026‑06‑03 | Idea | Collect B‑roll clips |

> 💡 Tip: Use the **/template button** “New Idea” to pre‑fill the Category and Priority fields for faster entry.

---

## SEO & Keywords  
Turn each idea into an SEO‑optimized plan. Leverage Notion AI (or an external LLM) to generate primary keywords, tags, and a suggested title.

| **Video** (Relation → Video Ideas Hub) | **Primary Keyword** (Text) | **Secondary Keywords** (Multi‑select) | **Suggested Title** (Formula) | **SEO Score** (Number) | **AI‑Generated** (Checkbox) |
|---|---|---|---|---|---|
| How to Edit YouTube Shorts Fast | “YouTube Shorts editing” | “quick edit”, “shorts tips”, “video editing shortcuts” | `prop("Primary Keyword") + " – " + formatDate(prop("Created"), "MMM DD")` | 86 | ✅ |
| 10 Hidden Features of Photoshop | “Photoshop hidden features” | “photoshop tips”, “design hacks”, “creative workflow” | `prop("Primary Keyword") + " – Top 10"` | 78 | ✅ |
| My First 30‑Day Challenge Recap | “30 day challenge vlog” | “vlog ideas”, “challenge recap”, “personal growth” | `prop("Primary Keyword") + " – My Journey"` | 71 | ✅ |

> ✅ Best practice: Keep **SEO Score** ≥ 80 before moving to Production. Re‑run AI if score drops.

---

## Production Pipeline  
Track every production task from script writing to final edit. Linked to the Ideas and SEO databases for context.

| **Task** (Title) | **Video** (Relation → Video Ideas Hub) | **Assignee** (Person) | **Stage** (Select) | **Due Date** (Date) | **Done** (Checkbox) |
|---|---|---|---|---|---|
| Write script for Shorts | How to Edit YouTube Shorts Fast | Alex | Draft | 2026‑06‑05 | ☐ |
| Record voice‑over | 10 Hidden Features of Photoshop | Maya | In‑Progress | 2026‑06‑07 | ☐ |
| Edit final video | My First 30‑Day Challenge Recap | Sam | Review | 2026‑06‑09 | ☐ |
| Create thumbnail mockup | How to Edit YouTube Shorts Fast | Lina | Design | 2026‑06‑06 | ☐ |

> 💡 Tip: Add a **Rollup** property “SEO Score” from the SEO database to see the score directly on each task row.

---

## Thumbnail & Assets  
Store all visual assets, version history, and final export specs. Use the **File** property for uploads and a **Select** for status.

| **Thumbnail** (Title) | **Video** (Relation → Video Ideas Hub) | **Version** (Number) | **Status** (Select) | **Export Size** (Text) | **File** (File) |
|---|---|---|---|---|---|
| Shorts‑Edit‑V1 | How to Edit YouTube Shorts Fast | 1 | Draft | 1280×720 PNG |  |
| Photoshop‑Top10‑V2 | 10 Hidden Features of Photoshop | 2 | Approved | 1920×1080 JPG |  |
| Challenge‑Recap‑V1 | My First 30‑Day Challenge Recap | 1 | Draft | 1280×720 PNG |  |

> ✅ Best practice: Lock the **Approved** version to prevent accidental edits.

---

## Publishing Schedule  
Plan the exact publish date, time, and platform details. A **Formula** calculates the “Time to Publish” from today.

| **Video** (Relation → Video Ideas Hub) | **Publish Date** (Date) | **Time** (Text) | **Platform** (Select) | **Time to Publish** (Formula) | **Live?** (Checkbox) |
|---|---|---|---|---|---|
| How to Edit YouTube Shorts Fast | 2026‑06‑12 | 10:00 AM PT | YouTube | `dateBetween(prop("Publish Date"), now(), "days") + " days"` | ☐ |
| 10 Hidden Features of Photoshop | 2026‑06‑15 | 2:00 PM PT | YouTube | `dateBetween(prop("Publish Date"), now(), "days") + " days"` | ☐ |
| My First 30‑Day Challenge Recap | 2026‑06‑20 | 5:00 PM PT | YouTube | `dateBetween(prop("Publish Date"), now(), "days") + " days"` | ☐ |

> 💡 Tip: Connect this table to Zapier/Make to auto‑push the publish date to YouTube’s “Scheduled” queue.

---

## Performance Analytics  
After a video goes live, paste the YouTube Analytics snapshot (or use Notion API integration) to track key metrics. A **Formula** flags “Underperforming” if views < 500 in the first 48 h.

| **Video** (Relation → Video Ideas Hub) | **Publish Date** (Date) | **Views (48h)** (Number) | **Avg. Watch Time** (Number) | **CTR** (Number) | **Status** (Formula) |
|---|---|---|---|---|---|
| How to Edit YouTube Shorts Fast | 2026‑06‑12 | 1 240 | 3.2 | 6.8% | `if(prop("Views (48h)") < 500, "Underperforming", "Good")` |
| 10 Hidden Features of Photoshop | 2026‑06‑15 | 842 | 4.1 | 5.2% | `if(prop("Views (48h)") < 500, "Underperforming", "Good")` |
| My First 30‑Day Challenge Recap | 2026‑06‑20 | 312 | 2.5 | 4.0% | `if(prop("Views (48h)") < 500, "Underperforming", "Good")` |

> ✅ Best practice: Review the **Status** column weekly and move any “Underperforming” video back to **SEO & Keywords** for a refresh.

---

## How to set up in Notion  
1. **Duplicate** this page → **Share → Duplicate as template** (or click “Duplicate” if you’re the creator).  
2. For each table: click the three‑dot menu → **Turn into → Database → Table – Full page**.  
3. Set property types exactly as indicated:  
   - Title columns: **Title**.  
   - Select columns: **Select** (add options shown).  
   - Multi‑select columns: **Multi‑select**.  
   - Date columns: **Date** (enable time if needed).  
   - Checkbox columns: **Checkbox**.  
   - Person columns: **Person**.  
   - Relation columns: **Relation** → link to the referenced database.  
   - Rollup columns: **Rollup** → pull the desired property (e.g., SEO Score).  
   - Formula columns: **Formula** → copy the formula text from the table.  
   - File columns: **File**.  
4. Add **Notion AI** buttons (or external integrations) where “AI‑Generated” or “Generate SEO” is mentioned—use the **/ai** block and set the prompt accordingly.  
5. (Optional) Connect **Zapier / Make**:  
   - Trigger: New row in **Publishing Schedule** with “Live?” unchecked.  
   - Action: Schedule video on YouTube using the Publish Date/Time fields.  
   - Trigger: New row in **Performance Analytics** → push metrics to a Google Sheet for deeper analysis.  
6. Test the flow: create a dummy video idea, run the AI SEO, move it through Production, set a publish date, and verify the “Time to Publish” formula updates.  
7. Once satisfied, go to **Share → Publish** and enable **Allow duplicate as template** to sell or share publicly.  

Enjoy a streamlined, data‑driven YouTube channel that lets you focus on creativity while the workspace handles the rest!