.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Indicates advertising efficiency and helps monitor profitability of ad campaigns.
Formula
ACOS = (Ad Spend ÷ Conversions Value) × 100
Insights and Actions
- Lower ACOS means better ad profitability.
- Ensures ad spending aligns with expected returns.
- Compare efficiency across campaigns or keywords.
- Monitor changes over time for optimization.
- Supports defining profitable advertising thresholds.
Detailed Breakdown
- Acos Ad Spend
- Conversions Value
- 100
Suggested Dimensions
CampaignChannelProduct / SKURegionDevice
Related Metrics
Example Use
Prompt
What was our ACOS last month?
Response
ACOS for Last Month — 18.5%
Query
SELECT ROUND((SUM(COALESCE(spend, 0.0)) / NULLIF(SUM(COALESCE(conversions_value, 0.0)), 0)) * 100,2) AS acos FROM spends WHERE spends_date BETWEEN :start AND :end;