| DAU | 日去重活跃 |
|---|---|
| MAU | 月去重活跃 |
| 粘性 | DAU/MAU |
粘性
粘性
SELECT
(SELECT count(DISTINCT user_id) FROM dwd_active_user WHERE dt = '2026-10-12') AS dau,
(SELECT count(DISTINCT user_id) FROM dwd_active_user
WHERE dt BETWEEN '2026-10-01' AND '2026-10-31') AS mau;月末未过完时 MAU 是「滚动 30 天」口径，与完整月不可比。