.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Total Cancellations represent the total number of orders that were canceled before fulfillment. This metric helps identify order management issues, customer experience gaps, and inventory mismatches.
Formula
Total Cancellations = Count of canceled order IDs
Insights and Actions
- High cancellations could indicate stock or delivery problems.
- Understand why customers change their minds post-purchase.
- Evaluate the impact of cancellation rules on sales performance.
- Spot spikes that align with specific products or regions.
- Measure operational dependability and checkout experience.
Detailed Breakdown
- Total Cancellations Count Of Canceled Order Ids
Suggested Dimensions
ChannelProduct / SKUCampaignRegionCustomer Type
Related Metrics
Example Use
Prompt
How many cancellations occurred last week?
Response
Total Cancellations Last Week — 72
Query
SELECT COUNT(DISTINCT CASE WHEN is_cancelled_flag = 1 THEN order_id END) AS total_cancellations FROM orders WHERE order_date BETWEEN :start AND :end;