Skip to content

Lifetime Reports Documentation

Menu Location: Reports > Financial Reports > Lifetime Reports

Access Level: Manager / Administrator / Kiva Admin

Last Updated: 2026-03-01

Overview

The Lifetime Reports page provides deep insights into customer value and churn patterns across your entire business history. This comprehensive analytics dashboard calculates Customer Lifetime Value (CLV), analyzes churn by both time and order count, and breaks down lifetime value by box type, helping you understand long-term customer behavior and optimize retention strategies.

Primary Functions:

  • Calculate overall Customer Lifetime Value using industry-standard methodology
  • Analyze churn patterns by days active (when customers typically cancel)
  • Examine churn patterns by orders received (how many deliveries before cancellation)
  • Compare lifetime value across different box types and sizes
  • Understand long-term customer value trends

Page Layout

Header Section

  • Navigation Links: Quick access to "Monthly Recurring Reports" and "Net Revenue Retention"
  • Page Title: "Reports / Lifetime Reports"

Main Content Area

The page displays four distinct analytical sections:

1. Lifetime Stats Card

  • Customer Lifetime Value metric with detailed calculation popup

2. Churn Breakdown by Days Table

  • Shows when customers cancel relative to signup date
  • Categories from "within 7 days" to "730+ days"
  • Displays count and percentage for each time period

3. Churn Breakdown by Orders Table

  • Shows cancellations by number of orders received
  • Categories from "After 0 orders" to "51+ orders"
  • Displays count and percentage for each order range

4. Lifetime Value By Box Table

  • Revenue breakdown by box size and type
  • Total lifetime value and order count per box variant
  • Average lifetime value calculation per box type

Understanding Customer Lifetime Value (CLV)

What is CLV?

Customer Lifetime Value represents the total revenue you can expect from a customer over their entire relationship with your business. This metric helps you understand how much you can spend to acquire customers while remaining profitable.

Calculation Method:

The system follows the industry-standard CLV formula with four components:

1. Average Order Value (AOV)

  • Formula: Total Revenue / Number of Orders
  • Represents how much customers spend per order on average

2. Purchase Frequency (f)

  • Formula: Number of Orders / Unique Customers
  • Shows how often customers order

3. Customer Value (CV)

  • Formula: Average Order Value × Purchase Frequency
  • Combines spending per order with ordering frequency

4. Customer Average Lifespan (t)

  • Calculated from cancelled customers only (active customers excluded to avoid skewing)
  • Formula: Average of (cancellation date - signup date) for all cancelled customers who received at least one order
  • Converted from seconds to days to years for final calculation

Final CLV Calculation: Customer Value × Average Lifespan (in years) = Customer Lifetime Value

Example: If customers spend $50 per order, order 12 times, and remain active for 2 years on average:

  • AOV: $50
  • Frequency: 12
  • Customer Value: $50 × 12 = $600
  • Lifespan: 2 years
  • CLV: $600 × 2 = $1,200

Why This Matters: If your CLV is $1,200, you know you can spend up to (but preferably well below) $1,200 to acquire each customer while remaining profitable.

Churn Breakdown Analysis

Churn by Days Active

This table reveals when customers are most likely to cancel relative to their signup date, helping you identify critical retention windows.

Time Categories:

  • Within 7 days (early drop-offs)
  • 7-30 days (first month challenges)
  • 31-90 days (getting started phase)
  • 91-120 days (early retention)
  • 121-180 days (mid-term retention)
  • 181-365 days (one-year milestone)
  • 366-730 days (year two)
  • 730+ days (long-term customers)

How to Interpret:

  • High percentages in early periods (0-30 days) suggest onboarding or expectation issues
  • Spikes at specific periods indicate predictable churn triggers
  • Lower percentages in later periods show successful long-term retention

Churn by Orders Received

This table shows cancellations based on how many orders customers received, revealing whether product experience meets expectations.

Order Categories:

  • After 0 orders (cancelled before first delivery)
  • After 1 order (one-and-done customers)
  • After 2-5 orders (early experience issues)
  • After 6-10 orders (medium-term satisfaction)
  • After 11-20 orders (established customers)
  • After 21-50 orders (loyal customers)
  • After 51+ orders (highly loyal customers)

Key Insights:

  • High cancellations after 0-1 orders suggest product/expectation mismatch
  • Gradual decline across categories is healthier than sudden spikes
  • Higher percentages in later categories (20+ orders) indicate strong product-market fit

Common Use Cases

Use Case 1: Calculating Customer Acquisition Budget

Goal: Determine how much to spend on marketing per customer

Steps:

  1. Review the Customer Lifetime Value metric
  2. Decide on target profit margin (e.g., 30% of CLV)
  3. Calculate maximum acquisition cost: CLV × (1 - profit margin)
  4. Use this number to set marketing budget limits

Example: CLV = $800, Target margin = 30%. Maximum acquisition cost = $800 × 0.70 = $560 per customer. Keep marketing costs per acquired customer below $560.

Use Case 2: Improving Early Retention

Goal: Reduce cancellations in first 30 days

Steps:

  1. Review "Churn Breakdown by Days" table
  2. Note percentage cancelling within 7 days and 7-30 days
  3. Review "Churn Breakdown by Orders" for 0-1 order cancellations
  4. Implement targeted onboarding improvements
  5. Monitor changes in these metrics over time

Tips:

  • High early churn often indicates expectation vs. reality gaps
  • Improve product descriptions and set accurate expectations
  • Enhance first-order experience and onboarding communications
  • Consider first-order discounts or bonus items to increase satisfaction

Use Case 3: Box Type Optimization

Goal: Identify most valuable box types for marketing focus

Steps:

  1. Review "Lifetime Value By Box" table
  2. Note which box types generate highest average lifetime value
  3. Compare against acquisition costs for different box types
  4. Focus marketing on highest-value box types
  5. Consider discontinuing or repositioning low-value boxes

Example: Large Organic boxes show $1,200 average lifetime value vs. Small Standard boxes at $400. Focus acquisition marketing on customers likely to choose Large Organic, as they provide 3x the lifetime value.

Report Data & Columns

Churn by Days Table

Column Description Calculation
Cancelled within (days) Time period from signup to cancellation Predefined ranges from 0-7 days through 730+ days
Overall subscription churn Count of customers who cancelled in this period Count of cancelled customer IDs matching criteria
% of cancelled customers Percentage of all cancellations (Period cancellations / Total cancellations) × 100

Churn by Orders Table

Column Description Calculation
Cancelled within (orders) Number of orders before cancellation Predefined ranges from 0 orders through 51+ orders
Overall subscription churn Count of customers Count of cancelled customer IDs with order count in range
% Percentage of all cancellations (Period cancellations / Total cancellations) × 100

Lifetime Value By Box Table

Column Description Calculation
Box Box size and type name Box configuration from system
Total Lifetime Value All-time revenue for this box type Sum of all payments for this box configuration
Total Orders Order count for this box type Count of completed orders for this box
Avg Lifetime Value Average revenue per order Total Lifetime Value / Total Orders

Troubleshooting

CLV Seems Unusually High or Low

Symptoms: Customer Lifetime Value number doesn't match expectations or industry benchmarks.

Solutions:

  1. Click "Customer Lifetime Value" to view detailed calculation breakdown
  2. Review each component (AOV, frequency, lifespan) individually
  3. Verify the data includes representative time period
  4. Consider if your business model differs from standard subscription services

Common Causes:

  • Very new business with limited cancellation history
  • Seasonal business with irregular ordering patterns
  • Recent pricing changes affecting averages

Churn Percentages Don't Add to 100%

Symptoms: Adding up percentages in churn tables doesn't equal exactly 100%.

Solutions: This is normal due to rounding in percentage displays. The underlying counts are accurate, but displayed percentages round to two decimal places.

Note: The system displays "total percent" at the bottom of tables showing the precise sum for verification purposes.

Some Box Types Missing from Lifetime Value Table

Symptoms: Expected box types don't appear in the Lifetime Value By Box table.

Solutions:

  1. Verify the box type has completed orders (not just sign-ups)
  2. Check if box type is very new with no historical orders yet
  3. Ensure box isn't a bundle type (bundles are excluded from this report)

Common Causes:

  • Recently added box types with no order history
  • Bundle boxes (filtered out intentionally)
  • Box types never actually ordered by customers
  • MRR Reports (mrr-reports.php) - Monthly recurring revenue metrics
  • MRR Reports 3 - Net Revenue Retention (mrr-reports3.php) - Year-over-year retention analysis
  • Reports - Customers (reports-customers.php) - Additional customer statistics
  • Admin Subscription Reports (admin-subscription-reports.php) - Subscription pricing analytics

Typical Workflow:

  1. Lifetime Reports → Identify CLV → Set acquisition budgets → Monitor MRR Reports for execution
  2. Notice high early churn → Review specific cancelled customers → Implement onboarding improvements

Permissions & Access

Required Access Level: Manager

Access Level Capabilities:

  • Customer Service: No access to lifetime value analytics
  • Manager: Full access to all lifetime metrics and churn analysis
  • Administrator: Full access to all lifetime metrics and churn analysis
  • Kiva Admin: Full access to all lifetime metrics and churn analysis

Best Practices

Regular Review Schedule

  1. Review CLV quarterly to track long-term business health
  2. Monitor churn tables monthly to catch retention issues early
  3. Compare CLV against customer acquisition costs regularly
  4. Track changes in churn patterns after product or service changes

Data Interpretation

  • Use CLV to inform maximum acquisition spending
  • Focus retention efforts on periods with highest churn percentages
  • Consider both time-based and order-based churn for complete picture
  • Compare box type performance to optimize product mix

Strategic Decision Making

  • Invest in retention for periods showing highest churn
  • Target marketing toward box types with highest lifetime value
  • Set realistic growth expectations based on CLV vs. acquisition costs
  • Use churn data to identify when to re-engage at-risk customers

Things to Avoid

  • Setting acquisition costs too close to CLV (leave room for profit)
  • Ignoring early churn signals (problems compound over time)
  • Focusing only on CLV without monitoring churn patterns
  • Making major decisions based on incomplete data from very new businesses

Quick Reference Card

Task Action/Location
View CLV calculation details Click "Customer Lifetime Value" link
Identify early churn rate Review first 2-3 rows of "Churn by Days" table
Find one-order cancellation rate Look at "After 1 order" row in "Churn by Orders"
Identify most valuable box Find highest "Avg Lifetime Value" in box table
Calculate max acquisition cost CLV × desired profit margin
Access monthly metrics Click "Monthly Recurring Reports" button
View year-over-year retention Click "Net Revenue Retention" button
Total cancelled customer count Top of "Churn by Days" table

FAQs

Why does CLV calculation exclude active customers from lifespan?

Including currently active customers would skew the average down since their full lifespan hasn't been realized yet. Using only completed customer lifecycles provides more accurate predictions.

Should I expect churn to be highest in early periods?

Not necessarily. While some businesses see high early churn, others see steady churn across all periods. Your pattern reveals your specific customer experience and retention challenges.

How can I use the box type data?

Focus acquisition on box types with highest average lifetime value, optimize inventory for popular configurations, and consider discontinuing boxes with very low lifetime value.

What's a good Customer Lifetime Value?

CLV varies dramatically by industry and price point. Focus on whether your CLV is 3-5x higher than your customer acquisition cost for sustainable profitability.

Why do the churn tables show different totals?

The "by days" table counts time from signup to cancellation, while "by orders" counts deliveries received. The same customers appear in both, just categorized differently.

Change Log

2026-03-01

  • Initial documentation created
  • All sections completed
  • CLV calculation methodology detailed
  • Churn analysis guidance provided

End of Documentation

For additional help, contact your system administrator or Kiva Logic support.