Criteo ROAS
roas
Overview
Criteo Return on Ad Spend (Criteo ROAS) refers to the Criteo-reported conversion value divided by the Criteo-reported ad spend.
Criteo ROAS = Criteo Ads Revenue / Criteo Ad Spend
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
Ad Spend = SUM(spend)
--> Ads table
Criteo Ads = where channel = 'criteo'
Insights and Actions
Criteo ROAS measures the revenue generated per dollar spent on Criteo ads, helping assess the effectiveness of your ad spend. Monitoring ROAS can guide budget decisions and inform optimization strategies.
- Evaluate Profitability: High ROAS indicates strong returns on ad spend, suggesting effective targeting and ad performance. If ROAS is low, review campaign settings to improve efficiency.
- Optimize Budget Allocation: Compare Criteo ROAS with other channels to determine where to scale or reduce investment. Prioritize channels with higher ROAS for better overall returns.
- Test and Adjust Campaigns: Low ROAS may indicate that ad creative or targeting needs improvement. Experiment with different strategies to increase ROAS and maximize ad impact.
Related Metrics
- Criteo Conversion Value: Tracks revenue from Criteo ads, providing a direct measure of ad-driven income.
- Criteo Ad Spend: Shows total spending on Criteo, which, when paired with ROAS, offers insight into cost efficiency.
- Criteo Conversions: Reflects the number of completed actions (e.g., purchases) attributed to Criteo ads, helping you gauge engagement effectiveness.
Example Use
Prompt
What's my channel-reported Criteo ROAS the last 30 days?
Response
Query
SELECT
pjt.channel AS channel,
COALESCE(
SUM(pjt.channel_reported_conversion_value) / NULLIF(SUM(pjt.spend), 0),
0
) AS roas
FROM
pixel_joined_tvf () AS pjt
WHERE
pjt.channel = 'criteo'
AND pjt.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE() - 1
GROUP BY
pjt.channel
ORDER BY
roas DESC;
Updated about 12 hours ago