.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Key measure of campaign effectiveness and goal achievement.
Formula
Total number of conversions during the selected period
Insights and Actions
- Measure the number of desired actions taken.
- Identify which marketing sources drive the most conversions.
- Core input for metrics like ROAS and Conversion Rate.
- Track which touchpoints lead to conversion.
- Align marketing outcomes with business KPIs.
Detailed Breakdown
- Total Number Of Conversions During The Selected Period
Suggested Dimensions
CampaignChannelDeviceProduct / SKURegion
Related Metrics
Example Use
Prompt
How many conversions did we get yesterday?
Response
Conversions from Yesterday — 340
Query
SELECT SUM(COALESCE(conversions, 0)) AS conversions FROM spends WHERE spends_date BETWEEN :start AND :end;