Skip to main content
LTV 180 is the average net revenue each new customer brings in during the 180 days after their first order. Customers are grouped by the date of that first order. The app shows it as LTV 180d.

​
Formula

LTV 180 = SUM ( Net revenue on each customer’s orders within 180 days of their first order ) ÷ Customers whose first order falls in the selected date range

​
Formula Components

​
How Upstack calculates it

  1. The date range picks the cohort. Selecting January to March selects customers whose first order was in those months. Orders placed after the range still count if they’re inside the customer’s own window.
  2. Each customer gets their own 180 days, counted from their first order. An order placed up to 180 full days later is included.
  3. Cancelled orders are excluded. Orders without a Shopify customer aren’t included.
  4. Refunds follow your Refund Date Attribution setting. With the default, Refund date (matches Shopify), a refund counts only if it was processed within the 180 days. With Original order date, every refund on an in-window order counts, whenever it happened.
  5. Young cohorts aren’t held back. A cohort that’s younger than 180 days shows what it has spent so far.

​
Example

A store’s Q1 cohort has 2,500 customers:

​
How to interpret it

  • Compare cohorts of the same age. A cohort acquired three months ago hasn’t had 180 days yet, so its LTV 180 will look low next to older cohorts.
  • Hold it against what a customer cost. Compare LTV 180 with CAC for the same acquisition period.
  • It’s revenue, not profit. For value after product, fulfillment and payment costs, use Cohort CM2.
See all LTV metrics →