.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Measures the revenue generated per dollar spent on advertising. It provides a focused view of campaign-level profitability and efficiency.
Formula
Ads Revenue ÷ Advertising Spend
Insights and Actions
- Identifies which ads are generating profitable returns.
- Helps reallocate budgets to top-performing campaigns.
- Quantifies how marketing spend translates into sales.
- Compare ROAS across products, platforms, or timeframes.
- Helps predict returns from future ad investments.
Detailed Breakdown
- Ads Revenue
- Advertising Spend
Suggested Dimensions
ChannelCampaignProductRegionDevice
Related Metrics
Example Use
Prompt
What’s our ROAS for Facebook campaigns this week?
Response
ROAS for Facebook Campaigns — 4.3
Query
SELECT SUM(COALESCE(conversions_value, 0.0)) / NULLIF(SUM(COALESCE(spend, 0.0)), 0) AS roas FROM spends WHERE spends_date BETWEEN :start AND :end;