Show HN: Google Analytics for Podcasts (Open Source)

11 points by mre 3y ago ↗ HN

We are building the open source tool Open Podcast, which provides deep listener insights to podcast hosts.

Demo dashboard here -> https://openpodcast.dev/demo

Get insights about your audience:

- Episode performance: When do people drop out? - What are interesting topics? How long do people listen to it? - Age/Gender groups and their favorite episodes. - Supports custom graphs and SQL queries (everything is transparent and open).

Tech details:

- Open Source! We love to get feedback or contributions at https://github.com/openpodcast - We extract data from Spotify and Apple and store all raw- and historical data in a MySQL database - More data sources (e.g. hosting platforms, Google, etc.) are planned - The raw data can be crunched, correlated, compared, and analyzed with any SQL-compatible tool (we recommend and use Metabase for our Demo)

You can run the full stack yourself using Docker images or reach out to us and we'll set up a hosted demo for you. We believe that Open Podcast will be a valuable tool for podcasters and help them grow their audience and improve their podcast's performance. Give it a try and let us know what you think! We're curious about your feedback.

4 comments

[ 3.3 ms ] story [ 21.9 ms ] thread

mtmail 3y ago ↗

clickable links: https://openpodcast.dev/demo , https://github.com/openpodcast

acecreamu 3y ago ↗

Nice stuff. How do you get the data from the podcasting platforms like spotify/apple/youtube?

andygrunwald 3y ago ↗

Seeing https://github.com/openpodcast/apple-connector and https://github.com/openpodcast/spotify-connector this looks like API scraping.

schafele 3y ago ↗

Hey (one of the authors here)!

We use the podcasters access which you get as the podcast host after claiming your podcast on apple or spotify. Using your host credentials, raw data is fetched from google/apple and stored in a local MySQL database. Subsequently, you can run custom queries on it and even derive additonal information which is not presented on apple's and spotify's podcaters dashboards (e.g. correlating data, using historical data, etc.).