# TikTok Creator Studio – Trend, Production & Brand Management  

## Dashboard / How to use  
A single‑page command center for TikTok creators to **spot viral trends**, **plan shoots**, **lock‑in brand deals**, **store all media assets**, and **see real‑time ROI**. AI‑driven suggestions surface the hottest ideas that match your audience’s past behavior, so you never chase a dead trend again. Ideal for solo creators, small teams, or agency managers who need end‑to‑end control without juggling spreadsheets.  

**Quick start**  
1. Duplicate the template (Share → **Duplicate**).  
2. Open **Trend Capture** → AI will auto‑populate “AI Suggested Hook” and “User Preference Score” for the day’s top 3 trends.  
3. Drag those trends into **Content Calendar** – the AI‑generated script prompt appears automatically.  
4. Link any brand contracts to the scheduled videos; the **Projected ROI** column updates in real time.  
5. Review **Performance & ROI Tracker** after publishing – AI Insight Summary highlights optimisation opportunities.  

---  

## Trend Capture  
Collect, rank, and archive TikTok trends before they fade. AI analyses platform data and your past performance to recommend hooks that resonate with your followers.  

> 💡 **Tip:** The “Trend Score” now incorporates **AI Suggested Hook Strength** (0‑100) and **User Preference Score** (0‑100) for a more predictive ranking.  

| Trend Name (Title) | Platform | Trend Score (Formula) | Category (Select) | Detected On (Date) | AI Suggested Hook (Text) | User Preference Score (Number) | Notes |
|--------------------|----------|-----------------------|-------------------|--------------------|--------------------------|--------------------------------|-------|
| AI Prompt Challenge | TikTok | `prop("Virality") * prop("Relevance") * (prop("AI Suggested Hook Strength")/100) * (prop("User Preference Score")/100)` | Education | 2024‑06‑28 | “Can you beat the AI in 30 seconds?” | 92 | High engagement in #AICommunity |
| 3‑Second Plant Hack | TikTok | `prop("Virality") * prop("Relevance") * (prop("AI Suggested Hook Strength")/100) * (prop("User Preference Score")/100)` | Lifestyle | 2024‑06‑27 | “Watch this plant grow in 3 seconds!” | 78 | Seasonal boost in spring |
| Retro 90s Dance | TikTok | `prop("Virality") * prop("Relevance") * (prop("AI Suggested Hook Strength")/100) * (prop("User Preference Score")/100)` | Entertainment | 2024‑06‑26 | “Throwback dance with a modern twist” | 85 | Partner with retro clothing brand |

*Columns:* Trend Name (Title), Platform (Text), Trend Score (Formula), Category (Select), Detected On (Date), AI Suggested Hook (Text), User Preference Score (Number 0‑100), Notes (Text).  

---  

## Content Inspiration & Challenges  
A curated bank of ideas and challenges that the AI updates weekly based on emerging trends and your niche performance.  

| Idea (Title) | Challenge Type (Select) | Difficulty (Select) | AI Prompt (Text) | Suggested Hashtag (Text) | Release Window (Date) |
|--------------|--------------------------|---------------------|------------------|--------------------------|-----------------------|
| “30‑Second Storytelling” | Storytelling | Medium | “Tell a complete story in exactly 30 seconds using only three props.” | #30SecStory | 2024‑07‑15 |
| “AI vs Human Remix” | Competition | Hard | “Create a remix where AI generates the beat and you add the vocals.” | #AIVsHuman | 2024‑07‑22 |
| “Eco‑Hack Challenge” | Sustainability | Easy | “Show a daily eco‑hack that saves water or energy.” | #EcoHack | 2024‑07‑08 |
| “Flashback Fashion” | Fashion | Medium | “Recreate a 90s outfit with items from your closet.” | #FlashbackFashion | 2024‑07‑12 |
| “One‑Take Tutorial” | Education | Hard | “Teach a skill in one continuous take without cuts.” | #OneTakeTeach | 2024‑07‑19 |

---  

## Content Calendar & Production  
Schedule shoots, assign tasks, and track production status. AI‑generated script prompts and reach forecasts keep the pipeline moving efficiently.  

> ✅ **Best practice:** Keep “Ready for Publish” as a separate status to trigger performance tracking and AI Insight generation.  

| Video Title (Title) | Trend (Relation) | Shoot Date (Date) | Status (Select) | Script ✅ (Checkbox) | Edit ✅ (Checkbox) | AI Script Prompt (Text) | Estimated Reach (Number) | Publish Date (Date) |
|---------------------|------------------|-------------------|-----------------|----------------------|--------------------|--------------------------|--------------------------|----------------------|
| AI Prompt Challenge – Part 1 | AI Prompt Challenge | 2024‑07‑02 | Pre‑Production | ☐ | ☐ | “Introduce the AI prompt, then attempt to beat it in 30 s.” | 250 000 | — |
| 3‑Second Plant Hack – Succulents | 3‑Second Plant Hack | 2024‑07‑04 | Filming | ✅ | ☐ | “Show a time‑lapse of a succulent sprouting, add a voice‑over.” | 180 000 | — |
| Retro 90s Dance – Outfit Reveal | Retro 90s Dance | 2024‑07‑06 | Editing | ✅ | ✅ | “Start with a closet pull, transition to dance on a neon backdrop.” | 320 000 | — |
| Eco‑Hack Challenge – Water Saver | Eco‑Hack Challenge | 2024‑07‑09 | Ready for Publish | ✅ | ✅ | “Demonstrate a DIY faucet aerator; end with a call‑to‑action.” | 210 000 | — |

*Columns:* Video Title (Title), Trend (Relation → Trend Capture), Shoot Date (Date), Status (Select – Pre‑Production, Filming, Editing, Ready for Publish, Published), Script ✅ (Checkbox), Edit ✅ (Checkbox), AI Script Prompt (Text), Estimated Reach (Number), Publish Date (Date).  

---  

## Brand Collaboration & Contracts  
Manage deals, payment milestones, and deliverable checkpoints. AI‑driven negotiation insights and projected ROI help you price smarter.  

> 💡 **Tip:** Link each contract to the corresponding video in **Content Calendar** to auto‑populate deliverable dates and AI‑generated ROI forecasts.  

| Brand (Title) | Campaign (Text) | Contract Value (Number USD) | Payment Milestone (Select) | Linked Video (Relation) | Status (Select) | Signed (Checkbox) | AI Negotiation Insight (Text) | Projected ROI % (Formula) |
|---------------|-----------------|-----------------------------|----------------------------|--------------------------|-----------------|--------------------|-------------------------------|---------------------------|
| GreenGlow Skincare | “Glow‑Up Challenge” | 1 500 | 50 % Up‑front | 3‑Second Plant Hack – Succulents | Active | ✅ | “Offer a 10 % discount on bulk orders for higher CPM.” | `prop("Revenue") / prop("Contract Value") * 100` |
| RetroThreads | “90s Outfit Drop” | 2 000 | 100 % on Publish | Retro 90s Dance – Outfit Reveal | Pending | ☐ | “Negotiate a performance bonus if views > 300 k.” | `prop("Revenue") / prop("Contract Value") * 100` |
| Promptly AI | “AI Prompt Series” | 1 200 | 30 % on Script | AI Prompt Challenge – Part 1 | Active | ✅ | “Bundle with a co‑branded AI tool for cross‑promotion.” | `prop("Revenue") / prop("Contract Value") * 100` |

---  

## Asset Library  
Central repository for raw footage, edited clips, thumbnails, and copy. AI‑tagging and quality scoring accelerate asset retrieval.  

> ✅ **Best practice:** Tag assets with both **Video Title** and **Asset Type**; the AI Quality Score highlights clips that need re‑editing.  

| Asset Name (Title) | Video (Relation) | Asset Type (Select) | Uploaded On (Date) | File Link (URL) | AI Tagging (Multi‑select) | AI Quality Score (Number 0‑100) | Approved (Checkbox) |
|--------------------|------------------|---------------------|--------------------|-----------------|--------------------------|----------------------------------|----------------------|
| Raw Footage – AI Prompt 1 | AI Prompt Challenge – Part 1 | Raw Footage | 2024‑07‑01 | https://drive.google.com/... | {“AI‑Generated”, “High‑Resolution”} | 92 | ✅ |
| Edited Clip – Plant Hack | 3‑Second Plant Hack – Succulents | Edited Video | 2024‑07‑04 | https://drive.google.com/... | {“Color‑Corrected”, “Music‑Added”} | 78 | ☐ |
| Thumbnail – Retro Dance | Retro 90s Dance – Outfit Reveal | Thumbnail | 2024‑07‑05 | https://drive.google.com/... | {“Bold‑Text”, “Neon‑Palette”} | 85 | ✅ |
| Caption Copy – Eco‑Hack | Eco‑Hack Challenge – Water Saver | Caption Copy | 2024‑07‑09 | https://docs.google.com/... | {“SEO‑Optimized”, “Hashtag‑Rich”} | 88 | ✅ |

---  

## Performance & ROI Tracker  
Automatic KPI dashboard that pulls data from published videos, contracts, and AI‑enhanced analytics. Deeper insights let you optimise each piece of content.  

> 💡 **Tip:** Export TikTok analytics CSV weekly, import into the **Performance** table, then run the “AI Insight Summary” roll‑up to get actionable recommendations.  

| Video (Relation) | Views (Number) | Likes (Number) | Avg. Watch Time (Number s) | CTR % (Number) | CPM ($) (Number) | Revenue (Number USD) | Engagement Rate % (Formula) | Revenue per View $ (Formula) | Audience Demographic (Multi‑select) | Sentiment Score (Number ‑10 to 10) | AI Insight Summary (Text) | Published On (Date) |
|------------------|----------------|----------------|----------------------------|----------------|------------------|----------------------|-----------------------------|------------------------------|--------------------------------------|-----------------------------------|---------------------------|----------------------|
| AI Prompt Challenge – Part 1 | 120 000 | 8 500 | 12.4 | 4.2 | 6.5 | 300 | `prop("Likes") / prop("Views") * 100` | `prop("Revenue") / prop("Views")` | {“18‑24 M”, “US”, “Tech‑Savvy”} | 7 | “High watch‑time but low CTR – add a stronger hook in the first 3 s.” | 2024‑07‑03 |
| 3‑Second Plant Hack – Succulents | 95 000 | 6 200 | 9.8 | 3.8 | 5.9 | 250 | `prop("Likes") / prop("Views") * 100` | `prop("Revenue") / prop("Views")` | {“25‑34 F”, “US”, “Eco‑Conscious”} | 8 | “Audience loves the visual; consider a series to boost repeat views.” | 2024‑07‑05 |
| Retro 90s Dance – Outfit Reveal | 150 000 | 12 000 | 15.1 | 5.1 | 7.2 | 400 | `prop("Likes") / prop("Views") * 100` | `prop("Revenue") / prop("Views")` | {“18‑24 M”, “US”, “Fashion‑Forward”} | 9 | “Excellent CTR – test a follow‑up challenge to increase brand lift.” | 2024‑07‑07 |
| Eco‑Hack Challenge – Water Saver | 210 000 | 14 800 | 13.6 | 4.7 | 6.8 | 350 | `prop("Likes") / prop("Views") * 100` | `prop("Revenue") / prop("Views")` | {“25‑34 F”, “US”, “Sustainability”} | 6 | “Strong engagement; add a CTA to drive traffic to brand landing page.” | 2024‑07‑10 |

*Formulas:*  
- **Engagement Rate %** = `prop("Likes") / prop("Views") * 100`  
- **Revenue per View $** = `prop("Revenue") / prop("Views")`  

---  

## Automation & SOPs  
Guidelines for linking databases and using Notion’s native automations (or Zapier/Make). New AI‑driven automations keep the workflow frictionless.  

- **Auto‑link Trend → Calendar**: When a trend’s **Trend Score** exceeds 80, a draft entry is created in **Content Calendar** with status “Pre‑Production” and the AI Script Prompt auto‑filled.  
- **AI‑Generated Insight Trigger**: On a new row in **Performance & ROI Tracker**, a Formula property runs an OpenAI prompt (via Zapier) that writes an “AI Insight Summary”.  
- **Milestone Reminder**: Date property with “Remind 1 day before” on **Payment Milestone** triggers a Notion reminder and sends a Slack message via Zapier.  
- **Performance Sync**: Zapier “New CSV Row (TikTok Analytics) → Update Notion row” populates Views, Likes, CTR, CPM, and updates the **Last Sync** date property.  
- **Content Inspiration Refresh**: Weekly Make.com scenario pulls the top 10 TikTok hashtags, runs an AI clustering model, and updates the **Content Inspiration & Challenges** table with new ideas.  

> ✅ **Best practice:** Keep a “Last Sync” date property on the Performance table and a “AI Model Version” text property to track which AI prompt generated the insights.  

---  

## How to set up in Notion  
1. Click **Share → Duplicate** to add the template to your workspace.  
2. For each table below, type `/database` → **Table – Full page**, then paste the markdown rows.  
3. Immediately after creation, open **⋮⋮ → Properties** and set the property types exactly as noted (Title, Select, Multi‑select, Date, Number, Checkbox, Relation, Formula, URL, Text).  
4. Create the required **Relations**:  
   - **Content Calendar** → Relation to **Trend Capture** (named “Trend”).  
   - **Brand Collaboration** → Relation to **Content Calendar** (named “Linked Video”).  
   - **Asset Library** → Relation to **Content Calendar** (named “Video”).  
   - **Performance & ROI Tracker** → Relations to **Content Calendar** (named “Video”) **and** **Brand Collaboration** (to pull “Contract Value”).  
5. Add the following **Formula** properties:  
   - In **Trend Capture**, “Trend Score” = `prop("Virality") * prop("Relevance") * (prop("AI Suggested Hook Strength")/100) * (prop("User Preference Score")/100)`.  
   - In **Performance & ROI Tracker**, “Engagement Rate %” and “Revenue per View $” as shown above.  
   - In **Brand Collaboration**, “Projected ROI %” = `prop("Revenue") / prop("Contract Value") * 100`.  
6. (Optional) Connect Zapier or Make.com for external analytics sync – follow the **Automation & SOPs** section for sample recipes.  
7. Publish the workspace page (Share → Publish) and enable **Allow duplicate as template** if you wish to sell or share it publicly.