One of the easiest dashboards I have made. Particularly since the data need not be cleaned so you can just reuse the template. Scroll down for instructions. 19,000 streamed songs in a year.
This is thanks to EU’s GDPR which mandates that consumers should have access to the company’s data about them. And even though I use Spotify in a non EU country, the fact that they are headquartered in Sweden (in EU) and they rely on a cloud provider that would have global resources means that I am eligible for GDPR’s rights too.
Caveat: Spotify even logs the songs that you skip over (so they have 0sec play time). Hence the
record count
can be slightly misleading. For context, I have 750 records with secPlayed=0, 5,000 records for <3sec 7,000 records for <15sec out of a total of 19,000 records.
To make this for yourself, just follow the instructions from here. I have added a lot more visualisations in my dashboard, so you might want to copy my report instead. You’ll just have to add a secPlayed
field (=msPlayed/1000
) in manage added data sources
.
This project leads to two other thoughts:
Other more evolved projects I found based on this data: