# Podcast Production Hub

## 1️⃣ Dashboard Overview  
A quick‑glance page that pulls in the most important views from the other databases.

| Widget | Description | Linked View |
|--------|-------------|-------------|
| Upcoming Episodes | Shows episodes scheduled in the next 14 days | Episodes → Calendar |
| Guest Pipeline | List of guests awaiting confirmation | Guests → Waiting List |
| To‑Do Summary | Count of open tasks by status | Tasks → Board (filtered) |
| Recent Analytics | Snapshot of latest episode stats | Analytics → Table (last 5) |

> 💡 Tip: Pin the Dashboard to your sidebar for one‑click access to the whole production workflow.

---

## 2️⃣ Episodes Database  
Track every episode from idea to publish.

| Episode # | Title | Status | Publish Date | Host(s) | Guest(s) | Length (min) | Notes |
|-----------|-------|--------|--------------|---------|----------|--------------|-------|
| 001 | Launching the Future | ✅ Published | 2024‑01-15 | Alex | — | 45 | Intro series, 10k downloads |
| 002 | AI in Everyday Life | 🎙️ Recording | 2024‑02‑05 | Alex, Maya | Dr. Lee (AI researcher) | 60 | Need B‑roll of smart home |
| 003 | Remote Work Hacks | ⏳ Planning | 2024‑02‑20 | Maya | — | 50 | Guest list pending |

**Properties:**  
- **Episode #** (Number)  
- **Title** (Title)  
- **Status** (Select: Planning, Recording, Editing, Review, Published)  
- **Publish Date** (Date)  
- **Host(s)** (Multi‑select)  
- **Guest(s)** (Relation → Guests)  
- **Length (min)** (Number)  
- **Notes** (Text)

> 💡 Tip: Use the “Status” select to drive filtered views for each production stage.

---

## 3️⃣ Guests & Outreach  
Manage guest information, outreach status, and contracts.

| Guest Name | Role | Episode # | Contact | Outreach Status | Contract Signed | Bio |
|------------|------|-----------|---------|-----------------|----------------|-----|
| Dr. Lee | AI researcher | 002 | dr.lee@email.com | ✅ Confirmed | ✅ Yes | Expert on machine learning |
| Sam Patel | Startup founder | 004 | sam@startup.io | 📧 Sent | ❌ No | Founder of FinTech app |
| Nina Gomez | Wellness coach | 005 | nina@gym.com | ⏳ Pending | — | Focus on mental health |

**Properties:**  
- **Guest Name** (Title)  
- **Role** (Select)  
- **Episode #** (Relation → Episodes)  
- **Contact** (Email)  
- **Outreach Status** (Select: Pending, Sent, Confirmed, Declined)  
- **Contract Signed** (Checkbox)  
- **Bio** (Text)

> 💡 Tip: Attach the signed contract file directly to the guest record for easy retrieval.

---

## 4️⃣ Production Tasks Board  
Kanban board for all tasks across episodes.

| Task | Episode # | Assigned To | Due Date | Priority | Status |
|------|-----------|-------------|----------|----------|--------|
| Draft intro script | 002 | Alex | 2024‑01‑28 | High | ✅ Done |
| Book studio time | 003 | Maya | 2024‑02‑02 | Medium | ⏳ In Progress |
| Edit raw audio | 002 | Sam | 2024‑02‑03 | High | 📋 To Do |
| Create episode artwork | 003 | Nina | 2024‑02‑10 | Low | 📋 To Do |

**Properties:**  
- **Task** (Title)  
- **Episode #** (Relation → Episodes)  
- **Assigned To** (Person)  
- **Due Date** (Date)  
- **Priority** (Select: Low, Medium, High)  
- **Status** (Select: To Do, In Progress, Done)

> 💡 Tip: Filter the board by “Assigned To” to see each team member’s workload at a glance.

---

## 5️⃣ Episode Analytics  
Capture performance metrics after each publish.

| Episode # | Publish Date | Downloads | Avg. Listen Time (min) | Rating (1‑5) | Sponsor Revenue |
|-----------|--------------|-----------|------------------------|--------------|-----------------|
| 001 | 2024‑01‑15 | 12,340 | 38 | 4.7 | $150 |
| 002 | 2024‑02‑05 | 9,210 | 42 | 4.5 | $120 |
| 003 | — | — | — | — | — |

**Properties:**  
- **Episode #** (Relation → Episodes)  
- **Publish Date** (Date)  
- **Downloads** (Number)  
- **Avg. Listen Time (min)** (Number)  
- **Rating (1‑5)** (Number)  
- **Sponsor Revenue** (Currency)

> 💡 Tip: Set a recurring reminder to fill this table within 48 hours of publishing for accurate data.

---

## 6️⃣ Content Library  
Store scripts, show notes, and assets.

| Asset Type | Title | Episode # | File | Tags |
|------------|-------|-----------|------|------|
| Script | Intro Script – Ep002 | 002 | 📎 intro_ep002.docx | script, intro |
| Show Notes | Show Notes – Ep001 | 001 | 📎 notes_ep001.md | notes |
| Artwork | Cover Art – Ep003 | 003 | 📎 cover_ep003.png | artwork, cover |
| Audio | Raw Audio – Ep002 | 002 | 📎 raw_ep002.wav | audio, raw |

**Properties:**  
- **Asset Type** (Select: Script, Show Notes, Artwork, Audio, Other)  
- **Title** (Title)  
- **Episode #** (Relation → Episodes)  
- **File** (Files & media)  
- **Tags** (Multi‑select)

> 💡 Tip: Use the “Tags” filter to quickly locate all assets of a certain type (e.g., all artwork).

---

## 7️⃣ SOP & Checklist Templates  
Standard operating procedures for each production stage.

**Recording SOP**  
1. Verify guest equipment & backup.  
2. Run a 2‑minute test recording.  
3. Record intro, interview, outro.  
4. Save raw file to Content Library → Audio.

**Editing Checklist**  
- [ ] Remove filler words  
- [ ] Normalize volume  
- [ ] Insert intro/outro music  
- [ ] Add sponsor ad slot  
- [ ] Export to MP3 (128 kbps)

> 💡 Tip: Duplicate the SOP page for each new episode and tick off items as you go.

---

## How to import into Notion  
1. **Create a new page** in your Notion workspace where you want the template.  
2. Click **“Import”** → select **“Markdown & CSV”** and upload this `.md` file.  
3. Notion will create the page hierarchy with headings as sub‑pages.  
4. For each table marked as a database (Episodes, Guests, Tasks, Analytics, Content Library):  
   a. Click the table → **“Turn into → Database”** → choose **Table**, **Board**, or **Calendar** as indicated in the section description.  
   b. Adjust property types to match the listed properties (e.g., set “Publish Date” as **Date**, “Guest(s)” as **Relation** to Guests, etc.).  
5. Re‑establish relations: open the **Relation** property in each database and link it to the corresponding target database.  
6. Duplicate the SOP & Checklist pages for each new episode, or use **Template Buttons** (add a button block → “New Episode”) to automate creation of a pre‑filled episode record with linked tasks and SOPs.  
7. Finally, customize views (Calendar, Board, Gallery) as you prefer and enjoy a streamlined podcast production workflow!