# TikTok Creator Hub

## Dashboard / How to use  
A single-page command center for TikTok creators to plan videos, manage brand deals, track payments, and monitor performance—all in one Notion workspace. Ideal for solo creators and small teams who need a clear, data-driven workflow without juggling spreadsheets.  

**Quick start**  
- Duplicate the template (Share → Duplicate).  
- Open **Content Calendar** and add your next 3 video ideas.  
- In **Brand Deal Pipeline**, enter any active negotiations.  
- Link each deal to its payment in **Payment Tracker**.  
- Watch the **Performance Dashboard** update automatically.

## Content Calendar  
Plan, schedule, and archive every TikTok post. Use the Status select to move items through the creation pipeline.

| Content Title | Publish Date | Status      | Platform | Asset Link                     | Notes                     | Estimated CPM | Total Earnings | ROI (%) |
|---------------|--------------|-------------|----------|--------------------------------|---------------------------|---------------|----------------|---------|
| 30-Day Dance Challenge | 2024-08-10 | Idea        | TikTok   | https://drive.google.com/…    | Research trending songs | =IF([Estimated Views]>0, ([Total Earnings]/[Estimated Views])*1000, 0) | =IF([Estimated Views]>0, [Estimated Views]*[Estimated CPM], 0) | =IF([Total Earnings]>0, ([Total Earnings]-[Cost])/[Cost]*100, 0) |
| Behind-the-Scenes Studio Tour | 2024-08-12 | Draft       | TikTok   | https://drive.google.com/…    | Need B-roll clips        | =IF([Estimated Views]>0, ([Total Earnings]/[Estimated Views])*1000, 0) | =IF([Estimated Views]>0, [Estimated Views]*[Estimated CPM], 0) | =IF([Total Earnings]>0, ([Total Earnings]-[Cost])/[Cost]*100, 0) |
| Q&A: Creator Tools | 2024-08-15 | Scheduled   | TikTok   | https://drive.google.com/…    | Add caption prompts      | =IF([Estimated Views]>0, ([Total Earnings]/[Estimated Views])*1000, 0) | =IF([Estimated Views]>0, [Estimated Views]*[Estimated CPM], 0) | =IF([Total Earnings]>0, ([Total Earnings]-[Cost])/[Cost]*100, 0) |
| Holiday Giveaway Reel | 2024-12-01 | Idea        | TikTok   | https://drive.google.com/…    | Partner: BrandX          | =IF([Estimated Views]>0, ([Total Earnings]/[Estimated Views])*1000, 0) | =IF([Estimated Views]>0, [Estimated Views]*[Estimated CPM], 0) | =IF([Total Earnings]>0, ([Total Earnings]-[Cost])/[Cost]*100, 0) |

*Title column: **Content Title** (Text)*  
*Publish Date → Date*  
*Status → Select (Idea, Draft, Scheduled, Published, Archived)*  
*Platform → Select (TikTok, Reels, Shorts)*  
*Asset Link → URL*  
*Estimated CPM → Formula*  
*Total Earnings → Formula*  
*ROI → Formula*  

> 💡 **Tip:** Turn the **Status** column into a Kanban board (`/board view`) to visualize your workflow at a glance.

## Brand Deal Pipeline  
Track every brand partnership from first outreach to contract signing. The **Stage** select drives the next actions and the **Value** field feeds the payment tracker.

| Deal Name | Brand | Campaign Type | Value ($) | Stage          | Expected Close | Contract (File) | Notes                     |
|-----------|-------|---------------|-----------|----------------|----------------|------------------|---------------------------|
| Summer Swimwear Launch | AquaWear | Sponsored Video | 2,500 | Negotiation | 2024-08-20 | (upload) | Need product samples |
| Gaming Chair Review | GameSeat | Affiliate + Review | 1,800 | Prospect | 2024-09-05 | — | First contact sent |
| Holiday Gift Guide | BrandX | Integrated Campaign | 3,200 | Contract Sent | 2024-11-15 | (upload) | Legal review pending |
| Fitness App Promo | FitFlow | Sponsored Series | 4,000 | Won | 2024-07-30 | (upload) | Launch 08/01 |

*Title column: **Deal Name** (Text)*  
*Brand → Text*  
*Campaign Type → Select (Sponsored Video, Affiliate, Integrated, Series)*  
*Value → Number (currency)*  
*Stage → Select (Prospect, Negotiation, Contract Sent, Won, Lost)*  
*Expected Close → Date*  
*Contract → Files & media*  

> ✅ **Best practice:** Add a **Rollup** in the **Payment Tracker** that sums the **Value** of all deals with Stage = Won. This gives you a real-time forecast of expected revenue.

## Payment Tracker  
Record every invoice, due date, and payment status. Link each payment back to its deal for automatic revenue roll-ups.

| Payment | Deal (Relation) | Amount ($) | Due Date   | Paid | Payment Method | Invoice (File) | Notes                |
|---------|-----------------|------------|------------|------|----------------|----------------|----------------------|
| INV-001 | Summer Swimwear Launch | 2,500 | 2024-08-25 | ☐   | Bank Transfer | (upload) | Awaiting receipt |
| INV-002 | Gaming Chair Review | 1,800 | 2024-09-10 | ☐   | PayPal        | (upload) | 50% upfront       |
| INV-003 | Holiday Gift Guide | 3,200 | 2024-11-20 | ☐   | ACH           | (upload) | Split into 2 payments |
| INV-004 | Fitness App Promo | 4,000 | 2024-08-05 | ☑   | Stripe        | (upload) | Paid in full       |

*Title column: **Payment** (Text)*  
*Deal → Relation to **Brand Deal Pipeline** (Deal Name)*  
*Amount → Number (currency)*  
*Due Date → Date*  
*Paid → Checkbox*  
*Payment Method → Select (Bank Transfer, PayPal, ACH, Stripe, Other)*  
*Invoice → Files & media*  

> 💡 **Tip:** Create a filtered view called **“Upcoming Payments”** (Due Date within next 7 days & Paid = unchecked) to stay on top of cash flow.

## Performance Dashboard  
A read-only overview that pulls data from the three databases. Use linked databases and roll-ups to see:

- **Total Published Videos** (Count of Content Calendar where Status = Published)  
- **Monthly Reach** (Roll-up of a numeric “Views” property you add to each video)  
- **Revenue Forecast** (Sum of Payment Tracker Amount where Paid = unchecked)  
- **Deal Conversion Rate** (Formula: Won Deals ÷ Total Prospects)  

Set up the dashboard as a page with the following blocks (no markdown table needed, just describe):

1. **Summary Callout** – “🟢 This month’s earnings: $X, 🎥 Videos published: Y”.  
2. **Bar Chart** – Linked view of Content Calendar grouped by **Publish Date (Month)** showing count of Published videos.  
3. **Table** – Linked view of Brand Deal Pipeline filtered to **Stage = Won** with columns Deal Name, Brand, Value, Expected Close.  
4. **Table** – Linked view of Payment Tracker filtered to **Paid = unchecked** showing Amount, Due Date, Deal.  
5. **Real-Time Metrics** – Embed Google Analytics to display current video performance metrics (views, likes, shares).  

> ✅ **Best practice:** Turn the dashboard into a **Full-width** page and lock the blocks so accidental edits don’t break the layout.

## Resources & SOPs  
A collection of standard operating procedures, templates, and quick-reference guides to keep your workflow smooth.

| Resource | Type | Link |
|----------|------|------|
| Video Production Checklist | Template | https://www.notion.so/... |
| Brand Pitch Email Script | Document | https://www.notion.so/... |
| Invoice Template (Google Sheets) | File | https://drive.google.com/... |
| Analytics Tracking Sheet | Template | https://www.notion.so/... |

> 💡 **Tip:** Duplicate each SOP into your own workspace and customize the placeholders (e.g., brand name, campaign dates) before using.

## How to set up in Notion  
1. **Import** this markdown file into a new Notion page (`Import → Markdown`).  
2. For each table, click the three-dot menu → **Turn into → Database → Table – Full page**.  
3. **Set property types** exactly as noted under each table (Title, Select, Date, Number, Checkbox, Relation, Files & media).  
4. In **Payment Tracker**, add a **Relation** to **Brand Deal Pipeline** (link on **Deal Name**) and enable a **Rollup** that pulls the **Value** field for revenue calculations.  
5. In **Content Calendar**, create a **Relation** to **Brand Deal Pipeline** (optional) if a video is part of a brand campaign, then add a **Rollup** for the deal’s **Value**.  
6. Build the **Performance Dashboard** page: add linked databases, set filters, groupings, and create the roll-up formulas as described.  
7. (Optional) Set up automation via Notion API + Zapier to send Slack/email reminders when a brand-deal stage changes or a payment is due.  
8. (Optional) Go to **Share → Publish → Allow duplicate as template** to make the workspace shareable with other creators.  

You’re now ready to schedule TikToks, close brand deals, get paid, and watch your metrics grow—all from one polished Notion hub. Enjoy creating!