Viral Video Analysis

Analyze video ad performance and provide actionable feedback to creators. Use when asked to analyze why videos underperform, give creator coaching feedback,...

Requirements

• API Key: Requires MEMORIES_API_KEY from Memories.ai
• External API: Sends video URLs to https://mavi-backend.memories.ai for transcription
• Python packages: generate_report.py will auto-install fpdf2, pandas, openpyxl if missing

Privacy Note

• Video URLs are sent to Memories.ai for transcription
• Batch analysis reads Excel files with creator/ROI data
• Review Memories.ai privacy policy before use

Analyze videos and provide actionable feedback for creators.

Core Insight

High ROI videos: <100 words, ~5s per product, visual-first + background music Low ROI videos: >150 words, >15s per product, too much explaining

The core problem: Creators spend too much time "selling" instead of "showing". Remember: Ads reach non-followers who need to be hooked in 3 seconds.

Quantitative Thresholds

Metric	✅ GOOD (High ROI)	❌ BAD (Low ROI)
Word Count	<100 words	>150 words
Time per Product	~5 seconds	>15 seconds
Shows All Products Upfront	YES	NO
Format	Visual + Music	Talking/Explaining

Analysis Workflow

Setup

Requires Memories.ai API key. Get one at https://api-tools.memories.ai

Set environment variable:

export MEMORIES_API_KEY="sk-mavi-your-key-here"

1. Get Audio Transcript (Word Count)

import os
import requests

BASE_URL = "https://mavi-backend.memories.ai/serve/api/v2"
API_KEY = os.environ.get("MEMORIES_API_KEY")
HEADERS = {"Authorization": API_KEY}

def get_transcript(url: str, platform: str = "instagram"):
    resp = requests.post(
        f"{BASE_URL}/{platform}/video/transcript",
        headers=HEADERS,
        json={"video_url": url, "channel": "rapid"},
        timeout=60
    )
    data = resp.json()
    if data.get("success"):
        text = data["data"]["transcripts"][0]["text"]
        return {"text": text, "word_count": len(text.split())}
    return {"error": data.get("msg")}

# Platform detection
def detect_platform(url):
    url = url.lower()
    if "tiktok" in url: return "tiktok"
    if "instagram" in url: return "instagram"
    if "twitter" in url or "x.com" in url: return "twitter"
    return "youtube"

2. Analyze Against Thresholds

def analyze_video(url):
    platform = detect_platform(url)
    result = get_transcript(url, platform)
    
    if "error" in result:
        return result
    
    word_count = result["word_count"]
    
    return {
        "url": url,
        "word_count": word_count,
        "word_count_status": "GOOD" if word_count < 100 else "OK" if word_count < 150 else "BAD",
        "issues": [],
        "transcript_preview": result["text"][:200]
    }

3. Generate Creator Feedback

Based on analysis, provide specific feedback:

If word_count > 150:

"Your video has {X} words. Top performers use <100 words. Try replacing verbal explanations with visual demonstrations - stretch the fabric, spin around, show the fit."

If pace is slow (>15s per product):

"You're spending ~{X} seconds per product. High-performers show each item in ~5 seconds. Try quick cuts - one outfit = one scene transition."

If no upfront overview:

"Show ALL products in the first 2-3 seconds. Let viewers see the full haul immediately - it sets expectations and keeps them watching."

Always remind:

"Remember: Ads reach people who DON'T follow you. You have 3 seconds to grab a stranger's attention - don't waste it on intros."

The Exception: Kirstin Approach

Detailed verbal reviews CAN work if:

1. Show all products FIRST before explaining
2. Use low-pressure language: "if it doesn't fit, just return it"
3. Focus on introducing products, not "selling" them

Word count: 373 words can still perform if structure is right.

Reference Videos

GOOD Examples (share with creators)

• instagram.com/reel/Cy1zs4gLGFG - 46 words, 15s for 3 outfits, pure visual
• instagram.com/reel/DEybxPbNeOl - 56 words, quick showcase, background music
• instagram.com/reel/DHHr5o2s1LG - 91 words, fast cuts, shows product features
• instagram.com/reel/DBd6NxbOeBb - 91 words, demonstrates fit visually

EXCEPTION Example (detailed review done RIGHT)

• instagram.com/reel/DCQJ355RWSE - 373 words but works: shows all upfront, low-pressure

BAD Example (avoid)

• instagram.com/reel/DRCdjLlDcla - 168 words, 30s per outfit, too much explaining

Feedback Template

Hi [Creator],

Thanks for your video! Here's some feedback to help improve performance:

**What's Working:**
- [Specific positive]

**Opportunities:**
1. **Pacing**: Currently ~{X}s per product. Try ~5s per item with quick cuts.
2. **Word Count**: {X} words detected. Top performers use <100. Show more, tell less.
3. **Opening**: Consider showing all products in first 2-3 seconds.

**Key Reminder:**
Ads reach people who don't follow you yet. They need to be hooked in 3 seconds!

**Reference Videos:**
[Link to good example]

Best,
[Team]

Batch Analysis

def analyze_batch(excel_path, sample_size=20):
    import pandas as pd
    df = pd.read_excel(excel_path)
    df.columns = [c.lower().replace('sum of ', '').replace(' ', '_') for c in df.columns]
    
    # Get top and bottom performers
    top = df.nlargest(sample_size // 2, 'roi')
    bottom = df.nsmallest(sample_size // 2, 'roi')
    
    results = []
    for _, row in pd.concat([top, bottom]).iterrows():
        url = row.get('video_url') or row.get('row_labels')
        analysis = analyze_video(url)
        analysis['roi'] = row['roi']
        analysis['tier'] = 'TOP' if row['roi'] > 1.0 else 'BOTTOM'
        results.append(analysis)
    
    return results

Quick Commands

• "Analyze this video: [url]" → Word count + feedback
• "Why is this video underperforming?" → Detailed analysis
• "Give me feedback for [creator]" → Coaching template
• "Compare these videos" → Side-by-side analysis
• "Analyze my performance data" → Batch analysis from Excel