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 Conversion Value / 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

SQL

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;