.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Provides a clear view of customer acquisition cost and profitability.
Formula
Ad Spend ÷ Conversions
Insights and Actions
- Profitability Insight — Compare CAC with LTV to ensure sustainability.
- Budget Efficiency — Track which channels acquire customers most affordably.
- Scalability Analysis — Monitor CAC trends during growth phases.
- Campaign Optimization — Detect costly or ineffective acquisition campaigns.
- Strategic Benchmarking — Compare CAC across time, products, or regions.
Detailed Breakdown
- Ad Spend= Ad Spend = SUM(spend_amount)
- Conversions= Total number of conversions during the selected period
Suggested Dimensions
ChannelCampaignRegionCustomer Type
Related Metrics
Example Use
Prompt
What was our average CAC last quarter?
Response
Average CAC for Last Quarter — $45.50
Query
SELECT COALESCE(SUM(spend) / NULLIF(SUM(conversions), 0), 0) AS cac FROM spends WHERE spends_date BETWEEN :start AND :end;