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.

• 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.