Note that we’ll be using the Track URL field as a unique identifier when we’re doing distinct counts of tracks since some songs may be named the same thing. Let’s start by analyzing the most popular tracks in Spotify’s Top 200 list. Drag the Spotify_Daily_Streaming CSV onto the Canvas.In the Connect pane, select “ Text file” and open the Spotify CSV we just downloaded. Note: I performed this for all available countries and dates prior to July 1st, 2019 and combined the csv’s into one file called Spotify_Daily_Streaming. Click “Download to CSV” in the top right-hand corner.For the purpose of this analysis, we will choose Daily and use the date dropdown to select the most recent date. You can also choose to select Daily or Weekly data. For this analysis, we’re going to focus on Global data so we can see listening habits by country. Use the dropdowns to filter by your specific country or select Global to see all country data.For this analysis, we will choose Top 200.
Select Top 200 or Viral 50 depending on the purpose of your analysis-to see top tracks or trending tracks.Navigate to to download data from Spotify’s Top Charts.Reference Materials Toggle sub-navigationįollow these steps to learn how to get the latest data from Spotify’s charts and bring it into Tableau for analysis.Teams and Organizations Toggle sub-navigation.
0 kommentar(er)
