# YouTube Channel Manager – Premium Edition  

> **⚡️ Goal:** End‑to‑end, multi‑channel YouTube operations in Notion with live analytics sync, auto‑calculated KPIs, visual dashboards, role‑based governance, full‑featured asset library, onboarding wizard, and A/B testing hub.  

---  

## 1️⃣ Dashboard Overview  

A single‑page hub that pulls live data (via Zapier/Make → YouTube API) and displays calculated KPIs, charts, and alerts.  

| Metric | Current Value (auto‑calc) | Target | Update Frequency |
|--------|---------------------------|--------|------------------|
| Weekly Uploads | `prop("Weekly Uploads")` (Formula) | 4 | Weekly |
| Avg. View Duration | `prop("Avg View Duration")` (Formula) | 5 min | Daily |
| Subscriber Growth % | `prop("% Subscriber Growth")` (Formula) | +15 % | Weekly |
| Revenue per View | `prop("Revenue per View")` (Formula) | $0.015 | Monthly |
| CTR (overall) | `prop("Overall CTR")` (Formula) | 7 % | Daily |
| Total Views (30 d) | `prop("Total Views (30d)")` (Rollup) | — | Daily |

### KPI Cards (Gallery View)  
- **Weekly Uploads** – Number of videos published this week.  
- **Growth Trend** – Line chart (Google Sheets embed) showing subscriber count over the last 12 weeks.  
- **Revenue Trend** – Bar chart (Google Sheets embed) of weekly revenue.  

> **📊 Chart embeds** – Add a synced block and paste the Google Sheets “Publish to web” chart URL (e.g., `https://docs.google.com/spreadsheets/d/…/pubchart?output=embed`).  

---  

## 2️⃣ Channels  

> **One record per YouTube channel** (supports multi‑channel networks).  

| Channel Name | Channel ID | Owner | Subscribers | Subscribers (Prev Week) | % Growth | Primary Language | Status |
|--------------|------------|-------|-------------|--------------------------|---------|------------------|--------|
| Tech Insights | UC‑abc123 | Alex | 124 500 | 122 300 | `format(round(((prop("Subscribers") - prop("Subscribers (Prev Week)")) / prop("Subscribers (Prev Week)")) * 100, 2)) + "%" ` | English | Active |
| Creative Vibes | UC‑def456 | Maya | 78 200 | 77 900 | `format(round(((prop("Subscribers") - prop("Subscribers (Prev Week)")) / prop("Subscribers (Prev Week)")) * 100, 2)) + "%" ` | English | Active |

> **🔗 Relation:** All video‑level databases (Content Calendar, Analytics Tracker, A/B Tests) link to a **Channel** record.  

---  

## 3️⃣ Content Calendar  

| Title | Channel (Relation) | Status | Publish Date | Video Type | Primary Keyword | Assigned To | Thumbnail (Files) | YouTube Video ID | **% CTR vs. Avg** (Formula) |
|-------|-------------------|--------|--------------|------------|-----------------|------------|-------------------|------------------|-----------------------------|
| How to Edit Fast in Premiere | Tech Insights | Draft | 2024‑07‑10 | Tutorial | video editing tips | Alex | ![thumb1](https://via.placeholder.com/40) | `UCabc123_001` | `format(round(prop("CTR (%)") / prop("Overall CTR") * 100, 1)) + "%"` |
| Top 10 Free Music Sources | Creative Vibes | Scheduled | 2024‑07‑15 | Listicle | royalty‑free music | Maya | ![thumb2](https://via.placeholder.com/40) | `UCdef456_045` | … |
| Live Q&A: Channel Growth | Tech Insights | Idea | 2024‑07‑20 | Live | YouTube growth | Sam | — | — | — |
| … | … | … | … | … | … | … | … | … | … |

**Views**  
- **Kanban** – Status columns (Idea → Draft → In Production → Scheduled → Published).  
- **Calendar** – Publish Date.  
- **Table (All)** – Full list with filters per channel.  

---  

## 4️⃣ Production Pipeline  

| Video (Relation) | Script Status | Recording | Editing | Thumbnail | Review | Publish |
|------------------|---------------|-----------|--------|-----------|--------|---------|
| How to Edit Fast in Premiere | ✅ Completed | 🎬 2024‑07‑08 | ✂️ In Progress | 🎨 Pending | 🔍 Pending | 📅 2024‑07‑10 |
| Top 10 Free Music Sources | ✅ Completed | 🎬 2024‑07‑09 | ✂️ Completed | 🎨 Done | 🔍 Approved | 📅 2024‑07‑15 |
| … | … | … | … | … | … | … |

> **🔗 Relation:** Links back to the **Content Calendar** entry for each video.  

---  

## 5️⃣ Asset Library  

| Asset Type | Name | File (Files & Media) | Thumbnail Preview (Files) | External Link | Tags | Last Used |
|------------|------|----------------------|---------------------------|---------------|------|-----------|
| Intro Clip | Channel Intro 2024 | (upload) | ![preview](https://via.placeholder.com/80) | — | intro, branding | 2024‑06‑30 |
| Music Track | Upbeat Loop | (upload) | — | — | royalty‑free, upbeat | 2024‑07‑03 |
| Thumbnail Template | Bold Text Overlay | — | ![preview](https://via.placeholder.com/80) | https://drive.google.com/file/d/def | thumbnail, template | 2024‑07‑01 |
| Lower Third | Subscriber Count | — | — | https://drive.google.com/file/d/ghi | lower‑third, stats | 2024‑07‑05 |
| Script Outline | Tutorial Structure | — | — | https://drive.google.com/file/d/jkl | script, tutorial | 2024‑06‑28 |

> **✅ Upload** – Drag‑and‑drop files directly into the **File** column; Notion automatically shows a preview thumbnail.  

---  

## 6️⃣ Analytics Tracker  

| Video (Relation) | Channel (Rollup) | Publish Date | Views (30d) | Avg. View Duration | CTR (%) | Revenue (USD) | **Revenue per View** (Formula) | **% Subscriber Growth** (Rollup) |
|------------------|------------------|--------------|------------|--------------------|---------|---------------|--------------------------------|-----------------------------------|
| How to Edit Fast in Premiere | Tech Insights | 2024‑07‑10 | 12,450 | 5 min 02 s | 6.8 | $210 | `format(round(prop("Revenue (USD)") / prop("Views (30d)"), 3), "$0.000")` | `prop("Channel") → % Growth` |
| Top 10 Free Music Sources | Creative Vibes | 2024‑07‑15 | 9,820 | 4 min 35 s | 5.9 | $158 | … | … |
| … | … | … | … | … | … | … | … | … |

**Live Sync** – Set up a **Zapier** “New Video” trigger → **YouTube → Get Video Statistics** → **Update row** in this database (matching on YouTube Video ID).  

**Views**  
- **Trend (Line Chart)** – Embed Google Sheets chart of Views over time.  
- **Low‑CTR Alerts** – Filter: `prop("CTR (%)") < 6` (saved view).  

---  

## 7️⃣ A/B Testing Hub  

| Test ID | Video (Relation) | Channel (Rollup) | Test Type | Variant A | Variant B | Start Date | End Date | Metric (Select) | A Value | B Value | **Winner** (Formula) |
|---------|------------------|------------------|-----------|-----------|-----------|------------|----------|------------------|---------|---------|-----------------------|
| AB‑001 | How to Edit Fast in Premiere | Tech Insights | Thumbnail | ![A](https://via.placeholder.com/40) | ![B](https://via.placeholder.com/40) | 2024‑07‑01 | 2024‑07‑07 | CTR (%) | 7.2 | 6.8 | `if(prop("A Value") > prop("B Value"), "A", "B")` |
| AB‑002 | Top 10 Free Music Sources | Creative Vibes | Title | “Free Music Sources” | “Best Free Music” | 2024‑07‑05 | 2024‑07‑12 | Avg. View Duration | 4 min 30 s | 4 min 45 s | … |
| … | … | … | … | … | … | … | … | … | … | … | … |

> **Workflow:** After the test period, the **Winner** formula auto‑selects the best variant; copy the winning asset into the **Production Pipeline**.  

---  

## 8️⃣ SOPs & Resources  

| SOP / Resource | Type | Link (Embed) | Related Property |
|----------------|------|--------------|------------------|
| Script Writing SOP | Document | `https://www.notion.so/.../Script‑Writing‑SOP` | Script Status |
| Recording Checklist | Checklist | `https://www.notion.so/.../Recording‑Checklist` | Recording |
| Editing Workflow | Document | `https://www.notion.so/.../Editing‑Workflow` | Editing |
| Thumbnail Design Guide | Document | `https://www.notion.so/.../Thumbnail‑Guide` | Thumbnail |
| YouTube SEO Cheat Sheet | Document | `https://www.notion.so/.../YouTube‑SEO‑Cheat‑Sheet` | Primary Keyword |
| A/B Testing Playbook | Document | `https://www.notion.so/.../AB‑Testing‑Playbook` | Test Type |

> **🔗 Direct Links** – Each SOP is linked to the corresponding property via a **Relation** field (e.g., “Script SOP” → Script Status).  

---  

## 9️⃣ Settings & Integrations  

| Integration | Purpose | Setup Link | Notes |
|-------------|---------|------------|-------|
| Zapier → YouTube (Video Creation) | Auto‑create a **Content Calendar** entry when a video is uploaded | https://zapier.com/apps/youtube/integrations/notion | Map “Video ID”, “Title”, “Publish Date”. |
| Zapier → YouTube (Metrics) | Pull **Views, CTR, Revenue** nightly into **Analytics Tracker** | https://zapier.com/apps/youtube/integrations/notion | Requires YouTube Data API v3 OAuth token. |
| Make (Integromat) → Google Sheets (Charts) | Sync KPI rollups to a Google Sheet for chart publishing | https://www.make.com/en/integrations/google-sheets/notion | Use “Update Row” to keep charts live. |
| Slack → Notion (Status Updates) | Post Kanban status changes to #video‑production | https://slack.com | Use Zapier “New Database Item” → Slack message. |
| Notion API → Airtable (Backup) | Daily JSON backup of all tables | https://www.notion.so | Schedule via a serverless function (e.g., AWS Lambda). |
| Google Drive (Asset Storage) | Store raw footage & large media; embed previews in **Asset Library** | https://drive.google.com | Use the **File** column for direct uploads; keep a secondary “External Link” for large files. |

> **⚙️ Quick‑Start:** After importing the template, click **Settings & Integrations → Zapier → Connect** to launch the YouTube sync wizard.  

---  

## 🔟 Onboarding & Checklist  

> **One‑time setup guide for new team members**  

1. **Watch the walkthrough video** – (embed)  
   ```markdown
   <iframe width="560" height="315" src="https://www.youtube.com/embed/your-onboarding-video-id" frameborder="0" allowfullscreen></iframe>
   ```  
2. **Complete the “Team Setup” checklist** (see below).  
3. **Connect your YouTube channel(s)** – Follow the Zapier link in **Settings & Integrations**.  
4. **Import existing assets** into the **Asset Library** (drag‑and‑drop).  
5. **Run the “Initial Data Sync”** – Trigger the Zapier “Back‑fill Metrics” to populate the **Analytics Tracker**.  
6. **Assign roles** (see **Team Roles & Audit Trail**).  

### Team Setup Checklist (Database)  

| Step | Description | Done (Checkbox) |
|------|-------------|-----------------|
| Add your Google account to the workspace | Required for YouTube API auth | ☐ |
| Create a Channel record for each YouTube channel you manage | Include Channel ID | ☐ |
| Link existing videos to the correct Channel | Use the Relation field | ☐ |
| Set up Zapier connections (Video Creation & Metrics) | Follow the URLs in Settings | ☐ |
| Define role permissions (see next section) | Viewer / Editor / Reviewer | ☐ |
| Verify Asset Library uploads & thumbnails | Ensure preview appears | ☐ |
| Run a test A/B experiment | Create a record in **A/B Testing Hub** | ☐ |

---  

## 📊 Team Roles & Audit Trail  

| Role | Permissions (Notion) | Users | Notes |
|------|----------------------|-------|-------|
| Owner | Full edit + sharing | Alex | Can change permissions. |
| Editor | Edit all databases, but **cannot** change page sharing | Maya, Sam | Standard production team. |
| Reviewer | Comment‑only + view audit log | External Consultant | Used for quarterly reviews. |
| Viewer | View‑only (no comments) | Stakeholders | Dashboard only. |

> **How to enforce:** On the top‑level **YouTube Channel Manager** page → **Share** → Add each user with the appropriate role.  

### Audit Log (Database)  

| Timestamp | User | Action | Affected Record | Details |
|-----------|------|--------|-----------------|---------|
| 2024‑07‑01 09:12 | Maya | Updated | Content Calendar – “Top 10 Free Music Sources” | Changed Status to *Scheduled* |
| 2024‑07‑02 14:05 | Alex | Created | A/B Test – AB‑001 | New thumbnail test started |
| … | … | … | … | … |

> **Automation:** Zapier “New Database Change” → Append row to **Audit Log** (captures `User`, `Action`, `Record ID`).  

---  

## 📥 How to import into Notion  

1. **Create a new page** in your workspace (e.g., “YouTube Channel Manager”).  
2. Click **Import → Markdown & CSV**, select this `.md` file.  
3. Notion will render each table as a **Table view**.  
4. For every table you want to treat as a database:  
   - Click the three‑dot menu → **Turn into database**.  
   - Rename the database (e.g., “Content Calendar”).  
   - Adjust property types:  
     - “Publish Date”, “Start Date”, “End Date” → **Date**.  
     - “Thumbnail”, “File”, “Thumbnail Preview” → **Files & media**.  
     - “YouTube Video ID” → **Text**.  
     - “Channel” → **Relation** → link to **Channels** database.  
5. Re‑create the views (Kanban, Calendar, Gallery, Chart embeds) using **+ Add a view**.  
6. Copy the SOP links, integration URLs, and onboarding video embed into the corresponding property fields.  
7. **Set up automations:**  
   - Open **Settings & Integrations** → click each Zapier/Make link → follow the wizard to connect your YouTube account and Google Sheets.  
   - Enable the **Audit Log** Zap to start recording changes.  

Your **YouTube Channel Manager – Premium Edition** is now fully functional: live analytics, auto‑calculated KPIs, visual dashboards, multi‑channel support, secure role‑based access, rich asset library, onboarding wizard, and data‑driven A/B testing. 🎬🚀