Skip to content

indranilbanerjee/digital-marketing-pro / skills/analytics-insights

analytics-insights

Verified

Design the analytics layer with script-backed benchmarks: KPI trees, report templates, MMM, cookieless. "define our KPIs"

FileKindSize
SKILL.mdskill md26.1 KB
anomaly-diagnosis.mdmarkdown13.7 KB
clv-analysis.mdmarkdown15.7 KB
competitive-intelligence.mdmarkdown13.5 KB
dark-social-tracking.mdmarkdown13.4 KB
dashboard-design.mdmarkdown20.9 KB
incrementality-testing.mdmarkdown14.2 KB
kpi-frameworks.mdmarkdown11.7 KB
mmm-framework.mdmarkdown17.6 KB
privacy-first-measurement.mdmarkdown19.2 KB
reporting-templates.mdmarkdown11.0 KB

clv-analysis.md

View on GitHub
# Customer Lifetime Value (CLV) — Analysis & Application Reference

## CLV Models Overview

| Model | Type | Complexity | Best For | Data Required |
|-------|------|-----------|----------|---------------|
| Simple historical | Backward-looking | Low | Quick estimates, early-stage businesses | Transaction history |
| Cohort-based | Backward-looking | Medium | Subscription and eCommerce with 12+ months data | Transaction history, cohort dates |
| Predictive (BG/NBD) | Forward-looking | High | Non-contractual (eCommerce, retail) | Recency, frequency, monetary, tenure |
| Predictive (Pareto/NBD) | Forward-looking | High | Non-contractual with high churn ambiguity | Recency, frequency, monetary, tenure |
| Contractual (MRR-based) | Forward-looking | Medium | SaaS, subscriptions, memberships | MRR, churn rate, expansion rate |
| Probabilistic RFM | Forward-looking | Medium | Retail, eCommerce with repeat purchases | Recency, frequency, monetary |

---

## Calculation Methods

### Method 1: Simple CLV

The quickest estimate. Useful for early-stage businesses or initial benchmarking.

```
CLV = Average Order Value (AOV) x Purchase Frequency x Customer Lifespan

Where:
- AOV = Total Revenue / Total Orders (in period)
- Purchase Frequency = Total Orders / Unique Customers (in period)
- Customer Lifespan = 1 / Churn Rate (annualized)
```

**Example:**
- AOV = $85
- Purchase frequency = 3.2 orders/year
- Customer lifespan = 1 / 0.25 churn = 4 years
- **CLV = $85 x 3.2 x 4 = $1,088**

**Limitations:** Assumes constant behavior, ignores margin, does not account for time value of money.

### Method 2: Margin-Adjusted CLV

Adds gross margin and discount rate for more realistic valuation.

```
CLV = (AOV x Purchase Frequency x Gross Margin %) x (1 / Churn Rate) x (1 / (1 + Discount Rate))

Or simplified:
CLV = (ARPU x Gross Margin %) / Churn Rate
```

**Example (SaaS):**
- Monthly ARPU = $99
- Gross margin = 80%
- Monthly churn = 3%
- **CLV = ($99 x 0.80) / 0.03 = $2,640**

### Method 3: Cohort-Based CLV

Tracks actual revenue generated by acquisition cohorts over time. Most accurate for businesses with 12+ months of data.

```
Month 0 cohort (Jan 2024): 500 customers acquired
├── Month 0: $42,500 revenue (500 customers, $85 AOV)
├── Month 1: $12,750 (150 returning, $85)
├── Month 2: $8,500 (100 returning, $85)
├── Month 3: $7,225 (85 returning, $85)
├── ...
├── Month 12: $3,400 (40 returning, $85)
└── 12-month cohort revenue: $125,000

12-month CLV = $125,000 / 500 = $250 per customer
```

### Cohort Revenue Table Template

| Cohort | Month 0 | Month 1 | Month 2 | Month 3 | Month 6 | Month 12 | 12-mo CLV |
|--------|---------|---------|---------|---------|---------|----------|-----------|
| Jan 2024 (500) | $42,500 | $12,750 | $8,500 | $7,225 | $4,675 | $3,400 | $250 |
| Feb 2024 (480) | $40,800 | $12,960 | $8,640 | $7,200 | $4,560 | — | — |
| Mar 2024 (520) | $44,200 | $13,520 | $9,100 | $7,540 | — | — | — |

### Method 4: Contractual CLV (SaaS / Subscription)

```
CLV = (Monthly Revenue per Account x Gross Margin %) / Monthly Churn Rate

With expansion:
CLV = (Monthly Revenue x Gross Margin %) x (1 + Net Expansion Rate) / Monthly Churn Rate
```

| Variable | Definition | Typical Range |
|----------|-----------|---------------|
| Monthly revenue per account | Average MRR per customer | Varies by pricing tier |
| Gross margin | Revenue minus COGS (hosting, support) | 70-85% for SaaS |
| Monthly churn rate | % of customers lost per month | 1-3% for SMB SaaS, <1% for enterprise |
| Net expansion rate | Monthly expansion revenue as % of starting MRR | 1-5% for strong SaaS |

---

## CLV Segmentation

### CLV by Acquisition Channel

| Channel | Typical CLV Relative | Explanation |
|---------|---------------------|-------------|
| Organic search | High (1.0x baseline) | High intent, self-selected, lower CAC |
| Direct / brand | Highest (1.2-1.5x) | Brand-aware, highest loyalty |
| Email (owned list) | High (1.0-1.3x) | Already engaged, repeat behavior |
| Referral | High (1.1-1.4x) | Social proof pre-qualified |
| Paid search (brand) | Medium-High (0.9-1.1x) | High intent but higher CAC |
| Paid search (non-brand) | Medium (0.7-0.9x) | Good intent, competitive CAC |
| Paid social | Low-Medium (0.5-0.8x) | Interrupt-driven, often lower repeat rates |
| Display / programmatic | Low (0.3-0.6x) | Awareness-driven, lowest repeat rates |
| Affiliate | Low-Medium (0.4-0.7x) | Often deal-seekers, lower loyalty |

### CLV by First Purchase Behavior

| First Purchase Signal | CLV Indicator | Why |
|----------------------|---------------|-----|
| Full-price first purchase | Higher CLV | Not discount-motivated, values product |
| Discount-driven first purchase | Lower CLV | May only return for more discounts |
| High AOV first order | Higher CLV | Willing to invest, higher trust |
| Multi-item first order | Higher CLV | Engaged browser, explored catalog |
| Repeat within 30 days | Much higher CLV | Strong product-market fit signal |
| Category with high repeat rate | Higher CLV | Consumable or habitual category |

### CLV by Customer Persona

| Persona | Typical CLV Pattern | Strategy |
|---------|--------------------|----------|
| Power users / enthusiasts | Highest CLV, high frequency, moderate AOV | Loyalty programs, early access, community |
| Professional buyers | High CLV, moderate frequency, high AOV | Account management, volume pricing |
| Occasional buyers | Medium CLV, low frequency, variable AOV | Seasonal re-engagement, reminders |
| Deal hunters | Low CLV, purchase only on discount | Minimize discounting, exclude from promo targeting |
| One-and-done | Lowest CLV, single purchase | Invest in second-purchase campaigns in first 30 days |

---

## CLV:CAC Ratio

### Ratio Interpretation

| CLV:CAC Ratio | Health Status | Interpretation | Action |
|---------------|-------------|----------------|--------|
| > 5:1 | Under-investing | Leaving growth on the table | Increase marketing spend, test new channels |
| 3:1 - 5:1 | Healthy | Sustainable unit economics | Optimize and scale proven channels |
| 2:1 - 3:1 | Acceptable | Viable but tight margins | Focus on improving retention and AOV |
| 1.5:1 - 2:1 | Concerning | Thin margins after operating costs | Reduce CAC or improve CLV before scaling |
| < 1.5:1 | Unsustainable | Losing money on each customer | Pause acquisition spend, fix retention and margins |

### CAC Calculation (Fully Loaded)

```
Fully Loaded CAC = (Ad Spend + Marketing Salaries + Tools & Software + Agency Fees + Content Production) / New Customers Acquired

Paid CAC = Paid Channel Spend / Customers Acquired via Paid Channels

Blended CAC = Total Marketing + Sales Cost / Total New Customers (including organic)
```

> **Important:** Use the fully loaded CAC for business planning. Use paid CAC for channel optimization. The gap between blended and paid CAC represents the value of your organic and brand channels.

---

## Payback Period

### Definition and Calculation

```
CAC Payback Period = CAC / (Monthly Revenue per Customer x Gross Margin %)

Example:
- CAC = $300
- Monthly revenue = $50
- Gross margin = 80%
- Payback = $300 / ($50 x 0.80) = 7.5 months
```

### Payback Period Benchmarks

| Business Model | Acceptable Payback | Good Payback | Excellent Payback |
|---------------|-------------------|-------------|-------------------|
| B2B SaaS (SMB) | < 18 months | < 12 months | < 6 months |
| B2B SaaS (Enterprise) | < 24 months | < 18 months | < 12 months |
| eCommerce (general) | < 6 months | < 3 months | First order |
| DTC / Subscription | < 12 months | < 6 months | < 3 months |
| Marketplace | < 12 months | < 6 months | < 3 months |

### Cash Flow Implications

- **Short payback (<6 months):** Self-funding growth is possible; reinvest revenue into acquisition
- **Medium payback (6-12 months):** Growth requires working capital; plan for cash flow gaps
- **Long payback (12-24 months):** Requires external capital or careful cash management; every churn event is expensive
- **Payback > CLV:** Unit economics are broken; fix retention or reduce CAC before scaling

---

## Improving CLV

### Lever 1: Increase Average Order Value

| Tactic | Implementation | Typical Lift |
|--------|---------------|-------------|
| Upsell at checkout | "Upgrade to premium for $20 more" | 10-20% AOV increase |
| Cross-sell recommendations | "Frequently bought together" module | 5-15% AOV increase |
| Bundle pricing | "Save 15% when you buy the set" | 10-25% AOV increase |
| Free shipping threshold | "Free shipping on orders over $75" | 8-15% AOV increase |
| Tiered pricing / volume discounts | "Buy 3, save 10%" | 5-12% AOV increase |
| Premium / luxury tier | Offer a higher-priced option | Anchoring effect lifts mid-tier |

### Lever 2: Increase Purchase Frequency

| Tactic | Implementation | Typical Lift |
|--------|---------------|-------------|
| Replenishment reminders | Timed emails based on product consumption cycle | 15-25% frequency increase |
| Subscription / auto-ship | Offer recurring delivery with discount incentive | 30-50% frequency increase |
| Loyalty / points program | Earn points per dollar, redeem for rewards | 10-20% frequency increase |
| New product launches | Regular new arrivals with early access for customers | 5-15% frequency increase |
| Seasonal campaigns | Targeted campaigns for gifting, back-to-school, etc. | 5-10% frequency increase |
| Post-purchase email flows | Product education, how-to content, complementary suggestions | 10-20% frequency increase |

### Lever 3: Increase Customer Lifespan (Reduce Churn)

| Tactic | Implementation | Typical Impact |
|--------|---------------|---------------|
| Onboarding optimization | Guided setup, quick wins, milestone celebrations | 15-30% churn reduction |
| Proactive support | Trigger outreach when usage drops | 10-20% churn reduction |
| Win-back campaigns | Targeted offers for at-risk and recently churned | 5-15% of churned customers recovered |
| Product stickiness | Integrations, data lock-in, network effects | 20-40% churn reduction |
| Customer success programs | Regular check-ins, QBRs, health scoring | 15-25% churn reduction (B2B) |
| Community building | Forums, user groups, events, exclusive content | 10-20% churn reduction |

### Lever 4: Reduce Cost of Goods Sold

| Tactic | Implementation | Impact on CLV |
|--------|---------------|---------------|
| Supplier negotiation | Volume discounts, alternative sourcing | Increases margin → increases CLV |
| Operational efficiency | Reduce fulfillment cost per order | Direct margin improvement |
| Support cost reduction | Self-serve knowledge base, AI chat | Lower per-customer servicing cost |
| Return rate reduction | Better product descriptions, sizing guides | Lower reverse logistics cost |

---

## CLV in Budget Decisions

### Setting Allowable CAC by Channel

```
Allowable CAC = CLV x Target CLV:CAC Ratio Inverse

Example:
- CLV = $900
- Target CLV:CAC ratio = 3:1
- Allowable CAC = $900 / 3 = $300

Channel allocation:
- Organic (CAC $50) → Scale aggressively
- Paid search brand (CAC $120) → Scale aggressively
- Paid search non-brand (CAC $250) → Scale with monitoring
- Paid social (CAC $350) → Optimize before scaling (exceeds allowable)
- Display (CAC $500) → Pause or restructure targeting
```

### LTV-Based Bidding Strategy

| Customer Segment | Predicted CLV | Allowable CPA | Bid Strategy |
|-----------------|--------------|---------------|-------------|
| High-value segment | $2,000+ | $600+ | Aggressive bidding, highest priority |
| Medium-value segment | $800-2,000 | $250-600 | Standard bidding, optimize for efficiency |
| Low-value segment | $200-800 | $60-250 | Conservative bidding, tight CPA targets |
| Negative-value segment | <$200 | Exclude | Suppress from paid targeting |

### High-Value Customer Identification Signals

Use these signals to identify potentially high-CLV customers early (before full CLV data exists):

| Signal | Measurable At | Predictive Strength |
|--------|--------------|-------------------|
| Full-price first purchase | First order | High — not discount-dependent |
| Multi-category browsing | Pre-purchase | Medium — indicates broad interest |
| Account creation | First visit | Medium — signals commitment |
| Email signup + first purchase | First visit | High — engaged from start |
| Referral source | Acquisition | High — referred customers have 16-25% higher CLV |
| High first-order AOV | First order | Medium-High — indicates willingness to spend |
| Mobile app install | Early lifecycle | High — deeper engagement channel |
| Repeat visit within 7 days | Week 1 | Very High — strong purchase intent |

---

## Industry Benchmarks

### eCommerce CLV Benchmarks

| Category | First-Order AOV | 12-Month CLV | CLV Multiple (vs. first order) |
|----------|----------------|-------------|-------------------------------|
| Apparel & fashion | $60-120 | $150-400 | 2-4x |
| Beauty & cosmetics | $40-80 | $120-300 | 2.5-5x |
| Health & supplements | $35-70 | $200-500 | 4-8x (subscription effect) |
| Electronics | $100-500 | $150-600 | 1.2-2x (low repeat) |
| Home & garden | $80-200 | $150-400 | 1.5-2.5x |
| Food & beverage (DTC) | $30-60 | $200-600 | 5-12x (subscription effect) |
| Pet supplies | $40-80 | $200-500 | 4-8x (habitual repeat) |

### SaaS CLV Benchmarks

| Segment | Monthly ARPU | Avg Lifespan | Typical CLV |
|---------|-------------|-------------|-------------|
| SMB SaaS (<$100/mo) | $30-99 | 18-30 months | $500-3,000 |
| Mid-market SaaS ($100-1K/mo) | $200-800 | 24-48 months | $5,000-40,000 |
| Enterprise SaaS ($1K+/mo) | $2,000-20,000 | 36-72+ months | $70,000-1,000,000+ |
| Usage-based SaaS | Highly variable | 24-60 months | Depends on expansion revenue |

### Subscription Business CLV Benchmarks

| Type | Monthly Price | Avg Retention | 2-Year CLV |
|------|-------------|---------------|-----------|
| Media / streaming | $10-20 | 12-24 months | $120-480 |
| Meal kits | $50-100 | 4-8 months | $200-800 |
| Box subscriptions | $25-60 | 6-12 months | $150-720 |
| Software (consumer) | $5-30 | 18-36 months | $90-1,080 |
| Fitness / wellness | $15-50 | 8-18 months | $120-900 |

---

## Data Requirements Checklist

### Minimum Data for CLV Analysis

- [ ] Customer ID (unique identifier across all transactions)
- [ ] Transaction date (order date for each purchase)
- [ ] Transaction value (revenue per order, ideally after returns/refunds)
- [ ] Customer acquisition date (first purchase or signup date)
- [ ] Acquisition channel/source (how each customer was acquired)

### Recommended Additional Data

- [ ] Product categories purchased (enables category-level CLV segmentation)
- [ ] Gross margin by product/order (enables margin-adjusted CLV)
- [ ] Customer support interactions (enables cost-adjusted CLV)
- [ ] Discount/promotion usage per order (identifies discount-dependent customers)
- [ ] Customer demographic data (enables persona-level CLV)
- [ ] Engagement metrics (email opens, site visits, app usage between purchases)
- [ ] NPS or satisfaction scores (leading indicator of churn/retention)
- [ ] Subscription status changes (upgrades, downgrades, cancellations, pauses)

### Data Quality Checks

- [ ] Customer IDs are consistent across channels (no duplicates for same person)
- [ ] Refunds and returns are reflected in transaction values
- [ ] Acquisition dates are accurate (not overwritten by subsequent activity)
- [ ] Channel attribution is reliable for first-touch acquisition source
- [ ] At least 12 months of historical data exists for cohort analysis
- [ ] Sample sizes are sufficient per segment (minimum 100 customers per segment for statistical validity)

---

*CLV is the single most important metric in marketing because it answers the fundamental question: how much can you afford to spend to acquire a customer and still build a profitable business? Every budget decision, channel investment, and retention initiative should be evaluated through the CLV lens.*
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall