# Podcast Studio Pro  

## 🎙️ Dashboard / How to Use  

**Cover Image:** `https://images.unsplash.com/photo-1526401485004-2c9e0f2d8e0c`  
**Icon:** `🎧`  

> **Toggle View:**  
> <details><summary>Quick‑Start (click to expand)</summary>  
> 1️⃣ **Import** this template → *Duplicate* → *Add to your workspace*  
> 2️⃣ **Link** the relational databases (Episodes ↔ Guests ↔ Sponsors ↔ Show Notes) – see “Database Setup” below.  
> 3️⃣ **Connect** the automations (Zapier/Make) – see “Automation Setup”.  
> 4️⃣ **Customize** the KPI widgets on the Dashboard (Episodes / Revenue charts).  
> 5️⃣ **Watch** the onboarding videos (links at the bottom).  
> </details>  

### 📊 KPI Widgets (auto‑generated)

| KPI | Formula | Visual |
|-----|---------|--------|
| **Episodes / Month** | `rollup(Episodes, “Release Date”, “dateMonth”) → count` | Bar chart (12 months) |
| **Revenue Trend** | `rollup(Revenue, “Date”, “dateMonth”) → sum(Amount)` | Line chart |
| **Average Duration** | `average(Episodes.Duration)` | Gauge |
| **Sponsor Pipeline Value** | `rollup(Sponsors, “Forecast”, “sum”)` | Donut chart |

> **Tip:** Click any widget to open the underlying roll‑up view for deeper analysis.  

---

## 📁 Database Setup  

### 1️⃣ Episodes Database  

| Property | Type | Relation |
|----------|------|----------|
| **Title** | Title | — |
| **Status** | Select (Planned, In Progress, Editing, Scheduled, Published) | — |
| **Release Date** | Date | — |
| **Guests** | Relation → **Guests** (many) | — |
| **Sponsor** | Relation → **Sponsors** (single) | — |
| **Show Notes** | Relation → **Show Notes** (one) | — |
| **Duration** | Number (minutes) | — |
| **Episode Link** | URL | — |
| **KPI Month** | Formula: `formatDate(prop("Release Date"), "YYYY‑MM")` | — |
| **Revenue Generated** | Rollup (Sponsor → “Forecast”) → sum | — |

### 2️⃣ Guests Database  

| Property | Type | Relation |
|----------|------|----------|
| **Name** | Title | — |
| **Email** | Email | — |
| **Contract Status** | Select (Signed, Pending, Expired) | — |
| **Episodes Featured** | Relation → **Episodes** (many) | — |
| **Notes** | Text | — |
| **Social Links** | URL | — |
| **Contract Reminder** | Formula: `if(prop("Contract Status") == "Pending", dateAdd(now(), 3, "days"), empty)` | — |

### 3️⃣ Sponsors Database (Pipeline)  

| Property | Type | Relation |
|----------|------|----------|
| **Sponsor Name** | Title | — |
| **Stage** | Select (Prospect, Negotiation, Contract, Paid) | — |
| **Deal Value** | Number (USD) | — |
| **Forecast** | Formula: `if(prop("Stage") == "Paid", prop("Deal Value"), 0)` | — |
| **Episodes** | Relation → **Episodes** (many) | — |
| **Notes** | Text | — |
| **Revenue Chart** | Rollup (Episodes → “Revenue Generated”) → sum | Embedded in Dashboard |

### 4️⃣ Show Notes Database  

| Property | Type | Relation |
|----------|------|----------|
| **Episode** | Relation → **Episodes** (single) | — |
| **Key Points** | Text | — |
| **Resources Links** | URL | — |
| **Timestamp** | Text | — |
| **Notes** | Text | — |
| **Episode Month** | Formula: `formatDate(prop("Episode").prop("Release Date"), "YYYY‑MM")` | — |

### 5️⃣ Royalty Splits Database  

| Property | Type |
|----------|------|
| **Contributor** | Title |
| **Role** | Text |
| **Percentage** | Number |
| **Notes** | Text |
| **Payment Due** | Date |
| **Payout Amount** | Formula: `prop("Percentage") / 100 * sum(Revenue.Amount)` |

---

## 🤖 Automation Setup (Notion API ↔ Zapier/Make)  

| Trigger | Action | Description |
|---------|--------|-------------|
| **Episode Status changed** (Notion) | **Create/Update** Google Calendar event | Sync “Scheduled” episodes to a calendar entry titled “Podcast – {Episode Title}”. |
| **Guest Contract Status = Pending** (Notion) | **Send** Gmail email reminder | Email template: “Reminder: Please sign the contract for {Episode Title} by {Contract Reminder}”. |
| **Sponsor Stage → Paid** (Notion) | **Add** row to Google Sheets “Revenue Forecast” | Keeps an external financial model up‑to‑date. |
| **New Episode added** (Notion) | **Post** to Twitter (via Zapier) | Auto‑tweet “New episode dropping on {Release Date}: {Episode Title} – stay tuned!”. |

**How to enable:**  

1. In Notion → *Settings & Members* → *Integrations* → **Create new integration** (name: “Podcast Studio Pro Automation”).  
2. Copy the **Internal Integration Token**.  
3. In Zapier/Make, add a **Notion** trigger, paste the token, and select the appropriate database & property.  
4. Map fields to the actions above and turn the Zap/Scenario **ON**.  

---

## 🎨 Polished UI Template  

- **Toggle Headings** – All major sections (Episodes, Guests, Sponsors, Show Notes, Royalty Splits, Analytics) are wrapped in Notion toggles for a clean, collapsible view.  
- **Light / Dark Variants** – Use the built‑in Notion theme switch. For dark mode, set the page background to a dark‑gray cover (`#212121`) and adjust icon colors to white.  
- **Icons** – Each database page gets a distinct emoji: Episodes `🎙️`, Guests `👤`, Sponsors `💰`, Show Notes `📝`, Royalty Splits `⚖️`.  
- **Cover Images** – Recommended covers are stored in the `Assets` folder (see below).  

### Assets Folder (pre‑populated)

| File | Description |
|------|-------------|
| `cover‑light.jpg` | Light‑mode podcast studio photo |
| `cover‑dark.jpg` | Dark‑mode studio silhouette |
| `icon‑episodes.png` | 128 × 128 px 🎙️ icon |
| `icon‑guests.png` | 128 × 128 px 👤 icon |
| `icon‑sponsors.png` | 128 × 128 px 💰 icon |

---

## 📹 Onboarding Video Series  

| Video | Length | Link |
|-------|--------|------|
| **1️⃣ Import & Duplicate** | 3 min | `https://youtu.be/PodcastStudioImport` |
| **2️⃣ Database Linking** | 4 min | `https://youtu.be/PodcastStudioLinks` |
| **3️⃣ Dashboard Customization** | 5 min | `https://youtu.be/PodcastStudioDashboard` |

> **Watch order:** Start with Video 1, then Video 2, finish with Video 3. All videos include subtitles and a dark‑mode view of the Notion UI.  

---

## 📈 Analytics Dashboard (Enhanced)  

- **Total Episodes** – Rollup count of **Episodes**.  
- **Monthly Episodes** – Bar chart (KPI widget).  
- **Total Revenue** – Rollup sum of **Revenue.Amount**.  
- **Revenue Trend** – Line chart (KPI widget).  
- **Average Episode Duration** – Gauge (KPI widget).  
- **Sponsor Pipeline Value** – Donut chart (sum of **Sponsors.Forecast**).  
- **Guest Engagement Rate** – Formula: `round((length(filter(prop("Guests").filter(prop("Contract Status") == "Signed")) / length(prop("Guests"))) * 100, 0) %`  

All widgets are **live‑linked** to the underlying roll‑ups, so any change in the databases instantly updates the visuals.  

---

## 🛠️ How to Set Up in Notion (Step‑by‑Step)  

1. **Duplicate** this page → *Duplicate* → *Add to workspace*.  
2. **Create** the five databases using the tables above (use `/table → Turn into database`).  
3. **Set property types** exactly as listed in the “Database Setup” section.  
4. **Add relations**:  
   - Episodes ↔ Guests (many‑to‑many)  
   - Episodes ↔ Sponsors (one‑to‑one)  
   - Episodes ↔ Show Notes (one‑to‑one)  
5. **Insert KPI widgets**:  
   - Click **+** → *Create linked database* → select the appropriate roll‑up → choose *Bar/Line/Donut* view.  
6. **Configure automations** (see “Automation Setup”).  
7. **Apply UI polish**:  
   - Upload cover images from the `Assets` folder.  
   - Set page icons.  
   - Enable dark mode if desired (`Settings → Appearance`).  
8. **Publish** (optional): Share → *Publish to web* → enable “Allow duplicate as template”.  

---  

**Enjoy a fully‑automated, analytics‑driven podcast workflow that out‑performs the competition!**