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.
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 seriescriteo_ads_placement_categoriesCriteo Placements
Performance metrics broken down by publisher placement.
21 fieldsTime seriescriteo_ads_placementsCriteo Statistics
Statistics and metrics for Criteo advertising campaigns.
156 fieldsTime seriescriteo_ads_statisticsCriteo Transactions
Transaction-level data with individual order details attributed to Criteo ads.
11 fieldsTime seriescriteo_ads_transactions
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"). |
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
ArtPix 3D — transparent KPI calculationsasset pending
Avrora — a partner we could trustasset pending
Avrora — clarity and confidence to decide fastasset pending
Avrora — reliable analytics systemasset pending
Avrora — transformed approach to BIasset pending
Better&Stronger — always there to helpasset pending
Better&Stronger — rich educational resourcesasset pending
Domas R. (G2) — data we can actually trustasset pending
Domas R. (G2) — solution to most data challengesasset pending
Hiveon — key metrics built our wayasset pending
Khrystyna G. (G2) — simple tool, amazing supportasset pending
MatahariMall — less time on reportingasset pending
MotionVFX — data quality to predict budgetasset pending
MotionVFX — exceeded our expectationsasset pending
MotionVFX — no decisions without analysisasset pending
MotionVFX — transparency behind every KPIasset pending
ON Clinic — cost per acquisition by serviceasset pending
ON Clinic — data for regional KPIsasset pending
ON Clinic — know AOV by segmentasset pending
IT
QVC — reports in line with business needsasset pending
QVC — totally satisfied with resultasset pending
Retail
IT
Wojciech W. (G2) — accurate data, more revenueasset pending
Wojciech W. (G2) — reliable business partnerasset pending
Wojciech W. (G2) — transparent, honest cooperation termsasset pending
Business & Consumer Services
ZOOD — foundation for years to comeasset pending
Every claim has a receipt.
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.”