.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
A vital metric for assessing marketing effectiveness and customer journey performance.
Formula
Conversion Rate = (Total Conversions / Total Clicks) * 100
Insights and Actions
- Higher conversion rates indicate effective targeting and ad quality.
- Helps identify friction points in checkout flow or product pages.
- Detects which campaigns convert best.
- Reveals which items drive more completed purchases.
- Conversion rate changes directly influence revenue outcomes.
Detailed Breakdown
- Conversion Rate Total Conversions
- Total Clicks
- 100
Suggested Dimensions
ChannelCampaignDeviceRegionProduct / SKU
Related Metrics
Example Use
Prompt
What was our conversion rate yesterday?
Response
Conversion Rate from Yesterday — 2.8%
Query
SELECT SUM(conversions) * 100.0 / NULLIF(SUM(clicks), 0) AS conversion_rate FROM spends WHERE spends_date BETWEEN :start AND :end;