.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Measures the percentage of orders canceled after being placed. Indicates order fulfillment reliability, customer satisfaction, and operational efficiency.
Formula
Cancellation Rate = (Canceled Orders ÷ Total Orders) × 100
Insights and Actions
- High cancellation rates may signal poor user experience or product issues.
- Helps identify fulfillment or stock-related delays.
- Frequent cancellations may distort true demand forecasts.
- Useful for evaluating payment or logistics performance.
- Tracks how flexible return/cancellation policies affect overall business.
Detailed Breakdown
- Cancellation Rate Canceled Orders
- Total Orders= Total Orders = Count of unique order IDs
- 100
Suggested Dimensions
ChannelProduct / SKURegionCampaignCustomer Type
Related Metrics
Example Use
Prompt
What’s our cancellation rate for this week?
Response
Cancellation Rate for This Week — 3.4%
Query
SELECT COALESCE(COUNT(DISTINCT order_id) * 100.0 / NULLIF(COUNT(DISTINCT order_id), 0), 0) AS cancellation_rate FROM orders WHERE order_date BETWEEN :start AND :end;