# Podcast Production Hub

## 1️⃣ Dashboard Overview  
A quick‑glance page that surfaces the most important items for any episode in progress.

| Status | Episode # | Title | Release Date | Guest | Progress |
|--------|-----------|-------|--------------|-------|----------|
| 🎙️ In Planning | 12 | “AI in Everyday Life” | 2024‑07‑15 | Dr. Maya Patel | 20% |
| 🎧 Recording | 13 | “Startup Funding 101” | 2024‑07‑22 | Alex Rivera | 55% |
| ✅ Ready to Publish | 14 | “Travel Hacks Post‑COVID” | 2024‑07‑29 | N/A | 90% |

> 💡 Tip: Use the **Progress** column to set a numeric % that updates automatically via a formula (e.g., `prop("Planning") + prop("Recording") + prop("Editing")`).  

## 2️⃣ Episode Master Database  
All episodes live here. Each row is an episode with linked sub‑pages for detailed workflow.

| Episode # | Title | Guest | Status | Release Date | Show Notes | Audio File |
|-----------|-------|-------|--------|--------------|------------|------------|
| 12 | AI in Everyday Life | Dr. Maya Patel | In Planning | 2024‑07‑15 | Draft in Notion | — |
| 13 | Startup Funding 101 | Alex Rivera | Recording | 2024‑07‑22 | Outline attached | — |
| 14 | Travel Hacks Post‑COVID | — | Ready to Publish | 2024‑07‑29 | Final script | travel‑hacks.mp3 |

*Properties to add in Notion*:  
- **Episode #** (Number)  
- **Title** (Title)  
- **Guest** (Person)  
- **Status** (Select: In Planning, Recording, Editing, Ready to Publish, Published)  
- **Release Date** (Date)  
- **Show Notes** (Relation → Show Notes DB)  
- **Audio File** (Files & media)  

> 💡 Tip: Turn **Status** into a Kanban view to drag episodes through production stages.

## 3️⃣ Show Notes & Scripts  
A database for all written content, linked to the Episode Master.

| Note ID | Episode # | Type | Content Preview | Last Edited |
|---------|-----------|------|-----------------|-------------|
| SN‑12‑01 | 12 | Outline | “Intro: why AI matters…” | 2024‑06‑20 |
| SN‑13‑01 | 13 | Script | “Welcome to Startup Funding 101…” | 2024‑06‑22 |
| SN‑14‑01 | 14 | Bullet List | “1. Book early… 2. Use flexible tickets…” | 2024‑06‑25 |

*Key fields*:  
- **Note ID** (Formula: `prop("Episode #") + "-" + formatDate(now(), "YYMMDD")`)  
- **Episode #** (Relation → Episode Master)  
- **Type** (Select: Outline, Script, Transcript, Research)  
- **Content** (Rich text)  

> 💡 Tip: Enable **Version History** on this page to revert accidental edits.

## 4️⃣ Guest Management  
Track contacts, bios, and scheduling.

| Guest | Email | Bio | Availability | Episode # |
|-------|-------|-----|--------------|-----------|
| Dr. Maya Patel | maya@aiinsights.com | AI researcher, author of “Machine Minds”. | Tue/Thu 10‑12 AM | 12 |
| Alex Rivera | alex@startuphub.io | Founder of SeedSpark, VC mentor. | Mon 2‑4 PM | 13 |
| — | — | — | — | 14 (no guest) |

*Fields*:  
- **Guest** (Person)  
- **Email** (Email)  
- **Bio** (Text)  
- **Availability** (Multi‑select)  
- **Episode #** (Relation → Episode Master)  

> 💡 Tip: Sync this table with Google Calendar via Zapier to auto‑create interview slots.

## 5️⃣ Production Checklist (Template)  
A reusable checklist page that appears on each episode page.

```
- [ ] Brainstorm topic
- [ ] Research & gather sources
- [ ] Book guest / confirm schedule
- [ ] Write outline
- [ ] Draft script
- [ ] Record audio
- [ ] Edit & clean audio
- [ ] Add intro/outro music
- [ ] Write show notes
- [ ] Create episode artwork
- [ ] Schedule social media posts
- [ ] Publish to hosting platform
- [ ] Send thank‑you email to guest
```

> 💡 Tip: Duplicate this checklist into the episode page and tick off items; the **Progress** formula in the Episode Master can sum completed items.

## 6️⃣ Marketing & Distribution Tracker  
Plan promotion across channels.

| Episode # | Platform | Post Date | Copy Draft | Status |
|-----------|----------|-----------|------------|--------|
| 12 | Instagram | 2024‑07‑13 | “AI is reshaping our lives…” | Draft |
| 12 | Twitter | 2024‑07‑13 | “New episode drops soon…” | Scheduled |
| 13 | LinkedIn | 2024‑07‑20 | “Funding tips for founders…” | Ready |
| 14 | Newsletter | 2024‑07‑28 | “Travel after the pandemic…” | Draft |

*Properties*:  
- **Episode #** (Relation)  
- **Platform** (Select)  
- **Post Date** (Date)  
- **Copy Draft** (Text)  
- **Status** (Select: Draft, Scheduled, Published)  

> 💡 Tip: Use a calendar view to see all upcoming posts at a glance.

## 7️⃣ Financials & Sponsorships  
Log episode costs, revenue, and sponsor details.

| Episode # | Sponsor | Amount | Expense Type | Amount | Net |
|-----------|---------|--------|--------------|--------|-----|
| 12 | AI Labs | $250 | Sponsorship | — | +$250 |
| 13 | — | — | Editing Service | $120 | -$120 |
| 14 | TravelCo | $300 | Sponsorship | — | +$300 |

*Fields*:  
- **Episode #** (Relation)  
- **Sponsor** (Text)  
- **Amount** (Number, $) – for income or expense  
- **Expense Type** (Select)  
- **Net** (Formula: `if(prop("Sponsor"), prop("Amount"), -prop("Amount"))`)  

> 💡 Tip: Create a rollup on the Episode Master to show total net profit per episode.

## How to import into Notion
1. **Create a new page** in your Notion workspace where you want the template.  
2. Click **Import** → **Markdown & CSV** and select this `.md` file.  
3. Notion will generate headings and plain tables.  
4. For each table:  
   a. Click the table → **Convert to Database**.  
   b. Rename the database according to the section title (e.g., “Episode Master”).  
   c. Add the missing property types (Select, Relation, Formula, Files, etc.) as described in each section.  
   d. Set up the relations between databases (Episode # ↔ Show Notes, Guest, Marketing, Financials).  
5. Duplicate the **Production Checklist** block into each episode page (use the “Duplicate” option).  
6. Adjust views (Kanban for Status, Calendar for Release Dates, Gallery for Artwork) as needed.  
7. (Optional) Connect external tools (Google Calendar, Zapier, social‑media schedulers) using Notion’s API or integration platforms.  

Your Podcast Production Hub is now ready—start creating episodes, track progress, and publish with confidence!