YouTube & TikTok Trends 2025
Three-page analytics dashboard comparing content, posting patterns, and creator trends across TikTok and YouTube
Dashboard Preview
This project analyzes short-form and long-form performance across platforms using views, engagement, posting cadence, and creator-level signals. The goal is to help marketers and creators decide what to publish, when to publish, and who to partner with. At a glance:
- Overview summarizes total/average views, total videos, engagement velocity, and country engagement rate.
- Contents & Posting surfaces winning hashtags and titles, seasonal lifts, a country map, and publish-day spikes.
- Trends & Creators compares trend duration types, engagement by tier (Micro/Mid), and top creators by views/engagement.
Tools & Technologies
- Tableau Public (interactive analytics & dashboarding)
- SQL (PostgreSQL/MySQL) for ad-hoc EDA
Dashboard Pages
- Overview – total & average views, total videos, average engagement per creator, engagement velocity, duration of most viral video, engagement rate by country
- Contents & Posting – top hashtags, top titles, total views by season, map by country, publish day per platform, duration vs engagement
- Trends & Creators – creator handles, trend duration by type (short/medium/evergreen), engagement rate by tier, engagement velocity by trend label, top creators by views & engagement
Key Insights
- Scale & velocity: TikTok generally shows higher total views and faster engagement velocity, while average views per video are similar across platforms.
- Seasons & timing: Views peak in Summer/Fall, with a strong posting-day spike on Fridays; Sundays often underperform.
- Content cues: Actionable/utility titles and broad hashtags (e.g., #FYP, #Lifestyle, #Music) remain reliable reach drivers.
- Trend duration: Evergreen and medium-length trends contribute outsized, durable performance vs. short spikes.
- Creators: Mid-tier creators can deliver strong engagement efficiency; leaderboards surface high-ROI partners.