Desire Onboarding SOT 원장

Desire Onboarding SOT 원장 (v1 / v2 / /create / 콘 / 구독 / OS)

mart.mart_aarrr_device와 mart.stg_experiment 기준 단일 조인 쿼리로 집계된 6대 순수 원장(Ledger)입니다.

1. v1 vs v2 총괄 비교 원장

experiment_id variant devices msg_devices start_pct reach5_devices handoff_devices payers pay_cvr_pct con_payers sub_payers total_tx repeat_payers revenue_krw arpu_krw arppu_krw paid_d1_msg_devices paid_d1_retention_pct
desire-onboarding-v1 control 1,097 322 29.4% 170 50 34 3.1% 27 7 49 12 896,500₩ 817₩ 26,368₩ 9 26.5%
desire-onboarding-v1 treatment 1,104 299 27.1% 127 81 31 2.8% 19 12 52 13 1,045,000₩ 947₩ 33,710₩ 10 32.3%
desire-onboarding-v2 control 700 184 26.3% 92 28 12 1.7% 10 2 17 4 258,500₩ 369₩ 21,542₩ 3 25%
desire-onboarding-v2 treatment 746 220 29.5% 114 38 19 2.6% 10 9 28 3 624,400₩ 837₩ 32,863₩ 7 36.8%
>_ Playground에서 이 쿼리 열기 & 직접 수정하기 → DuckDB에서 STG 테이블과 조인하거나 지표 정의를 직접 수정해 볼 수 있습니다.

2. desire-onboarding-v2 (/create 랜딩 모수 Only)

데이터가 없습니다.

3. desire-onboarding-v2 결제 수단별 (콘 Only vs 구독 Only)

payment_type variant payers total_tx revenue_krw arppu_krw paid_d1_retention_pct
Con Only (단건) control 10 15 148,500₩ 14,850₩ 10%
Con Only (단건) treatment 10 19 225,500₩ 22,550₩ 50%
Subscription Only (정기) control 2 2 110,000₩ 55,000₩ 100%
Subscription Only (정기) treatment 9 9 398,900₩ 44,322₩ 22.2%

4. desire-onboarding-v2 OS별 (iOS vs Android)

os variant devices msg_devices start_pct reach5_devices payers pay_cvr_pct con_payers sub_payers revenue_krw arpu_krw arppu_krw paid_d1_retention_pct
android control 172 52 30.2% 26 4 2.3% 4 0 44,000₩ 256₩ 11,000₩ 25%
android treatment 199 74 37.2% 45 8 4% 8 0 110,000₩ 553₩ 13,750₩ 50%
ios control 522 132 25.3% 66 8 1.5% 6 2 214,500₩ 411₩ 26,813₩ 25%
ios treatment 544 146 26.8% 69 11 2% 2 9 514,400₩ 946₩ 46,764₩ 27.3%