SoundExchange Reporting Blog

Thanks to all who attended my session Digital Media Metrics at the Public Radio Programming Conference here in Baltimore today. Also, big thanks to Mike Reszler of APM/MPR for, in actuality, graciously letting me horn in on what was originally his session, so I could present some streaming usage metrics that we’ve gleaned all that there SoundExchange data you guys send us each quarter.

Here, as promised, is my slide deck for your downloading pleasure: SoundExchange Reporting – PRPD 2011

As always, I’m greatly enjoying the PRPD conference and, in particular, meeting many of you in person. I’ll be here for the rest of the conference, often times hanging out at the NPR Digital Services booth, so please introduce yourself if you see me

Before getting into the main point of this post, allow me to remind all that the deadline for submitting your Q3 SoundExchange reporting data is this Friday, October 8, 2010. Sad, but true.

If you have already submitted data but haven’t checked with me yet, to ensure we have everything we need, please do so now!

If you haven’t yet submitted your Q3 SoundExchange data, then please, also, by all means, do so now!

Enough with the unpleasantries. I’m really writing here to let everyone know that Public Interactive has tweaked the statuses of your SoundExchange reports in Composer Basic and Pro. Previously, they were a bit confusing, so we’ve tried to  make them a little more self-explanatory. Here’s how they work now:

Incomplete – Means we haven’t received either playlist files and/or streaming logs from you.

Pending – Means we’ve received both playlists and streaming logs from you, but they haven’t been preprocessed. Before the final reports are generated, files get preprocessed to ensure they match our formatting and have the appropriate data fields. Playlist files get automatically preprocessed shortly after upload; streaming logs, on the other hand, get processed manually by PI staff, and so may take some time before they are preprocessed.

Ready – Means we have both playlists and streaming logs and that they’ve been preprocessed successfully to ensure we have enough data to generate a report; in other words, we have data from you and based on that we can generate a report.

Complete – The final report for SoundExchange has been generated.

Basically, this all means that reporting should work like this:

1. You upload your playlists and streaming logs to Public Interactive; your report status goes from Incomplete to Pending

2. PI successfully preprocesses your files, and your status goes from Pending to Ready.

3. Just before final submission to SoundExchange, PI generates the actual reports, and your status goes from Ready to Complete.

There you have it. Hopefully, this is somewhat less confusing than it was. If not, as always, contact me and I’ll try to clear it up…!

It’s probably not something worth blowing a vuvuzela over but, for better or worse, the deadline for submitting your station’s Q2 2010 SoundExchange reporting data to Public Interactive is quickly approaching: Friday July 9, 2010.

For those who are new to this process, or for those who don’t have it down pat yet, here are the basic SoundExchange reporting steps for this quarter:

1. Choose your 14-day reporting period for Q2 2010, which must be two 7-day-consecutive periods completely contained between April 1 – June 30
2. Create properly formatted playlist logs or, for Composer Pro clients, enter playlists with required reporting data directly into Composer Pro
3. Obtain streaming access logs from your stream host for your chosen reporting period (not required for PI streaming clients)
4. Upload playlist and streaming log files to Public Interactive using Composer Basic or Composer Pro
5. Update/enter the guide information for each of your content streams in Composer Basic or Composer Pro, so that we can integrate playlists for those syndicated shows that you stream
6. Specify the start dates of your two chosen reporting weeks using Composer Basic/Pro
7. Contact me to let me know you’ve uploaded your data, updated your guide(s) and specified your reporting dates
8. Have a beverage of your choosing to celebrate!

OK, let’s get this set of reports over with ASAP so we can all enjoy the summer!

As we quickly approach the next SoundExchange reporting deadline, here at Public Interactive we’ve made some tweaks to the SoundExchange Dashboard portion of Composer Basic and Composer Pro to (hopefully) make the reporting process a little bit easier.

Having now gone through two quarters of reporting with the Dashboard in place, it was clear that one of the biggest areas of confusion for stations has been how to specify their two chosen reporting weeks each quarter. Many folks didn’t know how to do this, as the screen used for it was hard to find. We’ve now made some changes in attempt to make it easier to complete this important step in the reporting process.

An aside, this step is particularly important because, if your station provides two weeks worth of reporting data but doesn’t specify which weeks in the quarter they pertain to, then SoundExchange will assume the data is not a sample but a census (that is a complete accounting) of all the recordings you streamed during the quarter. This effectively means you have under-reported and could, in theory, affect royalty payments to artists and key metrics used as benchmarks in the agreement between the CPB and SoundExchange (e.g. Music Aggregate Tuning Hours).

So, it’s very important you set these dates in the tool.

To try and make a little more obvious as to how and where to do so, we’ve made the following changes to the SoundExchange Dashboard:

1. The Select Report Dates screen can now be accessed from the global What do you want to do? navigation at the top of each page, under SoundExchange Dashboard:

Click to enlarge

2. The View Reports screen now displays the chosen reporting weeks for each of your content streams for the current reporting quarter, which are linked to the Select Report Dates screen:

Click to enlarge

3. The chosen reporting period for the current quarter is now also displayed on the Upload Playlists/Streaming Logs screen, and a link to the Select Report Dates screen is provided:

the

Click to enlarge

4. We’ve removed the previous functionality on the Upload Playlists/Streaming Logs screen that required you to specify the start and end dates for each individual playlist or streaming log file you uploaded to us. This was only causing confusion for users and these dates are now deduced from the files themselves.

5. If you have more than one content stream (e.g., an HD2 channel), you must specify reporting weeks for each one separately. You can now navigate between the Select Report Dates screens for each of your content streams by using the drop-down toggle we’ve added to the upper right hand corner of that screen (like you were already able to do on the upload logs and guide management screens):

Click to enlarge

Important reminder: when specifying your two chosen reporting weeks in Composer Basic or Pro, you specify the start dates of each week, rather than the start and end dates of your reporting period. We do it this way because stations are free to choose two non-consecutive reporting weeks.

OK, if you haven’t already, please go forth, gather and submit your Q2 reporting data!

Slowly but surely, Q2 2010 SoundExchange reporting data is starting to dribble in to us here at Public Interactive. Thanks to you early birds for getting us your data already!

For the rest of you, please please PLEASE don’t wait until the deadline to get us your Q2 data. I encourage you to submit your reporting data as soon as your reporting weeks are over! If you wait until the last minute, problems can arise (not to mention other important business like, say, pledge drives). The earlier you get us your data, the more time we have to work together to fix any data problems and ensure that PI can generate and submit reports on your station’s behalf.

Q2 2010 SoundExchange Reporting Steps:

1. Choose your 14-day reporting period, which must be two 7-day-consecutive periods completely contained between  April 1 – June 30
2. Create properly formatted playlist logs and obtain streaming access logs from your stream host for your chosen reporting period
3. Submit playlist and streaming log files to Public Interactive using Composer Basic or Composer Pro
4. Update/enter the guide (schedule) information for each of your content streams in Composer Basic or Composer Pro, so that we can integrate playlists for those syndicated shows that you stream
5. Specify the start dates of your two chosen reporting weeks using Composer Basic/Pro
6. Contact me to let me know you’ve uploaded your data, updated your guide(s) and specified your reporting dates
7. Complete all of these steps by Friday, July 9, 2010
8. Rinse, lather, repeat in Q3…

Of course, there are some exceptions to the above. For example, some stations (they know who they are) must report for the entire quarter. Also, Composer Pro clients that enter playlist data using that tool don’t need to upload playlist files, and PI streaming clients don’t need to upload streaming logs, etc. But, otherwise, them’s the rules.

Oh yes, if you produce a syndicated program and are not yet providing us with playlists, please review this page on what data we need from you, then contact me so we can start collecting your show’s data.

Wow – it seems like we just finished up gathering data for the Q4 2009 SoundExchange reports. But don’t look now, because just five weeks from this Friday – that’s Friday, April 9, 2010 – is the deadline to get Public Interactive your Q1 2010 SoundExchange reporting data!

Here, again, are the basics, which hopefully folks are getting familiar with:

1. All reporting data must come from within Q1 2010, that is between the dates of January 1 – March 31, 2010.

2. Playlist log files that meet our formatting requirements are required from all stations that are not PI Composer Pro clients. Also, streaming log files are required from all stations that do not host their streams through Public Interactive.

3. Any data files that need to be provided to PI should be uploaded to us using Composer Pro or Basic. To do that, go to Upload Playlists/Streaming Logs under SoundExchange Dashboard in the global navigation.

4. Every station that doesn’t report on the full quarter must specify the start dates of their two chosen reporting weeks using the SoundExchange Dashboard in Composer Pro/Basic. To do that go to View Reports under SoundExchange Dashboard in the global navigation then click on Edit Report Dates for Q1 for each of your streams. Then uncheck the Disregard dates and use full quarter instead check box and use the date drop downs to specify the two starting dates of your chosen reporting weeks.

5. If your station streams Classical 24 you must enter or update the guide information in Composer Pro/Basic for each stream to properly reflect when you streamed C24 during your reporting period, so that we can integrate those playlists into your reports. To do that go to Create/Edit Program Guide under Program Guide Composer in the global navigation. NOTE: When adding the Classical 24 program in your guide, be sure to set the Program Format to Classical: C24.

If you have already uploaded files to us and have not yet confirmed with me that we got them and they are in the correct format LET ME KNOW! Call or email me and I will verify whether we received your files and if the formatting is correct.

If you are not a Composer Pro client of ours and do not yet have your Composer Basic login, let me know and I will give that to you.

Finally, not many folks have weighed in on what they might like to learn from all this data that we’re collecting for SoundExchange reporting. We’d like to be able to give back and share information with the system, but we need your input! Take a look at this post and add your ideas as a comment.

Onward!

During our session on SoundExchange reporting at the PRIMA conference in New Orleans last week, an excellent question was posed: does Public Interactive have any plans to share information that could be gleaned from all of the playlist and stream listenting data that we’re collecting for reporting purposes?

Yes, indeed, a most excellent question!

The short-term answer is we don’t have a plan yet for reporting such information, because we’ve been quite busy just reaching out to stations, gathering data, building our tools like Composer Pro, and generating the quarterly reports. The long-term answer is most definitely yes! We would love to report back information and statistics that would be of interest to the system.

Now that the question has been raised – and now that we’ve gotten our reporting legs under us, a bit – we would like to begin generating and sharing aggregate information based on the data we’ve gathered.

The obvious question, though, is, what do you people want to know?

To that end, we’d like to begin soliciting your input on what type of information based on SoundExchange reporting data should we report back to the system? If you have any ideas or suggestions, please add them as a comment to this post, so all can see what others are interested in. Once we get an idea of what kind of information folks are interested in, we’ll see about generating some reports that answer your questions.

Keep in mind the following parameters:

• We can only share aggregate statistics, meaning we cannot share data for any specific station. Stations, of course, have access to their own SX reports that we generate via Composer Basic or Pro.

• We have two types of data upon which to draw:
  • Playlists (potentially) include the following information for each song streamed:
    • Song Title
    • Featured Artist
    • Album Title
    • Marketing Label
    • Song play frequency/time of each play/Actual Total Performances (number of people that heard a song)
  • Streaming access logs includes information about stream listening, such as time and duration of listener sessions.

• We can also break things down by stream format, which is identified as one of the following:
  • Classical
  • Jazz
  • Music Mix
  • News and Information
  • News/Classical
  • News/Jazz
  • News/Music Mix
  • Adult Album Alternative

So, we can answer – or try to answer – questions like:

What’s the most frequently played piece of music on classical streams?

What song was heard by the most listeners?

What are the peak listening hours for AAA streams?

Etc., and so on.

Think about it, noodle on it, kick it around a bit and let us know what you’d like to learn from all this. Once we get some feedback, we’ll figure out what the popular questions are and do our best to provide some answers both now and going forward.

Many of you already know this – or should know this – but the deadline to submit your station’s Q4 2009 SoundExchange reporting data to Public Interactive is two days away – Friday, January 15, 2010!

We’re up to our eyes, ears, noses and throats here already in Q4 data from stations (thanks to everyone who has already submitted their data!) but there are still a lot of you from whom we haven’t heard – so let’s get that data to us!

Here one more time, for the record, are the reporting particulars:

1. All reporting data must come from within Q4 2009, that is between the dates of October 1 – December 31, 2009.

2. Playlist log files that meet our formatting requirements are required from all stations that are not PI Composer Pro clients. Also, streaming log files are required from all stations that do not host their streams through Public Interactive.

3. Composer Basic users must accept the Terms of Service before we can officially accept your data and generate reports.

4. Every station (both Composer Pro and Basic users) must specify the start dates of their two chosen reporting weeks using the SoundExchange Dashboard in Composer Pro or Basic.

5. All stations that stream Classical 24 must enter or update the guide information in Composer Pro/Basic for each stream to properly reflect when you streamed C24 during your reporting period, so that we can integrate those playlists into your reports.

6. You should upload your data to Public Interactive using the SoundExchange Dashboard screens in Composer Pro or Basic. If you are not a Composer Pro client of PI and have not yet received a login to Composer Basic contact me and I’ll send you your login.

If you have already uploaded files to us and have not yet confirmed with me that we got them and they are in the correct format LET ME KNOW ASAP! Call or email me and I will verify whether we received your files and if the formatting is correct.

That is all for now.

A new year has begun which, aside from meaning that we’re all little bit older (as my kids enjoy reminding me of frequently), also means that anther calendar quarter has ended for which SoundExchange reporting data are soon due.

What better way to begin a new year than by meeting legal requirements? I don’t know about you but nothing better comes to mind for me.

As you should know by now, the mechanics of reporting to SoundExchange through PI changed a bit from Q3 to Q4, mainly with the release of Composer Basic (and the renamed and revamped Composer Pro for our previous Composer clients). Here are the main points to keep in mind:

1. All reporting data from Q4 2009 (that is data from between the dates of October 1 – December 31, 2009) must be in the required format and submitted to Public Interactive  by COB Friday January 15, 2010, in order for us to guarantee that we can generate and submit reports to SoundExchange on your station’s behalf.

2. Playlist log files that meet our formatting requirements are required from all stations that are not PI Composer Pro clients. Also, streaming log files are required from all stations that do not host their streams through Public Interactive.

3. Composer Basic users must accept the Terms of Service before we can officially accept your data and generate reports.

4. Every station (both Composer Pro and Basic users) must specify their chosen reporting dates using the SoundExchange Dashboard in Composer Pro or Basic.

5. Stations that stream Classical 24 – again whether you are a Composer Pro or Basic user – must  update the guide information for each of your streams in Composer to properly reflect when you streamed C24 during your reporting period, so that we can integrate those playlists into your reports. IMPORTANT NOTE: When adding the Classical 24 program in your guide, be sure to set the Program Format to Classical: C24.

All stations that have registered with Public Interactive for SoundExchange reporting should now have a login to either Composer Pro or Composer Basic. If you do not, contact me and I’ll send you your login.

If you have already uploaded files to us, whether via FTP or Composer Pro/Basic and have not yet confirmed with me that we got them and they are in the correct format LET ME KNOW ASAP! We’re still working out the kinks in the new tools and don’t want anybody to fall through the cracks.

OK, let’s all start the year by being fully compliant! Thanks as always for your efforts.

Before 2009 waltzes out of our lives, allow us here at Public Interactive to say thanks to everyone for their efforts in the realm of SoundExchange reporting this year! We appreciate all the hard work by stations that have submitted data to us for reporting back to SoundExchange. We appreciate it, the CPB appreciates it and, believe it or not, SoundExchange appreciates it! Honest.

Before everyone disappears to drink egg nog and whatnot I wanted to remind folks about a few key things to keep in mind for submitting your Q4 data for SoundExchange reporting to us .

By now, everybody who has opted to be covered by the CPB-SoundExchange agreement and registered with Public Interactive for SoundExchange reporting should have access to the tools we have developed to make data submission easier. This includes both Composer Pro clients of ours, as well as Composer Basic users. If your station is not a PI Composer Pro client and has not yet received a login to Composer Basic, please contact me and I’ll get you set up.

Lots of detail on Composer Basic is available here, so I won’t rehash it all in this post. Here are some important things for everyone to keep in mind:

1. Data for Q4 reports must come from with October 1 – December 31, 2009 (i.e. the fourth calendar quarter). Basic information on the reporting data that you need to provide to us is available here.

2. Composer Pro clients don’t need to submit playlist logs to us (assuming they actually put playlist data into Composer Pro); however, if your streams are not hosted by Public Interactive you will still need to upload your streaming access logs to us. Composer Pro documentation is available here.

3. Composer Basic users will need accept the Terms of Service before we can officially accept your data and generate reports. You will then need to upload playlist log files to us, in addition to streaming access logs. Composer Basic documentation is available here; in addition a Composer Basic Quick Start Guide is available here.

4. Everyone, whether you are a Composer Pro or Basic client, must specify their chosen reporting dates using the SoundExchange Dashboard in Composer Pro/Basic. If you don’t we’ll assume that you are supplying us with a full quarter’s worth of data and will generate reports based on that assumption. To set your reporting dates in Composer Pro or Basic, go to View Reports, then click on Edit Report Dates for Q4 for each of your streams. Then uncheck the Disregard dates and use full quarter instead check box and use the date drop downs to specify the starting date of both of your chosen reporting weeks. Make sure to do that for all of your streams for which you are supplying reporting data.

5. Stations that stream Classical 24 – again whether you are a Composer Pro or Basic user – must  update the guide information for each of your streams in Composer to properly reflect when you streamed C24 during your reporting period. This is so we can integrate C24 playlists into your your station’s reports. In the future will be collecting and integrating playlists for other syndicated shows. IMPORTANT NOTE: When adding the Classical 24 program in your guide, be sure to set the Program Format to Classical: C24.

All of this (file uploads, setting reporting dates, accepting TOS, etc.) needs to be done by the deadline of Friday, January 15, 2010 in order for us to guarantee that we’ll be able to generate and submit Q4 reports on your station’s behalf.

That’s it for now! I’ll be out of the office starting Christmas day and will be back on Monday, January 4, 2010. In the meantime, feel free to submit your data to us using Composer Pro or Basic. Let me know that you have and I’ll review it – or answer any questions – when I get back.

Thanks again and Happy New Year to all and to all a good night – or day, you know, depending on when you read this.