.5f521cec.png "Trivas.ai")
Data Dictionary
Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.
Trivas Metrics
Overview
Measures cost efficiency of paid media and bid strategy.
Formula
Cost Per Click = Total Spend ÷ Total Number of Clicks
Insights and Actions
- High CPC may indicate intense competition or poor targeting.
- Maintains an optimal spend-per-click ratio.
- Compare CPC across platforms and campaigns.
- Allocate budget to lower-cost, high-converting ads.
- Use alongside ROAS or Conversion Rate for complete ad insight.
Detailed Breakdown
- Cost Per Click Total Spend
- Total Number Of Clicks
Suggested Dimensions
CampaignChannelKeywordRegionDevice
Related Metrics
Example Use
Prompt
What’s our average CPC for the week?
Response
Average CPC for This Week — $0.72
Query
SELECT ROUND(CASE WHEN SUM(clicks) > 0 THEN SUM(spend) / NULLIF(SUM(clicks), 0) ELSE 0 END, 2) AS cost_per_click FROM spends WHERE spends_date BETWEEN :start AND :end;