| 口径 | 同批用户 + 顺序 + 窗口 |
|---|---|
| 数据 | 步骤事件明细 |
| 边界 | 多路径与回流 |
步骤漏斗
步骤漏斗
WITH step AS (
SELECT user_id, max(CASE WHEN step = 'view' THEN 1 ELSE 0 END) AS s1,
max(CASE WHEN step = 'cart' THEN 1 ELSE 0 END) AS s2,
max(CASE WHEN step = 'pay' THEN 1 ELSE 0 END) AS s3
FROM dwd_funnel_event
WHERE dt BETWEEN '2026-10-05' AND '2026-10-12'
GROUP BY user_id
)
SELECT sum(s1) AS v, sum(s2) AS c, sum(s3) AS p,
sum(s2) / sum(s1) AS cart_rate, sum(s3) / sum(s2) AS pay_rate
FROM step;窗口（如 7 日内完成）与步骤顺序是漏斗口径的核心参数，必须写进指标定义。