dws_log_domain_guid_extension_impress_kpis_d / _click_kpis_d;窗口 2026-05-13~06-11(近30天);均为事件级计数。| 服务 | impress_type | scene | 表面形态 |
|---|---|---|---|
| Inject·CB购物车 | CB | Injected | 购物车页内联返现条 |
| Inject·AT自动券 | AT | Injected | 购物车页内联试券入口 |
| Inject·PCP购物车 | PCP | Cart_Inject | 购物车页比价内联 |
| (PCP比价分析·后台) | PCP | Injected_Analysis | 商品页后台比价注入(量极大·非弹层) |
| Inject·Vio酒店 | AD | Vio_Injected | 酒店比价注入 |
| 悬浮球本体 | XF | FloatWin | 页面右侧浮球(出现即曝光) |
| 球内·优惠码 | CC | FloatWin | 展开浮球面板后·券模块 |
| 球内·AT / CB / 比价 / UGC | AT/CB/PCP/UGC | FloatWin | 展开浮球面板后·各服务模块 |
| 服务 | 用户何时看到 | 计数口径 | 示例 | 大盘CTR / 注意 |
|---|---|---|---|---|
| Inject·CB购物车 | 到购物车页,CB 弹窗被压制或被用户关闭后,把返现条内联注入到 selector 命中的 DOM 元素旁(before/after) | 曝光=注入元素进视口(非渲染即曝光);点击=点"激活返现" | temu 购物车结算按钮旁出现"预计返现 $X"内联条 | 2.97% · 必须 selector 命中 DOM,否则 30s 超时静默不出、零上报 |
| Inject·AT自动券 | 购物车页内联"自动试用优惠码"入口 | 同上(进视口/点击) | diy.com 购物车内联"帮你试券" | 13.3% · 航司/旅行类无购物车不适用 |
| Inject·PCP购物车 | 购物车/商品页比价内联 | 曝光/点击事件 | amazon 商品页比价模块 | 0.64% · 几乎全 amazon 后台注入,非弹层,CTR 不与其它可比 |
| 悬浮球本体(XF) | 页面右侧出现可拖拽圆球(弹窗/inject 之外的常驻入口) | 曝光=球渲染出现,同商家 2 小时去重上报;点击=展开面板 | 右侧浮球,点开 376px 面板(返现/券/比价/提现) | 3.44% · 曝光经 2h 去重,绝对值偏低,不与 inject 1:1 比 |
| 球内·优惠码(CC) | 用户展开浮球面板后,面板内的优惠码模块曝光 | 面板内模块曝光/点击 | 面板里"可用券 3 张"列表 | 17.1% |
| 球内·AT | 展开面板后的 AT 模块 | 同上 | 面板内"自动试券"按钮 | 50.2% · 展开球=高意向人群,故 CTR 高 |
| 球内·CB | 展开面板后的 CB 模块 | 同上 | 面板内返现激活 | 10.8% |
-- 数据源:数仓 dws_log_domain_guid_extension_impress_kpis_d / _click_kpis_d -- 时间窗口:近30天 2026-05-13 ~ 2026-06-11 SELECT impress_type AS svc, scene, SUM(impress_cnt) AS impr FROM dws_log_domain_guid_extension_impress_kpis_d WHERE impress_date BETWEEN '2026-05-13' AND '2026-06-11' AND (scene LIKE '%Inject%' OR scene LIKE 'FloatWin%' OR scene LIKE '%Ball%') GROUP BY impress_type, scene; -- 点击同理:_click_kpis_d / SUM(click_cnt) / click_date / click_type -- 大盘CTR = SUM(click_cnt) / SUM(impress_cnt) (按服务聚合)
WITH ib AS ( -- 曝光侧:按 (domain,服务) 聚合
SELECT domain,
CASE WHEN impress_type='CB' AND scene='Injected' THEN 'inj_CB'
WHEN impress_type='AT' AND scene='Injected' THEN 'inj_AT'
WHEN impress_type='PCP' AND scene='Cart_Inject' THEN 'inj_PCP'
WHEN impress_type='XF' AND scene='FloatWin' THEN 'ball_self'
WHEN impress_type='CC' AND scene='FloatWin' THEN 'ball_CC'
WHEN impress_type='AT' AND scene='FloatWin' THEN 'ball_AT'
WHEN impress_type='CB' AND scene='FloatWin' THEN 'ball_CB' END AS b,
SUM(impress_cnt) AS impr
FROM dws_log_domain_guid_extension_impress_kpis_d
WHERE impress_date BETWEEN '2026-05-13' AND '2026-06-11'
GROUP BY domain, 2),
cb AS ( -- 点击侧:同样的 CASE 归类
SELECT domain, /* 同上 CASE on click_type/scene */ ... AS b, SUM(click_cnt) AS clk
FROM dws_log_domain_guid_extension_click_kpis_d
WHERE click_date BETWEEN '2026-05-13' AND '2026-06-11'
GROUP BY domain, 2)
SELECT ib.domain, ib.b, ib.impr, COALESCE(cb.clk,0) AS clk,
COALESCE(cb.clk,0)/ib.impr AS ctr
FROM ib LEFT JOIN cb ON cb.domain=ib.domain AND cb.b=ib.b
WHERE ib.impr >= 500; -- 只看有足够曝光的 domain