# TikTok Creator Studio  

## Dashboard / How to use  
A premium‑grade command centre that **visualises KPIs**, **automates data sync**, **guides new users with interactive tutorials & tooltips**, and provides **mobile‑first & drag‑and‑drop views**. All databases are linked, roll‑ups power real‑time insights, and ready‑made Zapier/Make recipes keep your workflow in sync with TikTok, Instagram, YouTube, LinkedIn, Google Analytics, Meta Business Suite, Sprout Social, Hootsuite, Later & Buffer.

> **💡 Tip:** Hover over any column header to see a tooltip that explains the field’s purpose and the expected format. (Implemented with Notion “Callout” blocks + inline “Hover‑text” in the template.)

### 1️⃣ KPI Dashboard (Notion page)  
| Block | Description | Setup |
|------|-------------|-------|
| **Chart – Views & Likes (Line)** | Daily Views and Likes for the last 30 days. | 1️⃣ Insert a **Synced Block** → `/embed` → paste the **Google Data Studio** URL you generated in the *Analytics* automation (e.g., `https://datastudio.google.com/reporting/…`). 2️⃣ In Data Studio, pull the **TikTok + IG Analytics** Google Sheet (see Automation) and publish the chart. |
| **Chart – Top 5 Videos (Bar)** | Horizontal bar chart of the five videos with the highest **Total Views** (roll‑up). | Same embed method, using the **“Top 5 Videos”** chart in Data Studio. |
| **KPI Summary (Number cards)** | Quick cards for **Total Views (30 d)**, **Avg. Watch Time**, **Revenue (30 d)**, **CPM**, **ROI**, **Pending Sponsorship Payments**. | Insert a **Table – Inline** view of **Analytics** filtered to the last 30 days. Add Roll‑up formulas: `sum(prop("Views"))`, `average(prop("Avg. Watch Time"))`, `sum(prop("Revenue (USD)"))`, `average(prop("CPM"))`, `sum(prop("Revenue (USD)")) / sum(prop("Spend (USD)"))`. Convert each Roll‑up to a **Number** card via **“Create linked database → Turn into board → Card preview”**. |
| **Filter shortcuts** | Buttons that instantly apply the pre‑configured filters “Pending Payments”, “Due Today”, “Top 5 Performing Videos”, “ROI > 150 %”. | Add a **Toggle** block for each filter and link it to the corresponding saved view (see Views section). |
| **Interactive Onboarding** | Mini‑tutorial that walks new users through the dashboard, with **“Next”** buttons that highlight each section. | Duplicate the **Onboarding → Tutorial** page (see the *Onboarding* section) and embed it as a **Synced Block** at the top of the Dashboard. |

> **🔄 Live update:** All charts refresh automatically when the **Analytics** Google Sheet receives new TikTok/IG data (Automation step 2).  

---

## 📅 Content Calendar – Visual & Drag‑Drop  
| Video Title *(Title)* | Status *(Select)* | Publish Date *(Date)* | Platform *(Multi‑select)* | Script *(Relation → Scripts)* | Sponsorship *(Relation → Sponsorships)* | KPI Summary *(Rollup → Analytics → Total Views)* | Approver *(Person)* | Comments *(Text)* |
|-----------------------|-------------------|-----------------------|---------------------------|------------------------------|------------------------------------------|-------------------------------------------|--------------------|----------------|
| Morning Routine Hacks | Planning | 2026‑07‑10 | TikTok, YouTube Shorts, Instagram Reels | Morning Routine Script | – | 12 400 | Lina | ⤷ Add hook in first 3 sec |
| 3‑Minute Meal Prep | Ready to Publish | 2026‑07‑12 | TikTok, Instagram Reels, LinkedIn | Meal Prep Script | BrandX Collab | 22 800 | Alex | ⤷ Brand mention approved |
| Trend: #GlowUp Challenge | Scheduled | 2026‑07‑15 | TikTok, Instagram Reels, Snapchat Spotlight | GlowUp Script | – | 30 100 | Maya | ⤷ Audio “GlowUp Beat” synced |
| Q&A with Fans | Draft | 2026‑07‑18 | TikTok, Twitter Video | Q&A Script | – | 9 750 | Sam | ⤷ Collect fan questions |
| Sponsored Review: XYZ Phone | Approved | 2026‑07‑20 | TikTok, LinkedIn, YouTube Shorts | Phone Review Script | XYZ Corp | 45 600 | Lina | ⤷ Discount code added |

### Views (mobile‑first & drag‑drop)  
| View name | Type | Filters / Sort | Mobile notes |
|----------|------|----------------|--------------|
| **Board – Mobile Kanban** | Board | Group by **Status**; hide **Platform** column | Optimised for portrait; cards show **Title**, **Publish Date**, **KPI Summary**, **Approver**. Drag cards between columns to change status instantly. |
| **Timeline – Visual Calendar** | Timeline | Show items where **Publish Date** is within the next 30 days; colour‑code by **Platform** | Full‑screen timeline works on Notion iOS/Android; drag‑and‑drop to reschedule. |
| **Top 5 Performing Videos** | Table (sorted) | Sort by **KPI Summary** descending; limit to 5 rows (filter “Total Views > 0”). | Linked from KPI Dashboard button. |
| **Due Today** | Table | Filter: **Publish Date** = today OR **Repurpose Hub → Due Date** = today. | Quick‑access from Dashboard. |
| **Pending Payments** | Table | Filter: **Sponsorships → Payment Status** = “Pending”. | Linked from KPI Dashboard button. |
| **Approval Workflow** | Board | Group by **Approver**; columns: **Draft**, **In Review**, **Approved**, **Published**. | Use the **Approver** Person field; reviewers add a comment and move the card to **Approved**. |

> **🖱️ Drag‑and‑drop tip:** On desktop, hover the left edge of a card until the “move” cursor appears, then drag to a new column or timeline slot. On mobile, long‑press the card to activate drag mode.  

---

## 📝 Scripts Library  
| Script Name *(Title)* | Tone *(Select)* | Word Count *(Number)* | Linked Video *(Relation → Content Calendar)* | Approved *(Checkbox)* | Last Edited *(Date)* | Comments *(Text)* |
|-----------------------|-----------------|-----------------------|----------------------------------------------|------------------------|----------------------|-------------------|
| Morning Routine Script | Energetic | 180 | Morning Routine Hacks | ☐ | 2026‑07‑02 | Need hook in first 3 sec |
| Meal Prep Script | Friendly | 210 | 3‑Minute Meal Prep | ☑ | 2026‑07‑01 | Add brand mention |
| GlowUp Script | Playful | 150 | Trend: #GlowUp Challenge | ☐ | 2026‑07‑03 | Sync with audio cue |
| Q&A Script | Conversational | 250 | Q&A with Fans | ☐ | 2026‑07‑04 | Review fan questions |
| Phone Review Script | Professional | 200 | Sponsored Review: XYZ Phone | ☑ | 2026‑07‑02 | Include specs table |

**Saved Views**  
- **Approved Scripts** – Filter `Approved = ✅`.  
- **Pending Review** – Filter `Approved = ☐`.  

> **💬 Comment shortcut:** Click the **“Add comment”** icon on any script row to start a discussion with the copy team.  

---

## 🤝 Sponsorships  
| Deal Name *(Title)* | Brand *(Text)* | Campaign Goal *(Select)* | Video Linked *(Relation → Content Calendar)* | Deliverables *(Multi‑select)* | Payment Status *(Select)* | Contract Sent *(Date)* | Approver *(Person)* | Notes *(Text)* |
|---------------------|----------------|--------------------------|----------------------------------------------|-------------------------------|---------------------------|------------------------|--------------------|----------------|
| XYZ Corp Phone Review | XYZ Corp | Product Awareness | Sponsored Review: XYZ Phone | Video, Story, Swipe Up | Paid | 2026‑06‑25 | Lina | 15‑sec intro required |
| BrandX Energy Drink | BrandX | Lead Generation | 3‑Minute Meal Prep | Video, Giveaway | Pending | 2026‑07‑01 | Alex | Provide discount code |
| AppY Challenge | AppY | App Install | Trend: #GlowUp Challenge | Video, CTA Link | Paid | 2026‑06‑28 | Maya | Use UTM parameters |
| Local Gym Promo | FitGym | Membership Sign‑ups | Morning Routine Hacks | Video, Sticker | Pending | 2026‑07‑03 | Sam | Offer 2‑week trial |
| SaaS Tool Affiliate | CloudPro | Trial Sign‑ups | Q&A with Fans | Video, Affiliate Link | Paid | 2026‑06‑30 | Lina | Include affiliate ID |

**Saved Views**  
- **Pending Payments** – Filter `Payment Status = “Pending”`.  
- **Active Campaigns** – Filter `Payment Status = “Paid”` AND `Video Linked → Status ≠ “Published”`.  

> **🔔 Approval flow:** When a sponsor submits a contract, the **Approver** is notified via Notion’s @mention and must move the card to **Approved** before the video can be scheduled.  

---

## 📊 Analytics – Advanced Reporting  
| Date *(Date)* | Video *(Relation → Content Calendar)* | Views *(Number)* | Likes *(Number)* | Comments *(Number)* | Avg. Watch Time *(Number, seconds)* | Revenue (USD) *(Number)* | Spend (USD) *(Number)* | CPM (USD) *(Formula)* | ROI ( % ) *(Formula)* |
|---------------|----------------------------------------|-------------------|-------------------|----------------------|--------------------------------------|---------------------------|------------------------|------------------------|-----------------------|
| 2026‑07‑10 | Morning Routine Hacks | 12 400 | 1 200 | 45 | 18 | 45.00 | 12.00 | `Revenue / (Views/1000)` | `Revenue / Spend * 100` |
| 2026‑07‑12 | 3‑Minute Meal Prep | 22 800 | 2 500 | 78 | 22 | 78.50 | 18.00 | `Revenue / (Views/1000)` | `Revenue / Spend * 100` |
| 2026‑07‑15 | Trend: #GlowUp Challenge | 30 100 | 3 200 | 102 | 25 | 112.00 | 22.00 | `Revenue / (Views/1000)` | `Revenue / Spend * 100` |
| 2026‑07‑18 | Q&A with Fans | 9 750 | 850 | 30 | 15 | 22.00 | 5.00 | `Revenue / (Views/1000)` | `Revenue / Spend * 100` |
| 2026‑07‑20 | Sponsored Review: XYZ Phone | 45 600 | 4 800 | 210 | 28 | 210.00 | 30.00 | `Revenue / (Views/1000)` | `Revenue / Spend * 100` |

**Roll‑ups in Content Calendar**  
- **Total Views** – Sum of **Views** from linked Analytics rows.  
- **Avg. Watch Time** – Average of **Avg. Watch Time**.  
- **ROI** – `sum(prop("Revenue (USD)")) / sum(prop("Spend (USD)")) * 100`.  

**Saved Views**  
- **Last 7 Days** – Filter `Date ≥ today‑7`.  
- **Top 5 Performing Videos** – Sort `Views` descending, limit 5.  
- **High‑ROI Campaigns** – Filter `ROI ≥ 150`.  

> **📈 Insight tip:** Use the **“ROI”** card on the Dashboard to spot which sponsorships are delivering the best return and re‑allocate budget accordingly.  

---

## 📈 Automation – TikTok ↔ Instagram ↔ Google Sheets ↔ Notion  
1. **Google Sheet “Social Data”** – Columns: Date, Platform, Video Title, Views, Likes, Comments, Avg. Watch Time, Revenue (USD), Spend (USD).  
2. **Zapier recipe “TikTok + IG → Google Sheets”** –  
   - **Trigger:** TikTok “New Video Metrics” **AND** Instagram “New Media Insights”.  
   - **Action:** “Create/Update Spreadsheet Row” in **Social Data** (match on Platform + Video Title).  
   - **Action:** “Find or Create Notion Page” in **Analytics** (filter by Date + Video + Platform). Populate numeric fields.  
   - **Zap URL:** `https://zapier.com/shared/xxxxxx` (pre‑filled for you).  
3. **Make.com scenario “Google Sheets → Notion”** – Same logic, alternative for Make users.  
4. **Sync Frequency:** Every 5 minutes (Make) or **Every 15 minutes** (Zapier) – ensures the KPI Dashboard stays live.  

> **🔐 Security note:** Only one API token (TikTok Business) and one OAuth connection (Google Sheets) are required; all other platform integrations use Zapier’s built‑in connectors.  

---

## 📈 Trend Tracker (Content Ideation)  
| Trend *(Title)* | Category *(Select)* | Detected On *(Date)* | Source *(URL)* | Current Popularity *(Number, 0‑100)* | Platform Reach *(Multi‑select)* | Notes *(Text)* |
|----------------|---------------------|----------------------|----------------|--------------------------------------|-------------------------------|----------------|
| #GlowUp Challenge | Challenge | 2026‑07‑01 | https://www.tiktok.com/tag/glowup | 87 | TikTok, Instagram, Snapchat | Audio “GlowUp Beat” trending. |
| #EcoCooking | Niche | 2026‑07‑03 | https://www.tiktok.com/tag/ecocooking | 73 | TikTok, YouTube Shorts | Good for eco‑brand sponsors. |
| #QuickFit | Fitness | 2026‑07‑04 | https://www.tiktok.com/tag/quickfit | 68 | TikTok, Instagram Reels | Peaks on weekdays. |
| #MiniVlog | Lifestyle | 2026‑07‑05 | https://www.tiktok.com/tag/minivlog | 61 | TikTok, YouTube Shorts, LinkedIn | Works for cross‑platform repurposing. |
| #TechTips | Tech | 2026‑07‑06 | https://www.tiktok.com/tag/techtips | 79 | TikTok, Instagram Reels, LinkedIn | High engagement evenings. |

**Views**  
- **Board – Mobile Kanban – Trends** – Board grouped by **Category** (mobile‑friendly).  
- **Top Trends** – Table filtered `Current Popularity ≥ 80` sorted descending.  

> **🧭 Navigation tip:** Click a trend row to open a **linked page** where you can attach a **script draft**, **sponsor ideas**, and **preview assets**.  

---

## 📈 Hashtag Library  
| Hashtag *(Title)* | Category *(Select)* | Avg. Reach *(Number, 0‑100)* | Recommended Use *(Select)* | Last Checked *(Date)* | Platform Reach *(Multi‑select)* | Notes *(Text)* |
|-------------------|---------------------|------------------------------|----------------------------|-----------------------|-------------------------------|----------------|
| #GlowUp | Challenge | 87 | Video Caption | 2026‑07‑01 | TikTok, Instagram | Pair with upbeat audio. |
| #EcoCooking | Niche | 73 | Description | 2026‑07‑03 | TikTok, YouTube Shorts | Add brand‑friendly emojis. |
| #QuickFit | Fitness | 68 | CTA | 2026‑07‑04 | TikTok, Instagram Reels | Use in first 3 sec. |
| #MiniVlog | Lifestyle | 61 | Cross‑post | 2026‑07‑05 | TikTok, YouTube Shorts, LinkedIn | Good for Instagram Reels. |
| #TechTips | Tech | 79 | Thumbnail | 2026‑07‑06 | TikTok, Instagram, LinkedIn | Works on YouTube Shorts. |

**Saved Views**  
- **High‑Reach Hashtags** – Filter `Avg. Reach ≥ 80`.  

---

## 🎥 Onboarding & FAQ (Interactive)  
| Resource *(Title)* | Type *(Select)* | Link *(URL)* | Owner *(Person)* | Last Updated *(Date)* | Notes *(Text)* |
|--------------------|-----------------|--------------|------------------|-----------------------|----------------|
| 5‑Minute Studio Tour | Video | https://www.youtube.com/watch?v=5min‑tour | Lina | 2026‑07‑01 | Walk‑through of every page & view. |
| Interactive Tutorial – Dashboard | Page (Notion) | (embedded in Dashboard) | Alex | 2026‑07‑02 | Step‑by‑step with “Next” buttons & tooltips. |
| How to Connect TikTok & IG APIs | Video | https://www.youtube.com/watch?v=api‑setup | Alex | 2026‑07‑02 | Zapier & Make configuration. |
| FAQ – Common Issues | Document | https://example.com/tiktok‑faq.pdf | Maya | 2026‑07‑01 | Sync, payments, repurposing. |
| SOP – Repurposing Checklist | Document | https://example.com/repurpose‑checklist.pdf | Sam | 2026‑06‑10 | Platform specs. |
| Collaboration Guide – Comments & Approvals | Document | https://example.com/collab‑guide.pdf | Lina | 2026‑07‑03 | How to use Notion comments & approval workflow. |

> **📌 Pin the “5‑Minute Studio Tour”** to the sidebar for instant access when the workspace opens.  

---

## 🔁 Repurpose Hub – Platform‑Specific Checklists  
| Repurpose Task *(Title)* | Source Video *(Relation → Content Calendar)* | Target Platform *(Select)* | Status *(Select)* | Due Date *(Date)* | Owner *(Person)* | Approver *(Person)* | Checklist *(Relation → Repurpose Checklists)* |
|--------------------------|----------------------------------------------|----------------------------|-------------------|-------------------|-------------------|--------------------|----------------------------------------------|
| Create YouTube Short | Morning Routine Hacks | YouTube Shorts | To Do | 2026‑07‑11 | Alex | Lina | YouTube Short Checklist |
| Instagram Reel Clip | 3‑Minute Meal Prep | Instagram Reels | In Progress | 2026‑07‑13 | Maya | Alex | Instagram Reel Checklist |
| Blog Post Draft | Trend: #GlowUp Challenge | Blog | To Do | 2026‑07‑16 | Sam | Maya | Blog Checklist |
| TikTok Clip for Twitter | Q&A with Fans | Twitter Video | To Do | 2026‑07‑19 | Lina | Sam | Twitter Checklist |
| LinkedIn Teaser | Sponsored Review: XYZ Phone | LinkedIn | To Do | 2026‑07‑21 | Alex | Lina | LinkedIn Checklist |

### Repurpose Checklists (Database)  
| Checklist Name *(Title)* | Platform *(Select)* | Item *(Text)* | Completed *(Checkbox)* |
|--------------------------|---------------------|--------------|------------------------|
| YouTube Short Checklist | YouTube Shorts | Thumbnail 1080×1920 (max 2 MB) | ☐ |
| YouTube Short Checklist | YouTube Shorts | Caption ≤ 150 chars | ☐ |
| YouTube Short Checklist | YouTube Shorts | Add end‑screen link to channel | ☐ |
| Instagram Reel Checklist | Instagram Reels | 9:16 video, ≤ 30 sec | ☐ |
| Instagram Reel Checklist | Instagram Reels | Add branded stickers | ☐ |
| Instagram Reel Checklist | Instagram Reels | Caption ≤ 2200 chars | ☐ |
| Blog Checklist | Blog | 300‑word summary | ☐ |
| Blog Checklist | Blog | SEO title + meta description | ☐ |
| Blog Checklist | Blog | Add 2‑3 internal links | ☐ |
| Twitter Checklist | Twitter Video | ≤ 2 min MP4 | ☐ |
| Twitter Checklist | Twitter Video | Add caption with #hashtag | ☐ |
| LinkedIn Checklist | LinkedIn | 60‑sec video, square | ☐ |
| LinkedIn Checklist | LinkedIn | Tag sponsor page | ☐ |

**Saved Views**  
- **Due Today** – Filter `Due Date = today`.  
- **Platform Boards** – Board view grouped by **Target Platform** (mobile‑optimized).  

> **🗨️ Collaboration tip:** Assign an **Owner** and an **Approver**; the Approver receives an @mention when the task moves to **In Review**.  

---

## 📚 Resources & SOPs (enhanced)  
| Resource *(Title)* | Type *(Select)* | Link *(URL)* | Owner *(Person)* | Last Updated *(Date)* | Notes *(Text)* |
|--------------------|-----------------|--------------|------------------|-----------------------|----------------|
| Brand Guidelines – XYZ Corp | Document | https://example.com/xyz‑guidelines.pdf | Maya | 2026‑06‑20 | Mandatory logo usage |
| Trending Audio Pack – July | Audio | https://example.com/audio‑july.zip | Alex | 2026‑07‑01 | 30‑sec loops |
| SOP – Video Production | SOP | https://example.com/sop‑production.pdf | Sam | 2026‑05‑15 | Follow for every video |
| KPI Dashboard Template | Template | https://example.com/kpi‑template.notion | Lina | 2026‑04‑30 | Import into Analytics |
| Repurposing Checklist (PDF) | Checklist | https://example.com/repurpose‑checklist.pdf | Maya | 2026‑06‑10 | Use for each task |
| Onboarding Video | Video | https://www.youtube.com/watch?v=onboard‑tour | Lina | 2026‑07‑01 | 5‑minute walkthrough |
| FAQ – Sync Issues | Document | https://example.com/faq‑sync.pdf | Alex | 2026‑07‑02 | Troubleshoot API / Zapier |
| Collaboration Guide – Comments & Approvals | Document | https://example.com/collab‑guide.pdf | Lina | 2026‑07‑03 | Best practices for team workflow |

---

## 📅 Scheduler Integration (Zapier & Make)  
| Integration | Trigger | Action | Destination | Pre‑built Zap/Scenario |
|------------|---------|--------|-------------|------------------------|
| **Later** | New row in **Analytics** (Google Sheet) | Create **Scheduled Post** in Later | Later.com | `https://zapier.com/shared/later‑schedule‑xxxx` |
| **Buffer** | New entry in **Content Calendar** with Status = “Ready to Publish” | Add to Buffer queue (publish date = **Publish Date**) | Buffer.com | `https://zapier.com/shared/buffer‑queue‑yyyy` |
| **Hootsuite** | New task in **Repurpose Hub** (Status = “To Do”) | Create Hootsuite post (platform selected) | Hootsuite.com | `https://zapier.com/shared/hootsuite‑sync‑zzzz` |
| **Make.com – Repurpose Sync** | New task in **Repurpose Hub** (status = “To Do”) | Create task in Asana / Trello (optional) | Asana/Trello | `https://make.com/scenario/repurpose‑sync‑aaaa` |

**How to activate**  
1. Click the **“Activate”** button on each Zap/Scenario link.  
2. Authorise Notion, Google Sheets, TikTok, Instagram, Later/Buffer/Hootsuite as prompted.  
3. Map the fields exactly as shown in the table (Zapier auto‑fills).  

---

## How to set up in Notion (updated)  
1. **Duplicate** this page → “Duplicate → Copy to workspace”.  
2. For each markdown table, type `/database` → **Table – Full page**, then **Paste** the rows; Notion will auto‑create the columns.  
3. **Set property types** exactly as indicated in the column headers (Title, Select, Multi‑select, Date, Number, Checkbox, Person, URL, Relation, Rollup, Formula).  
4. **Create the Views** listed under each database (Board, Calendar, Timeline, Table, etc.) – copy the filter & sort settings verbatim.  
5. **Add the KPI Dashboard**:  
   - Insert a **Synced Block** → `/embed` → paste the Data Studio URLs you generated in the Automation section.  
   - Add