Project

YouData

YouTube Analytics Scraper (CLI)

Overview

A CLI tool that fetches video statistics (views, likes, comments) from any YouTube channel, stores them in a SQLite database, and generates ranked reports in Excel. Helps content creators spot trending topics, analyse successful content strategies, and refine their own approach.

Key Features

  • Fetch by Date Range: Download video data for a single day, week, month, or custom period.
  • Top Videos Dashboard: Shows the top 10 videos from today, yesterday, and 2 days ago with trending keyword extraction.
  • Excel Export: Generate single‑day or combined date range reports in `.xlsx` format, sorted by views.
  • Channel Management: Add, delete, and switch between multiple YouTube channels.
  • Trending Keywords: Extracts and ranks frequent words from top video titles to identify popular topics.
  • Timezone‑Aware: Converts UTC publication times to your local timezone for accurate daily tracking.

Technologies

Python YouTube Data API v3 SQLite Pandas pytz openpyxl

Links

🐙 GitHub Repository 🔒 CLI tool (no web demo) 📬 I need something like this

YouData is a command‑line tool with no public web interface. Check the GitHub repo for installation and usage instructions.