Integration of Criteo Ads with BigQuery
Connect Criteo Ads to Google BigQuery with WitCloud and collect campaign statistics - impressions, clicks, cost, sales and revenue - to analyze them with the rest of your data.
Updated
Introduction
This integration connects Criteo Ads with Google Cloud BigQuery. It collects your Criteo campaign statistics (impressions, clicks, cost, sales and revenue, by day, campaign and more) so that you can analyze them next to the rest of your data in WitCloud.
Configuration guide
Follow the steps below to connect Criteo Ads with BigQuery. Once the setup is complete, your Criteo data will be transferred to your BigQuery project.
Make sure you have access to the Criteo advertisers you want to collect data from before you start the configuration.
Module setup
Go to Integrations in the menu and click Add integration.

Select Criteo Ads from the list of available integrations.

Enter the Collect name, e.g., "Criteo PL".

Authorization
If you have previously authorized the Criteo Ads module and do not require additional permissions, you can skip this step and pick the existing authorization from the Select Criteo authorization list.
Click Authorize.

Grant the necessary permissions in the Criteo window.

Select the advertisers you want to collect data from in the Select advertisers list. You can select more than one: each advertiser becomes a separate data collect, named after the Collect name and the advertiser (e.g. "Criteo PL - Demo Advertiser PL").

Choose the Currency in which you want your data to be retrieved.

Optionally, click Show advanced settings. The Tables to collect field lets you narrow down the tables you want to collect; all are selected by default and at least one is required.

Click Next.
Historical data and scheduling
In the Historical Data field, enter the number of days of historical data you want to fetch. You can enter up to 365 days.

A data synchronization schedule will be created automatically. More information on this topic can be found here.
Click Create to complete the configuration.

Done! Your Criteo Ads data will now be synchronized with BigQuery.
Data schema
Expand the table below to view the full data schema collected from Criteo Ads.
Data schema for criteo_statistics
| Field Name | Mode | Type |
|---|---|---|
| AdvertiserId | NULLABLE | STRING |
| Advertiser | NULLABLE | STRING |
| CampaignId | NULLABLE | STRING |
| Campaign | NULLABLE | STRING |
| AdsetId | NULLABLE | STRING |
| Adset | NULLABLE | STRING |
| CategoryId | NULLABLE | STRING |
| Category | NULLABLE | STRING |
| ChannelId | NULLABLE | STRING |
| Channel | NULLABLE | STRING |
| CouponId | NULLABLE | STRING |
| Coupon | NULLABLE | STRING |
| Device | NULLABLE | STRING |
| Os | NULLABLE | STRING |
| Day | NULLABLE | STRING |
| Currency | NULLABLE | STRING |
| Clicks | NULLABLE | INTEGER |
| Displays | NULLABLE | INTEGER |
| ViewableDisplays | NULLABLE | INTEGER |
| NonViewableDisplays | NULLABLE | INTEGER |
| UntrackableDisplays | NULLABLE | INTEGER |
| AdvertiserCost | NULLABLE | FLOAT |
| QualifiedVisits | NULLABLE | INTEGER |
| Visits | NULLABLE | INTEGER |
| CostPerVisit | NULLABLE | FLOAT |
| BounceRate | NULLABLE | FLOAT |
| PotentialDisplays | NULLABLE | INTEGER |
| OverallCompetitionWin | NULLABLE | FLOAT |
| SalesClientAttribution | NULLABLE | FLOAT |
| SalesAllClientAttribution | NULLABLE | FLOAT |
| SalesPc30d | NULLABLE | FLOAT |
| SalesAllPc30d | NULLABLE | FLOAT |
| SalesPv24h | NULLABLE | FLOAT |
| SalesAllPv24h | NULLABLE | FLOAT |
| SalesPc30dPv24h | NULLABLE | FLOAT |
| SalesAllPc30dPv24h | NULLABLE | FLOAT |
| SalesPc1d | NULLABLE | FLOAT |
| SalesAllPc1d | NULLABLE | FLOAT |
| SalesPc7d | NULLABLE | FLOAT |
| SalesAllPc7d | NULLABLE | FLOAT |
| RevenueGeneratedClientAttribution | NULLABLE | FLOAT |
| RevenueGeneratedAllClientAttribution | NULLABLE | FLOAT |
| RevenueGeneratedPc30d | NULLABLE | FLOAT |
| RevenueGeneratedAllPc30d | NULLABLE | FLOAT |
| RevenueGeneratedPv24h | NULLABLE | FLOAT |
| RevenueGeneratedAllPv24h | NULLABLE | FLOAT |
| RevenueGeneratedPc30dPv24h | NULLABLE | FLOAT |
| RevenueGeneratedAllPc30dPv24h | NULLABLE | FLOAT |
| RevenueGeneratedPc1d | NULLABLE | FLOAT |
| RevenueGeneratedAllPc1d | NULLABLE | FLOAT |
| RevenueGeneratedPc7d | NULLABLE | FLOAT |
| RevenueGeneratedAllPc7d | NULLABLE | FLOAT |
| ExposedUsers | NULLABLE | FLOAT |
| Audience | NULLABLE | INTEGER |
| Reach | NULLABLE | FLOAT |
| AverageCartClientAttribution | NULLABLE | FLOAT |
| AverageCartAllClientAttribution | NULLABLE | FLOAT |
| AverageCartPc30d | NULLABLE | FLOAT |
| AverageCartAllPc30d | NULLABLE | FLOAT |
| AverageCartPv24h | NULLABLE | FLOAT |
| AverageCartAllPv24h | NULLABLE | FLOAT |
| AverageCartPc30dPv24h | NULLABLE | FLOAT |
| AverageCartAllPc30dPv24h | NULLABLE | FLOAT |
| AverageCartPc1d | NULLABLE | FLOAT |
| AverageCartAllPc1d | NULLABLE | FLOAT |
| AverageCartPc7d | NULLABLE | FLOAT |
| AverageCartAllPc7d | NULLABLE | FLOAT |
| ConversionRateClientAttribution | NULLABLE | FLOAT |
| ConversionRateAllClientAttribution | NULLABLE | FLOAT |
| ConversionRatePc30d | NULLABLE | FLOAT |
| ConversionRateAllPc30d | NULLABLE | FLOAT |
| ConversionRatePv24h | NULLABLE | FLOAT |
| ConversionRateAllPv24h | NULLABLE | FLOAT |
| ConversionRatePc30dPv24h | NULLABLE | FLOAT |
| ConversionRateAllPc30dPv24h | NULLABLE | FLOAT |
| ConversionRatePc1d | NULLABLE | FLOAT |
| ConversionRateAllPc1d | NULLABLE | FLOAT |
| ConversionRatePc7d | NULLABLE | FLOAT |
| ConversionRateAllPc7d | NULLABLE | FLOAT |
| ECosClientAttribution | NULLABLE | FLOAT |
| ECosAllClientAttribution | NULLABLE | FLOAT |
| ECosPc30d | NULLABLE | FLOAT |
| ECosAllPc30d | NULLABLE | FLOAT |
| ECosPv24h | NULLABLE | FLOAT |
| ECosAllPv24h | NULLABLE | FLOAT |
| ECosPc30dPv24h | NULLABLE | FLOAT |
| ECosAllPc30dPv24h | NULLABLE | FLOAT |
| ECosPc1d | NULLABLE | FLOAT |
| ECosAllPc1d | NULLABLE | FLOAT |
| ECosPc7d | NULLABLE | FLOAT |
| ECosAllPc7d | NULLABLE | FLOAT |
| CostPerOrderClientAttribution | NULLABLE | FLOAT |
| CostPerOrderAllClientAttribution | NULLABLE | FLOAT |
| CostPerOrderPc30d | NULLABLE | FLOAT |
| CostPerOrderAllPc30d | NULLABLE | FLOAT |
| CostPerOrderPv24h | NULLABLE | FLOAT |
| CostPerOrderAllPv24h | NULLABLE | FLOAT |
| CostPerOrderPc30dPv24h | NULLABLE | FLOAT |
| CostPerOrderAllPc30dPv24h | NULLABLE | FLOAT |
| CostPerOrderPc1d | NULLABLE | FLOAT |
| CostPerOrderAllPc1d | NULLABLE | FLOAT |
| CostPerOrderPc7d | NULLABLE | FLOAT |
| CostPerOrderAllPc7d | NULLABLE | FLOAT |
| Cpc | NULLABLE | FLOAT |
| ECpm | NULLABLE | FLOAT |
| RoasClientAttribution | NULLABLE | FLOAT |
| RoasAllClientAttribution | NULLABLE | FLOAT |
| RoasPc30d | NULLABLE | FLOAT |
| RoasAllPc30d | NULLABLE | FLOAT |
| RoasPv24h | NULLABLE | FLOAT |
| RoasAllPv24h | NULLABLE | FLOAT |
| RoasPc30dPv24h | NULLABLE | FLOAT |
| RoasAllPc30dPv24h | NULLABLE | FLOAT |
| RoasPc1d | NULLABLE | FLOAT |
| RoasAllPc1d | NULLABLE | FLOAT |
| RoasPc7d | NULLABLE | FLOAT |
| RoasAllPc7d | NULLABLE | FLOAT |
| AdvertiserValue | NULLABLE | FLOAT |
| AdvertiserAllValue | NULLABLE | FLOAT |
| CostOfAdvertiserValue | NULLABLE | FLOAT |
| PostInstallSales | NULLABLE | FLOAT |
| AppInstalls | NULLABLE | FLOAT |
| PostInstallConversionRate | NULLABLE | FLOAT |
| PostInstallCostOfSale | NULLABLE | FLOAT |
| PostInstallOrderValue | NULLABLE | FLOAT |
| CostPerInstall | NULLABLE | FLOAT |
| InstallRate | NULLABLE | FLOAT |
| PostInstallCostPerOrder | NULLABLE | FLOAT |
| PostInstallRoas | NULLABLE | FLOAT |
| OmnichannelRoasClientAttribution | NULLABLE | FLOAT |
| OmnichannelRoasPc30d | NULLABLE | FLOAT |
| OmnichannelRoasAllPc30d | NULLABLE | FLOAT |
| OmnichannelRoasPv24h | NULLABLE | FLOAT |
| OmnichannelRoasAllPv24h | NULLABLE | FLOAT |
| OmnichannelRevenueClientAttribution | NULLABLE | FLOAT |
| OmnichannelRevenuePc30d | NULLABLE | FLOAT |
| OmnichannelRevenueAllPc30d | NULLABLE | FLOAT |
| OmnichannelRevenuePv24h | NULLABLE | FLOAT |
| OmnichannelRevenueAllPv24h | NULLABLE | FLOAT |
| OmnichannelsalesClientAttribution | NULLABLE | FLOAT |
| OmnichannelSalesPc30d | NULLABLE | FLOAT |
| OmnichannelSalesAllPc30d | NULLABLE | FLOAT |
| OmnichannelSalesPv24h | NULLABLE | FLOAT |
| OmnichannelSalesAllPv24h | NULLABLE | FLOAT |
| RoasOfflinePc30d | NULLABLE | FLOAT |
| RoasOfflinePv24h | NULLABLE | FLOAT |
| SalesOfflinePc30d | NULLABLE | FLOAT |
| SalesOfflinePv24h | NULLABLE | FLOAT |
| RevenueGeneratedOfflinePc30d | NULLABLE | FLOAT |
| RevenueGeneratedOfflinePv24h | NULLABLE | FLOAT |
