Criteo CV
conversion_value
Overview
Criteo Conversion Value (Criteo CV) refers to the total conversion value as reported by Criteo.
Criteo CV = Total Criteo-Reported Conversion Value
The calculation is based on data from the Ads table.
Detailed Breakdown
The formula above is derived from the following components:
Conversion Value (CV) = SUM(conversion_value)
--> Ads table
Criteo Ads = where channel = 'criteo'
Insights and Actions
Criteo Conversion Value (Criteo CV) highlights the revenue generated through Criteo ads, offering insights into campaign performance and return on ad spend:
- Assess Revenue Impact: High CV indicates strong ad performance. Analyze these campaigns to identify effective strategies that could be scaled or applied to other channels.
- Optimize Campaigns: If CV is lower than expected, review ad targeting or messaging to attract more relevant audiences.
- Monitor Profitability: Pair CV with metrics like Criteo Ad Spend to evaluate if your campaigns are generating sufficient revenue relative to costs.
Related Metrics
- Criteo Conversions: Helps you understand the quantity of conversions contributing to total CV, which can indicate the success of your ad targeting.
- Criteo ROAS: Shows revenue generated relative to ad spend, essential for understanding profitability.
- Criteo Ad Spend: Provides context on the investment made, helping you evaluate the efficiency of spend against revenue generated.
Example Use
Prompt
What's my total Criteo-reported conversion value over the last 7 days?
Response
Query
SELECT
pjt.channel AS channel,
SUM(pjt.channel_reported_conversion_value) AS channel_reported_conversion_value
FROM
pixel_joined_tvf () AS pjt
WHERE
pjt.model = 'Triple Attribution'
AND pjt.channel = 'criteo'
AND pjt.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE() - 1
GROUP BY
pjt.channel;
Updated 27 days ago