| 起始 | 进入漏斗的实体 |
|---|---|
| 目标 | 达成行为 |
| 窗口 | 限时换算 |
转化率
转化率
WITH base AS (
SELECT user_id FROM dwd_event WHERE dt = '2026-10-05' AND action = 'click'
)
SELECT count(DISTINCT b.user_id) AS base_cnt,
count(DISTINCT p.user_id) AS paid_cnt,
count(DISTINCT p.user_id) / nullif(count(DISTINCT b.user_id), 0) AS cvr
FROM base b
LEFT JOIN (SELECT DISTINCT user_id FROM fact_pay
WHERE dt BETWEEN '2026-10-05' AND '2026-10-11' AND status = 'success') p
ON p.user_id = b.user_id;窗口外的后续支付不算转化：窗口变更等同口径变更。