Criteo Ad Spend

spend

Overview

Criteo Ad Spend refers to the total amount of money spent on advertising through Criteo Ads.

📘

Criteo Ad Spend = Ad Spend on Criteo

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

Ad Spend = SUM(spend) --> Ads table
Criteo Ads = where channel = 'criteo'

Insights and Actions

Criteo Ad Spend indicates the total investment in Criteo ads, helping you assess your budget usage and compare spend across channels. Tracking this metric can guide budget optimization and spending efficiency.

• Monitor Spending Patterns: Regularly review Criteo Ad Spend to stay within budget. Significant fluctuations may signal the need to adjust bidding or campaign settings.
• Assess Cost Allocation: Evaluate if Criteo is providing adequate returns on investment. If spend is high but results are lacking, consider reallocating funds to other channels.
• Set Spend Benchmarks: Use historical ad spend data to set daily or monthly benchmarks, ensuring consistent budget management across campaigns.

Related Metrics

• Criteo ROAS: Helps assess whether your ad spend is generating sufficient returns, crucial for profitability.
• Criteo Conversions: Indicates the number of conversions driven by Criteo ads, allowing you to evaluate the effectiveness of your spend.
• Criteo Impressions: Provides context on the reach of your ads relative to the spend, helping you gauge cost-effectiveness.

Example Use

Prompt

What's my total Criteo Ad Spend over the past 30 days?

Response

Query

SQL

SELECT
  adt.channel AS channel,
  COALESCE(SUM(adt.spend), 0) AS total_spend
FROM
  ads_table AS adt
WHERE
  adt.channel = 'criteo'
  AND adt.event_date BETWEEN CURRENT_DATE() - 30 AND CURRENT_DATE()  - 1
GROUP BY
  adt.channel;