Data Analytics🔨 Personal Project

YouTube Trends Analyzer & Content Calendar

Comprehensive tool for analyzing trending topics via Google Trends, tracking competitor YouTube channels, scoring videos for Shorts potential, and generating 7-day content calendars with automated recommendations.

Project Overview

🎯

Objective

Provide data-driven insights for YouTube Shorts content strategy by monitoring trends, analyzing competitors, and automating content planning

💼

My Role

Data Analyst & Developer - designed scoring algorithms, API integrations, and automated reporting system

⏱️

Timeline

2 weeks

🛠️

Tech Stack

Python, Google Trends API, YouTube Data API

📈

Key Results

  • 4 integrated modules: Trending topics monitor, competitor tracker, video analyzer (scoring 0-100), content calendar generator
  • Scoring criteria: Engagement (30%), Content quality (25%), Recency (15%), Duration (15%), Viral potential (15%)
  • Daily themes with optimal posting times (Mon: Motivasi 7AM, Tue: Tutorial 12PM, etc.)
  • Output formats: JSON reports, CSV exports, console dashboards with actionable recommendations
Impact
50+ videos analyzed per run
Value
7-day automated content calendar
📸

Visual Documentation

Project screenshot 1
Screenshot 1
Project screenshot 2
Screenshot 2
Project screenshot 3
Screenshot 3

🔗Project Links

GitHub RepositoryPrivate

Tools & Technologies

PythonGoogle Trends APIYouTube Data APIyt-dlpPandas
💼

Let's Work Together

I'm available for freelance projects and consulting. Let's discuss how I can help your business achieve its goals through data-driven solutions and technical expertise.

Available for freelance projects