Anyone processing CSV report files?

Question

question

Mike M asked Mar 15, '14

Anyone processing CSV report files?

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!

amazon appstore

10 |5000

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2014-03-24T11:44:25Z

Sujoy@Amazon answered Mar 24, '14

This is a question that community can help. We do not have any official parser available for you. :)

10 |5000

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2014-04-10T21:25:20Z

Mike M answered Apr 10, '14

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

10 |5000

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2014-04-14T05:36:16Z

Sujoy@Amazon answered Apr 14, '14

Thanks much Mattsenft. Really helpful and appreciated.

10 |5000

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question