CLV 180: 180-Day Cohort Lifetime Value

Total revenue generated by all customers within 180 days (6 months) of their first purchase.

Formula

CLV 180 = SUM ( Customer Revenue ) WHERE days since first order ≤ 180

Formula Components

Metric	Definition
Customer Revenue	Total revenue from all customer orders
days since first order ≤ 180	Filters to orders placed within 180 days of each customer’s first purchase

Metadata
Type	Currency
Data Source	Shopify
Aggregation	Sum

Example

Analyzing customers acquired in January shows $127,800 in CLV 180:

Cohort	Customers	First Orders	Repeat Orders (180d)	CLV 180
January	1,200	$72,000	$55,800	$127,800
February	1,450	$87,000	$71,050	$158,050
March	1,100	$66,000	$52,800	$118,800

The January cohort’s CLV 180 of $127,800 represents all revenue from those 1,200 customers within 6 months of their first purchase.

How It Works

CLV 180 sums all revenue from each customer’s orders within 180 days of their first purchase. This includes their initial order plus any repeat purchases made in that window. Unlike LTV 180 which calculates an average per customer, CLV 180 shows the total dollar value generated by the entire cohort—making it ideal for measuring aggregate cohort performance and ROI.

When to Use

Scenario	Action
Measuring cohort ROI	Compare CLV 180 against total acquisition spend for the cohort
Budgeting acquisition spend	Set monthly acquisition budgets based on expected CLV 180 returns
Evaluating marketing campaigns	Track CLV 180 for customers acquired during specific campaigns
Forecasting 6-month revenue	Project total revenue from newly acquired customer cohorts

Metric	Relationship
CLV 90	Shorter 90-day window for faster cohort performance signals
CLV 365	Full-year total for complete cohort value assessment
LTV 180	Average per-customer value (same 180-day window)
Total Revenue	Total revenue across all customers and timeframes

See all Lifetime Value metrics →

CLV 120 CLV 365

⌘I

​Formula

​Formula Components

​Example

​How It Works

​When to Use

​Related Metrics

Formula

Formula Components

Example

How It Works

When to Use

Related Metrics