Full Data Export

[DLu]

What problem does this address?

I loved the End of Year feature (#410) but it left me with more questions about my Pocket Casts habits. I know you can export your subscriptions, and that there are stats for total days listened and days saved, but I would like even more.

(Side note: I'm an American, but I feel like this is something that sometimes goes hand in hand with GDPR Data Portability requirements.)

What is your proposed solution?

An additional export option for outputting JSON/XML/CSV of all listening data available.

Did you search for existing feature suggestions?

• [X] I have searched for existing feature suggestions.

[geekygecko]

Thanks for the great suggestion. I have noticed in our emails other requests to export the listening history. We could include this in the settings "Import & export" section. It's a shame there isn't an open standard for sharing listening history similar to OPML.

Are there any improvements you would like to see on the stats page? We would like to improve this too.

[DLu]

Off the top of my head, some of the stats from the End of Year, like number of unique podcasts listened to, number of episodes listened to. Perhaps average episode length. Number of podcasts which you've listened to the entire catalog.

[CookieyedCodes]

I would also like stats to break down how many hours you have listend to each podcast & be a permanent archive for end of year stats :) More stats are allways great ❤️❤️

[yevgenypats]

Hey team 👋 ! Im Yevgeny, maintainer and founder @ CloudQuery, an open source high performance ELT framework.

We would love to help with an initial version of CloudQuery source plugin, if you can help us maintain it. It should solve this issue and enable your users to sync Swetric data to any database/datalake of the growing number of CQ destinations.

See similar thing we did with Plausible API, Plausible Docs and discussion

[DLu]

I think about this issue more than I'd like to admit and wish that I could contribute. Is there a way to obtain my own SQL database for my listening data? (I'm an experienced open source dev, but none in Android/mobile development)

[drdavient]

would also love to have access to this data :)

[MtndaleRedneck]

Thanks for the great suggestion. I have noticed in our emails other requests to export the listening history. We could include this in the settings "Import & export" section. It's a shame there isn't an open standard for sharing listening history similar to OPML.

Are there any improvements you would like to see on the stats page? We would like to improve this too.

Breakdown by day/week/month/year content listened to.

[DLu]

Via https://github.com/Automattic/pocket-casts-android/discussions/1326 I now have access to my own data

[DLu]

I am disappointed to discover that the data does not contain my entire listening history.

• If you unsubscribe from a podcast, the corresponding episodes are removed from the podcast_episodes table.
• If the podcast rss feed does not keep the complete catalog, only the "available" episodes are in the database.

However, I feel like what's in the table is NOT the complete collection of data, given that totalling up my played_up_tostats results in 70% of the number of days I've listened according to the stats page in the app.

[obskyr]

I have years and years of listening data in my Pocket Casts, and my phone is… very much dying! This feature would save me hours of work and probably months of confusion once I switch.