Collect Criteo Ads data. Deliver reports. Automate AI Insights.
Easily collect Criteo data with OWOX Data Marts, store in your data warehouse, automate reporting across major BI Tools and AI Insights (the ones that matter) delivered straight to corporate messengers on a schedule.
Data Partner You Can Trust
users
175K
Executives and data analysts across 20+ industries
G2 rating
4.9★
“A trusted data analytics partner” — verified review
Customers
IT
Retail
IT
Business & Consumer Services
Available connectors
Criteo Ads Connector to Azure SynapseCriteo Ads Connector to ChatGPTCriteo Ads Connector to ClaudeCriteo Ads Connector to Microsoft ExcelCriteo Ads Insights to EmailCriteo Ads Insights to Google ChatCriteo Ads Insights to Microsoft TeamsCriteo Ads Insights to SlackCriteo Ads to AWS Athena ConnectorCriteo Ads to AWS Redshift ConnectorCriteo Ads to Databricks ConnectorCriteo Ads to Google BigQuery ConnectorCriteo Ads to Google Sheets ConnectorCriteo Ads to Looker Studio ConnectorCriteo Ads to Snowflake Connector
Criteo Ads endpoints
4 Criteo Ads endpoints you can import. Each lands in its own table in your warehouse.
Placement Categories
Performance metrics broken down by content category.
8 fieldsTime seriesPlacements
Performance metrics broken down by publisher placement.
21 fieldsTime seriesStatistics
Statistics and metrics for Criteo advertising campaigns.
156 fieldsTime seriesTransactions
Transaction-level data with individual order details attributed to Criteo ads.
11 fieldsTime series
Criteo Ads Placement Categories schema
8 fieldsTime seriescriteo_ads_placement_categoriesSchema on GitHub
Performance metrics broken down by content category.
| Field | Type | Description |
|---|---|---|
advertiserId | STRING | The unique identifier for the advertiser. |
categoryId | STRING | The unique identifier for the content category. |
categoryName | STRING | The IAB content category of the publisher page where the ad was served. |
day | DATE | The day of the placement category data (YYYY-MM-DD format). |
displays | INTEGER | The number of ad impressions served in this category. |
clicks | INTEGER | The number of clicks in this category. |
salesPc30d | INTEGER | The number of transactions or conversions (30-day post-click). |
salesPv1d | INTEGER | The number of transactions or conversions (1-day post-view). |
Criteo Ads Placements schema
21 fieldsTime seriescriteo_ads_placementsSchema on GitHub
Performance metrics broken down by publisher placement.
| Field | Type | Description |
|---|---|---|
advertiserId | STRING | The unique identifier for the advertiser. |
adsetId | STRING | The unique identifier for the adset. |
adsetName | STRING | The name of the adset. |
environment | STRING | The environment where the ad was served (Web, Android, iOS). |
placement | STRING | The publisher placement where the ad was served. |
day | DATE | The day of the placement data (YYYY-MM-DD format). |
clicks | INTEGER | The number of clicks on this placement. |
displays | INTEGER | The number of ad impressions served on this placement. |
cost | NUMBER | Total money spent on this placement. |
salesPc30d | INTEGER | The number of transactions or conversions (30-day post-click). |
salesPv1d | INTEGER | The number of transactions or conversions (1-day post-view). |
revenuePc30d | NUMBER | The revenue generated (30-day post-click). |
revenuePv1d | NUMBER | The revenue generated (1-day post-view). |
cosPc30d | NUMBER | The cost of sale (30-day post-click). |
cosPv1d | NUMBER | The cost of sale (1-day post-view). |
roasPc30d | NUMBER | The return on ad spend (30-day post-click). |
roasPv1d | NUMBER | The return on ad spend (1-day post-view). |
cpoPc30d | NUMBER | The cost per order (30-day post-click). |
cpoPv1d | NUMBER | The cost per order (1-day post-view). |
cvrPc30d | NUMBER | The conversion rate (30-day post-click). |
cvrPv1d | NUMBER | The conversion rate (1-day post-view). |
Criteo Ads Statistics schema
156 fieldsTime seriescriteo_ads_statisticsSchema on GitHub
Statistics and metrics for Criteo advertising campaigns.
| Field | Type | Description |
|---|---|---|
Clicks | INTEGER | The number of clicks driven by your ads. |
Displays | INTEGER | The number of ad impressions served on publishers via Criteo. |
ViewableDisplays | INTEGER | The number of ads that have been viewed. A display is considered viewed if at least 50% of the ad appears on the screen for at least one second. |
NonViewableDisplays | INTEGER | The number of ads that have not been viewed |
UntrackableDisplays | INTEGER | The number of untracked displays. Some displays cannot be tracked because of the display environment (for instance, native banner). |
AdvertiserCost | NUMBER | Total money spent on Criteo advertising. |
QualifiedVisits | INTEGER | The number of users on the target website or app for which at least two events or one sale event occurred within the hour following a click. |
Visits | INTEGER | The number of users on the target website or app for which at least one event occurred within the hour following a click. |
CostPerVisit | NUMBER | The amount of money spent per visit to your website or app. |
BounceRate | NUMBER | The proportion of website visitors leaving after only viewing one page. |
PotentialDisplays | INTEGER | The number of display opportunities, or the number of bid requests received. |
OverallCompetitionWin | NUMBER | The number of displays divided by the total number of display opportunities. |
ExposedUsers | INTEGER | The number of users who have been served an ad. |
Audience | INTEGER | Potential users who could be served an ad. |
Reach | NUMBER | Share of potential users who have been served an ad. |
ClickThroughRate | NUMBER | Percentage of users served an ad who clicked. |
Cpc | NUMBER | Cost per click. |
ECpm | NUMBER | Cost per 1000 impressions. |
PostInstallSales | INTEGER | The number of your completed events after an app install. |
AppInstalls | INTEGER | The number of installations of your app. |
PostInstallConversionRate | NUMBER | Percentage of post-install sales compared to the clicks that occurred. |
PostInstallCostOfSale | NUMBER | The cost of sale for app install campaigns. |
PostInstallOrderValue | NUMBER | The amount of money generated by sales after an app install. |
CostPerInstall | NUMBER | The ad cost per app install. |
InstallRate | NUMBER | The percentage of completed app installs compared to the number of clicks. |
PostInstallCostPerOrder | NUMBER | The cost per order for sales after an app install. |
PostInstallRoas | NUMBER | The return on ad spend for sales after an app install. |
SalesClientAttribution | INTEGER | The number of transactions or conversions resulting from Criteo ads. |
SalesAllClientAttribution | INTEGER | The number of transactions or conversions resulting from Criteo ads. |
SalesPc30d | INTEGER | The number of transactions or conversions resulting from Criteo ads. |
SalesAllPc30d | INTEGER | The number of transactions or conversions resulting from Criteo ads. |
SalesPv24h | INTEGER | The number of transactions or conversions resulting from Criteo ads. |
SalesAllPv24h | INTEGER | The number of transactions or conversions resulting from Criteo ads. |
SalesPc30dPv24h | INTEGER | The number of transactions or conversions resulting from Criteo ads. |
SalesAllPc30dPv24h | INTEGER | The number of transactions or conversions resulting from Criteo ads. |
SalesPc1d | INTEGER | The number of transactions or conversions resulting from Criteo ads. |
SalesAllPc1d | INTEGER | The number of transactions or conversions resulting from Criteo ads. |
SalesPc7d | INTEGER | The number of transactions or conversions resulting from Criteo ads. |
SalesAllPc7d | INTEGER | The number of transactions or conversions resulting from Criteo ads. |
RevenueGeneratedClientAttribution | NUMBER | The amount of money generated by online sales. |
RevenueGeneratedAllClientAttribution | NUMBER | The amount of money generated by online sales. |
RevenueGeneratedPc30d | NUMBER | The amount of money generated by online sales. |
RevenueGeneratedAllPc30d | NUMBER | The amount of money generated by online sales. |
RevenueGeneratedPv24h | NUMBER | The amount of money generated by online sales. |
RevenueGeneratedAllPv24h | NUMBER | The amount of money generated by online sales. |
RevenueGeneratedPc30dPv24h | NUMBER | The amount of money generated by online sales. |
RevenueGeneratedAllPc30dPv24h | NUMBER | The amount of money generated by online sales. |
RevenueGeneratedPc1d | NUMBER | The amount of money generated by online sales. |
RevenueGeneratedAllPc1d | NUMBER | The amount of money generated by online sales. |
RevenueGeneratedPc7d | NUMBER | The amount of money generated by online sales. |
RevenueGeneratedAllPc7d | NUMBER | The amount of money generated by online sales. |
AverageCartClientAttribution | NUMBER | Average revenue generated by a conversion or sale. |
AverageCartAllClientAttribution | NUMBER | Average revenue generated by a conversion or sale. |
AverageCartPc30d | NUMBER | Average revenue generated by a conversion or sale. |
AverageCartAllPc30d | NUMBER | Average revenue generated by a conversion or sale. |
AverageCartPv24h | NUMBER | Average revenue generated by a conversion or sale. |
AverageCartAllPv24h | NUMBER | Average revenue generated by a conversion or sale. |
AverageCartPc30dPv24h | NUMBER | Average revenue generated by a conversion or sale. |
AverageCartAllPc30dPv24h | NUMBER | Average revenue generated by a conversion or sale. |
AverageCartPc1d | NUMBER | Average revenue generated by a conversion or sale. |
AverageCartAllPc1d | NUMBER | Average revenue generated by a conversion or sale. |
AverageCartPc7d | NUMBER | Average revenue generated by a conversion or sale. |
AverageCartAllPc7d | NUMBER | Average revenue generated by a conversion or sale. |
ConversionRateClientAttribution | NUMBER | Percentage of conversions or sales compared to the clicks that occurred. |
ConversionRateAllClientAttribution | NUMBER | Percentage of conversions or sales compared to the clicks that occurred. |
ConversionRatePc30d | NUMBER | Percentage of conversions or sales compared to the clicks that occurred. |
ConversionRateAllPc30d | NUMBER | Percentage of conversions or sales compared to the clicks that occurred. |
ConversionRatePv24h | NUMBER | Percentage of conversions or sales compared to the clicks that occurred. |
ConversionRateAllPv24h | NUMBER | Percentage of conversions or sales compared to the clicks that occurred. |
ConversionRatePc30dPv24h | NUMBER | Percentage of conversions or sales compared to the clicks that occurred. |
ConversionRateAllPc30dPv24h | NUMBER | Percentage of conversions or sales compared to the clicks that occurred. |
ConversionRatePc1d | NUMBER | Percentage of conversions or sales compared to the clicks that occurred. |
ConversionRateAllPc1d | NUMBER | Percentage of conversions or sales compared to the clicks that occurred. |
ConversionRatePc7d | NUMBER | Percentage of conversions or sales compared to the clicks that occurred. |
ConversionRateAllPc7d | NUMBER | Percentage of conversions or sales compared to the clicks that occurred. |
ECosClientAttribution | NUMBER | Advertising cost per conversion or sale. |
ECosAllClientAttribution | NUMBER | Advertising cost per conversion or sale. |
ECosPc30d | NUMBER | Advertising cost per conversion or sale. |
ECosAllPc30d | NUMBER | Advertising cost per conversion or sale. |
ECosPv24h | NUMBER | Advertising cost per conversion or sale. |
ECosAllPv24h | NUMBER | Advertising cost per conversion or sale. |
ECosPc30dPv24h | NUMBER | Advertising cost per conversion or sale. |
ECosAllPc30dPv24h | NUMBER | Advertising cost per conversion or sale. |
ECosPc1d | NUMBER | Advertising cost per conversion or sale. |
ECosAllPc1d | NUMBER | Advertising cost per conversion or sale. |
ECosPc7d | NUMBER | Advertising cost per conversion or sale. |
ECosAllPc7d | NUMBER | Advertising cost per conversion or sale. |
CostPerOrderClientAttribution | NUMBER | The price you pay for each order. Calculated as total cost divided by the total number of orders. |
CostPerOrderAllClientAttribution | NUMBER | The price you pay for each order. Calculated as total cost divided by the total number of orders. |
CostPerOrderPc30d | NUMBER | The price you pay for each order. Calculated as total cost divided by the total number of orders. |
CostPerOrderAllPc30d | NUMBER | The price you pay for each order. Calculated as total cost divided by the total number of orders. |
CostPerOrderPv24h | NUMBER | The price you pay for each order. Calculated as total cost divided by the total number of orders. |
CostPerOrderAllPv24h | NUMBER | The price you pay for each order. Calculated as total cost divided by the total number of orders. |
CostPerOrderPc30dPv24h | NUMBER | The price you pay for each order. Calculated as total cost divided by the total number of orders. |
CostPerOrderAllPc30dPv24h | NUMBER | The price you pay for each order. Calculated as total cost divided by the total number of orders. |
CostPerOrderPc1d | NUMBER | The price you pay for each order. Calculated as total cost divided by the total number of orders. |
CostPerOrderAllPc1d | NUMBER | The price you pay for each order. Calculated as total cost divided by the total number of orders. |
CostPerOrderPc7d | NUMBER | The price you pay for each order. Calculated as total cost divided by the total number of orders. |
CostPerOrderAllPc7d | NUMBER | The price you pay for each order. Calculated as total cost divided by the total number of orders. |
RoasClientAttribution | NUMBER | The ratio between revenue generated and the cost. |
RoasAllClientAttribution | NUMBER | The ratio between revenue generated and the cost. |
RoasPc30d | NUMBER | The ratio between revenue generated and the cost. |
RoasAllPc30d | NUMBER | The ratio between revenue generated and the cost. |
RoasPv24h | NUMBER | The ratio between revenue generated and the cost. |
RoasAllPv24h | NUMBER | The ratio between revenue generated and the cost. |
RoasPc30dPv24h | NUMBER | The ratio between revenue generated and the cost. |
RoasAllPc30dPv24h | NUMBER | The ratio between revenue generated and the cost. |
RoasPc1d | NUMBER | The ratio between revenue generated and the cost. |
RoasAllPc1d | NUMBER | The ratio between revenue generated and the cost. |
RoasPc7d | NUMBER | The ratio between revenue generated and the cost. |
RoasAllPc7d | NUMBER | The ratio between revenue generated and the cost. |
AdvertiserValue | NUMBER | The revenue generated by each product, considering margin (if provided in your product catalog). |
AdvertiserAllValue | NUMBER | The revenue generated by each product, considering margin (if provided in your product catalog). |
CostOfAdvertiserValue | NUMBER | The ratio between the advertiser value generated by sales and the cost of the campaign(s), given as a percentage. |
CostOfAdvertiserValueAll | NUMBER | The ratio between the advertiser value generated by sales and the cost of the campaign(s), given as a percentage. |
OmnichannelRoasClientAttribution | NUMBER | The ratio between revenue generated online and offline, and the cost. |
OmnichannelRoasPc30d | NUMBER | The ratio between revenue generated online and offline, and the cost. |
OmnichannelRoasAllPc30d | NUMBER | The ratio between revenue generated online and offline, and the cost. |
OmnichannelRoasPv24h | NUMBER | The ratio between revenue generated online and offline, and the cost. |
OmnichannelRoasAllPv24h | NUMBER | The ratio between revenue generated online and offline, and the cost. |
OmnichannelRevenueClientAttribution | NUMBER | The revenue generated by online and offline sales. |
OmnichannelRevenuePc30d | NUMBER | The revenue generated by online and offline sales. |
OmnichannelRevenueAllPc30d | NUMBER | The revenue generated by online and offline sales. |
OmnichannelRevenuePv24h | NUMBER | The revenue generated by online and offline sales. |
OmnichannelRevenueAllPv24h | NUMBER | The revenue generated by online and offline sales. |
OmnichannelsalesClientAttribution | INTEGER | The number of online and offline transactions or conversions resulting from Criteo ads. |
OmnichannelSalesPc30d | INTEGER | The number of online and offline transactions or conversions resulting from Criteo ads. |
OmnichannelSalesAllPc30d | INTEGER | The number of online and offline transactions or conversions resulting from Criteo ads. |
OmnichannelSalesPv24h | INTEGER | The number of online and offline transactions or conversions resulting from Criteo ads. |
OmnichannelSalesAllPv24h | INTEGER | The number of online and offline transactions or conversions resulting from Criteo ads. |
RoasOfflinePc30d | NUMBER | The ratio between the revenue generated offline and the cost. |
RoasOfflinePv24h | NUMBER | The ratio between the revenue generated offline and the cost. |
SalesOfflinePc30d | INTEGER | The number of completed in-store transactions or purchases. |
SalesOfflinePv24h | INTEGER | The number of completed in-store transactions or purchases. |
RevenueGeneratedOfflinePc30d | NUMBER | The amount of revenue generated by in-store sales. |
RevenueGeneratedOfflinePv24h | NUMBER | The amount of revenue generated by in-store sales. |
Day | DATE | The day of the statistics data (YYYY-MM-DD format). |
Campaign | STRING | The campaign name. |
CampaignId | STRING | The unique identifier for the campaign. |
AdvertiserId | STRING | The unique identifier for the advertiser. |
Advertiser | STRING | The advertiser name. |
Adset | STRING | The adset name. |
AdsetId | STRING | The unique identifier for the adset. |
Ad | STRING | The ad name. |
AdId | STRING | The unique identifier for the ad. |
Currency | STRING | The currency of the advertiser cost. |
Device | STRING | The device type on which the ad was served (e.g., Desktop, Tablet, Mobile). |
Os | STRING | The operating system of the device on which the ad was served. |
Channel | STRING | The channel name through which the ad was served. |
ChannelId | STRING | The unique identifier of the channel through which the ad was served. |
Category | STRING | The product category name. |
CategoryId | STRING | The unique identifier for the product category. |
Coupon | STRING | The coupon or promotion name. |
CouponId | STRING | The unique identifier for the coupon or promotion. |
MarketingObjective | STRING | The marketing objective name (e.g., awareness, consideration, conversion). |
MarketingObjectiveId | STRING | The unique identifier for the marketing objective. |
Criteo Ads Transactions schema
11 fieldsTime seriescriteo_ads_transactionsSchema on GitHub
Transaction-level data with individual order details attributed to Criteo ads.
| Field | Type | Description |
|---|---|---|
transactionId | STRING | The unique identifier for the transaction. |
transactionDate | STRING | The date and time when the transaction occurred (MM/DD/YYYY HH:MM:SS). |
advertiserId | STRING | The unique identifier for the advertiser. |
advertiserName | STRING | The name of the advertiser. |
adsetName | STRING | The name of the adset that drove the transaction. |
eventType | STRING | The type of event that triggered the attribution (click or display). |
eventDate | STRING | The date and time of the click or view event that drove the transaction (MM/DD/YYYY HH:MM:SS). |
attributedTransaction | STRING | Whether the transaction was attributed to a Criteo ad (returned as "True" / "False"). |
currency | STRING | The currency of the transaction amount. |
amount | NUMBER | The transaction amount (order value). |
crossDeviceTransaction | STRING | Whether the transaction occurred on a different device from the one where the ad was viewed (returned as "Yes" / "No"). |
Why collect Criteo Ads data into your warehouse with OWOX?
Your Criteo Ads data shouldn’t be trapped in a platform you can’t query. OWOX collects it into your warehouse on autopilot — no per-connector fees, no vendor lock-in. The entire platform is open-source on GitHub, so you can self-host it today and never worry about losing access to your own data pipelines.
Collect to your warehouse
No per-connector pricing — connect as many sources as you need, all included
Zero-maintenance syncs
Fully open-source on GitHub — self-host anytime, no vendor lock-in, your data stays yours
Full-funnel joins
Full transparency and control — every query, every schema, every schedule is visible and auditable
R01 · Collect
Collect all your Criteo Ads data with zero engineering
Pull everything your company needs from Criteo without touching code or maintaining custom scripts. OWOX Data Marts handle the heavy lifting.
- Your Criteo data is stored in one place – your own infrastructure. OWOX Data Marts automatically land your data directly into BigQuery, Snowflake, or Redshift.
- Your Criteo data lands on a schedule: clean, complete, and ready to re-use across reports, dashboards, BI tools, and spreadsheets.
- No API maintenance, no broken scripts — just reliable daily syncs
R02 · Report
Build reports with Criteo Ads data that everyone trusts
Once your Criteo data lands in your warehouse, OWOX Data Marts make it instantly reusable across spreadsheets and BI tools.
- Pre-built data marts for campaign performance, spend, and retargeting ROAS
- Join Criteo Ads with CRM, GA4, and revenue data in one query
- Self-serve reporting for marketing teams — no analyst tickets needed
R03 · Visualize
Visualize Criteo Ads data instantly in your BI tools
With OWOX Data Marts, your Criteo data becomes instantly available for charts, dashboards, pivots, and spreadsheets.
- Whether you use Google Sheets, Looker Studio, Excel, or Power BI, OWOX delivers clean, scheduled Criteo data that just works.
- Deliver to Looker Studio, Google Sheets, Power BI, or Excel automatically
- Same numbers everywhere — one source of truth for all stakeholders
Why use OWOX connectors to collect your Criteo Ads data?
Eight outcomes you get the moment your data marts go live.
Full picture, one screen
Send Criteo spend and performance into dashboards from one governed source — retargeting and prospecting, clearly split.
Beyond native dashboards
Criteo blends prospecting and retargeting; in your warehouse you separate the two and judge each on its real return.
Your questions, your reports
Build reports that answer your questions — ecommerce ROAS, incremental revenue, CPA by audience — on your definitions.
Faster decisions, better data
See whether Criteo drives new revenue or just reclaims existing customers — a distinction only your own data can settle.
Always fresh, always complete
OWOX Data Marts automate Criteo collection on a schedule — campaigns, spend, and conversions — with no manual exports.
All sources, one warehouse
Merge Criteo with Shopify and other channels to measure true incremental ROAS, not last-click credit.
Zero manual work
Automate transfer into BigQuery, Snowflake, or Redshift — governed and reusable across every report, saving time and removing errors.
Blended reports
Once Criteo data lands in governed Data Marts, anyone can ask in their own AI chat — “is Criteo incremental or just retargeting?” — every number tracing to analyst-written SQL.
Not testimonials. Comment threads.
Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.
Nodari RizunFounder & CEO, Pürblack®“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”
Mark SimmonsCMO, Pürblack®“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
Nodari RizunFounder & CEO, Pürblack®“We regained time. And time is the one resource that never comes back.”
Start collecting Criteo Ads data for free
Set up your Criteo Ads connector in minutes. No credit card, no engineering team required.
