Criteo Conversions (Purchases)

conversions

Overview

Criteo Conversions (Purchases) represent the total number of purchases as reported by Criteo.

📘

Criteo Conversions = Number of Purchases Reported by Criteo

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

Conversions = SUM(conversions) --> Ads table
Criteo Ads = where channel = 'criteo'

Insights and Actions

Criteo Conversions (Purchases) provide insight into how many purchases were driven by your Criteo ads, helping you assess campaign performance and optimize ad strategies:

• Track Campaign Effectiveness: Use Criteo Conversions to gauge the impact of each campaign on driving purchases. If conversions are low, consider adjusting ad creatives or targeting to better engage potential buyers.
• Optimize Ad Spend: Regularly review conversion rates to ensure that your budget is effectively generating purchases. If conversions aren’t meeting expectations, reassess spend distribution across campaigns.
• Increase High-Performing Campaigns: High conversion counts suggest effective campaigns. Scale these efforts after confirming profitability through Criteo ROAS to maximize revenue.

Related Metrics

• Criteo ROAS: Helps evaluate if your conversion revenue justifies the ad spend, ensuring efficient budget use.
• Criteo Clicks: Provides context on engagement levels. Compare with conversions to determine how well clicks are converting into purchases.
• Criteo Ad Spend: Analyzing this alongside conversions allows for a deeper understanding of cost efficiency, guiding budget decisions.

Example Use

Prompt

How many Criteo-reported conversions were there in the past 7 days?

Response

Query

SQL

SELECT
  pjt.channel AS channel,
  SUM(pjt.channel_reported_conversions) AS criteo_reported_conversions
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;