# TikTok Brand Deal Tracker

## Dashboard / How to use  
A single‑page KPI hub for creators who manage multiple brand deals, link every TikTok video to its contract, and automatically calculate CPM & ROI. Ideal for influencers, talent managers, and agency reps who need real‑time performance data and a fast way to pitch new sponsors.  

**Quick start**  
- 1️⃣ Duplicate this template (Share → “Duplicate as template”).  
- 2️⃣ Import the two seed tables as Notion databases and set the property types.  
- 3️⃣ Link the **TikTok Videos** database to **Brand Deals** via the Relation column.  
- 4️⃣ Connect Zapier (instructions below) to pull TikTok analytics into the video rows.  
- 5️⃣ Open the **KPI Dashboard** sub‑page to see live CPM, ROI, and click “Generate Pitch Email”.

---

## Brand Deals (Database)  
Tracks every contract, budget, and KPI target. The **Deal Name** column is the Title property.  

| Deal Name | Brand | Campaign | Contract Link | Status | Start Date | End Date | Budget ($) | CPM Target ($) | Notes |
|-----------|-------|----------|---------------|--------|------------|----------|------------|----------------|-------|
| Summer Splash 2024 | AquaGlow | #SummerVibes | https://example.com/contract1.pdf | Signed | 2024‑06‑01 | 2024‑08‑31 | 12,000 | 15 | First major summer campaign |
| Fitness Fusion | PowerFit | #FitLife | https://example.com/contract2.pdf | Negotiating | 2024‑07‑15 | 2024‑10‑15 | 8,500 | 12 | Pending final terms |
| Tech Trendsetters | GadgetPro | #TechTalk | https://example.com/contract3.pdf | Prospect | 2024‑09‑01 | 2024‑12‑01 | 15,000 | 18 | Outreach in progress |

> 💡 **Tip:** Set **Status** as a **Select** property with the options: Prospect, Negotiating, Signed, Completed, Cancelled.  

> ✅ **Best practice:** Keep the **Contract Link** URL up‑to‑date; Notion will preview PDFs directly.

---

## TikTok Videos (Database)  
One row per video, automatically linked to its brand deal. The **Video Title** column is the Title property.  

| Video Title | Deal (Relation) | Publish Date | Views | Likes | Comments | CPM ($) | ROI (%) | Video URL | Status |
|-------------|-----------------|--------------|-------|-------|----------|---------|---------|-----------|--------|
| “Sunset Splash Challenge” | Summer Splash 2024 | 2024‑06‑05 | 420,000 | 12,300 | 540 | =prop("Budget")/prop("Views")*1000 | =((prop("Views")*prop("CPM"))-prop("Budget"))/prop("Budget")*100 | https://tiktok.com/@creator/video/12345 | Posted |
| “Morning HIIT Routine” | Fitness Fusion | 2024‑07‑20 | 310,000 | 9,800 | 310 | =prop("Budget")/prop("Views")*1000 | =((prop("Views")*prop("CPM"))-prop("Budget"))/prop("Budget")*100 | https://tiktok.com/@creator/video/67890 | Draft |
| “Unboxing the Latest Gadget” | Tech Trendsetters | 2024‑09‑10 | 250,000 | 7,200 | 210 | =prop("Budget")/prop("Views")*1000 | =((prop("Views")*prop("CPM"))-prop("Budget"))/prop("Budget")*100 | https://tiktok.com/@creator/video/54321 | Draft |

> 💡 **Tip:** The **CPM** and **ROI** columns are **Formula** properties. After Zapier fills in the **Views** column, the formulas recalculate instantly.  

> ✅ **Best practice:** Keep **Status** as a **Select** with Draft, Posted, Archived – this drives the KPI views.

---

## Zapier Automation – Pull TikTok Analytics  
Connect Notion to TikTok via Zapier so every new video row automatically receives its latest view count, likes, and comments.  

1. **Trigger:** “New Database Item” in Notion → select the **TikTok Videos** database.  
2. **Action:** “Find Video” in TikTok (or use a webhook to TikTok’s API) using the **Video URL** field.  
3. **Action:** “Update Database Item” in Notion → map **Views**, **Likes**, **Comments** back to the same row.  
4. Turn on **Polling** every 15 min (free Zapier tier) or use **Webhooks** for real‑time updates.  

> 💡 **Tip:** Store your TikTok API token in Zapier’s **Secrets** and reference it in the webhook header to keep credentials secure.  

> ✅ **Best practice:** Add a **Last Synced** **Date** property to the video database and update it in the Zapier “Update Item” step – this gives you a clear audit trail.

---

## KPI Dashboard (Sub‑page)  
A visual hub that aggregates data from both databases. Create the following views inside the **Brand Deals** database:  

| View Name | Type | Filters | Sort | Group By | Rollup / Formula |
|-----------|------|---------|------|----------|------------------|
| Active Deals | Table | Status = Signed OR Negotiating | Start Date ↑ | — | — |
| Completed Deals | Table | Status = Completed | End Date ↓ | — | — |
| Budget Summary | Table | — | — | — | **Rollup** of **Budget** → Sum |
| CPM & ROI Overview | Table | — | — | — | **Formula** columns already defined in **TikTok Videos**; add a **Relation** to pull average CPM and ROI per deal. |
| Pitch‑Ready Deals | Gallery | Status = Signed | — | — | Show **Deal Name**, **Budget**, **Avg CPM**, **Avg ROI**. |

> 💡 **Tip:** Use a **Linked Database** on this sub‑page to pull the **TikTok Videos** table, then add a **Group** by **Deal** and a **Rollup** of **Views** (Sum) and **CPM** (Average).  

> ✅ **Best practice:** Pin the **KPI Dashboard** page to the sidebar for one‑click access.

---

## Pitch Email Generator (Sub‑page)  
A ready‑to‑send email that pulls live numbers from the selected deal. Create a **Template** page with the following content; use Notion’s **@property** syntax to inject values.  

```
Subject: 📈 Performance Update – {{Deal Name}} Campaign

Hi {{Brand Contact Name}},

I’m excited to share the latest results from our {{Campaign}} collaboration:

- **Total Spend:** ${{Budget}}
- **Total Views:** {{Sum of Views}}
- **Average CPM:** ${{Average CPM}}
- **Overall ROI:** {{Average ROI}}%

The audience response has been fantastic, especially on the video “[{{Top Performing Video Title}}]” which alone generated {{Top Video Views}} views.

Would you like to discuss extending the partnership into Q4? I’ve attached a brief deck with creative ideas.

Looking forward to your thoughts!

Best,
[Your Name]
[Your Contact Info]
```

To use:  
1. Open the **Pitch‑Ready Deals** gallery, click a deal → “Copy link”.  
2. Paste the link into the **Deal** field of a new **Pitch Email** page (create a **Relation** to **Brand Deals**).  
3. The template auto‑fills with the latest rollup numbers.  

> 💡 **Tip:** Add a **Checkbox** “Sent” to track outreach status.

---

## How to set up in Notion  
1. **Duplicate** this template (Share → “Duplicate as template”).  
2. **Convert tables**:  
   - Click the three‑dot menu on the **Brand Deals** table → **Turn into → Database → Table – Full page**.  
   - Set property types:  
     - **Deal Name** – Title  
     - **Brand** – Select (add options from seed data)  
     - **Campaign** – Text  
     - **Contract Link** – URL  
     - **Status** – Select (Prospect, Negotiating, Signed, Completed, Cancelled)  
     - **Start Date / End Date** – Date  
     - **Budget**, **CPM Target** – Number (currency)  
     - **Notes** – Text  
   - Repeat for **TikTok Videos**:  
     - **Video Title** – Title  
     - **Deal** – Relation → link to **Brand Deals** (allow linking to multiple)  
     - **Publish Date** – Date  
     - **Views, Likes, Comments** – Number  
     - **CPM**, **ROI** – Formula (copy formulas from example)  
     - **Video URL** – URL  
     - **Status** – Select (Draft, Posted, Archived)  
3. **Create Relations & Rollups**:  
   - In **Brand Deals**, add a **Relation** → **TikTok Videos** (named “Videos”).  
   - Add a **Rollup** on “Videos → Views” → **Sum** (named “Total Views”).  
   - Add a **Rollup** on “Videos → CPM” → **Average** (named “Avg CPM”).  
   - Add a **Rollup** on “Videos → ROI” → **Average** (named “Avg ROI”).  
4. **Set up Zapier** (see “Zapier Automation” section).  
5. **Build KPI Dashboard** sub‑page: create linked databases, apply the view settings listed above.  
6. **Create Pitch Email Generator** sub‑page: add a **Template** block, insert the placeholder syntax, and link the **Deal** relation.  
7. (Optional) **Publish**: Share → Publish → enable “Allow duplicate as template” so others can import it.  

Your TikTok Brand Deal Tracker is now live—track contracts, auto‑populate video analytics, monitor ROI, and pitch sponsors with a single click. Enjoy the data‑driven workflow!