Data Project 16: I Analyzed 48,000+ TikTok and YouTube Shorts to Build a Content Advisor
The data reveals exactly when, where, and how viral content is made
Everyone’s guessing what makes content go viral. I stopped guessing.
I analyzed 48,000+ videos from TikTok and YouTube Shorts (Jan-Aug 2025 data) across 15 genres and 60 countries. Then I built an AI-powered dashboard that tells you exactly what to post, when to post, and which hashtags to use.
Do you know that posting at the wrong hour can cost you 47% of your engagement?
Do you know that TikTok outperforms YouTube Shorts in some genres by 38%, but loses in others?
Do you know that the top 1% of content creators use videos that are 23 seconds shorter than average?
I didn’t know either. But the data told me everything.
Any feedback? Fill out this form, and each month, I’ll send a free subscription to those who contribute the most.
What do I build?
This isn’t just another data analysis. I built a complete Content Advisor dashboard with:
Viral Score Predictor: Input your video details, get a viral probability score before you post
Golden Hours Finder: Heatmap showing exactly when to post for maximum engagement
Content DNA Analyzer: What separates the top 1% from everyone else
Competition Radar: Find low-competition, high-reward niches
AI Advisor: Claude-powered personalized recommendations
The dashboard is live. The code is available. And here’s the kicker. I built the entire 1,186-line dashboard using Claude Code with a single prompt.
LearnAIWithMe Paid Perks
The standard subscription ($12/mo or $100/year) gives you full access to all my articles and posts on Substack
The Founding Member tier ($200/year) includes everything above PLUS access to The Vault, 700+ prompts, projects, AI tools, and AI labs.
Now, let’s look at the prompt to build this Streamlit app without coding!