← All posts
Claude AIAutomationBigQueryYouTube

My "Viral" Videos Were 54% Ads — I Had Claude Build a YouTube Analytics AI to Prove It

I connected Claude to my YouTube Analytics, had it build its own BigQuery pipeline, then a "Channel Doctor" report that tells me what to make next. Here's the reveal and the full build.

June 30, 2026

▶ Panoorin ang full video

Hey 👋

I’ll be honest: for the longest time I thought some of my videos were “viral.” Thousands of views — it felt like a win. But when I had Claude read my real analytics… it flipped everything I believed.

Those “viral” videos? ~54% of the views were paid ads — with only 5% retention (people drop off fast). My “boring” tutorials? 25–41% retention. The ones I thought were winners weren’t. The ones people actually watch to the end were the tutorials.

Here’s how I found out — and how you can too.

The problem: the real data is hidden

YouTube Studio is limited. The impressions, CTR, traffic source, and retention — the numbers that tell you what’s actually working — aren’t easy to get. They’re locked away.

So instead of guessing, I had Claude build its own data system.

What Claude did (not me!)

Here’s the fun part — I didn’t write the code. Claude wrote the Python and built the whole pipeline itself:

  • Pulled my real analytics via the YouTube Analytics API
  • Loaded it into BigQuery — 5 tables (video info, daily channel, per-video, traffic source, impressions)
  • Backfilled the history, then put it on a daily cron — it updates itself every day. Set-and-forget.

Not everything was smooth — expired auth, API limits, random errors. That’s real debugging, part of any real build. But the result: a warehouse of my real data, always up to date.

The punchline: “Channel Doctor”

I had Claude read the whole warehouse, and it produced a report — I call it “Channel Doctor” — that recommends my next 3 videos, based on the real data. No more guessing.

And that’s where the 54% ads reveal came out. 😩 Painful, but exactly the kind of truth I needed to make better decisions.

Now, every month Claude tells me what’s working and what I should do next. That’s the real power — not the dashboard, but the AI with access to your real data.

Want to do the same?

I packaged the whole YouTube→BigQuery Starter (scripts + Channel Doctor + setup tutorial) on Buy Me a Coffee — grab it, paste it in, point it at your channel, done: YouTube→BigQuery Starter

To run your pipeline 24/7, mine lives on a Hostinger VPS: hostinger.com/lakwatseros (code: LAKWATSEROS).

Watch the full step-by-step build in the video below. Less manual work, more lakwatsa. 🌴