.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Measures product pricing effectiveness and revenue performance across SKUs or categories.
Formula
Net Sales ÷ Total Units
Insights and Actions
- Pricing Strategy — Track how pricing adjustments impact average selling value.
- Product Mix — Identify which products contribute to a higher ASP.
- Market Positioning — Evaluate premium vs. budget product performance.
- Revenue Optimization — Helps forecast sales based on price changes.
- Promotion Impact — Observe ASP shifts during discount campaigns.
Detailed Breakdown
- Net Sales= Net Sales = gross_sales - discount_amount
- Total Units
Suggested Dimensions
Product / SKUCategoryChannelRegionCampaign
Related Metrics
Example Use
Prompt
What was our average selling price last month?
Response
ASP for Last Month — $42.30
Query
SELECT COALESCE(SUM(net_sales_amount) / NULLIF(SUM(quantity), 0),0) AS asp FROM spends WHERE spends_date BETWEEN :start AND :end;