YouTube Analytics

The Situation

YouTube creators have rich analytics data in YouTube Studio but no way to turn it into strategic decisions. The platform shows numbers -views, retention, CTR -but not what they mean for your specific channel or what you should do next.

The Problem

The gap between 'here are your numbers' and 'here is what you should do next' requires analysis that YouTube Studio doesn't provide. Generic YouTube advice doesn't account for your specific audience, content mix, or posting patterns.

The Approach

Built a Python CLI that connects to real channel data via Google APIs, caches it in SQLite to conserve API quota, then optionally runs Gemini-powered video content analysis across 12 quality dimensions. Everything feeds into an interactive Claude session that acts as a dedicated content advisor with full knowledge of the channel.

What I Built

A terminal tool with four core capabilities: an interactive chat interface where Claude answers strategic questions using live channel data; automated snapshot reports capturing performance at a point in time; an SEO impact tracker that measures before-and-after results; and Gemini-powered content quality scoring covering hook strength, thumbnail effectiveness, speech pacing, SEO, and more.

The Stack

The Result

After implementing SEO recommendations from the advisor: views per video increased by 549%, subscriber efficiency up 16.8x. In the following seven days: views up 154.7%, watch time up 535%.