Subscription E-commerce Profitability: CAC, LTV, and Cohort Analysis

Decoding Subscription Profitability: From CAC to Sustainable Growth

For e-commerce store owners running subscription models, the allure of recurring revenue can mask a critical blind spot: understanding true customer profitability and acquisition payback. Many scale marketing spend based on retention assumptions, only to discover they're "flying blind" on key metrics. The core question isn't just "are customers coming back," but "are they coming back profitably, and quickly enough to sustain growth?"

The Challenge with Standard Analytics for Subscriptions

Platforms like Shopify offer robust sales data, but their native analytics often fall short for subscription businesses. Obtaining clear, detailed cohort views—showing customer behavior and value over 30, 60, or 90 days post-acquisition—can be challenging. This gap leaves store owners guessing about their Customer Lifetime Value (LTV) by acquisition cohort, making it difficult to ascertain the actual payback window for Customer Acquisition Cost (CAC).

Beyond Revenue: Understanding True Profitability

To move from assumptions to data-driven strategy, define and track the right financial metrics:

Customer Acquisition Cost (CAC): The total cost to acquire one new customer. Calculate by dividing total ad spend by new customers acquired in that period, not just platform-reported cost per purchase. Attribute spend carefully, as it often serves both new and returning customers.
Cost of Delivery (COD): For subscriptions, this hits every reorder. It includes landed product cost, pick and pack, shipping labels, and payment processing fees.
Gross Profit: Net sales minus your Cost of Delivery (COD).
Contribution Profit: Gross profit minus the ad spend directly attributable to that customer or cohort.

The true metric isn't just whether "most customers come back," but at what point their cumulative gross profit covers your initial CAC. If your CAC is $38 and your gross margin per order is, say, $15, you need roughly three orders to break even on acquisition. The real question, then, becomes: "What percentage of a cohort survives to place that third order?"

Practical Steps to Uncover Your Cohort Data

While dedicated analytics tools offer sophisticated LTV and cohort views, you can start with existing resources.

1. Leveraging Shopify's Built-in Cohort Report

Shopify includes a cohort analysis feature providing valuable insights:

Navigate to Analytics, then Reports.
Open the default "Customer cohort analysis" report or click New exploration and switch the report method to Cohorts.
Set the primary metric to "Amount spent per customer." This shows the average cumulative amount customers in that cohort have spent since their first order.
Each row represents an acquisition cohort (e.g., month of first purchase), and columns show months since first purchase. This provides your essential 30, 60, and 90-day views.

Important Caveat: "Amount spent per customer" is revenue, not profit. You'll need to "haircut" this revenue data by your gross margin percentage to estimate gross profit per customer over time. For instance, if your gross margin is 60%, a cohort showing $63 in cumulative revenue has only generated about $38 in gross profit—your true breakeven point on a $38 CAC.

2. Manual Spreadsheet Analysis

For a detailed, custom view, especially if your subscription app has its own data, a manual approach is effective:

Export customer data from your subscription app and Shopify order exports.
Identify all customers acquired within a specific month (your cohort).
Track each customer's subsequent orders and the total revenue/gross profit they've generated.
Count how many customers from that cohort placed a second, third, or fourth order to reveal retention rates.

Critical Metrics for Sustainable Subscription Growth

Beyond general cohort analysis, focus on these specific indicators:

First-to-Second Order Retention Rate: High churn immediately after the first order signals product-market fit issues, onboarding problems, or acquisition strategies attracting deal-seekers. Nail this initial retention before scaling acquisition.
CAC Payback Window (in Gross Profit): How many months or orders does it take for a customer to generate enough gross profit to cover their acquisition cost? This is your ultimate breakeven point.
Attributing Spend by Outcome: Segment ad spend by whether it brought in new customers or returning customers. Track these costs separately.
Cohort Payback Trends: Monitor if newer cohorts are taking longer to reach their payback point. A lengthening payback period can indicate increasing real acquisition costs or declining product value.

The Path to a Sustainable Business

Scaling marketing spend without a clear view of your true gross profit payback window is a high-risk gamble. A small, loyal customer segment might carry the overall LTV average, while significant paid spend acquires one-time buyers who never earn back their CAC. This can lead to a widening "cash gap"—the period between paying for a customer and earning back that investment—which can starve a business of working capital.

The path to a sustainable subscription business lies in clarity. By moving beyond simple revenue metrics to understand gross profit, tracking cohort performance, and meticulously calculating your true CAC payback, you transform your marketing spend from a gamble into a strategic investment. This data-driven approach allows you to scale with confidence, building a resilient and profitable enterprise.