Free tool · Shopify Insights

What's your customer LTV, really?

Measured from your own orders, not a blended average: what a customer is worth from day 30 to year two, what returns and discounts take off the top, and which codes have quietly gone public.

  1. 01
    Build one report in Shopify. A saved Sales exploration, about five minutes, once.
  2. 02
    Drop the CSV here. It's read in this tab; nothing is uploaded.
  3. 03
    Read your numbers. Seven views, each with the caveat that goes with it.
Input · Shopify exploration CSVLocal only

Drop your CSV here

or

Runs entirely in your browser. Your order data never leaves your computer.

What you'll see

  1. 01LTV from day 30 to year 2, as orders × order value
  2. 02Where $100 of sales goes
  3. 03What discount-code customers are worth
  4. 04Returns, year over year
  5. 05When repeat buyers come back
  6. 06How much runs on codes
  7. 07Codes that have leaked or outlived their purpose

01 · Customer lifetime value

What a new customer is worth, at one year

Net LTV per customer

—

Before returns

—

Returns take

—

Orders per customer

—

Net per order

—

30d1y2y

  • Net of returns (what you keep)
  • Before returns (what most dashboards show)

Average order value

What an order is worth, month by month

  • Net of returns
  • Before returns
02 · Where $100 of sales goes

For every $100 of sales, you keep —

    03 · Customers acquired with a discount code

    Are discount-code customers worth less?

    One-year LTV by the quarter customers were acquired

    • Full price first order
    • Discount code on first order

    04 · Returns over time

    Return rate by the month the order was placed

      05 · Time to second order

      When repeat customers come back

      Share of new customers who have placed a second order, by days since their first

      06 · Discount dependency

      How much of the business runs on codes

      • All orders using a code
      • First orders using a code
      07 · Code health

      Codes that may have outlived their purpose

      The tool can see that a code has spread or become permanent. It can't see whether those buyers would have paid full price without it. That takes a holdout test, which is what a measurement audit is for.

      08 · More from your orders

      The rest of the picture

        Net LTV at one year, by acquisition quarter
        Orders per customer, first year or more
        Monthly sales: new vs returning customers
        • Returning customers
        • First orders
        This is the napkin version

        Want to know which of this revenue is actually incremental?

        Everything above is measured from your own orders. What it can't tell you is whether the discount-code buyers, the promo spikes and the platform-reported wins would have happened anyway. A measurement audit tests that directly.

        Find your gaps