# Podcast Production Hub

## 1️⃣ Dashboard  
A quick‑glance page that pulls together the most important info for each episode.

| View | Description |
|------|-------------|
| **Upcoming Episodes** | Calendar view of episodes scheduled in the next 4 weeks. |
| **Production Status** | Board view grouped by *Stage* (Idea → Recording → Editing → Review → Published). |
| **Metrics Snapshot** | Inline table showing total episodes, average download per episode, and upcoming guest count. |

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

---

## 2️⃣ Episode Pipeline (Database)  
This is the core database. Create it in Notion and copy the rows below.

| Episode # | Title | Guest(s) | Release Date | Stage | Recording File | Edit Notes | Publish Link |
|-----------|-------|----------|--------------|-------|----------------|-----------|--------------|
| 001 | Launching the Future of AI | Dr. Maya Patel | 2024‑07‑15 | Published | `Launch_AI.mp3` | Final cut approved | https://podcast.com/001 |
| 002 | Remote Work Hacks | Alex Rivera | 2024‑07‑22 | Editing | `Remote_Work.mp3` | Add intro music |  |
| 003 | Mindful Tech | Dr. Sam Lee | 2024‑07‑29 | Recording |  |  |  |

> 💡 Tip: Use the **Stage** select property to drive board view filters and automate reminders with Notion’s built‑in formulas.

### Suggested Properties
- **Episode #** (Number) – auto‑increment.
- **Title** (Title) – episode name.
- **Guest(s)** (People) – link to Guest Database.
- **Release Date** (Date) – schedule.
- **Stage** (Select) – Idea, Research, Recording, Editing, Review, Published.
- **Recording File** (File) – upload raw audio.
- **Edit Notes** (Text) – checklist for editor.
- **Publish Link** (URL) – final episode URL.
- **Show Notes** (Relation) – link to Show Notes page.

---

## 3️⃣ Guest Management (Database)  
Keep all guest details, contact info, and episode assignments.

| Guest | Email | Bio | Socials | Confirmed? | Assigned Episode |
|-------|-------|-----|---------|------------|------------------|
| Dr. Maya Patel | maya@aiinsight.com | AI researcher, author of *Future Code* | @mayapatel (Twitter) | ✅ | 001 |
| Alex Rivera | alex@remotework.io | Founder of RemoteCo | @alexremote (IG) | ❌ | 002 |
| Dr. Sam Lee | sam.lee@mindfultech.org | Neuroscientist, mindfulness advocate | @samlee (LinkedIn) | ✅ | 003 |

> 💡 Tip: Turn the **Confirmed?** checkbox into a filter for the “Upcoming Episodes” board so only booked guests appear.

---

## 4️⃣ Show Notes & Assets (Database)  
Each row is a page that contains the full show notes, timestamps, and linked assets.

| Episode # | Show Notes (Page) | Timestamped Topics | Audio Snippets | SEO Keywords |
|-----------|-------------------|--------------------|----------------|--------------|
| 001 | [Show Notes – 001](/show-notes-001) | 00:00 Intro, 02:15 AI Ethics, 15:40 Q&A | `ethics_clip.mp3` | AI, ethics, future |
| 002 | [Show Notes – 002](/show-notes-002) | 00:00 Intro, 03:00 Remote tools, 12:45 Burnout tips | `tools_clip.mp3` | remote work, productivity |
| 003 | [Show Notes – 003](/show-notes-003) | 00:00 Intro, 04:20 Mindful apps, 18:00 Closing | `mindful_clip.mp3` | mindfulness, tech health |

> 💡 Tip: Use Notion’s **Toggle List** inside each Show Notes page for collapsible sections (e.g., “Sponsor Message”, “Resources”).

---

## 5️⃣ Marketing & Distribution Checklist (Template Page)  
Duplicate this page for each episode to ensure consistent promotion.

- **Social Posts**  
  - [ ] Create Instagram carousel (design file attached)  
  - [ ] Schedule tweet thread (include episode link)  
  - [ ] Draft LinkedIn article summary  

- **Email Newsletter**  
  - [ ] Write teaser (150‑200 words)  
  - [ ] Insert “Listen Now” button linking to Publish Link  

- **Ads & Partnerships**  
  - [ ] Confirm sponsor ad slot (timecode)  
  - [ ] Send tracking URL to partner  

> 💡 Tip: Link the **Publish Link** from the Episode Pipeline directly into this checklist using a Relation property for one‑click access.

---

## 6️⃣ Analytics Dashboard (Linked Database View)  
Create a linked view of the **Episode Pipeline** with the following columns:

| Episode # | Release Date | Downloads (last 7d) | Avg. Listening Time | Rating (⭐) |
|-----------|--------------|---------------------|---------------------|------------|
| 001 | 2024‑07‑15 | 12,340 | 32:10 | 4.8 |
| 002 | 2024‑07‑22 | — | — | — |
| 003 | 2024‑07‑29 | — | — | — |

> 💡 Tip: Connect this view to an external analytics tool (e.g., Chartable) via CSV export and re‑import weekly for up‑to‑date numbers.

---

## 7️⃣ SOP & Resources (Page)  
A static page containing standard operating procedures, templates, and tool links.

- **Recording Setup** – checklist for mic, interface, backup recorder.  
- **Editing Workflow** – recommended plugins (Audacity, Descript) and export settings.  
- **Hosting Provider** – login credentials for Libsyn / Anchor.  
- **Brand Assets** – logos, intro/outro audio files (download links).  

> 💡 Tip: Protect this page with Notion’s **Lock** feature so only team leads can edit SOPs.

---

## How to import into Notion
1. **Create a new page** in your workspace and select **“Import” → “Markdown”**.  
2. Upload this `.md` file. Notion will create headings, text, and plain tables.  
3. For each table marked as a **Database** (Episode Pipeline, Guest Management, Show Notes & Assets, Analytics Dashboard), click the table, choose **“Turn into → Database”**, then select the appropriate view type (Table, Board, Calendar).  
4. Add the **property types** as described in each section (Select, Date, Files, Relations, etc.).  
5. Re‑create the **linked database views** (Analytics Dashboard) by duplicating the Episode Pipeline and applying filters/groupings.  
6. Duplicate the **Marketing & Distribution Checklist** page for each episode and link it via the Relation property on the Episode Pipeline.  
7. (Optional) Set up **automations** with Notion’s native reminders or third‑party tools (Zapier, Make) to move episodes between stages automatically on due dates.  

Your Podcast Production Hub is now ready—start adding episodes, guests, and watch your workflow streamline!