Show HN: Google Analytics for Podcasts (Open Source)
4 コメント
clickable links: https://openpodcast.dev/demo , https://github.com/openpodcast
Nice stuff.
How do you get the data from the podcasting platforms like spotify/apple/youtube?
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.).
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.).
Seeing https://github.com/openpodcast/apple-connector and https://github.com/openpodcast/spotify-connector this looks like API scraping.
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.