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

SQL

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;