Average order value over time

The Average order value over time report visualizes fluctuations in Average Order Value (AOV) across customizable time units, enabling granular analysis of purchasing behavior and sales performance.

Formulas

• Average Order Value (AOV) = (Gross sales - Discounts) / Orders
• Gross sales = Units sold × Product price

> Excludes post-purchase adjustments (e.g., edits, replacements).

Group data by hour, day, week, month, quarter, year, hour of day, day of week, or month of year to analyze trends. Compare date ranges to identify seasonal patterns and long-term shifts.

Use this report to

• Track AOV trends: Monitor daily, weekly, monthly, quarterly, or yearly AOV changes to detect seasonality and strategic impacts.
• Multidimensional analysis: Segment AOV by region, customer segment, product category, or sales channel (e.g., online store, mobile app) to uncover growth opportunities and risks.
• Optimize pricing strategies: Leverage trend insights to refine promotions, product bundling, and channel-specific pricing.

Example

Scenario: Your store sells in one day:

• 3 T-shirts at $20 each (10% discount)
• 2 sneakers at $50 each (20% discount)

Calculations:

1. Gross sales:

   T-shirts: 3 × $20 = $60  
   Sneakers: 2 × $50 = $100  
   Total gross sales = $60 + $100 = $160

2. Discounts:

   T-shirts: 10% × $60 = $6  
   Sneakers: 20% × $100 = $20  
   Total discounts = $6 + $20 = $26

3. AOV:

   AOV = ($160 - $26) / 5 orders = $134 / 5 = $26.80