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.
Vault
Paid subscribers can not only read articles but also access the vault. We have many new and exciting features.
You can now build infographics simply by clicking with Nano Banana Pro.
Also, now, you can talk with AI projects with this new agent!
Now, let’s look at the prompt to build this Streamlit app without coding!