.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Total Orders represents the total number of confirmed orders placed within a selected period, regardless of their status. It serves as a measure of overall order volume and customer activity.
Formula
Total Orders = Count of unique order IDs
Insights and Actions
- Indicates overall market demand or traffic conversion effectiveness.
- Helps forecast fulfillment workload and shipping requirements.
- Links marketing activity with actual purchase volume.
- Tracks changes in buying activity over time.
- Reveals peaks during holidays or major promotions.
Detailed Breakdown
- Total Orders Count Of Unique Order Ids
Suggested Dimensions
ChannelCampaignProduct / SKURegionDevice
Related Metrics
Example Use
Prompt
How many total orders did we receive yesterday?
Response
Total Orders from Yesterday — 2,150
Query
SELECT COUNT(DISTINCT order_id) AS total_orders FROM orders WHERE order_date BETWEEN :start AND :end;