Q3 Retention and LTV Analysis
Q3 Retention and LTV Analysis
| cohort_date_kst | cohort_age_days | devices | d0_msg_devices | d0_msg_cvr_pct | d1_msg_devices | d1_msg_cvr_pct | d7_msg_devices | msg_devices | msg_cvr_pct | reach5_devices | reach5_pct | reach10_devices | reach10_pct | handoff_devices | handoff_cvr_pct | payers | pay_cvr_pct | web_payers | con_payers | rc_payers | con_of_reach5_pct | paid_d1_msg_devices | paid_d1_retention_pct | revenue_krw | d7_revenue_krw | d30_revenue_krw | refund_krw | refund_payers | refund_rate_pct | rc_d1_cancel_devices | rc_d1_cancel_pct | rc_d3_cancel_devices | rc_d3_cancel_pct | user_msg_count | meta_ads_krw | openrouter_krw | replicate_krw | opex_vendors_reporting | cost_krw | cost_per_device_krw | profit_krw | roi_pct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025-12-23 | 234 | 2 | 0 | 0% | 0 | 0% | 0 | 0 | 0% | 0 | 0% | 0 | 0% | 0 | - | 2 | - | 2 | 0 | 0 | - | 0 | 0% | 25,980₩ | 25,980₩ | 25,980₩ | 0₩ | 0 | 0% | 0 | - | 0 | - | 0 | 0₩ | 0₩ | 0₩ | 0 | - | - | - | - |
| 2025-12-29 | 228 | 4 | 0 | 0% | 0 | 0% | 0 | 0 | 0% | 0 | 0% | 0 | 0% | 0 | - | 4 | - | 4 | 0 | 0 | - | 0 | 0% | 51,960₩ | 51,960₩ | 51,960₩ | 0₩ | 0 | 0% | 0 | - | 0 | - | 0 | 0₩ | 0₩ | 0₩ | 0 | - | - | - | - |
| 2026-01-07 | 219 | 1 | 0 | 0% | 0 | 0% | 0 | 0 | 0% | 0 | 0% | 0 | 0% | 0 | - | 1 | - | 1 | 0 | 0 | - | 0 | 0% | 12,990₩ | 12,990₩ | 12,990₩ | 0₩ | 0 | 0% | 0 | - | 0 | - | 0 | 0₩ | 0₩ | 0₩ | 0 | - | - | - | - |
| 2026-01-08 | 218 | 5 | 0 | 0% | 0 | 0% | 0 | 0 | 0% | 0 | 0% | 0 | 0% | 0 | - | 4 | - | 4 | 0 | 0 | - | 0 | 0% | 75,930₩ | 75,930₩ | 75,930₩ | 0₩ | 0 | 0% | 0 | - | 0 | - | 0 | 0₩ | 0₩ | 0₩ | 0 | - | - | - | - |
| 2026-01-09 | 217 | 1 | 0 | 0% | 0 | 0% | 0 | 0 | 0% | 0 | 0% | 0 | 0% | 0 | - | 1 | - | 1 | 0 | 0 | - | 0 | 0% | 12,990₩ | 12,990₩ | 12,990₩ | 0₩ | 0 | 0% | 0 | - | 0 | - | 0 | 0₩ | 0₩ | 0₩ | 0 | - | - | - | - |