ARPPU (Average Revenue per Paid User)

The average sales per paid users in the game.

Description

ARPPU (Average revenue per paid user) is a measure to use how much money the game is making per user. This is used to track the revenue sources and growth.

Sample Input

pay
time user_id price count
1416435585 2 100 3
1416435586 3 500 1
1416435587 5 100 10
1416435588 1 100 8
... ... ... ...

Query


to view this query

Sample Output

day arppu
2014-10-01 3.21
2014-10-02 3.64
2014-10-03 3.43
2014-10-04 3.21
2014-10-05 4.01
2014-10-06 3.21
2014-10-07 3.21
2014-10-08 3.64
2014-10-09 3.43
2014-10-10 3.21
2014-10-11 3.21
2014-10-12 3.64
2014-10-13 3.43
2014-10-14 3.21