Introducing the CSV exports
Published in Getting Started
While we do our best to offer a complete but easy-to-use interface, you may be interested in some cases to export raw data to build your reports or analysis with your own tools. This is possible for all our users with a BUSINESS subscription, as well as during the free trial.
Here is below the description of all the data you can export on Spot On Track, in CSV files.
Track exports
For one track, you can download the following data:
- Current Spotify charts
- Peak Spotify charts
- Current Apple Music charts
- Peak Apple Music charts
- All playlists (current , removed, from all platforms)
- Current Spotify playlists
- Removed Spotify playlists
- Current Apple Music playlists
- Removed Apple Music playlists
- Spotify playlists evolution
- Spotify streams (total and daily values)
Here is the format of the exports related to charts (items 1 to 4 from previous list):
- platform: spotify/apple
- date
- type: streams/viral for Spotify, songs for Apple Music
- frequency: daily/weekly for Spotify, empty for Apple Music (always daily)
- genre: empty for Spotify
- country_code
- country_name
- position
- previous_position
- streams: only for Spotify streams charts
Here is the format of the exports related to playlists (items 5 to 9 from previous list):
- platform: spotify/apple
- playlist_id: id on the streaming platform
- playlist_name
- playlist_link
- curator_id: id on the streaming platform, could be empty for Apple Music
- curator_name: could be empty for Apple Music
- added_at
- removed_at: empty if the track is still in the playlist
- current_position: empty if the track is not in the playlist anymore
- current_nb_tracks: current number of tracks in the playlist, empty if the track is not in the playlist anymore
- days_in
- followers: only for Spotify
Here is the format the exports related to playlists evolution (item 10 from previous list):
- platform: spotify
- date
- playlists: number of playlists that contained the track on that date
- followers: total followers of the playlists that contained the track on that date
Here is the format the exports related to Spotify stream count (item 11 from previous list):
- date
- total: total streams on Spotify. If the track has less than 1000 streams, Spotify gives no information, therefore we record the value 0.
- daily: daily streams on Spotify, computed based on this day et previous day total values
Playlist exports
The evolution of the number of followers from a Spotify playlist can be downloaded as a CSV. This file will contain the number of follower of the playlist for each date we have the data.
The columns of the CSV are as follows:
- date
- followers