jinx.de
jinx.de


iTunes store sales statistic scripts (update)
Dienstag, 4. August 2009
Seems that Apple changed their iTunes connect webpage layout. The scanning of the page no longer worked, so I updated the scripts here. I’ll put them on GitHub once I’ve some spare time.
If you have an application in the appstore the following scripts might be of interest to you:
Downloading every day from the iTunes store (e.g. via crontab )
itunes.provisioning.download.perl
Logs in to the iTunes store looks up the Weekly and Daily files that it has not downloaded yet and does that.
Supplies the provisioning.download script with login and password from the keychain. You don’t need that when you change the provisioning.download script to contain the login and password in plaintext - I’m more paranoid, which is why I have them stored in the keychain.
This script works on the weekly or daily files and creates Tables for all the programs you sell/offer. You can directly pipe that to Tables ( or Numbers ) to create nice graphs like this:

So in a shell you would type:
TIN> mkdir itunesdownloads
TIN> perl itunes.provisioning.download.perl itunesdownloads
action url: /cgi-bin/WebObjects/Piano.woa/3/wo/emFestTest8ter2geTher/0.4
action url: /cgi-bin/WebObjects/Piano.woa/3/wo/emFestTest8ter2geTher/2.9
action url: /cgi-bin/WebObjects/Piano.woa/3/wo/emFestTest8ter2geTher/2.9
subaction url: /cgi-bin/WebObjects/Piano.woa/3/wo/emFestTest8ter2geTher/3.9
datetypeaction url: /cgi-bin/WebObjects/Piano.woa/3/wo/emFestTest8ter2geTher/3.9
Missing dates: 06/28/2009 Weekly.2009.06.28.txt.gz
Missing dates: 06/21/2009 Weekly.2009.06.21.txt.gz
Missing dates: 06/14/2009 Weekly.2009.06.14.txt.gz
Missing dates: 06/07/2009 Weekly.2009.06.07.txt.gz
Missing dates: 05/31/2009 Weekly.2009.05.31.txt.gz
Missing dates: 05/24/2009 Weekly.2009.05.24.txt.gz
Missing dates: 05/17/2009 Weekly.2009.05.17.txt.gz
Missing dates: 05/10/2009 Weekly.2009.05.10.txt.gz
Missing dates: 05/03/2009 Weekly.2009.05.03.txt.gz
Missing dates: 04/26/2009 Weekly.2009.04.26.txt.gz
Missing dates: 04/19/2009 Weekly.2009.04.19.txt.gz
Missing dates: 04/12/2009 Weekly.2009.04.12.txt.gz
Missing dates: 04/05/2009 Weekly.2009.04.05.txt.gz
downloading file: Weekly.2009.05.31.txt.gz
downloading file: Weekly.2009.05.24.txt.gz
downloading file: Weekly.2009.06.21.txt.gz
downloading file: Weekly.2009.06.14.txt.gz
downloading file: Weekly.2009.06.28.txt.gz
downloading file: Weekly.2009.04.05.txt.gz
downloading file: Weekly.2009.04.12.txt.gz
downloading file: Weekly.2009.05.10.txt.gz
downloading file: Weekly.2009.06.07.txt.gz
downloading file: Weekly.2009.05.03.txt.gz
downloading file: Weekly.2009.04.19.txt.gz
downloading file: Weekly.2009.05.17.txt.gz
downloading file: Weekly.2009.04.26.txt.gz
subaction url: /cgi-bin/WebObjects/Piano.woa/3/wo/emFestTest8ter2geTher/17.9
datetypeaction url: /cgi-bin/WebObjects/Piano.woa/3/wo/emFestTest8ter2geTher/17.9
Missing dates: 06/30/2009 Daily.2009.06.30.txt.gz
Missing dates: 06/29/2009 Daily.2009.06.29.txt.gz
Missing dates: 06/28/2009 Daily.2009.06.28.txt.gz
Missing dates: 06/27/2009 Daily.2009.06.27.txt.gz
Missing dates: 06/26/2009 Daily.2009.06.26.txt.gz
Missing dates: 06/25/2009 Daily.2009.06.25.txt.gz
Missing dates: 06/24/2009 Daily.2009.06.24.txt.gz
downloading file: Daily.2009.06.26.txt.gz
downloading file: Daily.2009.06.27.txt.gz
downloading file: Daily.2009.06.28.txt.gz
downloading file: Daily.2009.06.30.txt.gz
downloading file: Daily.2009.06.25.txt.gz
downloading file: Daily.2009.06.24.txt.gz
downloading file: Daily.2009.06.29.txt.gz
TIN> perl applereport.perl itunesdownloads/Daily.* |open -f -a Tables
Have fun with it - Jolly