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

Formula

LTV 365 = SUM ( Net revenue on each customer’s orders within 365 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 selects customers whose first order was in January. Orders placed after the range still count if they’re inside the customer’s own window.
  2. Each customer gets their own 365 days, counted from their first order. An order placed up to 365 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 365 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 365 days shows what it has spent so far.

Example

A store’s January cohort has 500 customers:

How to interpret it

  • Compare cohorts of the same age. A cohort acquired five months ago hasn’t had 365 days yet, so its LTV 365 will look low next to older cohorts.
  • Hold it against what a customer cost. Compare LTV 365 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 →