858255 - Add "Gross Revenue" sub-graph

Status: VERIFIED FIXED

(Marketplace Graveyard :: Statistics, defect, P1)

Description

[Wil Clouser [:clouserw]]

Please add a new sub-menu item:
> Transactions
> -> Gross Revenue

This is a single line graph for revenue (although splitting by paid/in-app/total if possible would get you some bonus points).

Filters should be by date, region, *and carrier*.

This graph is available only to admins!

Comment 1

[Rob Hudson [:robhudson]]

This one will be interesting.

Some notes after talking with Andy:

* We have 2 sources of data that we can potentially get this information from: (1) zamboni and the contributions table, or (2) solitude and the solitude logs. Solitude seems the better source.

* Solitude writes out a log file on S3. We would need the credentials to access the S3 bucket to pull these logs from within Monolith. Monolith would probably need a plugin that knows how to pull data from S3.

* The log format in code is here: https://github.com/mozilla/solitude/blob/master/lib/transactions/models.py#L73  Note that it contains the amount and currency and that these values aren't normalized to a single currency. This may make aggregating across currencies difficult. We may have to show different charts per currency.

* Andy and I discussed adding price_tier to the log, but price tiers can change over time because of currency fluctuations which could skew the revenue.

Comment 2

[Wil Clouser [:clouserw]]

Having separate graphs per currency is fine, and we could add a "total in ____" with an asterisk that says it's based on current exchange rates and is an estimate.

Comment 3

[Rob Hudson [:robhudson]]

API side done in https://github.com/mozilla/zamboni/commit/0c6e43c 

Assigning to Davor to wire up to the stats front-end.

Comment 4

[Rob Hudson [:robhudson]]

Note: We decided to go with USD values only. The USD values are derived from the price tier near the time the transaction occurred (Monolith processes solitude's transactions each day).

Comment 5

[Rob Hudson [:robhudson]]

Actually, wrong bug. I mis-read this one for bug 858296 which is per-app gross revenue.

Comment 6

[Rob Hudson [:robhudson]]

https://github.com/mozilla/zamboni/commit/e685d55 and
https://github.com/mozilla/zamboni/commit/23dda6b 

Global stats documented here:
http://firefox-marketplace-api.readthedocs.org/en/latest/topics/stats.html#gross-revenue

Assigning to Davor for front-end.

Comment 7

[Davor Spasovski [:spasovski]]

https://github.com/mozilla/marketplace-stats/commit/776da6d

Comment 8

[Victor Carciu]

Verified as fixed : http://screencast.com/t/Hr1ju5ukxJKw