Analytics Unscripted's podcast dashboard

I built a pipeline to pull my Substack podcast stats into BigQuery - so here's the payoff, live on this page. Download numbers for Analytics Unscripted, straight from that pipeline and refreshed every six hours.

Podcast downloads

This is the same idea as my live GA dashboard, pointed at a different, messier data source. Substack doesn't give you a proper way to get your podcast numbers out - so I reverse-engineered its API and piped the data into BigQuery. I wrote up exactly how in pulling Substack podcast data into BigQuery.

The dashboard below reads from those BigQuery tables rather than hitting the Substack APIs directly. That means this page is just doing the easy bit - reading clean data out of a warehouse and drawing some charts. Built using Recharts and styled to match the site, with Claude Code doing the front-end work.