Average Order Value (AOV)

Overview

Average Order Value (AOV) calculates the average amount spent by customers per order, after shipping and taxes.

📘

AOV = (Order Revenue - Shipping Price - Taxes) / Orders Count

The calculation is based on data from the Orders table.

Insights and Actions

Average Order Value (AOV) is a key metric for e-commerce businesses, indicating the average amount spent per order, which provides a lens into customer spending behavior. Efficiently leveraging AOV data can guide strategic business decisions:

• Implement Upselling Techniques: Encourage customers to purchase higher-value items or additional features to increase the overall order value.
• Introduce Bundle Offers: Bundle products together at a slight discount to promote the sale of more items in a single transaction.
• Set Free Shipping Thresholds: Establish a minimum order value for free shipping that's above your current AOV to incentivize larger purchases.
• Create Loyalty Programs: Reward customers for higher spending, encouraging them to increase their order size to unlock rewards.
• Optimize Product Pricing: Regularly review your pricing strategy to ensure it encourages customers to add more to their carts, potentially raising your AOV.

Example Use

Prompt

What's my AOV for the last 90 days?

Response

Query

SQL

SELECT
  COALESCE(
    SUM(od.order_revenue - od.shipping_price - od.taxes) / NULLIF(SUM(od.orders_quantity), 0),
    0
  ) AS aov
FROM
  orders_table AS od
WHERE
  od.platform IN ('stripe', 'shopify', 'amazon')
  AND od.event_date BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 90 DAY) AND DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
ORDER BY
  aov DESC;