3 · IN THE PROJECT · METRICS
run
Game Metrics: ClickHouse Functions
DAU / MAU
CONTENTS
DISTRIBUTIONS
FUNNEL
uniq(player_id)
retention()
quantile(0.95)
windowFunnel()
GROUP BY toDate(ts)
Approximate: 0.3% error in the labor. uniqExact is accurate but more memory-intensive.
Retention (Day 0, Day 1, Day 7) per player, then sum: how many returned on D1 and D7 (P8).
p95 for damage, match duration, and ping. The mean hides the tail; quantileExact.
Tutorial steps -> match -> purchase within the time window: how many players reached each step.
Approximate functions account for a portion of memory and processing time, which is sufficient for dashboards. Money, rewards, and everything else the player perceives as fact are calculated precisely and serve as the source of truth.