⚡ Promptolis Original · Data & Analytics

👥 Customer Analytics Deep Dive — CAC / LTV / Segmentation Mastery

The structured customer analytics covering CAC calculation (marketing + sales fully-loaded), LTV methodology, CAC:LTV ratio benchmarks, cohort-based segmentation, and the 'customer economics' discipline that separates healthy growth from burning cash.

⏱️ 6 hours analysis + ongoing 🤖 ~2 min in Claude 🗓️ Updated 2026-04-20

Why this is epic

Most companies calculate CAC + LTV incorrectly. This Original produces rigorous methodology + segmentation + interpretation.

Names the 5 CAC/LTV calculation errors (partial cost inclusion / wrong time windows / blended vs. segment / LTV overestimation / no cohort-based).

Produces complete framework: proper calculation, segmentation, benchmarks, action implications.

The prompt

Promptolis Original · Copy-ready
<role> You are a SaaS customer analytics + unit economics specialist. 12 years experience at companies $5M-$500M ARR. You've calculated unit economics for IPO prep + VC rounds. You are direct. You will name when calculations sloppy, when numbers don't reconcile, when segments hide truth. </role> <principles> 1. CAC = fully-loaded (all marketing + sales cost). 2. LTV = gross margin × 1/churn. 3. CAC:LTV target 1:3, floor 1:2. 4. CAC payback < 12 months for healthy SaaS. 5. Segment by cohort. 6. Include fully-loaded costs. 7. LTV forecast from cohort data. 8. Annual review cadence. </principles> <input> <business-model>{SaaS, DTC, etc.}</business-model> <acv-or-aov>{deal size}</acv-or-aov> <customer-count>{active customers}</customer-count> <marketing-spend>{total annual}</marketing-spend> <sales-spend>{total annual including salaries}</sales-spend> <gross-margin>{percentage}</gross-margin> <churn-rate>{monthly or annual}</churn-rate> <customer-segments>{SMB/mid-market/enterprise}</customer-segments> <data-availability>{cohort data quality}</data-availability> </input> <output-format> # Customer Analytics: [Business] ## CAC Calculation (Proper) Fully-loaded methodology. ## LTV Calculation Cohort-based. ## CAC:LTV Ratio + Benchmark ## Segmentation Analysis By cohort, channel, segment. ## Payback Period ## Improvement Levers ## Red Flags in Current Numbers ## Action Framework ## Key Takeaways 5 bullets. </output-format> <auto-intake> If input incomplete: ask for business model, ACV, customers, marketing, sales, margin, churn, segments, data. </auto-intake> Now, analyze:
🚀 Open in ChatGPT ✨ Open in Claude 💎 Open in Gemini

Example: input → output

Here's how this prompt actually performs. Real input below, real output from Claude Opus 4.

📝 Input
<business-model>B2B SaaS. Customer data platform. Serve SMB + mid-market + growing enterprise.</business-model>
<acv-or-aov>Average ACV: $15K. SMB: $6K. Mid-market: $25K. Enterprise: $120K.</acv-or-aov>
<customer-count>2,200 total customers (1,500 SMB, 600 mid-market, 100 enterprise).</customer-count>
<marketing-spend>Annual: $4M (ads + content + events + team salaries + tools).</marketing-spend>
<sales-spend>Annual: $6M (8 AEs + 4 SDRs + sales leadership + tools + enablement).</sales-spend>
<gross-margin>78% (industry-standard SaaS).</gross-margin>
<churn-rate>Blended: 8% annual. SMB: 14%. Mid-market: 6%. Enterprise: 3%.</churn-rate>
<customer-segments>SMB (< $10K ACV), Mid-market ($10-100K), Enterprise ($100K+).</customer-segments>
<data-availability>Full cohort data past 36 months. Clean attribution.</data-availability>
🤖 Output

Customer Analytics: B2B SaaS, $15K Avg ACV, 2,200 Customers, 3 Segments

A customer analytics deep-dive produces proper CAC/LTV methodology + segmentation. Your blended numbers likely hide segment truth. This analysis: proper calculation, segment breakdown, benchmarks, action framework.

CAC Calculation (Proper)

Fully-loaded Customer Acquisition Cost:

Total GTM cost (annual):

  • Marketing: $4M
  • Sales: $6M
  • Total: $10M

New customers acquired (annual): ~800 (based on growth rate)

Blended CAC: $10M / 800 = $12,500

BUT blended hides truth. By segment:

SMB CAC
  • Marketing (self-serve funnel): ~$1M (ad spend targeted SMB)
  • Sales (SDR + inbound): ~$1M (mostly lower-touch)
  • SMB customers acquired: ~650
  • SMB CAC: $3,100
Mid-Market CAC
  • Marketing: ~$1.5M (content + events targeting mid-market)
  • Sales: ~$3M (AE-led sales)
  • Mid-market customers acquired: ~130
  • Mid-Market CAC: $34,600
Enterprise CAC
  • Marketing: ~$1.5M (high-touch events, ABM, enterprise content)
  • Sales: ~$2M (2-3 senior AEs dedicated, longer cycles)
  • Enterprise customers acquired: ~20
  • Enterprise CAC: $175,000

LTV Calculation

Proper LTV formula:

LTV = Gross Margin × (1 / Churn Rate)

SMB LTV
  • ACV: $6,000
  • Gross margin: 78% → contribution margin $4,680/year
  • Churn: 14% annual → average lifetime 7.1 years
  • BUT: discount back to present value (10% discount rate) = $3,850 × 5.5 year effective = ~$21K
  • SMB LTV: ~$21K
Mid-Market LTV
  • ACV: $25,000
  • Gross margin: 78% → contribution $19,500/year
  • Churn: 6% annual → average lifetime 16.7 years
  • PV-adjusted (5% discount for mid-market cash flow): ~10 year effective
  • Mid-Market LTV: ~$195K
Enterprise LTV
  • ACV: $120,000
  • Gross margin: 78% → contribution $93,600/year
  • Churn: 3% annual → average lifetime 33 years
  • PV-adjusted (5% discount): ~12 year effective
  • Enterprise LTV: ~$1,120K

CAC:LTV Ratio + Benchmark

SegmentCACLTVRatioHealthy?
SMB$3,100$21,0001:6.8EXCELLENT
Mid-Market$34,600$195,0001:5.6EXCELLENT
Enterprise$175,000$1,120,0001:6.4EXCELLENT
Blended$12,500~$92,0001:7.4EXCELLENT

All segments well above 1:3 minimum + 1:2 floor.

Excellent unit economics across segments. Signals: (1) pricing power, (2) retention health, (3) acquisition efficiency.

Payback Period

CAC Payback = CAC / (Gross Margin × ARR per customer per month)

SMB
  • CAC: $3,100
  • Monthly contribution: ($6K × 78%) / 12 = $390
  • Payback: 8 months — healthy
Mid-Market
  • CAC: $34,600
  • Monthly contribution: ($25K × 78%) / 12 = $1,625
  • Payback: 21 months — concerning (> 12-month target)
Enterprise
  • CAC: $175,000
  • Monthly contribution: ($120K × 78%) / 12 = $7,800
  • Payback: 22 months — concerning (> 12-month target)

Finding: CAC:LTV looks great, but payback periods for mid-market + enterprise > 12 months.

Implication: long time to recoup investment. Cash flow concern if growing rapidly.

Segmentation Analysis

By Cohort (Time)

Compare cohort performance 2024 vs. 2025:

2024 cohorts:

  • SMB CAC: $2,600 (improved acquisition)
  • Mid-Market CAC: $28,000 (improved)
  • Enterprise CAC: $210,000 (got worse — competitive pressure)

2025 cohorts:

  • SMB CAC: $3,400 (increasing costs)
  • Mid-Market CAC: $36,000 (increasing)
  • Enterprise CAC: $175,000 (improved with dedicated team)

Pattern: CAC trending up for SMB + mid-market. Enterprise improving. Reflects:

  • Competitive pressure in SMB/mid-market
  • Diminishing returns on current channels
  • Enterprise segment focus paying off
By Channel (CAC)

Channel breakdown:

  • Inbound organic: $2K CAC (high LTV — self-qualified)
  • Paid search: $5K CAC (mid-market quality)
  • Paid social: $8K CAC (mixed quality)
  • Events: $18K CAC (enterprise-focused, longer cycle)
  • Outbound (SDR): $15K CAC (mid-market/enterprise)
  • Referrals: $1.5K CAC (excellent quality)

Implication: referrals + organic lowest CAC. Doubling down on these = efficient growth.

Improvement Levers

Lever 1: Reduce SMB CAC

Current trend: $2,600 → $3,400 (up 30%).

Actions:

  • Audit paid ad channels — where's inefficiency?
  • Improve onboarding + product-led growth
  • Referral program (currently informal)
  • Content SEO for long-tail SMB searches

Target: SMB CAC back to $2,600.

Lever 2: Improve Mid-Market Payback

Current: 21 months payback. Target: 15 months.

Actions:

  • Shorten sales cycle (better qualification, fewer losing deals)
  • Increase mid-market ACV (up from $25K → $32K via packaging)
  • Faster time-to-value → lower churn → longer LTV

Target: CAC payback 15 months.

Lever 3: Scale Enterprise (High-LTV)

Enterprise LTV: $1.1M. Margin room to invest.

Actions:

  • Add 2 enterprise AEs
  • Increase ABM spend targeting enterprise accounts
  • Case studies + executive reference program

Target: enterprise customers from 100 → 200 over 2 years.

Red Flags in Current Numbers

Hidden issues despite good CAC:LTV:

1. SMB CAC trending up 30% — watch for efficiency erosion

2. Mid-market payback > 20 months — cash flow risk if scaling rapidly

3. Blended CAC hides truth — enterprise is investment, SMB is efficient

4. Churn likely understated — check gross churn, not net (expansion masks)

5. LTV assumes long-term retention — validate with cohort data

Action Framework

Monthly monitoring:

  • CAC by channel + segment
  • Blended CAC trend
  • Cohort retention patterns

Quarterly review:

  • CAC:LTV by segment
  • Channel efficiency ranking
  • Improvement initiative status

Annual strategic:

  • Full unit economics review
  • Investment allocation across segments
  • Targets for next year

Key Takeaways

  • Blended CAC $12,500, blended LTV $92K, ratio 1:7.4 = excellent. But blended hides truth. Segment-level analysis shows different stories.
  • Payback period concern: mid-market + enterprise both >20 months. Above 12-month healthy target. Cash flow risk if scaling fast.
  • Channel efficiency: referrals ($1.5K) + organic ($2K) = best CAC. Paid social ($8K) + events ($18K) = most expensive. Shift mix toward efficient channels.
  • Enterprise segment is highest-LTV ($1.1M) + room to invest. Plan: add 2 enterprise AEs + ABM spend. 2x enterprise customer count over 2 years.
  • Watch trend: SMB CAC trending up 30%. Efficient acquisition channel degrading. Investigate + address before ratios deteriorate.

Common use cases

  • Marketing teams measuring true CAC
  • CFOs evaluating unit economics
  • Investors doing DD
  • Growth teams optimizing channels
  • Companies defending/improving valuation

Best AI model for this

Claude Opus 4 or Sonnet 4.5. Customer analytics requires finance + analytics + business understanding. Top-tier reasoning matters.

Pro tips

  • CAC = TOTAL marketing + sales cost / new customers. Not just ad spend.
  • LTV = gross margin × 1/churn rate. Not revenue.
  • Target CAC:LTV = 1:3. Below 1:2 unsustainable.
  • CAC payback <12 months for healthy SaaS.
  • Segment by cohort — blended metrics hide truth.
  • Include fully-loaded costs: salaries, tools, overhead allocation.
  • LTV forecast uses cohort data, not single-customer projections.
  • Annual CAC:LTV review + improvement targets.

Customization tips

  • Calculate fully-loaded CAC (include salaries, tools, allocated overhead). Not just ad spend.
  • Use cohort-based LTV, not single-customer projections. Cohorts reveal truth.
  • Segment analysis essential. Blended metrics hide dramatic differences between customer types.
  • Track CAC PAYBACK not just CAC:LTV. Payback matters for cash flow + scaling decisions.
  • Annual review + target-setting. Improvement initiatives tied to specific metric moves.

Variants

SaaS Unit Economics

Subscription business model.

E-commerce Unit Economics

DTC + retail.

Marketplace Metrics

Two-sided platforms.

Enterprise B2B

High-ACV long-cycle businesses.

Frequently asked questions

How do I use the Customer Analytics Deep Dive — CAC / LTV / Segmentation Mastery prompt?

Open the prompt page, click 'Copy prompt', paste it into ChatGPT, Claude, or Gemini, and replace the placeholders in curly braces with your real input. The prompt is also launchable directly in each model with one click.

Which AI model works best with Customer Analytics Deep Dive — CAC / LTV / Segmentation Mastery?

Claude Opus 4 or Sonnet 4.5. Customer analytics requires finance + analytics + business understanding. Top-tier reasoning matters.

Can I customize the Customer Analytics Deep Dive — CAC / LTV / Segmentation Mastery prompt for my use case?

Yes — every Promptolis Original is designed to be customized. Key levers: CAC = TOTAL marketing + sales cost / new customers. Not just ad spend.; LTV = gross margin × 1/churn rate. Not revenue.

Explore more Originals

Hand-crafted 2026-grade prompts that actually change how you work.

← All Promptolis Originals
P

Curated by

Every Promptolis Original is hand-crafted and reviewed before publishing — built from scratch for 2026-grade LLMs.

Last reviewed on · About Promptolis