Podcast Analytics Warehouse

What they needed

Monthly Spotify exports and manual metrics lived in Sheets. The client wanted a Postgres warehouse with custom multipliers, demographics, and history — EU-friendly hosting in mind.

What I delivered

• PostgreSQL schema for podcasts, Spotify snapshots, manual inputs, demographics, social, users
• Python ETL importers for the monthly file types
• ER diagram, requirements pack, and demo recording

Why it helped

Podcast numbers accumulate in one warehouse with a repeatable import path instead of a growing spreadsheet pile.

Tech in the build

Access