# Shorts‑Studio™

## Overview
A end‑to‑end Notion system that takes a raw Short idea, turns it into a script, batches production, schedules publishing, tracks live performance, and ties every Short to its brand‑deal revenue. The template is built around a single **Shorts Master Database** that links to supporting databases for ideas, scripts, schedules, performance metrics, and brand deals.

> 💡 Tip: Keep the **Shorts Master Database** as your single source of truth. All other pages pull data via filtered views or roll‑ups, so you never duplicate information.

---

## 📋 Idea Bank
Collect every spark, trend, or brand brief here. Each idea can be turned into a Short later.

| Idea ID | Title | Source (Trend/Brief) | Priority | Tags | Created |
|---------|-------|----------------------|----------|------|---------|
| ID‑001 | “3‑Second Coffee Hack” | TikTok Trend | High | #coffee #lifehack | 2024‑09‑01 |
| ID‑002 | “Quick Yoga Stretch” | Brand Brief – FlexFit | Medium | #wellness #brand | 2024‑09‑03 |
| ID‑003 | “Sneaker Unboxing” | Instagram Reel | Low | #sneakers #unboxing | 2024‑09-05 |

> 💡 Tip: Use the **Priority** select (High, Medium, Low) to decide which ideas go into the next production batch.

---

## ✍️ Script & Production Pipeline
Turn ideas into scripts, then mark production steps. This view is filtered to show only items in the **Script** or **Production** stages.

| Short ID | Title | Idea ID | Script Status | Production Status | Production Date | Notes |
|----------|-------|---------|---------------|-------------------|-----------------|-------|
| SH‑001 | 3‑Second Coffee Hack | ID‑001 | Draft | Not Started | — | Add quick cut to espresso machine |
| SH‑002 | Quick Yoga Stretch | ID‑002 | Approved | Filming | 2024‑09‑10 | Use brand logo overlay |
| SH‑003 | Sneaker Unboxing | ID‑003 | In Review | Editing | — | Await brand assets |

> 💡 Tip: Link the **Idea ID** to the Idea Bank (Relation). Use a roll‑up to pull the **Tags** field for quick filtering.

---

## 📅 Schedule & Publishing
Plan batch releases and keep a calendar view of upcoming Shorts. The table below is the **Schedule** view of the Shorts Master Database.

| Short ID | Title | Publish Date | Platform | Status | Promotion |
|----------|-------|--------------|----------|--------|-----------|
| SH‑001 | 3‑Second Coffee Hack | 2024‑09‑12 | YouTube Shorts | Scheduled | Instagram Story |
| SH‑002 | Quick Yoga Stretch | 2024‑09-14 | YouTube Shorts | Scheduled | TikTok Teaser |
| SH‑003 | Sneaker Unboxing | 2024‑09-16 | YouTube Shorts | Draft | — |

> 💡 Tip: Set the **Publish Date** as a Date property with a reminder 30 minutes before publishing to ensure you’re ready to hit “Post”.

---

## 📈 Performance Dashboard
Live metrics pulled from YouTube via API (or manually entered) give you a quick health check. Use roll‑ups from the **Performance** linked database.

| Short ID | Title | Views | Likes | Avg. Watch % | Revenue (USD) | Brand Deal |
|----------|-------|-------|-------|--------------|---------------|------------|
| SH‑001 | 3‑Second Coffee Hack | 12,450 | 1,210 | 78% | 45.00 | FlexFit |
| SH‑002 | Quick Yoga Stretch | 8,300 | 950 | 65% | 30.00 | FlexFit |
| SH‑003 | Sneaker Unboxing | 5,120 | 620 | 70% | 22.00 | SneakerCo |

> 💡 Tip: Create a **Formula** column “Revenue per View” (`prop("Revenue (USD)") / prop("Views")`) to spot high‑performing content.

---

## 🤝 Brand Deal Tracker
Manage every brand partnership, its deliverables, and the revenue tied to each Short.

| Deal ID | Brand | Campaign | Total Budget (USD) | Shorts Linked | Payout Status |
|---------|-------|----------|-------------------|---------------|---------------|
| BD‑001 | FlexFit | “Fit in 3” | 500 | SH‑001, SH‑002 | Paid |
| BD‑002 | SneakerCo | “Drop Alert” | 300 | SH‑003 | Pending |
| BD‑003 | TechGear | “Gadget Quick‑Tips” | 400 | — | Negotiating |

> 💡 Tip: Use a **Relation** to link each Deal to the Shorts Master Database, then a **Roll‑up** to count how many Shorts are tied to each deal.

---

## How to import into Notion
1. **Create a new page** in your Notion workspace where you want Shorts‑Studio™ to live.  
2. Click the three‑dot menu → **“Import”** → select **“Markdown & CSV”** and upload this `.md` file.  
3. Notion will render each heading as a sub‑page and each markdown table as a **simple table**.  
4. For each table:  
   a. Click the table → **“Turn into database”** → choose **“Table – Full page”** (or **“Table – Inline”** if you prefer it embedded).  
   b. Rename the database to match the section title (e.g., “Idea Bank”, “Shorts Master Database”).  
   c. Adjust property types:  
      - Title → **Title**  
      - Dates → **Date** (enable time & reminder)  
      - Numbers → **Number** (currency for revenue)  
      - Select/Multi‑select → **Select** or **Multi‑select** as indicated  
      - Relations → **Relation** to the appropriate database (e.g., “Idea ID” → Relation to Idea Bank)  
      - Roll‑ups → **Rollup** pulling the needed field (e.g., Tags, Shorts Linked).  
5. After converting all tables, **link the databases**:  
   - In the “Shorts Master Database”, add Relation properties to **Idea Bank**, **Brand Deal Tracker**, and **Performance** (if you separate performance data).  
   - Set up filtered **Views** (Board, Calendar, Gallery) as shown in the sections above.  
6. (Optional) Connect the **Performance** database to YouTube via a third‑party integration (e.g., Notion API + Zapier) to auto‑populate Views, Likes, and Watch % daily.  
7. **Duplicate** the page as a template for future projects or share it with collaborators.

Your Shorts‑Studio™ workspace is now ready to turn ideas into revenue‑generating YouTube Shorts!