Slide 32
Slide 32 text
基本KPI: ARPPU
日付、ユーザー別売上
さらに平均を求める
SELECT
DATE(purchase_dt) AS Dt,
user_id,
SUM(unit_price) AS Uriage
FROM tbl_receipt
GROUP BY Dt, user_id
ORDER BY Dt
SELECT
T.Dt AS Date,
FLOOR(AVG(T.Uriage)) AS ARPPU
FROM (
SELECT
DATE(purchase_dt) AS Dt,
user_id,
SUM(unit_price) AS Uriage
FROM tbl_receipt
GROUP BY Dt,user_id
ORDER BY Dt
) AS T
GROUP BY Date
32