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
- 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.
- Each customer gets their own 365 days, counted from their first order. An order placed up to 365 full days later is included.
- Cancelled orders are excluded. Orders without a Shopify customer aren’t included.
- 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.
- 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.
Related Metrics
See all LTV metrics →