Average Page Views per User

The average number of page views per user.

Description

The average number of page views per user. This is often used to measure the average engagement of the web site.

Sample Input

access
time user_id
1416435585 2
1416435586 3
1416435587 5
1416435588 1
... ...

Query


to view this query

Sample Output

day average_pv
2014-10-01 6.21
2014-10-02 1.21
2014-10-03 7.1
2014-10-04 6.1
2014-10-05 4.1
2014-10-06 3.1
2014-10-07 1.1
2014-10-08 3.0
2014-10-09 1.1