With a UGC tracking tool connected to Claude over MCP, one team analyzed 18,736 September UGC videos by talking to it, replacing what they say was 90% of their day in spreadsheets. It ranks hooks, formats and angles by views and consistency, says which creators to scale or coach, turns the top videos into 10 new concepts with the winners that inspired each one, and lists unanswered comment questions per creator. The author co-founded Trackr and measures app downloads, but the same prompts work on a DTC brand's UGC and Spark Ads library.
Prompt
Analyze every video from [CAMPAIGN] over [TIME PERIOD]. Identify the top-performing hooks, formats, and messaging angles, ranking them by average views, engagement, and consistency. Show me the specific videos supporting each finding.