0.01
No release in over 3 years
Low commit activity in last 3 years
Allows easy calculation of revenue sharing by app and in-app purchases. Munges the monthly CSV reports from Google Play or Amazon Android app stores. Does Amazon currency conversions and verifies against payment amounts.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
 Dependencies

Development

~> 1.5
>= 0
~> 2.14
~> 0.18.1
~> 1.1.0

Runtime

~> 0.4.2
~> 0.18.0
 Project Readme

app_earnings

Process App Store monthly "raw" CSV files into a report by Application and IAP. Currently supports Google Play and Amazon Android marketplace data.

Background

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.

Description

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.

Installation

Install it yourself as:

$ gem install app_earnings

Usage

This will show the full set of current commands and options:

app_earnings help

Google Play Marketplace

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

Amazon Android Marketplace

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

Contributing

  1. Fork it ( http://github.com/eggheadgames/app_earnings/fork )
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Add some feature')
  4. Push to the branch (git push origin my-new-feature)
  5. Create new Pull Request