# TikTok Trend‑to‑Post Master Template

## 1️⃣ Dashboard  
A single‑page snapshot that lets you see the health of your TikTok pipeline at a glance.

- **Top 3 Trending Sounds** – pulled automatically from the **Trend Feed**.  
- **Ideas in‑Progress** – count of video ideas that are still in the “Idea” stage.  
- **Scheduled Posts** – number of videos with a publish date set in the future.  
- **Last 7‑Day Performance** – key KPIs from the **Performance Analytics** table.

> 💡 Tip: Pin this page to the top of your workspace so you can monitor your TikTok engine without opening multiple pages.

---

## 2️⃣ Trend Feed  
A database that stores the daily TikTok trend dump (you can paste CSV or use Zapier/Make to auto‑populate).  

| Date       | Trend Name                | Category   | Sound                | Views (M) | Selected | Notes                              |
|------------|---------------------------|------------|----------------------|-----------|----------|------------------------------------|
| 2024‑06‑28 | #GlowUpChallenge          | Beauty     | “Glow Up” – @user123 | 12.4      | ✅        | High teen engagement, easy edit   |
| 2024‑06‑28 | #QuickMealHack            | Food       | “Sizzle Beat”        | 8.1       |          | Needs a 30‑sec recipe video       |
| 2024‑06‑27 | #PetDanceOff              | Pets       | “Bark Remix”         | 5.6       | ✅        | Good for user‑generated content   |
| 2024‑06‑27 | #EcoFashionTips           | Lifestyle  | “Green Groove”       | 3.2       |          | Aligns with brand sustainability  |
| 2024‑06‑26 | #TechHack2024             | Tech       | “Circuit Loop”       | 9.9       | ✅        | Ideal for quick‑tip format        |

> 💡 Tip: Use a Zapier “New CSV Row” trigger to add each day’s trends automatically; set the **Selected** checkbox to true for trends you’ll turn into videos.

---

## 3️⃣ Video Idea Builder  
Turn selected trends into concrete video concepts, complete with caption prompts and ownership.

| Idea ID | Trend (Relation) | Video Concept                     | Caption Prompt                              | Status   | Target Publish Date | Owner   |
|---------|------------------|-----------------------------------|--------------------------------------------|----------|---------------------|---------|
| VID‑001 | #GlowUpChallenge | 15‑sec before‑after makeup demo   | “Ready for a glow‑up? ✨ #GlowUpChallenge”   | Ready    | 2024‑07‑02          | Alex    |
| VID‑002 | #PetDanceOff     | My dog’s “dance battle” with friend| “Who’s got the better moves? 🐾 #PetDanceOff”| Scheduled| 2024‑07‑03          | Maya    |
| VID‑003 | #TechHack2024    | Quick tip: hide phone charger cable| “Never lose your charger again! #TechHack2024”| Idea     | —                   | Sam     |
| VID‑004 | #QuickMealHack   | 30‑sec avocado toast recipe       | “Breakfast in a flash! 🥑 #QuickMealHack”   | Idea     | —                   | Lina    |
| VID‑005 | #EcoFashionTips  | Upcycle old tee into tote bag     | “Turn old tees into eco‑bags 🌿 #EcoFashionTips”| Ready    | 2024‑07‑05          | Alex    |

> 💡 Tip: Link the **Trend** column to the **Trend Feed** database. This creates a two‑way relation so you can always jump back to the original trend data.

---

## 4️⃣ Content Calendar  
A calendar view of the **Video Idea Builder** filtered to only show items where **Status** is “Ready” or “Scheduled”.  

| Publish Date | Video Title (Rollup) | Owner | Status   |
|--------------|----------------------|-------|----------|
| 2024‑07‑02   | 15‑sec before‑after makeup demo | Alex  | Ready    |
| 2024‑07‑03   | My dog’s “dance battle”          | Maya  | Scheduled|
| 2024‑07‑05   | Upcycle old tee into tote bag    | Alex  | Ready    |

> 💡 Tip: Drag‑and‑drop a card on the calendar to instantly change the **Target Publish Date** – the change propagates back to the Idea Builder automatically.

---

## 5️⃣ Performance Analytics  
After each video goes live, copy the TikTok stats into this table to track ROI and inform future ideas.

| Publish Date | Video Title                              | Views (M) | Likes (K) | Comments | Shares | Avg. Watch % | ROI (Views ÷ Cost) |
|--------------|------------------------------------------|-----------|-----------|----------|--------|--------------|--------------------|
| 2024‑07‑02   | 15‑sec before‑after makeup demo          | 4.2       | 120       | 18       | 22     | 68%          | 4.2                |
| 2024‑07‑03   | My dog’s “dance battle”                  | 3.8       | 95        | 12       | 15     | 71%          | 3.8                |
| 2024‑07‑05   | Upcycle old tee into tote bag            | 2.5       | 80        | 9        | 10     | 65%          | 2.5                |

> 💡 Tip: Create a filtered view that only shows videos with **Avg. Watch %** < 60 % – those are candidates for quick‑fire A/B testing.

---

## 6️⃣ Settings & Resources  
Central hub for SOPs, API keys, and reference material.

- **Trend Import SOP** – step‑by‑step for Zapier/Make integration.  
- **Caption Library** – reusable hooks (e.g., “Did you know…?”, “Tag a friend who…”).  
- **Brand Guidelines** – color palette, logo usage, voice tone.  
- **Analytics Dashboard Link** – optional embed of Google Data Studio for deeper insights.

> 💡 Tip: Keep the **Caption Library** as a separate Notion page and link it in the **Caption Prompt** field using `@` mentions for instant autocomplete.

---

## How to import into Notion  
1. **Create a new page** in your Notion workspace where you want the template.  
2. Click **“Import” → “Markdown & CSV”**, then select this `.md` file.  
3. Notion will create a series of sub‑pages for each H2 heading.  
4. For each table (Trend Feed, Video Idea Builder, Content Calendar, Performance Analytics):  
   - Click the three‑dot menu on the table → **“Turn into database”**.  
   - Choose the appropriate view type (Table, Calendar, Gallery) as described in the sections.  
5. Set up the **Relation** between **Video Idea Builder** → **Trend Feed**:  
   - Open the **Video Idea Builder** database → **+ Add a property** → **Relation**, select **Trend Feed**, enable **Show on both sides**.  
6. Add the **Calendar view** to the **Video Idea Builder** (or use the pre‑filled **Content Calendar** table) and filter to **Status** = Ready or Scheduled.  
7. (Optional) Connect your Zapier/Make automation to the **Trend Feed** database to auto‑populate daily trends.  

Your TikTok workflow is now live—start selecting trends, crafting ideas, scheduling posts, and measuring results—all within a single Notion workspace. Happy creating!