# YouTube Creator Ops Hub

> **🎨 Cover Image:** Abstract Gradient (Deep Purple/Blue)
> **🚀 Icon:** 🎬

---

## 1. 📊 Executive Dashboard
The central command center providing a real-time snapshot of channel health, financial performance, and production velocity.

### Layout: 3-Column Structure
**Column 1: Key Performance Indicators (KPIs)**
*   **Callout Block (Green):** `💰 MTD Revenue: $[Rollup Formula]`
*   **Callout Block (Blue):** `📥 Total Views: [Rollup Formula]`
*   **Callout Block (Orange):** `🔥 Active Deals: [Rollup Formula]`

**Column 2: Production Schedule**
*   **Linked View:** *Content Pipeline* — "Publish Calendar" View (Calendar format).
*   *Filter:* `Status` is `Scheduled` or `Published` (Last 7 days).

**Column 3: Action Center**
*   **Linked View:** *Brand Deal CRM* — "Urgent Follow-ups" View (List format).
*   *Filter:* `Payment Status` is `Pending` OR `Next Follow-up` is `Today`.
*   **Linked View:** *Content Pipeline* — "In Production" View (Kanban format).
*   *Filter:* `Status` is `Scripting`, `Filming`, or `Editing`.

---

## 2. 🎬 Content Studio
The engine of your operation. Tracks every video from ideation to analytics, including asset management and team assignments.

### Database Schema
| Property Name | Type | Configuration/Options |
| :--- | :--- | :--- |
| **Video Title** | Title | *Name of the video* |
| **Status** | Select | `Idea`, `Scripting`, `Filming`, `Editing`, `Review`, `Scheduled`, `Published` |
| **Assignee** | Person | *Team member responsible* |
| **Publish Date** | Date | *Include time* |
| **Video Length** | Number | *Format: Duration (e.g., 12:30)* |
| **Sponsor** | Relation | *Links to "Brand Deal CRM"* |
| **Est. Revenue** | Rollup | *From "Sponsor" -> "Contract Value" (Sum)* |
| **Actual Revenue** | Rollup | *From "Revenue Tracker" -> "Amount" (Sum)* |
| **Views** | Number | *Format: Number* |
| **Retention %** | Number | *Format: Percentage (e.g., 45%)* |
| **Thumbnail** | Files & Media | *Upload final thumbnail here* |
| **Project Link** | URL | *Link to Google Drive/Edit folder* |
| **Progress** | Formula | *Visual Bar (See Formula Below)* |
| **Actions** | Button | *Label: "Mark Published" (See Automation Below)* |

#### Formula: Progress Bar
```javascript
if(prop("Status") == "Idea", "▱▱▱▱▱", 
if(prop("Status") == "Scripting", "▰▱▱▱▱", 
if(prop("Status") == "Filming", "▰▰▱▱▱", 
if(prop("Status") == "Editing", "▰▰▰▱▱", 
if(prop("Status") == "Review", "▰▰▰▰▱", 
if(prop("Status") == "Scheduled", "▰▰▰▰▰", 
if(prop("Status") == "Published", "✅", "")))))))
```

#### Automation: Button Configuration
*   **Button Name:** "Mark Published"
*   **Action 1:** Set `Status` to `Published`.
*   **Action 2:** Set `Publish Date` to `Now`.

### Views
1.  **Master Board:** Kanban Board grouped by `Status`. Drag and drop cards to move videos through the pipeline.
2.  **Release Calendar:** Calendar view grouped by `Publish Date`. Shows scheduled content.
3.  **Production Timeline:** Timeline view. Start Date = `Created time`, End Date = `Publish Date`.
4.  **Analytics Leaderboard:** Table view. Sorted by `Views` (High to Low). Hidden columns: `Project Link`, `Actions`.

---

## 3. 🤝 Brand Command
A dedicated CRM to manage sponsorships, track deliverables, and ensure invoices are paid on time.

### Database Schema
| Property Name | Type | Configuration/Options |
| :--- | :--- | :--- |
| **Brand Name** | Title | *Company Name* |
| **Contact Person** | Person | *Primary point of contact* |
| **Deal Status** | Select | `Outreach`, `Negotiating`, `Contract Sent`, `Signed`, `Live`, `Completed` |
| **Contract Value** | Number | *Format: Currency ($)* |
| **Payment Status** | Select | `N/A`, `Invoice Sent`, `Overdue`, `Paid` |
| **Payment Date** | Date | *Date payment received* |
| **Deliverables** | Relation | *Links to "Content Studio"* |
| **Next Follow-up** | Date | *Reminder to contact brand* |
| **Contract File** | Files & Media | *PDF of signed contract* |
| **Talking Points** | Text | *Key messages, discount codes, links* |

### Views
1.  **Deal Pipeline:** Kanban Board grouped by `Deal Status`.
2.  **Outstanding Invoices:** Table view.
    *   *Filter:* `Payment Status` is `Invoice Sent` OR `Overdue`.
    *   *Sort:* `Next Follow-up` (Ascending).
3.  **Brand Directory:** List view showing all active partners.

---

## 4. 💰 Revenue Engine
A financial ledger connecting content performance and brand deals to visualize income streams and tax estimates.

### Database Schema
| Property Name | Type | Configuration/Options |
| :--- | :--- | :--- |
| **Date** | Date | *Date of transaction* |
| **Source** | Select | `AdSense`, `Sponsorship`, `Affiliate`, `Merch`, `Other` |
| **Amount** | Number | *Format: Currency ($)* |
| **Status** | Select | `Pending`, `Received` |
| **Linked Video** | Relation | *Links to "Content Studio"* |
| **Linked Brand** | Relation | *Links to "Brand Command"* |
| **Tax Deductible** | Checkbox | *Check if expense (for future expansion)* |
| **Net Income** | Formula | *See Formula Below* |

#### Formula: Net Income (Est. 30% Tax)
```javascript
prop("Amount") * 0.7
```

### Views
1.  **Financial Log:** Table view sorted by `Date` (Newest first).
2.  **Pending Income:** List view.
    *   *Filter:* `Status` is `Pending`.
    *   *Properties shown:* `Source`, `Amount`, `Linked Brand`.

---

## 5. 📁 Asset Vault
A centralized repository for reusable creative assets (stock footage, music, graphics) to speed up editing.

### Database Schema
| Property Name | Type | Configuration/Options |
| :--- | :--- | :--- |
| **Asset Name** | Title | *Name of file* |
| **Type** | Select | `Video`, `Audio`, `Image`, `Graphic` |
| **Tags** | Multi-select | `B-Roll`, `Intro`, `Outro`, `Music`, `Sound FX` |
| **Source** | URL | *Link to original source or license* |
| **File** | Files & Media | *The actual asset* |

### Views
1.  **Gallery:** Gallery view grouped by `Type`. Preview images/video directly in the board.
2.  **Tag Cloud:** List view grouped by `Tags`.

---

## ⚙️ Backend Configuration (One-Time Setup)

To ensure the "Duplicate & Go" experience, verify these connections:

1.  **Relations:**
    *   In **Content Studio**, create `Sponsor` property → Select "Relation" → Select "Brand Command".
    *   In **Brand Command**, create `Deliverables` property → Select "Relation" → Select "Content Studio".
    *   In **Revenue Engine**, create `Linked Video` property → Select "Relation" → Select "Content Studio".
    *   In **Revenue Engine**, create `Linked Brand` property → Select "Relation" → Select "Brand Command".

2.  **Rollups:**
    *   In **Content Studio** (`Est. Revenue`): Rollup `Sponsor` → `Contract Value` → Calculate "Sum".
    *   In **Content Studio** (`Actual Revenue`): Rollup `Revenue Engine` (via `Linked Video` relation) → `Amount` → Calculate "Sum".
    *   In **Executive Dashboard** (MTD Revenue): Create a database view of Revenue Engine filtered to this month, or use a Rollup property on a parent page if applicable.

3.  **Dashboard Formulas:**
    *   Create a new page-level database (or use a "Settings" database) to hold global stats if not using page-level rollups. For the simplest setup, drag the "Revenue Engine" database onto the Dashboard, filter it for "Received" status in the current month, and name the view "MTD Revenue".