Calculating Average Order Value For Multi‑Channel Retailers: Step‑By‑Step Example

Average Order Value The average revenue value of an order during a defined period. For multi-channel retailers, calculating AOV requires consistent definitions across channels and adjustments for discounts, taxes, refunds, and channel-specific fees.

Many retailers report a single blended AOV, but a more actionable approach is to calculate per-channel AOV (website, marketplaces, brick-and-mortar, wholesale) and a consolidated AOV that reconciles differences in how revenue is recorded across systems.

Data Sources And Definitions

Before calculating, define what ‘order’ and ‘revenue’ include. Common choices:

• Order Definition: A customer checkout that results in a paid transaction. Decide whether to include marketplace orders and POS transactions.
• Revenue Definition: Net transaction revenue: product price minus discounts, excluding sales tax (collected on behalf of governments), and minus refunds. Include shipping if you consider it part of order revenue for your business model.
• Time Period: Align reporting windows across channels (calendar month, quarter). Use order-placed date or order-fulfilled date consistently.

Step‑By‑Step Calculation

Follow these steps to compute both per-channel and consolidated AOV.

1. Collect Gross Order Data: Pull total orders and gross sales per channel for the period.
2. Subtract Discounts: Remove coupon and promotional discounts from gross sales to get net sales.
3. Exclude Taxes Collected: Remove sales tax if you don’t treat it as revenue.
4. Subtract Refunds/Returns: Deduct refunded amounts or return credits to measure net transaction revenue.
5. Decide On Shipping: Include or exclude shipping revenue consistently; if included, reconcile where shipping was paid to carrier vs netted off.
6. Compute AOV: AOV = Net Transaction Revenue / Number of Orders (per channel and then aggregated).

Handling Returns, Discounts, And Marketplace Fees

Key adjustments that commonly trip up multi-channel calculation:

• Returns & Chargebacks: Use net revenue after refunds. For returns with restocking fees or refurbished resale, adjust accordingly.
• Discounts: Account for both order-level and item-level discounts. Do not double-count discounts applied by marketplaces.
• Marketplace Fees: Decide whether marketplace commissions reduce revenue or are treated as operating expense. For order-level economics, subtract commissions to get net revenue per order.

Channel Attribution And Blended AOV

Channels differ in how revenue is recorded: marketplaces may pay sellers after fees; POS systems include local tax; direct channels may include shipping. To build a blended AOV:

• Normalize Revenue Metrics: Convert all channels to the same net revenue basis (usually net-of-discounts-and-returns, excluding tax).
• Consolidate Order Counts: Count each sold order once in the channel where the transaction occurred. For omnichannel events (buy online pick up in store), choose a consistent rule (often the channel where payment was taken).
• Weight Appropriately: Blended AOV = Sum(Net Revenue All Channels) / Sum(Orders All Channels).

Example Calculation

Consider a retailer with three channels during a month:

• Website: Gross sales $120,000, discounts $10,000, refunds $2,000, tax $8,000, orders 2,000. Net revenue (exclude tax) = $120,000 − $10,000 − $2,000 = $108,000.
• Marketplace: Gross sales $60,000, discounts $3,000, refunds $1,000, marketplace commission $6,000, orders 800. Net revenue (seller receipts) = $60,000 − $3,000 − $1,000 − $6,000 = $50,000.
• POS (Stores): Gross sales $40,000, discounts $2,000, refunds $500, tax $3,000, orders 900. Net revenue (exclude tax) = $40,000 − $2,000 − $500 = $37,500.

Aggregate net revenue = $108,000 + $50,000 + $37,500 = $195,500. Aggregate orders = 2,000 + 800 + 900 = 3,700. Blended AOV = $195,500 / 3,700 ≈ $52.84.

Best Practices And Pitfalls

• Keep Definitions Consistent: Document and apply the same rules across reporting periods to track trends reliably.
• Use Net Revenue For Decision-Making: Gross sales overstate economic value and can mislead pricing and promotions decisions.
• Watch For Timing Mismatches: Marketplace settlement delays and returns processing windows can distort monthly AOV if not normalized.
• Segment AOV: Report AOV by channel, campaign, and cohort—blended AOV hides actionable differences.

In short, the Average Order Value for multi-channel retailers is most useful when built on a consistent net-revenue basis and reported by channel. Accurate AOV requires clear definitions, adjustments for discounts/returns, and attention to attribution; do this and AOV becomes a reliable input to pricing, promotions, and fulfillment planning.