24 hours of iTMS

I’ve been tracking the number of songs distributed from iTunes Music Store for the past 2472 hours, using the numbers on Apple’s homepage since noon on July 6. In 24 hours Apple distributed 483,091 songs, going from 96,995,792 to 97,478,883, averaging 20,128 songs/hour. At the current rate, my Excel spreadsheet (my first!) says that 100 million songs contest will end at 5:14 PM 12:55 PM EDT on July 12th. This is almost certainly wrong as sales will speed up as the number approaches 100 million, but this just gives a general idea of how many songs Apple distributes.
You can download the raw data or my Excel file if you like. I’ll try to update this post and the Excel file at least every 24 hours until Apple stops posting the numbers. Also, there’s no purchase necessary, you can enter the 100 million songs contest for free.
The contest ended at 1:21 AM EDT July 12, but they kept updating the numbers for another 13 hours. I’ve posted the final data and spreadsheet, which goes from noon on July 6th (96,995,792 downloads) to 2:30 PM on July 12th (100,192,509 downloads). If you need iTunes Music Store statistics, this provides a pretty granular view, although it’s most likely distorted due to the contest. Fin. [Last updated: July, 14 @ 9:00 AM]

5 thoughts on “24 hours of iTMS

  1. Conditional formatting and estimated chances of winning would make your Excel file that much better. How much better? That much better. 🙂

  2. Thanks for the suggestions, but I’m not sure what I could use conditional formatting for. Like I said, this is my first Excel spreadsheet, but I’ll look into it.
    As for the estimated chance of winning, I put it at zero. I may be underestimating it, but only slightly 🙂

  3. You could use conditional formatting to show the difference between the positive and negative numbers/percentages. For example you could make all of the positive numbers in the “Change” and “% Change” columns green and all of the negative numbers red. This would allow someone to quickly identify numerical trends simply based on the color of the data (without actually reading the data).
    The calculations and general structure are quite good for your first attempt at creating an Excel worksheet.
    As for my estimated chance of winning… definately zero, since I haven’t entered. 🙂

Leave a Reply