918846 - Store USD amounts in monolith for aggregation of gross revenues.

Status: RESOLVED FIXED

(Marketplace Graveyard :: Payments/Refunds, defect, P2)

Description

[Rob Hudson [:robhudson]]

The idea here, in Wil's words:

"""
I liked the idea of storing 
USD at the time of purchase. We don't need a conversion API, we have 
price tiers, we can just use those. So, EUR1.59 would be stored as 
EUR1.59 and USD1.99 and if the tiers change in the future those two 
records would remain the same.
"""

This is for Monolith to have all values in USD so we can aggregate on them for charts and "top grossing apps" lists.

Comment 1

[Andy McKay]

This is stored in zamboni and is on the contribution record. Solitude doesn't actually know about the price tier at that point. The apps stats will need to do quite a bit of work to pull the information about apps, sellers and so on, wonder if it should do this too.

Comment 2

[Rob Hudson [:robhudson]]

Andy and I talked a bit more on IRC. Here's the current plan...

1. Monolith aggregator reads from the solitude logs on S3. For each completed transaction we...
2. Query the (to be created) Transaction API to get additional details about the transaction given the transaction ID in the solitude logs. The extra data we would want are the app ID, the amount in USD, whether this transaction was a regular purchase or in-app, and possibly some user information.
3. Write this data into monolith.

This will need a few bugs spawned off:
* Add an S3-based log reading to monolith-aggregator as a plugin.
* Add the transaction API to zamboni to get extra details about a transaction.

Comment 3

[Rob Hudson [:robhudson]]

This is done with https://github.com/mozilla/monolith-aggregator/commit/6e591da