.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Average Order Value (AOV) measures the average amount spent per transaction. It helps assess customer purchasing behavior and pricing effectiveness.
Formula
AOV = Net Sales ÷ Total Orders
Insights and Actions
- Tracks how much customers spend on average.
- Identify tactics to increase AOV through bundles or add-ons.
- Evaluate the impact of price changes on customer behavior.
- Higher AOV during promotions signals successful targeting.
- Helps project total sales based on order volume trends.
Detailed Breakdown
- Aov Net Sales
- Total Orders= Total Orders = Count of unique order IDs
Suggested Dimensions
ChannelCampaignCustomer TypeRegionDevice
Related Metrics
Example Use
Prompt
What’s our average order value for this week?
Response
AOV for This Week — $48.75
Query
SELECT COALESCE(SUM(net_sales_amount), 0) / NULLIF(COUNT(DISTINCT order_id), 0) AS aov FROM orders WHERE order_date BETWEEN :start AND :end;