| 静默期 | 30/60/90 天按业务定 |
|---|---|
| 订阅 | 到期未续费 |
| 分母 | 期初在册实体 |
静默流失
静默流失
SELECT count(DISTINCT u.user_id) / (SELECT count(DISTINCT user_id) FROM dim_user_active WHERE dt = '2026-09-01') AS churn_30d
FROM dim_user_active u
WHERE u.dt = '2026-09-01'
AND NOT EXISTS (
SELECT 1 FROM dwd_active_user a
WHERE a.user_id = u.user_id AND a.dt > '2026-09-01' AND a.dt <= '2026-10-01');验证期不完整（如统计日刚过静默期一半）时结果不可比，标注数据成熟度。