# TikTok Creator Brand Deal Manager

## 1️⃣ Overview & Quick Start  
A single‑pane‑of‑glass workspace that walks you from brand outreach to paid invoice, while surfacing the metrics that matter to sponsors and your own growth goals.  

> 💡 Tip: Bookmark the **Dashboard** page (last section) as your browser’s start page – it refreshes automatically with the latest KPI numbers.

### Core Workflow  
1. **Add a new brand** in the *Brand Deal Pipeline* table.  
2. **Upload the contract** in *Contracts & Invoicing* and generate an invoice.  
3. **Plan the content** in the *Content Calendar* and assign owners.  
4. **Publish** and let the *Analytics Dashboard* pull performance data (via CSV import or Zapier).  
5. **Mark the deal as “Paid”** – the system will calculate ROI and update your KPI board.

---

## 2️⃣ Brand Deal Pipeline  
Track every outreach, negotiation, and deal status in one relational database.

| Brand | Campaign | Status | Deal Value (USD) | Expected Publish Date | Contact Person | Next Action | Priority |
|-------|----------|--------|------------------|-----------------------|----------------|-------------|----------|
| GlowSkin Co. | “Summer Glow” | Negotiation | 3,200 | 2024‑07-15 | Maya L. (Marketing Lead) | Send revised deliverables brief | High |
| FitFlex Apparel | “30‑Day Challenge” | Contract Sent | 5,500 | 2024‑08‑01 | Carlos R. (Partnerships) | Follow‑up call (3 days) | Medium |
| SnackBurst | “Snack Hack” | Closed‑Won | 2,000 | 2024‑06‑20 | Priya S. (Brand Manager) | Schedule shoot | Low |

> 💡 Tip: Use the **Priority** tag to filter high‑value deals on your dashboard and focus your outreach effort.

---

## 3️⃣ Contracts & Invoicing  
Store signed agreements, generate invoices, and track payment status.

| Deal ID | Contract Signed | Contract Link | Invoice # | Invoice Amount (USD) | Due Date | Payment Received | Notes |
|---------|-----------------|---------------|-----------|----------------------|----------|------------------|-------|
| GLW‑2024‑07 | ✅ | [GlowSkin_Contract.pdf](#) | INV‑00123 | 3,200 | 2024‑07‑20 | ❌ | Awaiting final creative brief |
| FFX‑2024‑08 | ✅ | [FitFlex_Contract.pdf](#) | INV‑00124 | 5,500 | 2024‑08‑05 | ❌ | 50 % upfront required |
| SNB‑2024‑06 | ✅ | [SnackBurst_Contract.pdf](#) | INV‑00125 | 2,000 | 2024‑06‑25 | ✅ | Paid via PayPal |

> 💡 Tip: Link the **Deal ID** back to the Brand Deal Pipeline row – Notion’s relation property will let you view contract status directly from the pipeline view.

---

## 4️⃣ Content Calendar & Scheduling  
Plan, produce, and publish sponsored TikTok videos with built‑in status tracking.

| Date | Platform | Campaign | Content Idea | Asset Status | Publish Time | Tag | Owner |
|------|----------|----------|--------------|--------------|--------------|-----|-------|
| 2024‑07‑15 | TikTok | Summer Glow | “3‑step skincare routine” | 🎬 Filmed, 🎞️ Editing | 18:00 | #GlowSkin | Alex |
| 2024‑08‑01 | TikTok | 30‑Day Challenge | “Day 5 workout + product plug” | 📋 Script approved | 12:00 | #FitFlex | Maya |
| 2024‑06‑20 | TikTok | Snack Hack | “Quick snack hack with product” | ✅ Ready to post | 09:00 | #SnackBurst | Priya |

> 💡 Tip: Enable Notion’s **Reminder** on the *Publish Time* column to get a push notification 30 minutes before go‑live.

---

## 5️⃣ Analytics & KPI Dashboard  
A live‑updating table that aggregates performance metrics and calculates ROI per campaign.

| Date Range | Campaign | Views | Likes | Comments | Shares | Engagement Rate (%) | Revenue (USD) | ROI (%) |
|------------|----------|-------|-------|----------|--------|----------------------|----------------|----------|
| 2024‑06‑20 – 2024‑06‑27 | Snack Hack | 120,000 | 8,400 | 620 | 1,200 | 8.5 | 2,000 | 100 |
| 2024‑07‑15 – 2024‑07‑22 | Summer Glow | 250,000 | 22,000 | 1,500 | 3,400 | 10.2 | 3,200 | 128 |
| 2024‑08‑01 – 2024‑08‑08 | 30‑Day Challenge | 340,000 | 30,500 | 2,200 | 5,100 | 11.8 | 5,500 | 150 |

> 💡 Tip: Export TikTok analytics CSV weekly, then use Notion’s **CSV import** to refresh this table. The ROI column uses the formula `(Revenue ÷ Deal Value) × 100`.

---

## 6️⃣ Resources & SOPs  
Central hub for brand outreach templates, contract checklists, and performance reporting guides.

- **Outreach Email Template** – copy‑paste into Gmail or your CRM.  
- **Creative Brief Checklist** – ensures every sponsor receives the required assets.  
- **Invoice Template (Google Sheet)** – pre‑filled with tax info, auto‑calculates totals.  
- **Monthly Report Blueprint** – a Notion page you duplicate each month; includes charts linked to the Analytics table.

> 💡 Tip: Duplicate the **Monthly Report Blueprint** at the start of each month and rename it “Report – MMM YYYY” for easy archiving.

---

## 7️⃣ How to import into Notion  
1. **Create a new page** in your Notion workspace where you want the template.  
2. Click the three‑dot menu → **“Import”** → select **“Markdown & CSV”**.  
3. Upload this `.md` file. Notion will create headings, text, and **tables as plain tables**.  
4. For each table (Brand Deal Pipeline, Contracts & Invoicing, Content Calendar, Analytics Dashboard):  
   a. Click the table → **“Turn into database”** → choose **Table – Full page** (or **Table – Inline** if you prefer).  
   b. Adjust property types:  
      - Status → **Select** (options: Prospect, Negotiation, Contract Sent, Closed‑Won, Closed‑Lost)  
      - Deal Value, Invoice Amount, Revenue → **Number (USD)**  
      - Dates → **Date** (enable time for Publish Time)  
      - Contract Link, Asset Status → **URL** or **Files & media** as needed  
      - Engagement Rate, ROI → **Formula** (e.g., `prop("Revenue") / prop("Deal Value") * 100`)  
5. Set up **relations**:  
   - In *Contracts & Invoicing*, add a **Relation** to *Brand Deal Pipeline* linking `Deal ID`.  
   - In *Analytics Dashboard*, add a **Relation** to *Brand Deal Pipeline* to pull `Deal Value`.  
6. Create **views** for each database:  
   - *Board view* by **Status** for the pipeline.  
   - *Calendar view* for the Content Calendar.  
   - *Grouped view* by **Campaign** for the Analytics table.  
7. (Optional) Connect to external tools via **Zapier** or **Make** to auto‑populate the Analytics table from TikTok CSV exports.  

Your TikTok Creator Brand Deal Manager is now live—start adding deals, schedule content, and watch your ROI climb!