Process App Store monthly "raw" CSV files into a report by Application and IAP. Currently supports Google Play and Amazon Android marketplace data.
Egghead Games is an independent app developer who has to provide monthly royalties to various licensors based on sales. None of the existing tools like Distimo or App Annie provided data that was sufficiently accurate to make payments. The stores provide data files (usually CSV) with the raw data, but processing these by hand or spreadsheet is painful. This command utility takes the CSV files and outputs sales by app and in-app purchase within the app. It takes into account refunds and currency conversions, so that the amounts given should exactly correspond to the payments made by the app store.
The Google Play and Amazon Android Marketplaces provide monthly earning reports in the form of CSV files.
This command line utility processes the transactions, groups them by app and in-app purchase (IAP), and produces the net dollar amount for each app. It includes the following features:
- handles returns
- provides sub-totals for IAPs, so you can see how much individual IAPs are earning.
- uses Amazon exchange rates to ensure that all amounts are in your final currency
- should handle non-USD Google Wallet accounts (though this is untested)
- JSON output is available, to make further processing simpler
By default, it provides simple text output.
Install it yourself as:
$ gem install app_earnings
This will show the full set of current commands and options:
app_earnings help
To process a Google Play monthly earnings report csv file into a text sales report:
app_earnings play PlayApps_201401.csv
Alternatively, you can get a JSON version of the data with:
app_earnings play PlayApps_201401.csv --format json
To process Amazon monthly earnings report files into a text sales report:
app_earnings amazon EarningsReport-Jan-1-2014-Jan-31-2014.csv PaymentReport-Feb-1-2014-Mar-1-2014.csv
Note that the payment report must be for the month after, as Amazon payments happen a month in arrears.
Alternatively, you can get a JSON version of the data with:
app_earnings amazon EarningsReport-Jan-1-2014-Jan-31-2014.csv PaymentReport-Feb-1-2014-Mar-1-2014.csv --format json
- Fork it ( http://github.com/eggheadgames/app_earnings/fork )
- Create your feature branch (
git checkout -b my-new-feature) - Commit your changes (
git commit -am 'Add some feature') - Push to the branch (
git push origin my-new-feature) - Create new Pull Request