--- title: "Criteo Ads to Claude | OWOX MCP" canonical: "https://www.owox.com/connectors/criteo-ads-connector-to-claude" updated: "2026-09-17" --- # Ask Criteo Ads Questions in Claude Ask Criteo Ads questions in Claude using OWOX Data Marts. Collect Criteo Ads data into a governed data mart, then get answers in Claude via OWOX's MCP server — every number traces back to analyst-written SQL. [Get Started Free](https://www.owox.com/app-signup) ## Endpoints ## Criteo Ads endpoints 4 Criteo Ads endpoints you can import. Each lands in its own table in your warehouse. * ### Criteo Placement Categories Performance metrics broken down by content category. 8 fieldsTime series`criteo_ads_placement_categories` * ### Criteo Placements Performance metrics broken down by publisher placement. 21 fieldsTime series`criteo_ads_placements` * ### Criteo Statistics Statistics and metrics for Criteo advertising campaigns. 156 fieldsTime series`criteo_ads_statistics` * ### Criteo Transactions Transaction-level data with individual order details attributed to Criteo ads. 11 fieldsTime series`criteo_ads_transactions` ## Data schema ## Criteo Ads data schema **Criteo Placement Categories** 8 fields · criteo\_ads\_placement\_categories | 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 Placements** 21 fields · criteo\_ads\_placements | 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 Statistics** 156 fields · criteo\_ads\_statistics | 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 Transactions** 11 fields · criteo\_ads\_transactions | 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"). | ## In Claude ## Ask Criteo Ads questions in Claude You Which Criteo placements cost us money without bringing revenue? Claude The Criteo Placements table (criteo\_ads\_placements) holds cost and revenuePc30d for each placement. I listed placements with cost but no revenuePc30d, highest cost first. It is read from your governed Criteo Ads Data Mart through the OWOX MCP server and reflects that Data Mart's last scheduled refresh. You And which placements deserve more budget? Claude Sorting the same table by roasPc30d, keeping placements with a meaningful number of clicks, shows those returning the most per unit of cost. roasPv1d gives the one-day post-view view of the same thing if you want a shorter window. ## Related connectors [AWS Athena Connector to Claude](/connectors/aws-athena-connector-to-claude) [AWS Redshift Connector to Claude](/connectors/aws-redshift-connector-to-claude) [Bank of Canada Connector to Claude](/connectors/bank-of-canada-connector-to-claude) ## What users are saying ## Every claim has a receipt. Real things real customers said — each quote pinned to a specific claim, straight from the quotes database. A3re: trusting AI ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public)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.”_ C9re: one source of truth ![Mark Simmons](https://cdn.owox.ai/www/webflow/6a7b298b2b9daab0ade631d7_mark-headshot.png/public)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.”_ E7re: getting time back ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public)Nodari RizunFounder & CEO, Pürblack® > _“We regained time. And time is the one resource that never comes back.”_ ## Turn Criteo Ads Data into Answers in Claude See how OWOX Data Marts helps you ask Criteo Ads questions in Claude, blend it with other sources, and scale reporting without rebuilding logic. [Get Started Free](https://www.owox.com/app-signup) ## References Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Get Started Free](https://www.owox.com/app-signup) - [AWS Athena Connector to Claude](https://www.owox.com/connectors/aws-athena-connector-to-claude) — /connectors/aws-athena-connector-to-claude.md - [AWS Redshift Connector to Claude](https://www.owox.com/connectors/aws-redshift-connector-to-claude) — /connectors/aws-redshift-connector-to-claude.md - [Bank of Canada Connector to Claude](https://www.owox.com/connectors/bank-of-canada-connector-to-claude) — /connectors/bank-of-canada-connector-to-claude.md