#11: What Podcasters can learn from Spotify’s data
Failed to add items
Add to basket failed.
Add to Wish List failed.
Remove from Wish List failed.
Follow podcast failed
Unfollow podcast failed
#11: What Podcasters can learn from Spotify’s data
-
Narrated by:
-
By:
About this listen
What Podcasters can learn from Spotify’s data
Spotify’s data is a goldmine for podcasters. It can help you understand your audience, improve your content, and grow your audience. Here are some of the most important things you can learn from Spotify’s data.
In the last episode, we talked about the Spotify API and how we access and store the data.
This time we pick up where we left off and talk about what you can do with the data and why it's important to own your data.
We expose the data in a SQL database and use metabase to visualize the data. (See also episode #8 for more on metabase, redash, grafana, and superset.)
With the data in a SQL database, we can do more powerful things like calculating averages and comparing episodes through SQL custom queries.
It's even more powerful when you store historical data. You can then correlate the data with other data sources (e.g. from different podcasts or hosts). It’s hard to retrieve historical data after the fact.
Users want to know if they have improved over time and compare between episodes. All of this is possible with historical data and graphs that are easy to understand.
Links- Our Open Podcast documentation: https://openpodcast.dev
- Open Podcast on Github: github.com/openpodcast
- Matthias Endler (https://twitter.com/matthiasendler)
- Wolfgang Gassler (https://twitter.com/schafele)
- Email: echo@openpodcast.dev
- Twitter: https://twitter.com/OpenPodcastDev
The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License.