全链路投放复盘

drama-pipeline-mcp / full-link report v2

全链路投放复盘 · 2026-05-28

13 节点漏斗 · 7 维拆细 · 05-28 00:00 → 05-29 00:00 GMT(账号TZ)

Report Ready

§0 · 总览 ad + drama + 收入一屏

总投放

$235.9

7 日均 $109.28

CPM

$48.71

≤ $50 优秀 · > $100 异常

CTR

18.75%

7 日均 18.08%

触达

4,181

freq 1.16

LPV

399

7 日均 85

新落地

479

7 日均 267

付费

已剔 $0 试用

ROAS

0.21

目标 ≥ 0.4

§1 · 全链路 13 节点漏斗 · Meta 8 + drama 5 05-28 00:00 → 05-29 00:00 GMT

Stage vs 展示 Count Drop

— Meta · 视频观看链 —

① 广告展示

4,842 —

② 独立触达 (reach)

4,181 -13.7%

③ Video 3s+ 观看

2,504 -40.1%

④ Video 50%

303 -87.9%

⑤ Video 75%

259 -14.5%

— Meta · 出站点击链 —

⑥ Link Click

528 —

⑦ Landing Page View

399 -24.4%

⑧ View Content (Pixel)

511 +28.1%

— drama · 后端漏斗 —

⑨ drama 新落地访客

479 —

⑩ PlayStart

228 -52.4%

⑪ 完整观看 (≥90%)

69 -69.7%

⑫ Paywall 触达 (≥EP10)

52 -24.6%

⑬ 付费

2 -96.2%

视频 3s 率

51.7%

3s→75% 留存

10.3%

吊起率 (Click→LPV)

75.6%

整体转化 (展示→付费)

0.0413%

§2 · 账号汇总 3 账号

账号	Spend	Imp	Reach	Clicks	CTR	CPM	LPV	VC
primary act_800509389474426	$0.00	0	—	0	0.00%	$0.00	0	0
secondary act_1152552146845197	$0.00	0	—	0	0.00%	$0.00	0	0
tertiary act_2316825152099128	$235.87	4,842	4,181	908	18.75%	$48.71	399	511

单条 ad CPM 极高 · 3 $204

`3` (campaign `Popularreels_FB_T1_20260524_Accidentally Slept with the Youn`) spend $48.28, imp 237, CPM $204。top 3 条这种高 CPM 的 ad 共占 $67.78 spend, 是均值被拉高的主要原因。

→ ACTION

把这几条 ad 单独 pause 或换素材重测; 保留 CPM < $100 的创意继续跑。

§3 · Campaign 细分 (全部跑量) 7 个 campaign

Campaign	Spend	Imp	Clicks	CTR	CPM	Video 3s	LPV	吊起率
Popularreels_FB_T1_20260524_Accidentally Slept with the Youn 剧目: Accidentally Slept with the Young Mafia Boss · tertiary	$59.68	279	44	15.77%	$213.91	124	20	45%
Popularreels_FB_T1_20260526_Accidentally Slept with the Youn 剧目: Accidentally Slept with the Young Mafia Boss · tertiary	$35.86	1,114	207	18.58%	$32.19	591	80	39%
Popularreels_FB_T1_20260526_Accidentally Slept with the Youn 剧目: Accidentally Slept with the Young Mafia Boss · tertiary	$35.27	1,279	214	16.73%	$27.58	611	94	44%
Popularreels_FB_T1_20260526_Accidentally Slept with the Youn 剧目: Accidentally Slept with the Young Mafia Boss · tertiary	$35.20	1,200	242	20.17%	$29.33	632	105	43%
Popularreels_FB_T1_20260528_Accidentally Slept with the Youn 剧目: Accidentally Slept with the Young Mafia Boss · tertiary	$33.52	402	77	19.15%	$83.38	248	52	68%
Popularreels_FB_T1_20260526_Accidentally Slept with the Youn 剧目: Accidentally Slept with the Young Mafia Boss · tertiary	$18.92	442	87	19.68%	$42.81	228	34	39%
Popularreels_FB_T1_20260526_Accidentally Slept with the Youn 剧目: Accidentally Slept with the Young Mafia Boss · tertiary	$17.42	126	37	29.37%	$138.25	70	14	38%

§4 · Ad 创意 Top 15 按 spend desc · 单条素材

Ad	Spend	Imp	Clicks	CTR	CPM	Video 3s	LPV
3 Accidentally Slept with the Young Mafia Boss · tertiary	$48.28	237	30	12.66%	$203.71	102	15
3 Accidentally Slept with the Young Mafia Boss · tertiary	$17.33	123	37	30.08%	$140.89	68	14
8 Accidentally Slept with the Young Mafia Boss · tertiary	$11.40	42	14	33.33%	$271.43	22	5
7 Accidentally Slept with the Young Mafia Boss · tertiary	$8.61	314	58	18.47%	$27.42	203	42
3 Accidentally Slept with the Young Mafia Boss · tertiary	$8.10	33	8	24.24%	$245.45	17	3
4 Accidentally Slept with the Young Mafia Boss · tertiary	$6.82	8	1	12.50%	$852.50	7	1
6 Accidentally Slept with the Young Mafia Boss · tertiary	$3.79	16	2	12.50%	$236.88	8	1
8 Accidentally Slept with the Young Mafia Boss · tertiary	$2.69	12	3	25.00%	$224.17	5	3
5 Accidentally Slept with the Young Mafia Boss · tertiary	$2.64	5	2	40.00%	$528.00	2	1
4 Accidentally Slept with the Young Mafia Boss · tertiary	$1.75	44	2	4.55%	$39.77	18	0
4 Accidentally Slept with the Young Mafia Boss · tertiary	$1.75	56	5	8.93%	$31.25	20	2
4 Accidentally Slept with the Young Mafia Boss · tertiary	$1.75	45	15	33.33%	$38.89	26	6
4 Accidentally Slept with the Young Mafia Boss · tertiary	$1.75	56	10	17.86%	$31.25	29	3
4 Accidentally Slept with the Young Mafia Boss · tertiary	$1.75	39	5	12.82%	$44.87	17	0
4 Accidentally Slept with the Young Mafia Boss · tertiary	$1.74	54	11	20.37%	$32.22	29	1

§5 · 国家拆分 4 国

国家	Spend	Spend %	Imp	Clicks	CTR	CPM	LPV	吊起率
US	$142.73	61%	2,171	380	17.50%	$65.74	166	44%
GB	$48.01	20%	1,775	334	18.82%	$27.05	154	46%
CA	$26.86	11%	484	112	23.14%	$55.50	39	35%
AU	$18.27	8%	413	82	19.85%	$44.24	40	49%

美国吃 61% spend, 吊起率 44%

US spend $142.73, clicks 380, LPV 166 → 吊起率 44%。对比非美国 (1.5x spend), 吊起率没相应低多少, 但 US 的 CPM 通常更高, 单 LPV 成本会被拉到不健康水平。

→ ACTION

考虑给非美国地区 (CA / GB / AU) 单独开 adset, 用更便宜的展示拿同样的 LPV。

§6 · 版位 (publisher_platform)

Platform	Spend	Imp	Clicks	CTR	CPM	LPV
facebook	$235.81	4,838	906	18.73%	$48.74	399
unknown	$0.06	5	2	40.00%	$12.00	0

§7 · 设备 (impression_device)

Device	Spend	Imp	Clicks	CTR	CPM
iphone	$149.21	2,908	490	16.85%	$51.31
android_smartphone	$75.59	1,631	370	22.69%	$46.35
desktop	$5.15	81	16	19.75%	$63.58
ipad	$4.44	170	19	11.18%	$26.12
android_tablet	$1.24	34	8	23.53%	$36.47
other	$0.24	19	5	26.32%	$12.63

§8 · 受众 (age × gender)

Age × Gender	Spend	Imp	Clicks	CTR	CPM
45-54 · female	$53.81	696	145	20.83%	$77.31
35-44 · female	$52.07	919	118	12.84%	$56.66
55-64 · female	$40.07	652	149	22.85%	$61.46
65+ · female	$39.81	802	218	27.18%	$49.64
25-34 · female	$28.66	581	58	9.98%	$49.33
18-24 · female	$6.56	174	36	20.69%	$37.70
25-34 · male	$3.88	102	9	8.82%	$38.04
65+ · male	$3.04	321	60	18.69%	$9.47
35-44 · male	$2.41	126	19	15.08%	$19.13
55-64 · male	$1.91	227	45	19.82%	$8.41
45-54 · male	$1.63	147	31	21.09%	$11.09
18-24 · male	$1.03	44	5	11.36%	$23.41
35-44 · unknown	$0.28	10	1	10.00%	$28.00
45-54 · unknown	$0.26	11	4	36.36%	$23.64
65+ · unknown	$0.24	14	1	7.14%	$17.14
25-34 · unknown	$0.11	4	2	50.00%	$27.50
55-64 · unknown	$0.09	12	7	58.33%	$7.50
18-24 · unknown	$0.01	1	0	0.00%	$10.00

video 3s→50% 只剩 12%

昨日 2,504 人看了 3s+, 但只有 303 撑到 50%。hook 抓住了人 (3s+ 还行), 但中段没接住, 大部分人在 3-15s 之间走了。

→ ACTION

拆 top 3 在跑素材, 看第 5-15 秒的画面/旁白节奏。换一版加快剧情冲突。

§9 · 剧目 × ROAS · drama Top 10 按 sessions desc · ROAS = 分摊收入 / Meta spend

Sessions

1,625

基线 877

独立访客

503

完播率

32.6%

平均观看

55.8%

Beacon Gap

60.90%

剧目	Spend (Meta)	Sessions	独立访客	平均完播	Paywall	Paywall %	单 Paywall $	分摊收入	ROAS
Accidentally Slept with the Young Mafia Boss Revenge · max EP 53	$235.87	1,450	489	52.5%	51	10%	$4.62	$44.60	0.189
Sinful Nights with My Ex's Uncle Romance · max EP 61	—	63	1	94.8%	1	100%	—	$1.94	—
The Foolish Heiress Strikes Back Romance · max EP 52	—	60	4	88.2%	1	25%	—	$1.85	—
The Alpha’s Hidden Heir Mafia · max EP 9	—	36	7	27.8%	0	0%	—	$1.11	—
Everybody Step Aside, The Matriarch Is Back Revenge · max EP 5	—	12	5	30.7%	0	0%	—	$0.37	—
Never Betray the Woman Who Built You Revenge · max EP 11	—	2	2	0.0%	1	50%	—	$0.06	—
Fired, Framed and Fierce Business · max EP 8	—	2	2	0.0%	0	0%	—	$0.06	—

落地→开播 47.6%

昨日新落地 479 人, 只 228 个点开视频, 剩 251 人到了页面就走。落地页加载、player 初始化、首图吸引力这三个地方最容易卡。

→ ACTION

看 CF Edge TTFB; play_sessions.ttff_ms 分布 (null + 长尾分开); 落地图 vs 广告 hook 是否一致。

paywall 触达 98% 集中在《Accidentally Slept with the Young Mafia Boss》

当日 paywall_clients 52 个, 其中 51 个来自《Accidentally Slept with the Young Mafia Boss》。其他剧带不动用户走到 EP10, 整盘对一部剧高度依赖。

→ ACTION

看 Top 2-3 剧的 EP1-EP3 hook 是否够强; 把广告里这些剧的素材改成 hook 更急的版本。

§10 · 收入 / WoW 2026-05-28 vs 2026-05-21

昨日

$49.98

2 付费 (剔 $0)

前 7 日均值

$19.99

0.9 付费/日

上周同日

$0.00

spend $74.84

WoW Δ 收入

—%

WoW Δ 投放

215.2%

ROAS 0.212 < 0.4

真付费 2 笔 ($49.98), spend $235.87。额外 0 笔免费试用待 D+7 验续费。

→ ACTION

1) 把高 spend / 低 paywall 的钱坑剧目暂停; 2) paywall 价格档位 A/B (当前只有 $13.99 Weekly?); 3) 看试用→续费转化拉数据。

§11 · 集数深度分布 (独立访客口径) drama play_sessions episode_index

集数深度	独立访客	drop	vs EP1
≥ EP1	503	—	100.0%
≥ EP3	119	-76.3%	23.7%
≥ EP5	88	-26.1%	17.5%
≥ EP10 (paywall)	52	-40.9%	10.3%
≥ EP15	4	-92.3%	0.8%
≥ EP20	3	-25.0%	0.6%

EP10 = paywall 集; EP10→EP15 大跌通常意味着 paywall 卡死 (用户不愿付); EP1→EP3 大跌意味着剧目开头钩子不强。

§12 · Stripe ↔ DB 对账窗口 GMT 05-28 00:00 → 05-29 00:00

Stripe 总

含 internal 0

complete

expired

进了 paywall 没付

真付 (external)

$49.98

试用 (external)

price=0 赠送

— 对账明细 —

来源	笔数	金额
Stripe external paid (price>0)	2	$49.98
DB recharge_records paid (price>0)	2	$49.98
Stripe external trial (price=0)	0	$0.00
DB recharge_records trial (price=0)	0	$0.00

— external 完成 sessions —

时间	Stripe id	Amount	Email
05-28 13:31 UTC	cs_live_b1a9k0Ac6qU4a4JL	$19.99	—
05-28 16:45 UTC	cs_live_b1JdQaWAf6vYAmzY	$29.99	—

— 诊断扩展 v2 —

维度×指标 cube + 逐集流失 + Paywall→Stripe 漏斗 + 数据缺口

cross-source 派生指标 (CPI/CAC/ARPU/付费率/D0 ROI) 按整体精确, breakdown 切片上不分摊。

诊断 · 总览 14 核心指标 cube new_users 479 · paid_uid 2

指标	值	公式 / 备注
spend	$235.87	Meta 总投放
CPM	$48.71	<$50 健康
CTR	18.75%	link_click / imp
3s 完播率	51.71%	video_view (≥3s) / imp
完播率 (p75)	10.34%	p75 / 3s · 长视频留存
CVR (LPV/click)	43.94%	实达落地 / 点击
吊起率 (PlayStart/click)	25.11%	起播 / 点击
CPI 注册 (proxy)	$0.49	spend / 新注册 (479)
purchase	2	DB recharges_external
付费用户成本 (CAC)	$117.94	spend / 付费 uid (2)
ARPU	$24.99	revenue / 付费 uid
付费率	0.42%	付费/注册 (2/479)
D0 ROI	0.2119	revenue / spend · 目标 ≥0.4
paywall 面板吊起率	⚠️ 缺埋点	paywall_impression / paywall_view

诊断 · Campaign × 指标 cube (n=8) 前端指标精确; purchase 来自 Meta omni_purchase action

campaign	spend	CPM	CTR	click	LPV	CVR	3s	3s 率	p75	p75/3s	init_ck	purch
PR_20260524_Accidentally Slept with the Young Mafia Bos	$59.68	$214	15.8%	27	20	74.1%	124	44.4%	13	10.5%	1	1
PR_20260526_Accidentally Slept with the Young Mafia Bos	$35.86	$32	18.6%	106	80	75.5%	591	53.0%	63	10.7%	0	1
PR_20260526_Accidentally Slept with the Young Mafia Bos	$35.27	$28	16.7%	121	94	77.7%	611	47.8%	63	10.3%	0	0
PR_20260526_Accidentally Slept with the Young Mafia Bos	$35.20	$29	20.2%	133	105	79.0%	632	52.7%	75	11.9%	1	0
PR_20260528_Accidentally Slept with the Young Mafia Bos	$33.52	$83	19.2%	75	52	69.3%	248	61.7%	7	2.8%	1	0
PR_20260526_Accidentally Slept with the Young Mafia Bos	$18.92	$43	19.7%	45	34	75.6%	228	51.6%	30	13.2%	0	0
PR_20260526_Accidentally Slept with the Young Mafia Bos	$17.42	$138	29.4%	21	14	66.7%	70	55.6%	8	11.4%	0	0
PR_20260526_Accidentally Slept with the Young Mafia Bos	$0.00	$0	0.0%	0	0	—	0	—	0	—	0	0

📊 观察

Top 1 campaign 吃 25% spend ($60/$236): Popularreels_FB_T1_20260524_Accidentally Slept wit
同剧 CPM 跨 campaign 极差: 《Accidentally Slept with the Yo》最低 $28 vs 最高 $214 (7.8×差); pause 高 CPM 那条
沉默 campaign: 1 个 spend≈0 (active 但没拉量), 确认 status 或者归档

诊断 · Ad × 指标 cube · Top 15 total raw n=101

ad	spend	CPM	CTR	click	LPV	CVR	3s	3s 率	p75	p75/3s	p100	init_ck	purch
3	$48.28	$204	12.7%	20	15	75%	102	43%	6	6%	5	1	1
3	$17.33	$141	30.1%	21	14	67%	68	55%	8	12%	4	0	0
8	$11.40	$271	33.3%	7	5	71%	22	52%	7	32%	5	0	0
7	$8.61	$27	18.5%	64	42	66%	203	65%	3	1%	3	0	0
3	$8.10	$245	24.2%	4	3	75%	17	52%	1	6%	1	1	0
4	$6.82	$852	12.5%	1	1	100%	7	88%	0	0%	0	0	0
6	$3.79	$237	12.5%	1	1	100%	8	50%	0	0%	0	0	0
8	$2.69	$224	25.0%	3	3	100%	5	42%	1	20%	0	0	0
5	$2.64	$528	40.0%	1	1	100%	2	40%	0	0%	0	0	0
4	$1.75	$40	4.5%	2	0	0%	18	41%	0	0%	0	0	0
4	$1.75	$31	8.9%	3	2	67%	20	36%	1	5%	0	0	0
4	$1.75	$39	33.3%	12	6	50%	26	58%	2	8%	1	0	0
4	$1.75	$31	17.9%	5	3	60%	29	52%	4	14%	4	0	0
4	$1.75	$45	12.8%	3	0	0%	17	44%	1	6%	0	0	0
4	$1.74	$32	20.4%	4	1	25%	29	54%	4	14%	2	0	0

📊 观察

高 CPM 钱坑 (3 条 CPM≥$150): 3 ($204) · 8 ($271) · 3 ($245); 累计 $67.78 被这些条吃掉, 建议优先 pause 重测
零 LPV 但有 click (2 条): 4 · 4; 点击吊不起来, 可能落地页跳错 / 商品 link 失效
高 CVR 潜力股 (1 条 CVR≥80%, spend<$5): 8 (CVR 100%); 加预算放量试

诊断 · 国家 × 指标 cube Meta breakdowns=country

国家	spend	CPM	CTR	click	LPV	CVR	3s	3s 率	p75	p75/3s	init_ck	purch
US	$142.73	$66	17.5%	225	166	73.8%	1119	51.5%	130	11.6%	1	1
GB	$48.01	$27	18.8%	197	154	78.2%	903	50.9%	85	9.4%	2	1
CA	$26.86	$55	23.1%	58	39	67.2%	268	55.4%	29	10.8%	0	0
AU	$18.27	$44	19.9%	48	40	83.3%	214	51.8%	15	7.0%	0	0

📊 观察

Spend 集中在 US (61%, $143)
CPM 性价比: GB $27 (最便宜) vs US $66 (最贵, 2.4×)
吊起率反差: AU CVR 83% (最强) vs CA 67% (最弱); 弱国家可能 in-app browser / Safari fallback 没适配

诊断 · 版位 × 指标 cube Meta breakdowns=publisher_platform

版位	spend	CPM	CTR	click	LPV	CVR	3s	3s 率	p75	p75/3s	init_ck	purch
facebook	$235.81	$49	18.7%	526	399	75.9%	2503	51.7%	258	10.3%	3	2
unknown	$0.06	$12	40.0%	2	0	0.0%	1	20.0%	1	100.0%	0	0

📊 观察

主导: facebook 吃 100% spend

诊断 · 设备 × 指标 cube Meta breakdowns=impression_device

设备	spend	CPM	CTR	click	LPV	CVR	3s	3s 率	p75	p75/3s	init_ck	purch
iphone	$149.21	$51	16.9%	305	236	77.4%	1541	53.0%	164	10.6%	1	1
android_smartphone	$75.59	$46	22.7%	189	136	72.0%	784	48.1%	78	10.0%	2	1
desktop	$5.15	$64	19.8%	7	7	100.0%	43	53.1%	2	4.7%	0	0
ipad	$4.44	$26	11.2%	16	12	75.0%	101	59.4%	12	11.9%	0	0
android_tablet	$1.24	$36	23.5%	6	6	100.0%	26	76.5%	2	7.7%	0	0
other	$0.24	$13	26.3%	5	2	40.0%	9	47.4%	1	11.1%	0	0

📊 观察

主导: iphone 吃 63% spend
CPM 差: ipad $26 最便宜 vs desktop $64 最贵; 高 CPM 设备看是不是错配人群

诊断 · 年龄×性别 × 指标 cube Meta breakdowns=age, gender

人群	spend	CPM	CTR	click	LPV	CVR	3s	3s 率	p75	p75/3s	init_ck	purch
45-54 · female	$53.81	$77	20.8%	81	68	84.0%	340	48.9%	38	11.2%	1	2
35-44 · female	$52.07	$57	12.8%	73	59	80.8%	380	41.3%	38	10.0%	0	0
55-64 · female	$40.07	$61	22.9%	79	61	77.2%	377	57.8%	41	10.9%	1	0
65+ · female	$39.81	$50	27.2%	100	66	66.0%	549	68.5%	65	11.8%	0	0
25-34 · female	$28.66	$49	10.0%	41	27	65.8%	220	37.9%	27	12.3%	0	0
18-24 · female	$6.56	$38	20.7%	23	22	95.7%	73	41.9%	15	20.5%	0	0
25-34 · male	$3.88	$38	8.8%	6	3	50.0%	37	36.3%	3	8.1%	0	0
65+ · male	$3.04	$9	18.7%	49	44	89.8%	205	63.9%	12	5.9%	0	0
35-44 · male	$2.41	$19	15.1%	16	7	43.8%	59	46.8%	6	10.2%	0	0
55-64 · male	$1.91	$8	19.8%	24	18	75.0%	145	63.9%	4	2.8%	0	0
45-54 · male	$1.63	$11	21.1%	21	13	61.9%	76	51.7%	4	5.3%	0	0
18-24 · male	$1.03	$23	11.4%	4	2	50.0%	14	31.8%	2	14.3%	0	0
35-44 · unknown	$0.28	$28	10.0%	1	1	100.0%	8	80.0%	1	12.5%	0	0
45-54 · unknown	$0.26	$24	36.4%	4	3	75.0%	8	72.7%	2	25.0%	0	0
65+ · unknown	$0.24	$17	7.1%	1	0	0.0%	3	21.4%	0	0.0%	0	0
25-34 · unknown	$0.11	$28	50.0%	2	1	50.0%	3	75.0%	0	0.0%	0	0
55-64 · unknown	$0.09	$8	58.3%	4	4	100.0%	7	58.3%	1	14.3%	1	0
18-24 · unknown	$0.01	$10	0.0%	0	0	—	0	0.0%	0	—	0	0

📊 观察

Top 3 人群吃 62% spend: 45-54·female / 35-44·female / 55-64·female
性别比: 女 94% (221$) / 男 6% (14$); 严重失衡 → 男性人群是否被算法误投

诊断 · 剧目 × 后端指标 drama play_sessions

剧目	category	sessions	独立访客
Accidentally Slept with the Young Mafia Boss	Revenge	1450	489
Sinful Nights with My Ex's Uncle	Romance	63	1
The Foolish Heiress Strikes Back	Romance	60	4
The Alpha’s Hidden Heir	Mafia	36	7
Everybody Step Aside, The Matriarch Is Back	Revenge	12	5
Never Betray the Woman Who Built You	Revenge	2	2
Fired, Framed and Fierce	Business	2	2

诊断 · 逐集流失 × 加载时长 per-drama × per-episode · 7 剧

独立访客口径; TTFF 单位 ms; 健康 <1000ms (橙) · >5000ms (红)

Accidentally Slept with the Young Mafia Boss

集	独立访客	sessions	drop	vs EP1	avg ttff	null ttff	avg watch
EP1	483	576	—	100.0%	1945	314	30%
EP2	134	155	-72.3%	27.7%	4222	43	51%
EP3	99	115	-26.1%	20.5%	2899	27	44%
EP4	82	90	-17.2%	17.0%	1781	20	50%
EP5	69	73	-15.9%	14.3%	2123	10	53%
EP6	59	64	-14.5%	12.2%	482	6	55%
EP7	54	57	-8.5%	11.2%	637	3	69%
EP8	51	56	-5.6%	10.6%	596	5	74%
EP9	47	61	-7.8%	9.7%	381	3	69%
EP10 🔴 paywall	50	65	+6.4%	10.4%	267	61	76%
EP11	20	22	-60.0%	4.1%	293	19	100%
EP12	11	13	-45.0%	2.3%	305	10	100%
EP13	5	11	-54.5%	1.0%	270	8	83%
EP14	5	10	+0.0%	1.0%	253	7	100%
EP15	4	4	-20.0%	0.8%	397	1	69%
EP16	2	2	-50.0%	0.4%	331	0	100%
EP17	2	2	+0.0%	0.4%	321	0	100%
EP18	2	2	+0.0%	0.4%	329	0	74%
EP19	2	2	+0.0%	0.4%	342	0	100%
EP20	2	2	+0.0%	0.4%	374	0	100%
EP21	2	2	+0.0%	0.4%	425	0	100%
EP22	2	2	+0.0%	0.4%	366	0	100%
EP23	2	2	+0.0%	0.4%	331	0	100%
EP24	2	2	+0.0%	0.4%	346	0	100%
EP25	2	2	+0.0%	0.4%	355	0	62%
EP26	2	2	+0.0%	0.4%	388	0	100%
EP27	2	2	+0.0%	0.4%	349	0	100%
EP28	2	2	+0.0%	0.4%	266	0	100%
EP29	2	2	+0.0%	0.4%	347	0	90%
EP30	2	2	+0.0%	0.4%	323	0	100%
EP31	2	2	+0.0%	0.4%	287	0	100%
EP32	2	2	+0.0%	0.4%	355	0	100%
EP33	2	2	+0.0%	0.4%	424	0	100%
EP34	2	2	+0.0%	0.4%	308	0	100%
EP35	2	2	+0.0%	0.4%	336	0	90%
EP36	2	2	+0.0%	0.4%	300	0	76%
EP37	2	3	+0.0%	0.4%	401	0	67%
EP38	2	2	+0.0%	0.4%	364	0	60%
EP39	2	2	+0.0%	0.4%	271	0	100%
EP40	2	2	+0.0%	0.4%	401	0	100%
EP41	2	2	+0.0%	0.4%	339	0	100%
EP42	2	2	+0.0%	0.4%	364	0	100%
EP43	2	2	+0.0%	0.4%	372	0	100%
EP44	2	2	+0.0%	0.4%	397	0	100%
EP45	2	2	+0.0%	0.4%	330	0	100%
EP46	2	2	+0.0%	0.4%	366	0	100%
EP47	2	2	+0.0%	0.4%	362	0	100%
EP48	2	2	+0.0%	0.4%	343	0	84%
EP49	2	2	+0.0%	0.4%	315	0	100%
EP50	2	2	+0.0%	0.4%	393	0	100%
EP51	2	2	+0.0%	0.4%	300	0	100%
EP52	2	3	+0.0%	0.4%	349	0	100%
EP53	2	2	+0.0%	0.4%	386	0	100%

Sinful Nights with My Ex's Uncle

集	独立访客	sessions	drop	vs EP1	avg ttff	avg watch
EP1	1	1	—	100.0%	366	100%
EP2	1	1	+0.0%	100.0%	294	100%
EP3	1	2	+0.0%	100.0%	347	50%
EP4	1	1	+0.0%	100.0%	329	70%
EP5	1	1	+0.0%	100.0%	262	100%
EP6	1	1	+0.0%	100.0%	420	100%
EP7	1	1	+0.0%	100.0%	410	100%
EP8	1	1	+0.0%	100.0%	475	100%
EP9	1	1	+0.0%	100.0%	353	100%
EP10 🔴 paywall	1	1	+0.0%	100.0%	355	100%
EP11	1	1	+0.0%	100.0%	413	100%
EP12	1	1	+0.0%	100.0%	385	100%
EP13	1	1	+0.0%	100.0%	292	100%
EP14	1	1	+0.0%	100.0%	329	100%
EP15	1	1	+0.0%	100.0%	327	100%
EP16	1	1	+0.0%	100.0%	329	100%
EP17	1	1	+0.0%	100.0%	340	100%
EP18	1	1	+0.0%	100.0%	328	100%
EP19	1	1	+0.0%	100.0%	418	100%
EP20	1	1	+0.0%	100.0%	368	100%
EP21	1	1	+0.0%	100.0%	411	100%
EP22	1	1	+0.0%	100.0%	346	100%
EP23	1	1	+0.0%	100.0%	294	100%
EP24	1	1	+0.0%	100.0%	331	100%
EP25	1	1	+0.0%	100.0%	406	100%
EP26	1	1	+0.0%	100.0%	414	100%
EP27	1	1	+0.0%	100.0%	431	100%
EP28	1	1	+0.0%	100.0%	560	100%
EP29	1	1	+0.0%	100.0%	374	100%
EP30	1	1	+0.0%	100.0%	349	100%
EP31	1	1	+0.0%	100.0%	361	100%
EP32	1	1	+0.0%	100.0%	353	100%
EP33	1	1	+0.0%	100.0%	378	100%
EP34	1	1	+0.0%	100.0%	425	100%
EP35	1	1	+0.0%	100.0%	344	100%
EP36	1	1	+0.0%	100.0%	401	100%
EP37	1	1	+0.0%	100.0%	325	100%
EP38	1	1	+0.0%	100.0%	345	100%
EP39	1	1	+0.0%	100.0%	344	100%
EP40	1	1	+0.0%	100.0%	365	100%
EP41	1	1	+0.0%	100.0%	415	100%
EP42	1	1	+0.0%	100.0%	437	100%
EP43	1	1	+0.0%	100.0%	326	100%
EP44	1	1	+0.0%	100.0%	451	100%
EP45	1	1	+0.0%	100.0%	478	100%
EP46	1	1	+0.0%	100.0%	324	100%
EP47	1	1	+0.0%	100.0%	368	100%
EP48	1	1	+0.0%	100.0%	412	100%
EP49	1	2	+0.0%	100.0%	365	44%
EP50	1	1	+0.0%	100.0%	426	15%
EP51	1	1	+0.0%	100.0%	70	100%
EP52	1	1	+0.0%	100.0%	439	100%
EP53	1	1	+0.0%	100.0%	361	100%
EP54	1	1	+0.0%	100.0%	383	100%
EP55	1	1	+0.0%	100.0%	402	100%
EP56	1	1	+0.0%	100.0%	376	100%
EP57	1	1	+0.0%	100.0%	418	100%
EP58	1	1	+0.0%	100.0%	486	100%
EP59	1	1	+0.0%	100.0%	364	100%
EP60	1	1	+0.0%	100.0%	450	100%
EP61	1	1	+0.0%	100.0%	350	100%

The Foolish Heiress Strikes Back

集	独立访客	sessions	drop	vs EP1	avg ttff	null ttff	avg watch
EP1	3	3	—	100.0%	1348	0	53%
EP2	2	2	-33.3%	66.7%	1312	0	56%
EP3	3	3	+50.0%	100.0%	450	0	38%
EP4	2	2	-33.3%	66.7%	405	0	51%
EP5	2	2	+0.0%	66.7%	371	0	52%
EP6	2	2	+0.0%	66.7%	436	0	57%
EP7 ⚠️ 加载慢	1	1	-50.0%	33.3%	84591	0	100%
EP8 ⚠️ 加载慢	1	1	+0.0%	33.3%	59543	0	100%
EP9 ⚠️ 加载慢	1	1	+0.0%	33.3%	87480	0	100%
EP10 🔴 paywall	1	1	+0.0%	33.3%	123134	0	100%
EP11 ⚠️ 加载慢	1	1	+0.0%	33.3%	122448	0	100%
EP12 ⚠️ 加载慢	1	1	+0.0%	33.3%	141996	0	100%
EP13 ⚠️ 加载慢	1	1	+0.0%	33.3%	113100	0	100%
EP14 ⚠️ 加载慢	1	1	+0.0%	33.3%	100827	0	100%
EP15 ⚠️ 加载慢	1	1	+0.0%	33.3%	77054	0	100%
EP16 ⚠️ 加载慢	1	1	+0.0%	33.3%	155824	0	100%
EP17 ⚠️ 加载慢	1	1	+0.0%	33.3%	136362	0	100%
EP18 ⚠️ 加载慢	1	1	+0.0%	33.3%	108231	0	100%
EP19 ⚠️ 加载慢	1	1	+0.0%	33.3%	108413	0	100%
EP20	1	1	+0.0%	33.3%	—	1	0%
EP21 ⚠️ 加载慢	1	1	+0.0%	33.3%	14451	0	100%
EP22 ⚠️ 加载慢	1	1	+0.0%	33.3%	94990	0	100%
EP23 ⚠️ 加载慢	1	1	+0.0%	33.3%	76049	0	100%
EP24 ⚠️ 加载慢	1	1	+0.0%	33.3%	113017	0	100%
EP25 ⚠️ 加载慢	1	1	+0.0%	33.3%	84053	0	100%
EP26 ⚠️ 加载慢	1	1	+0.0%	33.3%	138677	0	100%
EP27 ⚠️ 加载慢	1	1	+0.0%	33.3%	63002	0	100%
EP28 ⚠️ 加载慢	1	1	+0.0%	33.3%	72807	0	100%
EP29 ⚠️ 加载慢	1	1	+0.0%	33.3%	82631	0	100%
EP30 ⚠️ 加载慢	1	1	+0.0%	33.3%	109257	0	100%
EP31 ⚠️ 加载慢	1	1	+0.0%	33.3%	66543	0	100%
EP32 ⚠️ 加载慢	1	1	+0.0%	33.3%	99142	0	100%
EP33 ⚠️ 加载慢	1	1	+0.0%	33.3%	103185	0	100%
EP34 ⚠️ 加载慢	1	1	+0.0%	33.3%	61930	0	100%
EP35 ⚠️ 加载慢	1	1	+0.0%	33.3%	74049	0	100%
EP36 ⚠️ 加载慢	1	1	+0.0%	33.3%	72724	0	100%
EP37 ⚠️ 加载慢	1	1	+0.0%	33.3%	92254	0	100%
EP38 ⚠️ 加载慢	1	1	+0.0%	33.3%	90235	0	100%
EP39 ⚠️ 加载慢	1	1	+0.0%	33.3%	70129	0	100%
EP40 ⚠️ 加载慢	1	1	+0.0%	33.3%	70917	0	100%
EP41 ⚠️ 加载慢	1	1	+0.0%	33.3%	100338	0	100%
EP42 ⚠️ 加载慢	1	1	+0.0%	33.3%	100091	0	100%
EP43 ⚠️ 加载慢	1	1	+0.0%	33.3%	98783	0	100%
EP44 ⚠️ 加载慢	1	1	+0.0%	33.3%	87039	0	100%
EP45 ⚠️ 加载慢	1	1	+0.0%	33.3%	79263	0	100%
EP46 ⚠️ 加载慢	1	1	+0.0%	33.3%	80704	0	100%
EP47 ⚠️ 加载慢	1	1	+0.0%	33.3%	92678	0	100%
EP48 ⚠️ 加载慢	1	1	+0.0%	33.3%	78277	0	100%
EP49 ⚠️ 加载慢	1	1	+0.0%	33.3%	108738	0	100%
EP50 ⚠️ 加载慢	1	1	+0.0%	33.3%	67050	0	100%
EP51 ⚠️ 加载慢	1	1	+0.0%	33.3%	94422	0	100%
EP52 ⚠️ 加载慢	1	1	+0.0%	33.3%	88064	0	100%

The Alpha’s Hidden Heir

集	独立访客	sessions	drop	vs EP1	avg ttff	null ttff	avg watch
EP1	3	6	—	100.0%	796	0	30%
EP2 ⚠️ 加载慢	2	7	-33.3%	66.7%	22601	0	17%
EP3	1	3	-50.0%	33.3%	643	0	4%
EP4	1	3	+0.0%	33.3%	616	0	18%
EP5	2	4	+100.0%	66.7%	661	0	26%
EP6	2	4	+0.0%	66.7%	540	0	58%
EP7	1	2	-50.0%	33.3%	422	0	34%
EP8	2	3	+100.0%	66.7%	619	0	40%
EP9	3	4	+50.0%	100.0%	—	4	0%

Everybody Step Aside, The Matriarch Is Back

集	独立访客	sessions	drop	vs EP1	avg ttff	null ttff	avg watch
EP1	5	8	—	100.0%	498	2	35%
EP2 ⚠️ 加载慢	1	1	-80.0%	20.0%	6100	0	2%
EP3	1	1	+0.0%	20.0%	665	0	0%
EP4	1	1	+0.0%	20.0%	689	0	0%
EP5	1	1	+0.0%	20.0%	641	0	97%

Fired, Framed and Fierce

集	独立访客	sessions	drop	vs EP1	avg ttff	null ttff	avg watch
EP6	1	1	—	100.0%	2521	0	0%
EP8	1	1	+0.0%	100.0%	2316	0	0%

Never Betray the Woman Who Built You

集	独立访客	sessions	drop	vs EP1	avg ttff	null ttff	avg watch
EP1	1	1	—	100.0%	254	0	0%
EP11	1	1	+0.0%	100.0%	—	1	0%

📊 观察

EP1→EP3 钩子弱: 《Accidentally Slept with the Yo》483 → 99 (-80%); 前 3 集没留住人, 优先改前 3 集节奏
EP10→EP11 解锁意愿低: -60% 不愿付费看下一集; paywall 文案/价格/CTA 至少一个失效
异常大跌位置 (drop ≤ -50%): EP2 (-72%, 483→134), EP13 (-55%, 11→5), EP16 (-50%, 4→2); 看这些集是否有故障 / 内容崩塌

诊断 · Paywall → Stripe → 支付漏斗 window 05-28 → 05-29

阶段	count	段内转化	口径
⑫ Paywall 触达 (≥EP10)	52	—	DB play_sessions episode_index >= 10
⑬ paywall_impression	⚠️ 缺埋点	—	前端 paywall_impression event 未埋
⑭ paywall_cta_click	⚠️ 缺埋点	—	前端 paywall 按钮 click event 未埋
⑮ Stripe sessions total	5	9.6%	Stripe checkout.session.created
⑯ Stripe external	5	100.0%	剔 internal_test
⑰ Stripe complete	2	40.0%	session.status='complete'
⑱ Stripe expired	0	0.0%	进 paywall 没付
⑲ Stripe external paid (真付)	2	100.0%	complete & paid & amt>0; $49.98
⑳ DB recharges_external	2	—	对账金额 $49.98; 付费 uid 2

段间转化率：
• Paywall触达 → Stripe session: 9.6% (5/52; 缺 paywall_impression 中间节点)
• Stripe complete → 真付 (amt>0): 100% (2/2)
• Paywall触达 → 真付: 3.85% (2/52)

📊 观察

最大流失节点: Paywall触达 → Stripe session 丢 90%
Paywall → Stripe 转化只有 9.6% (5/52): 大量用户走到 paywall 但没点 CTA → paywall 设计需 A/B (文案/价格档位/按钮显著度)
整体 Paywall→真付 3.85% (偏低，目标 ≥5%)

诊断 · 数据缺口 frontend 埋点 + click_id 链路 todo

缺口	影响指标	补法
落地页加载时长 (Web Vitals: FCP/LCP/TTI)	无法定位 CVR (LPV/click) drop 是落地慢还是文案问题	前端注入 web-vitals.js → POST /api/v1/web-vitals → 新表 web_vitals(session_id, fcp, lcp, tti, inp)
paywall_impression / paywall_cta_click 埋点	无法测算 paywall 面板吊起率 + CTA 点击率	前端 paywall 组件 onMount → log_event('paywall_impression'); 按钮 onClick → log_event('paywall_cta_click')
ad/campaign × backend join (click_id ↔ play_sessions)	Breakdown 上的 CAC/ARPU/付费率没法算 (只能整体)	1) Meta CAPI 配 client_user_id; 2) drama 前端把 fbclid/click_id 写到 first_touch 字段
initiate_checkout 双口径差异	Meta omni_initiated_checkout vs Stripe sessions 数对不齐	对齐 Meta Pixel event 触发位置 + Stripe checkout.session.created 时间戳, 比一致性

生成时间 2026-05-29 · v2 (2026-05-25) chenkai 拍板重写 · 13 节点 + 7 维

数据源: Meta Insights API (actions[] + breakdowns) · drama Supabase (剔 @sandwichlab.ai + price=0) · Cloudflare Stream

口径: Stage ①-⑧ Meta events 计数 · ⑨-⑬ drama distinct 人数 · Meta 仅 date 粒度 2026-05-28 ~ 2026-05-28 (账号 TZ)

ROAS 按 sessions 占比分摊 (无 click-level join, AF Pull API 待开通)