Two sizes of plain parcel boxes arranged on a packing bench in a small online shop.

Your Average Order Value Rose. Did Customers Spend More?

An online shop’s average order value rises from $24 to $40. It is tempting to conclude that customers are putting more into their baskets. But the same change can occur even when the average within each customer group stays exactly the same.

The missing question is about the mix of orders. If a larger share comes from a group that already places higher-value orders, the overall average can rise without either group changing its spending pattern.

Start with a definition you can reproduce

For this example, average order value means included order revenue divided by included orders. Both periods use the same currency, revenue rules, and treatment of cancellations, refunds, shipping, and tax. The figures are hypothetical and deliberately simplified.

In a real report, write down those choices. A number based on net merchandise revenue cannot be compared cleanly with one that starts including delivery charges halfway through the series.

Keep the unit clear too. Orders, items, and purchasers are different counts. One person can place several orders, and one order can contain several items. Dividing by the wrong count produces a different metric, even if the chart keeps the same title.

Two groups, unchanged averages

Imagine that the shop classifies each order according to whether its customer is new or returning at the time of purchase. In the first period, there are ninety orders from new customers, averaging $20 each, and ten from returning customers, averaging $60 each.

The first group contributes $1,800 and the second $600. Total revenue is $2,400 across one hundred orders, giving an average order value of $24.

In the second period, there are fifty orders from each group. New-customer orders still average $20. Returning-customer orders still average $60. Revenue is now $1,000 plus $3,000, or $4,000 across one hundred orders. The overall average is $40.

No group’s average increased. The higher-value group simply accounts for more of the orders. This is a change in composition, sometimes called a mix effect.

Do not average the averages without their weights

Taking the simple average of $20 and $60 gives $40. That happens to match the second period because the groups have equal order counts. It does not describe the first period, where nine out of ten orders belong to the lower-value group.

The overall calculation needs the number of orders behind each group average. A group with ninety orders should not receive the same weight as a group with ten when calculating a per-order result.

This is also a useful check when combining reports from branches, devices, or product categories. Keep the underlying revenue and order counts, then recompute the combined value. Avoid assuming that displayed averages can simply be added together and divided by the number of rows.

Hold the mix still for one diagnostic

To ask a narrower question, apply the first period’s order shares to the second period’s group averages. Here that means weighting $20 by 90% and $60 by 10%. The result is $24.

This fixed-mix comparison asks what the average would look like with the earlier composition. It is a diagnostic calculation, not a replacement for the actual $40 result. State which weights you used so someone else can reproduce it.

In a less tidy business, both the group averages and their shares may change. Examine both rather than trying to explain the entire movement with a single label. If a group did not exist in the earlier period, note that limitation before constructing a like-for-like comparison.

Choose the next question before celebrating

A higher aggregate can still be commercially meaningful. More returning-customer orders may be an important development. But order value alone does not establish why the mix changed, whether customers are more profitable, or whether a campaign caused the result.

Look at the relevant companion measures, such as order counts, discounts, returns, and margin, using consistent definitions. Check whether a small number of unusual orders dominates a segment. Keep explanations provisional until the evidence supports them.

A precise report might say that overall order value rose while the two group averages stayed unchanged, alongside a larger share of returning-customer orders. That sentence gives colleagues a testable account of the numbers and a sensible place to investigate next.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top