ARPU (Average Revenue per User)

The average sales per users in the game.

Description

ARPU (Average revenue per 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

access
time user_id
1416435585 2
1416435586 3
1416435587 5
1416435588 1
... ...
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 arpu
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