.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Reflects customer satisfaction and product quality.
Formula
(Returned Units / Total Units Sold) × 100
Insights and Actions
- Quality Insight — High returns may indicate product or sizing issues.
- Customer Experience — Monitors satisfaction and delivery accuracy.
- Inventory Forecasting — Adjust future production based on returns.
- Profit Impact — Returns reduce both revenue and efficiency.
- Policy Evaluation — Analyze effects of return policies.
Detailed Breakdown
- Returned Units
- Total Units Sold
- 100
Suggested Dimensions
ProductCategoryRegionCustomer Type
Related Metrics
Example Use
Prompt
What’s our return rate for the past 30 days?
Response
Return Rate — 5.1%
Query
SELECT (SUM(returned_items) * 100.0 / NULLIF(SUM(sold_items),0)) AS return_rate FROM orders WHERE order_date BETWEEN :start AND :end;