--- title: "Criteo Ads to Microsoft Excel Connector | OWOX" canonical: "https://www.owox.com/connectors/criteo-ads-connector-to-microsoft-excel" updated: "2026-09-17" --- # Criteo Ads Connector to Microsoft Excel Own your Criteo Ads data in Microsoft Excel with OWOX Data Marts. Collect granular, analytics-ready Criteo Ads data, control schema and refresh logic, and reuse it across Microsoft Excel and AI Insights. [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"). | ## Related connectors [AWS Athena Connector to Microsoft Excel](/connectors/aws-athena-connector-to-microsoft-excel) [AWS Redshift Connector to Microsoft Excel](/connectors/aws-redshift-connector-to-microsoft-excel) [Bank of Canada Connector to Microsoft Excel](/connectors/bank-of-canada-connector-to-microsoft-excel) ## 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 your Criteo Ads Connector to Microsoft Excel data into business decisions [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 Microsoft Excel](https://www.owox.com/connectors/aws-athena-connector-to-microsoft-excel) — /connectors/aws-athena-connector-to-microsoft-excel.md - [AWS Redshift Connector to Microsoft Excel](https://www.owox.com/connectors/aws-redshift-connector-to-microsoft-excel) — /connectors/aws-redshift-connector-to-microsoft-excel.md - [Bank of Canada Connector to Microsoft Excel](https://www.owox.com/connectors/bank-of-canada-connector-to-microsoft-excel) — /connectors/bank-of-canada-connector-to-microsoft-excel.md