Indie Artist Cross-Platform Performance Dashboard

Zero-cost analytics stack: Built entirely on free-tier tools (Python, MySQL, Looker Studio) with AI-assisted development, so the solution is fully sustainable without a platform budget.
Automated ETL pipeline: Ingests Spotify and Apple Music CSV exports alongside Instagram API data into one unified source, eliminating manual reporting and keeping the dashboard always current.
Social vs streaming ROI: Gave the artist a direct way to evaluate whether social media investment translates into streaming growth, informing smarter channel decisions.

#DataVisualization #BusinessIntelligence #Dashboard #MusicAnalytics #CrossPlatform

Challenge

For indie artists, growing an audience means juggling Spotify, Apple Music, and Instagram at once, but the data never talks to each other. Without a unified view, marketing decisions come down to guesswork. Cross-platform analytics tools exist, but they cost money most independent musicians do not have, and the tools do not tailor for individual needs.

Action

I built an automated Python and MySQL ETL pipeline that ingests Spotify and Apple Music CSV exports alongside Instagram API data and loads everything into a unified Looker Studio dashboard. The solution was designed to be zero-cost, running entirely on free-tier tools to keep it sustainable for an independent artist.

Result

The artist now has a single live view of cross-platform performance, saving 30% of yearly marketing costs by replacing guesswork with data-driven decisions on where to invest time and budget.