YouTube → BigQuery Starter — Let AI Tell You What to Film Next

BigQuery and turns it into a "Channel Doctor" report that tells you what to film

next — ranked by WATCH-TIME and traffic source, not vanity views.

I built this live with Claude Code. Now you can point it at your own channel.

WHAT'S INSIDE

• 4 ready-to-run Python scripts — a daily ETL into 5 BigQuery tables

(video info, channel-daily, per-video-daily, traffic source, impressions + CTR)

• "Channel Doctor" report generator — an interactive HTML brief that ends in

data-backed "make this next" recommendations

• A click-by-click HTML setup tutorial (your progress saves as you go)

• A Claude Code SKILL file — drop it in and Claude sets the whole thing up for you

• .env template + troubleshooting for every common gotcha

WHO IT'S FOR

Creators & faceless channels who want real data, and freelancers/VAs who want a

portfolio-grade data-automation project (YouTube API → BigQuery → reporting).

WHAT YOU NEED

A Google account + a Google Cloud project (free-tier friendly). Optional: a VPS

to run it 24/7. Beginner-friendly — the tutorial walks you through every click.

Note: thumbnail impressions + CTR come from YouTube's Reporting API and appear

~48 hours after first run (plus a 30-day backfill). Everything else is immediate.

☕ Less manual work, more time to create.