SuperAPI AI Directory

commerce-ltv-cac-architect

General & other

View repository

Updated 10-15 22:33

About this skill

Customer-level Profit Structure Design (LTV/CAC Architect)

Overview

From ROAS-centered decision-making to LTV-based decision-makingThis is a profit structure design skill for Korean D2C and e-commerce sellers looking to transition.

One-line responsibility: Revenue·Ad Spend·COGS·Repurchase Rate·Purchase Cycle·ARPU input → 6-metric linkage model + LTV/CAC ratio diagnosis + Ad Dependency diagnosis + Break-even ROAS + Channel·Segment-level repurchase rate decomposition + Action priority auto-generation.

vs commerce-margin-calculator: Paired skill is single-item margin calculation. This skill is the lifetime profit structure of one customer design. If single-item margin is P&L, LTV is the health of the business model.

6-Metric Linkage Model

                          ┌──────────────────────┐
                          │   CAC (고객획득비용)   │  ← 광고비 ÷ 신규 고객 수
                          └────────┬─────────────┘
                                   │
                                   ▼
┌────────────────┐        ┌──────────────────────┐
│ 재구매율 (RR)   │ ─────▶ │      ARPU            │ ← 1회 구매 평균 매출
│   r = 30~50%   │        │      (₩ / 1구매)      │
└────────────────┘        └────────┬─────────────┘
        │                          │
        │  ┌───────────────┐       │
        └─▶│ 구매주기 (PC) │       │
           │  60~90일      │       │
           └───────┬───────┘       │
                   │               │
                   ▼               ▼
           ┌──────────────────────────┐
           │      공헌이익률 (CM%)      │  ← (매출 - 변동비) / 매출
           │       30~50%             │
           └────────────┬─────────────┘
                        │
                        ▼
              ┌─────────────────────┐
              │     LTV             │  ← ARPU × CM% × (1 / (1-r))
              │     ₩100K~500K      │
              └────────────┬────────┘
                           │
                           ▼
                    ┌──────────────┐
                    │ LTV/CAC      │  ← ≥ 3 건강 / < 1 위험
                    └──────────────┘

Core Formula

LTV Formula (Geometric Series Model)

LTV = ARPU × 공헌이익률 × (1 / (1 - 재구매율))

예시:
ARPU = 30,000원
공헌이익률 = 40%
재구매율 = 40%

LTV = 30,000 × 0.40 × (1 / (1 - 0.40))
    = 30,000 × 0.40 × 1.667
    = 20,000원

LTV/CAC Ratio

Ratio Diagnosis Action
< 1 🔴 Loss — Ad spend per customer exceeds LTV Immediately halt ad spend or cut CAC in half
1 ≤ x < 3 🟡 Near break-even — Repurchase has not started Limit new ads until repurchase rate reaches 40%+
3 ≤ x < 5 🟢 Healthy — Standard SaaS·D2C benchmark Ad expansion + channel diversification possible
≥ 5 🟢🟢 Excellent — but possible ad underinvestment Consider accelerating growth through ad expansion

Payback Period

Payback Period = CAC / (ARPU × 공헌이익률 × 월 구매빈도)

예시:
CAC = 50,000원
ARPU × CM% = 12,000원
월 구매빈도 = 0.33 (= 3개월 1회)

Payback = 50,000 / (12,000 × 0.33)
        = 50,000 / 4,000
        = 12.5개월

Korean D2C standard:

  • Cosmetics·Food: 6-12 months (fast subscription·repurchase)
  • Fashion: 12-18 months
  • Home Appliances·Home Interior: 18-24 months

Ad Dependency Diagnosis

Ad spend to revenue ratio (광고비 / 매출):

Ratio Diagnosis Korean D2C meaning
30%+ 🔴 Ad dependency risk Stage of following ROAS only. LTV 0 assumption. Revenue immediately drops to 0 if ads are turned off
20-30% 🟡 Dependency progressing New channel stabilization stage
15-20% 🟢 Normal D2C standard (balance of ads + organic revenue)
10-15% 🟢🟢 Excellent Brand self-sustainability + repurchase loop working
5-10% ⚪ Possible ad underinvestment Consider accelerating growth or entering the next stage

Transition Case (Korean seller 6-month real case): Ad spend 30% → 11.2%

  • New customer ad share reduced by half from 30%→15%
  • Shift remaining 50% of ad spend to repurchase-inducing CRM·LTV channels
  • Repurchase rate 25% → 45% increase → organic revenue share surges

Break-even ROAS Auto-Calculation

손익분기 ROAS = 1 / 공헌이익률

예시:
공헌이익률 35% → 손익분기 ROAS = 1 / 0.35 = 2.86

→ ROAS 2.86 미만이면 광고 1원당 0.35원 손실
→ ROAS 2.86 = 손익분기 (광고 1원 = 매출 2.86원 = 공헌이익 1원 = 광고비 1원 회수)
→ ROAS 3.5 = 광고비 회수 + 약간의 수익 (1.225원 추가 공헌이익)

Important Pitfall: A case where ad ROAS is below break-even but revenue looks large — a structure where revenue also becomes 0 when ad spend is 0. Often occurs when ad dependence is 30%+.

Repurchase rate breakdown by channel and segment

Even if the overall average repurchase rate is 40%, segmenting reveals the true picture:

Segment Repurchase rate LTV multiple Action
New member (first purchase) 0% 1.0x Drive first purchase → second purchase within 7 days (message/discount)
2-time purchaser 65% 2.5x Onboarding sequence up to 5 purchases
VIP (5회+) 85% 5x+ Lookalike seed (best ad efficiency) + VIP benefits
About to become dormant (60-90 days) 25% 1.3x Golden-time push at repurchase point (cs-channel-message app push planning mode)
Dormant (90+ days) 8% 1.05x Win-back event or cut losses

Repurchase rate by channel

Channel Suitable for new acquisition Suitable for repurchase Notes
Meta ads 🟢 🟡 Mainly new customers. Repurchase goes to CRM
Google Search 🟢 🟢 Keywords with clear intent. Also capture repurchase searches
Naver Ads 🟢 🟡 Entering the Korean market. Run C-Rank at a similar level
KakaoTalk Friend Talk ⚪ 🟢🟢 90%+ open rate. Strongest repurchase channel
Email sequence ⚪ 🟢 Lowest CAC. Core of organic revenue
App push ⚪ 🟢 Retention golden-time trigger

6-step roadmap to escape ad dependence

[Month 1] 진단
   - 현재 LTV/CAC ratio 측정
   - 광고비 매출 비율 확인
   - 채널·세그먼트별 재구매율 분해

[Month 2] CRM 인프라
   - 회원·구매 데이터 정리 (이메일 + 휴대폰 옵트인 100% 점검)
   - 채널별 (이메일·카톡·앱푸시) 옵트인 동의 확보

[Month 3] 재구매 메시지 시퀀스
   - 첫 구매 후 7일·30일·60일·90일 시퀀스 (4단계)
   - cs-channel-message 활용 (운영 카피 + 앱 푸시 기획 모드)

[Month 4] 광고 채널 재배분
   - 신규 광고비 50%로 감축 (해당 매출은 일시 -10%)
   - 잔여 50%를 재구매 채널 (카카오 친구톡·이메일)로 이동

[Month 5] VIP 세그먼트 Lookalike
   - 5회+ 구매 VIP 세그먼트 추출
   - 메타·구글에 Lookalike 1~3% 씨앗으로 등록
   - CAC -30~40% 효과

[Month 6] 자생 매출 비율 측정
   - 광고비 매출 비율 11~15% 달성 검증
   - 재구매율 40%+ 달성 검증
   - LTV/CAC ratio 3+ 달성 검증

Workflow

Input slots

Item Required Example
Monthly revenue Required 1억 원
Monthly ad spend Required KRW 30 million (ad dependence 30%)
Monthly new customers Required 1,000명 (CAC = 30,000원)
ARPU (average revenue per purchase) Required 50,000원
Variable cost ratio (COGS/fees) Required 60% (contribution margin 40%)
Repurchase rate Required 35% (specify monthly or quarterly)
Purchase cycle Recommended 75일
VIP segment share Recommended 12% (5+ time purchasers)

Calculation order

[Step 1] CAC 계산
   광고비 ÷ 신규 고객 수

[Step 2] LTV 계산
   ARPU × 공헌이익률 × (1 / (1 - 재구매율))

[Step 3] LTV/CAC ratio
   < 3 시 위험 신호

[Step 4] Payback Period
   CAC ÷ (ARPU × CM% × 월 구매빈도)

[Step 5] 광고 의존도
   광고비 ÷ 매출

[Step 6] 손익분기 ROAS
   1 ÷ 공헌이익률

[Step 7] 채널·세그먼트 분해 추정
   채널별 신규/재구매 비율 + 세그먼트별 재구매율

[Step 8] 액션 우선순위 (탑 3)
   - LTV 낮은 경우 → 재구매 시퀀스
   - CAC 높은 경우 → VIP Lookalike
   - 광고 의존도 30%+ → 광고 채널 재배분 6단계 로드맵

Output format

# 📊 LTV/CAC 진단 리포트

## 1. 6대 지표 요약

| 지표 | 값 | 진단 |
|------|-----|------|
| CAC | 30,000원 | — |
| 재구매율 | 35% | 🟡 정상 하한 |
| 구매주기 | 75일 | 화장품 표준 |
| ARPU | 50,000원 | — |
| 공헌이익률 | 40% | 🟢 정상 |
| LTV | 30,769원 | — |

## 2. 핵심 진단

- **LTV/CAC**: 30,769 / 30,000 = **1.03** → 🟡 손익분기 근방
- **Payback Period**: 4.5개월 → 🟢 빠른 회수
- **광고 의존도**: 30% → 🔴 위험
- **손익분기 ROAS**: 2.50 → 현재 ROAS와 비교 필요

## 3. 채널·세그먼트 분해

- 신규 회원 → 첫 구매 → 7일 내 재구매율 12% (낮음, 시퀀스 부족)
- 2회+ 구매자 재구매율 65% (정상)
- VIP 12% (5회+) → Lookalike 씨앗 자격 ✅

## 4. 액션 우선순위 (탑 3)

### Priority 1: 첫 구매 후 7일 시퀀스 (Payback 단축)
- 현재 12% → 목표 30% 재구매율
- 도구: cs-channel-message (운영 카피 + 앱 푸시 기획 모드)
- 예상 LTV 상승: +35%

### Priority 2: VIP Lookalike 메타 등록 (CAC 감축)
- VIP 12% 세그먼트를 메타·구글 Lookalike 1~3% 씨앗으로
- 예상 CAC 절감: -30%

### Priority 3: 광고비 30%→15% 6개월 로드맵
- Month 4부터 신규 광고비 50% 감축
- 잔여 50%를 카카오 친구톡·이메일 시퀀스로 이동
- 예상 자생 매출 비율: 70%+

Quality checklist

  • All 6 key metrics entered + calculation completed
  • Specify LTV/CAC ratio + Payback Period
  • Specify ad dependence + break-even ROAS
  • Channel/segment breakdown estimate (at least 5 segments)
  • Top 3 action priorities (specify each tool + expected effect)

Usage example

"/commerce-ltv-cac-architect — 월 매출 1억, 광고비 3천만, 신규 1000명, ARPU 5만,
 변동비 60%, 재구매 35%"
→ LTV/CAC 1.03 + Payback 4.5개월 + 광고 의존 30% 위험 + 액션 3종

"/commerce-ltv-cac-architect — 재구매율 분해 안 되는데 추정해줘"
→ 표준 한국 D2C 벤치마크 적용 + 세그먼트별 재구매율 가정 + 액션 3종

"/commerce-ltv-cac-architect — 광고비 11% 만들기 6개월 로드맵"
→ 6단계 로드맵 + 월별 KPI + 예상 LTV·CAC 변화

Korean D2C benchmarks

Category LTV/CAC standard Payback standard Repurchase Rate Standard
Cosmetics·Beauty 3-5 6-12 months 40-55%
Food·Health Supplements 2.5-4 6-10 months 35-50%
Fashion 2-3 12-18 months 25-35%
Home Appliances·Home Interior 1.5-2.5 18-24 months 15-25%
펫 4-6 4-8 months 50-65%
Subscription SaaS 3-5 12-18 months 80%+ (Inverse of churn rate)

Related Skills

Chaining: commerce-margin-calculator (Single-item margin) → commerce-ltv-cac-architect (Customer revenue structure) → Next-step action skill

  • commerce-margin-calculator — Single-item margin·End ROAS calculation (pair, different responsibility)
  • cs-channel-message — Message copy for Priority 1·3 actions + app push planning (app push planning mode)
  • commerce-integrated-strategy — Include this diagnostic result in the 1-page integrated strategy

When not to use this skill

  • Single-item margin calculation: commerce-margin-calculator use
  • Message copy writing: cs-channel-message use
  • Ad campaign planning: marketing-campaign-planner use
  • Simple ROAS calculation (ad level): moai-seller:commerce-marketplace-coupang-ads or marketing-performance-report use