Customer LTV Analysis that finds your best customers
Growth & MarketingFind your top 10% VIP customers. See which channels bring repeaters vs. one-and-done buyers. Optimize spend for LTV, not first order.
Your first run is free - no card required.
Growth & Marketing Data
Live sync
Auto‑Generated
2 min ago
Coming Q3 2026
📍 Cohort grouping complete, channel attribution in testing
What's Inside the Excel
Get a ready-to-use file with everything you need
📊
Cohort performance
Month-by-month LTV and repeat rates by acquisition date
👑
VIP customer list
Top 10% customers by actual $ spent with contact info
💰
LTV by channel
Facebook vs. Google vs. organic - which bring loyal buyers
📋
Repeat curves
When customers make 2nd, 3rd, 4th purchases
Available for These Platforms
Platform-specific implementations of this decision kit with unique insights for each
What You'll Get
Real outcomes for your business
👑
Know your VIPs: Top 10% of customers driving 60-80% of repeat revenue - treat them right
💵
Channel payback: See how long until Facebook vs. Google customers pay back CAC
🎯
Smart budgets: Shift spend to channels that bring loyal buyers, not one-hit wonders
Is this for me?
✓
You want to know which customers are actually worth acquiring
✓
You need to see if Facebook vs. Google customers repeat better
✓
You want to optimize for LTV, not just first-order revenue
How We Calculate LTV & Cohort Performance
From first purchase to lifetime value, by acquisition source
📊
Customer Lifetime Value (LTV)
Definition: (Total revenue from customer) ÷ (Time since first purchase) × expected lifespan
Source: Order history by customer
Granularity: Per-customer, averaged by cohort
📊
Repeat Rate
Definition: (Customers with 2+ orders) ÷ (Total customers) × 100
Source: Order count per customer
Granularity: By cohort month, by channel
📊
Channel Payback Period
Definition: Months until cumulative LTV > estimated acquisition cost
Source: LTV curve by channel + CAC estimates
Granularity: Per-channel, by cohort
Key Features
Unlock powerful insights with these automated features.
Cohort Performance Grid
Month-by-month view: see which cohorts repeat best and drive highest LTV.
Top Customer Identification
Ranked list of your best customers by LTV, with contact info for VIP treatment.
LTV by Acquisition Channel
Compare Facebook vs. Google vs. organic vs. email - see which channels bring loyal customers.
Repeat Purchase Curves
Visual timeline showing when customers typically make their 2nd, 3rd, 4th purchases.
Why Manual Reporting Doesn't Work
Hours spent downloading CSVs, cleaning data, and formatting spreadsheets. Every week, every month, every platform.
The Pain Points
- Manual exports that eat up your time
- Inconsistent formatting between platforms
- Errors from manual copy-pasting
- Data that's outdated the moment you get it
Our Solution
- Fully automated report generation
- Expertly formatted Excel & Google Sheets reports
- Fresh data delivered on your schedule
- Pre-built Report Recipes by e-commerce experts
How It Works
3 simple steps to your first report
1. Connect your store
OAuth2 - no passwords
2. Pick dates
Select your date range
3. Download Excel
Ready in ~30 seconds
Prerequisites
- ✓ E-commerce platform with customer order history (Shopify, WooCommerce, or Stripe)
- ✓ Minimum data: 6 months of customer purchase data
- ✓ Optimal: 12+ months for accurate LTV curves
- ℹ️ Channel attribution based on first-touch or last-touch (configurable); CAC data optional, improves payback analysis
Frequently Asked Questions
How do you track which channel acquired each customer?
We use your platform's basic attribution (like Shopify's referring_site). For better accuracy, you can import UTM parameters from Google Analytics.
Can I see my top customers by actual dollars spent?
Yes - we rank customers by net LTV (total spent minus refunds). You'll get a VIP list with contact info for special treatment.
How long do I need data for accurate LTV?
Minimum 6 months, but 12+ months is better for seeing full repeat patterns. We'll work with what you have.
Do you account for refunds in LTV calculation?
Yes - critical for accuracy. A customer who spent $500 but returned $300 shows as $200 LTV, not $500.
Why Choose Spreadsheet Broccoli?
Start automating your e-commerce reporting today and save hours every week.
🚀
Expert-Built Templates
Our report recipes are designed by e-commerce experts who understand what metrics matter most for your business decisions.
⚡
Lightning Fast Setup
Connect your platforms in minutes, not hours. Our OAuth2 integration makes setup secure and simple.
📊
Excel & Sheets Native
Reports are delivered in perfectly formatted Excel files that work seamlessly with your existing workflow.
🎯
Playbooks, not just reports
Our report recipes are designed to provide actionable insights and recommendations for your business.
Ready to Reconcile Your Payouts?
Start using Customer LTV & Cohorts today and turn your data into decisions
No card • Keep the file forever • Cancel anytime