Ecommerce customer value analysis

Ecommerce customer value analysis asks what customers have contributed so far and whether that evidence supports a decision. Start with a defined customer group, an order-value rule and a fixed observation window. Keep recorded value separate from any forecast.

Choose the decision and measure

A report might help a store review an introductory offer, investigate first-product groups or assess whether acquisition spending deserves closer study. Sales value can answer a spending question. Contribution requires reliable cost records. Neither should be called lifetime value without a stated horizon and calculation.

For an Australian single-currency report, label amounts A$. If orders use several currencies, retain each transaction currency and document any conversion before combining amounts.

Before adopting a platform measure, check what its timeframe controls: customer entry, order activity or the dates used to display results. Those are not interchangeable. A measure based on customers’ full order histories may answer a different question from a report that deliberately limits value to a fixed period after entry.

Key Metrics in Ecommerce Customer Value Analysis

Read platform measures on their own terms

Shopify’s customer reports include average order count, average order totals and expected purchase value. These describe different things, and expected purchase value is not recorded value. Name the specific measure in the report and keep expected or predicted figures separate from observed results.

A selected report timeframe does not necessarily restrict the customer history behind a result. Shopify’s customer reports can use a new customer’s entire order history, so someone whose first order was in November can appear as a repeat customer in a November-only report after ordering again in December. That is different from measuring a fixed period after entry.

Shopify defines average order value using gross sales and discounts while excluding adjustments. Adjustments include edits, exchanges and returns made after an order is created. A custom measure that includes those later changes is not directly comparable to Shopify’s average order value, even if both are labelled the same way.

Shopify vs Custom Measures: Key Differences

Pros and Cons of Using Shopify’s Customer Reports

Compare like histories

Compare customer groups at the same completed age, under the same order-status and value rules. Divide each group's qualifying value by its original eligible entrant count, including customers who did not buy again. Show the count and total beside the average. A fixed observation window is one possible reporting choice, not a customer's whole lifetime.

Flag open observation windows as incomplete rather than treating them as complete.

Shopify lists Customer cohort analysis among its customer reports. Check that report’s definitions before comparing it with a custom cohort.

Keep the platform’s measure definition alongside the report definition. If the definitions cannot be aligned, report the results separately rather than treating them as a like-for-like trend.

Customer Observation Window: Timeframe Considerations

Check periods and value definitions

Report freshness can affect a comparison. Shopify customer reports might not show activity from the past 12 hours; the New vs returning customer report is an exception, with data up to date within a few seconds. Shopify sales reports are generally up to date within about a minute. Record the extraction time and allow for these differences when interpreting recent results.

The New vs returning customer report can group customers by hour, day, week, month, quarter, year, hour of day, day of week or month of year. This choice changes how customers are grouped in the report; it does not make their post-entry histories equally complete. Choose a grouping that matches the decision, then check whether customer ages are comparable.

Shopify defines gross sales as product price multiplied by quantity before taxes, shipping, discounts and sales reversals. Its sales reports include pending, cancelled and unpaid orders in gross sales, while excluding test and deleted orders. Those inclusion rules matter when choosing a population and interpreting a sales figure; gross sales is not the same as payments received.

Use a difference to choose the next check

A higher average may be driven by a few large orders, first-order price, offers, missing customer links or later purchases. Show a distribution or median where available, and retain an unknown-identity group. A first-product or acquisition label describes a group; it does not show that the product or channel caused its later spending.

Record the observed difference, group sizes, factors that could change the comparison and the next investigation. If the decision depends on profit, check cost coverage before using a sales-value ranking.

Keep the customer key, qualifying statuses, amount formula, time zone, extraction date and adjustment cut-off with the result.