Is anyone processing the CSV files that Amazon makes available? E.g. the EarningsReport or PaymentReport? I need to be able to pay licensees based on the data, and it's tedious going through and separate out revenue by app, and then allowing for currency conversions etc. I'm hoping someone else is already doing this. Fwiw, I've started to write this code for Google Play CSV files and will open source it when it's done (in the next week or two). If someone has made a start for Amazon, that would save me some time. Or, if anyone is interested in joining in, I'll take the help! (I tried using both Distimo and AppAnnie for this, but the numbers never quite match the store numbers, so I can't rely on them for paying licensees unfortunately!) thx!
My company ended up designing and building a tool to do this (it also works with Google Play transactions). We open sourced it at:
https://github.com/eggheadgames/app_earnings If you have suggestions (or pull requests!), please add them directly at github. I really hope this is useful to others as well! Note that it uses both the Amazon earnings and payments files and takes into account the currency conversion rate used. Thus you can attribute to every app and IAP exactly the amount that was deposited into your bank account. E.g. you can run it with something like: 1. Download the earnings report for, say, Jan 1 to Jan 31 2. Download the corresponding payment report for, Feb 1 to Mar 1. 3. Install the app_earnings tool from
https://github.com/eggheadgames/app_earnings 4. Run it with: app_earnings amazon EarningsReport-Jan-1-2014-Jan-31-2014.csv PaymentReport-Feb-1-2014-Mar-1-2014.csv This will output something like (fake data & names): Yahtzee Transactions: CHARGE: 82 Total: USD $223.55 Sub totals by IAP: yahtzeevol2 - Yahtzee Volume 2: USD $35.53 yahtzeevol3 - Yahtzee Volume 3: USD $16.72 yahtzeevol4 - Yahtzee Volume 4: USD $14.55 yahtzeevol5 - Yahtzee Volume 5: USD $12.54 yahtzeevol6 - Yahtzee Volume 6: USD $12.54 yahtzeevol7 - Yahtzee Volume 7: USD $8.36 yahtzeevol8 - Yahtzee Volume 8: USD $6.27 yahtzeevol9 - Yahtzee Volume 9: USD $4.18 .... more app data goes here Total of refunds: USD $4.18 Total of all transactions: USD $456.78