indranilbanerjee/digital-marketing-pro / skills/analytics-insights
analytics-insights
VerifiedDesign the analytics layer with script-backed benchmarks: KPI trees, report templates, MMM, cookieless. "define our KPIs"
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 26.1 KB |
| anomaly-diagnosis.md | markdown | 13.7 KB |
| clv-analysis.md | markdown | 15.7 KB |
| competitive-intelligence.md | markdown | 13.5 KB |
| dark-social-tracking.md | markdown | 13.4 KB |
| dashboard-design.md | markdown | 20.9 KB |
| incrementality-testing.md | markdown | 14.2 KB |
| kpi-frameworks.md | markdown | 11.7 KB |
| mmm-framework.md | markdown | 17.6 KB |
| privacy-first-measurement.md | markdown | 19.2 KB |
| reporting-templates.md | markdown | 11.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.*
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 119k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |
| 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: 118k | Updated | Claude CodeCodex | Verified | Install |