NPR

How can I download a CSV report of my new Audio Downloads data?

Once the dashboard view is loaded, a Download CSV link will appear in the top right corner of the page. Clicking the link downloads a zip file containing many CSV files, one for each query the dashboard is running behind the scenes. Not all of these contain relevant data. The highlighted ones in the pictures below will be most useful:

Overview CSVs

Description of each CSV file in the overview

File name suffix

Description

sas_downloads_overview-downloads_per_user_trend

Trended data from the Downloads per User line graph

sas_downloads_overview-downloads_trend

Trended data from the Downloads line graph

sas_downloads_overview-users_trend

Trended data from the Users line graph

sas_downloads_overview-platforms_table

Data from the Platforms table

sas_downloads_overview-platforms_trend

Trended data showing top 5 Platforms over time

sas_downloads_overview-programs

Downloads and Uses by program from the Programs table

sas_downloads_overview-segments_episodes

Downloads by segment or audio file from Segments / Episodes table

Program Drilldown CSVs

Description of each CSV file in the Program Drilldown

File name suffix

Description

sas_program_drilldown-platforms_table

Data from the Platforms table for the selected Program

sas_program_drilldown-platforms_trend

Trended data showing top 5 Platforms over time for the selected Program

sas_program_drilldown-program_downloads_per_user_trend

Trended data from the Downloads per User line graph for the selected Program

sas_program_drilldown-program_downloads_trend

Trended data from the Downloads line graph for the selected Program

sas_program_drilldown-program_users_trend

Trended data from the Users line graph for the selected Program

sas_program_drilldown-segments_episodes

Downloads by segment, episode or audio file from Segments / Episodes table for the selected Program


Questions? Having Trouble? Contact Station Relations

Did you find this article helpful?