.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Fundamental indicator of business profitability.
Formula
Total Revenue - Cost of Goods Sold
Insights and Actions
- Profit Health — Indicates how efficiently products are produced or sourced.
- Pricing Review — Compare gross profit margins across products.
- Cost Management — Monitor the impact of rising COGS.
- Trend Analysis — Assess long-term profitability performance.
- Strategic Planning — Input for setting pricing and production goals.
Detailed Breakdown
- Total Revenue
- Cost Of Goods Sold
Suggested Dimensions
Product / SKUCategoryChannelRegion
Related Metrics
Example Use
Prompt
What’s our gross profit for Q3?
Response
Gross Profit for Q3 — $96,500
Query
SELECT SUM(net_sales_amount) - SUM(cost_of_goods_sold) AS gross_profit FROM orders WHERE order_date BETWEEN :start AND :end;