---
updatedAt: 2025-03-27T13:23:50.000Z
agentTools:
  projectIndex: https://triplewhale.readme.io/llms.txt
---

# Criteo AOV

aov

# Overview

Criteo Average Order Value (Criteo AOV) calculates the average amount spent by customers per order, after shipping and taxes, as reported by Criteo.

> 📘 Criteo AOV = Criteo-Reported CV ÷ Criteo-Reported Conversions

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:

Conversion Value (CV) = `SUM(conversion_value)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) table\
Conversions = `SUM(conversions)` --> [Ads](https://triplewhale.readme.io/docs/ads-table) table
Criteo Ads = `where channel = 'criteo'`

# Insights and Actions

Criteo Average Order Value (AOV) measures the average revenue generated per order from Criteo-driven sales, helping to evaluate customer purchasing behavior and campaign impact:

* **Analyze Purchase Trends**: Track Criteo AOV over time to identify changes in customer spending habits, guiding pricing and promotional strategies.
* **Target High-Value Customers**: Use AOV data to refine audience targeting, focusing on segments that generate higher-value orders.
* **Improve Campaign Profitability**: Pair AOV with conversion data to assess the impact of upselling or bundling strategies, helping to increase the average order size and overall revenue.

### Related Metrics

* **Criteo Conversion Value (CV)**: Shows the total revenue generated by Criteo campaigns, essential for calculating AOV and evaluating revenue impact.
* **Criteo Conversions**: Tracks the total number of orders, providing context for interpreting AOV and understanding customer behavior.
* **Criteo ROAS**: Complements AOV by revealing revenue efficiency relative to ad spend, offering insights into overall campaign profitability.

# Example Use

### Prompt

> What's my Criteo-reported AOV for the last 90 days?

### Response

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

### Query

```sql
SELECT
  COALESCE(
    SUM(pjt.channel_reported_conversion_value) / NULLIF(SUM(pjt.channel_reported_conversions), 0),
    0
  ) AS channel_reported_aov
FROM
  pixel_joined_tvf () AS pjt
WHERE
  pjt.event_date BETWEEN CURRENT_DATE() - 90 AND CURRENT_DATE()  - 1
  AND pjt.channel = 'criteo'
  AND pjt.model = 'Triple Attribution'
```