Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

The Cohort That Did Not Come Back: How an Online Retailer Used Consulting and E-Commerce Analytics to Diagnose a Customer Lifetime Value Collapse in Its Highest-Spend Acquisition Cohorts

The Cohort That Did Not Come Back: How an Online Retailer Used Consulting and E-Commerce Analytics to Diagnose a Customer Lifetime Value Collapse in Its Highest-Spend Acquisition Cohorts

Executive Snapshot

Client

Direct-to-Consumer Online Retailer, Germany

Situation/Challenge

The client had scaled its paid acquisition spend significantly over the prior eighteen months, with strong first-purchase conversion rates and encouraging average order values at the point of acquisition. Twelve months after the spending increase, the revenue and customer team noticed that blended customer lifetime value across those cohorts was falling materially short of the projections that had justified the acquisition spend. The growth team was attributing the gap to market saturation, but the finance team wanted a more specific explanation before authorising the next acquisition budget cycle.

Objective

Engage consulting to build a cohort-level customer lifetime value diagnostic framework, then apply e-commerce analytics to the client's customer purchase history, acquisition channel data, and product category data to identify which cohorts were underperforming, why, and what operational change could recover the projected lifetime value.

Constancy Researchers Solution

Consulting Services combined with Data Analytics & Business Intelligence, a consulting-led cohort-level CLV diagnostic framework, paired with an analytics workstream examining acquisition channel composition, post-acquisition purchase behaviour, and product category repurchase patterns across all cohorts from the scaling period.

Impact

Analytics confirmed the CLV underperformance was concentrated in cohorts acquired through two specific paid social channels during a defined six-month window, and that those cohorts showed a dramatically lower second-purchase rate than cohorts acquired through other channels in the same period. Consulting analysis traced this to a specific product category that had been heavily promoted through those channels, where the category's inherent repurchase dynamics were inconsistent with the CLV model the acquisition spend had been justified against.

Client Outcome

The client adjusted its acquisition channel mix and creative strategy to reduce dependency on the two underperforming channels for the implicated product category, and revised its CLV projection methodology to incorporate category-specific repurchase dynamics before the next acquisition budget cycle was authorised.

The Situation / Challenge

Customer lifetime value projections in direct-to-consumer e-commerce are typically built on historical repurchase rates and average order value trends from existing customers, and then applied as assumptions to new customer acquisition cohorts. The problem with that approach is that it assumes the new customers being acquired behave like the existing customers in the historical dataset, which is only true if the acquisition channel mix and the product categories being used to acquire new customers are comparable to those that generated the historical data the projection was built on.

The client’s growth team had scaled paid acquisition through a channel mix that included two paid social platforms where the cost per first-purchase conversion was favourable, and had promoted products across those platforms in categories that happened to perform well in short-term paid social creative formats. The CLV projections justifying the spend were built on the historical blended repurchase rates across the entire existing customer base, which included a very different channel and product category acquisition mix.

By the time the CLV underperformance was visible in the cohort data, the growth team had been spending against projections that were structurally mismatched to the customers those projections were being applied to for over a year.

Key Challenges

  • No cohort-level CLV diagnostic breaking down lifetime value performance by acquisition channel, acquisition period, and first-purchase product category.
  • CLV projections built on blended historical repurchase rates applied without adjusting for the new cohorts’ channel and category mix’ channel and category mix.
  • A growth team attributing the gap to market saturation without evidence distinguishing a structural model mismatch from a genuine demand decline.
  • Finance team requiring a specific analytical explanation before authorising the next acquisition budget cycle.
  • No visibility into whether CLV underperformance was concentrated in specific channels or categories that could be corrected, or was uniform across all recent acquisition activity.
  • Risk that the next acquisition budget cycle would be built on CLV projections with the same structural mismatch if the methodology was not corrected.

Customer lifetime value projections that are built on blended historical repurchase rates and applied to new acquisition cohorts with a different channel and product category mix are not projections, they are extrapolations that embed an assumption of behavioural similarity that may not hold. Discovering the mismatch a year after the spend has been committed is an avoidable outcome when cohort-level analytics are applied during the acquisition phase rather than retrospectively.

Constancy Researchers Solution

Constancy Researchers built a cohort-level CLV diagnostic framework and applied it to the client’s full purchase history and acquisition data, identifying precisely which cohorts were underperforming, what their first-purchase and channel characteristics were, and whether the underperformance was concentrated in factors that could be operationally corrected.

Cohort-Level CLV Diagnostic Framework
  • Built a cohort-level CLV diagnostic segmenting customers by acquisition month, channel, and first-purchase category, and computing second-purchase rate.
  • Confirmed that the blended CLV underperformance was not uniform across acquisition cohorts but was concentrated in specific cohort segments.
Acquisition Channel Cohort Analytics
  • Analysed second-purchase rates and twelve-month revenue per customer by acquisition channel.
  • Found paid social channel cohorts showing second-purchase rates significantly below both the historical baseline and same-period cohorts from other channels, concentrating the CLV underperformance on a specific acquisition channel source rather than a general market dynamic.
Product Category Repurchase Pattern Analysis
  • Analysed the product categories through which the paid social channel cohorts had been acquired, examining the historical repurchase rate, repurchase interval.
  • Found that the product categories most heavily promoted through the paid social channels had inherently low repurchase rates and low cross-sell propensity.
CLV Projection Methodology Audit
  • Audited the CLV projection methodology the growth team had used to justify the acquisition spend.
  • Built a revised CLV projection methodology incorporating channel-specific and category-specific repurchase rate assumptions.
Acquisition Strategy & Methodology Correction
  • Delivered an acquisition channel mix recommendation reducing paid social channel dependency for the specific product categories associated with low repurchase dynamics.

The engagement replaced a general market saturation explanation with a specific, operationally actionable diagnosis, and corrected the projection methodology before the next budget cycle committed the same structural error again.

Impact

  • Cohort-level analytics confirmed the CLV underperformance was concentrated rather than uniform, ruling out the market saturation explanation.
  • Paid social channel cohorts showed second-purchase rates significantly below both the historical baseline and other channel cohorts from the same period.
  • The product categories promoted through the implicated channels were confirmed as having inherently low repurchase and cross-sell dynamics.
  • The CLV projection methodology was confirmed as applying blended repurchase rates without channel or category adjustment.
  • A revised methodology incorporating channel-specific and category-specific repurchase assumptions was built and validated.
  • Paid social channel mix was adjusted to reduce dependency on channels where the first-purchase category mix was structurally incompatible with the CLV targets.
  • The revised CLV projection methodology was applied to the next acquisition budget cycle before authorisation.
  • Finance leadership authorised the next acquisition budget based on a methodology they could validate rather than blended assumptions they could not interrogate.

Client Outcome

Diagnosis Specificity

The CLV underperformance was traced to two specific paid social channels and specific product categories within those channels, replacing a general market saturation attribution.

Methodology Corrected

CLV projections now incorporate channel-specific and category-specific repurchase assumptions rather than blended historical rates applied uniformly.

Channel Mix Adjusted

Paid social acquisition spend was rebalanced away from channels whose first-purchase category mix was incompatible with the CLV model.

Budget Authorisation

Finance leadership authorised the next acquisition budget based on a methodology they could interrogate, replacing projections built on unexamined blending assumptions.

Retrospective Quantification

The revised methodology quantified the extent to which original projections had overstated the paid social cohort lifetime value, giving the growth team a calibration benchmark.

Saturation Myth Dispelled

Analytics evidence ruled out market saturation as the primary cause, redirecting the growth team's strategic energy toward an operationally correctable channel and category problem.

Cohort Intelligence

A cohort-level CLV diagnostic framework was retained for monitoring acquisition performance in real time during future scaling periods.

Cross-Functional Alignment

Growth and finance teams aligned around a shared, analytically grounded understanding of what had driven the CLV gap and what changes were needed to prevent its recurrence.

Market Positioning

The retailer was repositioned as a growth operator that validates its acquisition model assumptions at the cohort level rather than discovering mismatches in the annual revenue review.

Looking to unlock new growth opportunities with data-driven insights?

Connect Now

Case Studies

Learn how our success stories power data-driven growth across industries

Speak with an Analyst

    Download TOC

      Request a Sample Report