---
updatedAt: 2025-01-29T10:31:43.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# 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](https://triplewhale.readme.io/docs/ads-table) table.

### Detailed Breakdown

The formula above is derived from the following components:

Conversions = `SUM(conversions)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) 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

![](https://files.readme.io/c2a7ab8c6e25088fe09362602151afddc358604fbf074fcee6c1feed0583beaa-image.png)

### 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;
```