Group and organize your iTunes sales stats
I've been watching my daily stats for my application (soon to be two applications). I haven't announced them here yet simply because I have updates pending, and I'd rather wait for the update to come out. The one app has been doing surprisingly well, but as the days go by, I keep getting frustrated with dragging files into Numbers and looking at them individually. Weekly reports are great, too, but then I saw this post over at tap tap tap in which they had pretty graphs for their numbers.
I decided it was time to write something to aggregate my daily dumps into a format that I could more easily graph. So, I created a short Python script to do the job. Introducing appstorestats.py, a simple script that scans its own directory looking for daily dumps from the iTunes store. It will then gather all the statistics and output several reports in a tab delimited format that Numbers (and I'm sure Excel) can read. It makes it a couple clicks to get a great graph for your data.
Reports are generated first for all applications found, and then also re-run for all applications combined.
The current reports are:
- Downloads per country per day
- Downloads per day
I plan on supporting date ranges in the future, but since no one has more than a month of data yet, I figured it wasn't important to implement tonight. Hopefully some people find this useful. If you have any suggestions for reports, you can either implement it and send it to me, or suggest it below. If you implement it yourself, it's more likely to be added.
If you'd like to get updates, you can check out the script from Subversion on Google Code.
Update August 8, 2008: Fixed a silly copy/paste error when outputting total downloads per day. Also, updates no longer are counted if they aren't paid.
Update August 10, 2008: Country names are now resolved.
Discuss | Posted on Thursday, August 07, 2008, in apple, iphone, appstats
