SoundExchange Reporting Blog

As I have mentioned here before, we have posted guidelines for the formatting of playlist and streaming log files to be submitted to Public Interactive for SoundExchange reporting on this here blog. With the deadline for getting us your Q3 SoundExchange reporting data really not all that far off (seven weeks from Friday, but who’s counting?) – and since these guidelines have been tweaked a bit since first posted, I figured it was worth it to revisit these guidelines.

Streaming Access Log File Guidelines

Since, in general, streaming log files are produced by software applications (e.g. Windows Media, SHOUTcast, Icecast, Real, etc.) these really are just guidelines to make sure your server is logging the required data, since stations won’t generally have control over the formatting. We’re ready to work with the various formats produced by these tools, since there are only a handful of them that most stations use.

Playlist Log File Guidelines

Playlist log files, however, are another matter. These really are requirements, not just guidelines, in that we must have your data in a fairly specific format in order to make automated processing possible. Many stations track playlist data using a homegrown application or a spreadsheet, so it’s just not possible for us to try and accommodate the near infinite variety of possible data formats that could arise. For those that use commercial applications (e.g. Spinitron, MusicMaster, Liquid Compass, etc.) we have been working with the vendors where possible to communicate our formatting needs.

Please be sure to review our playlist file formatting requirements if you haven’t recently! If the data is not given to us in the required format we will not process it and won’t be able to submit reports on your behalf to SoundExchange.

Some of the finer points of the formatting to bear in mind:

• Files must be tab-delimited, text files (i.e. no spreadsheets, Word documents, PDFs, etc.)
• Please use the following exact field identifiers: Title, Artist, Album, Label, Start Time, End Time, Duration. Field ordering within the file doesn’t matter, so long as your are consistent throughout.
• Please do not include any other data in the playlist file, other than the header row and playlist entries (i.e. no schedule data)
• Start Time must include the date (i.e. one field for the start date and time, not two separate fields); same for End Time.
• Times must be in 24-hour format

If your station will be entering playlist data by hand, we have prepared an empty, sample spreadsheet that you could use as a starting point.

Download this sample playlist entry spreadsheet here.

It has all of the required fields (though remember that we only need either End Time OR Duration, not both), including the proper field headers, and formatting for start and end times. Once you enter your data you would simply choose to Save As a Tab Delimited text (.txt) file, which you can then send to Public Interactive. Voila!

These requirements are pretty well set now, but it’s possible we may tweak things if the need arises in the future. When and if that happens I will be sure to note it here in the blog. Thanks to everyone for your patience as we work the kinks out of this whole process.