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.

Integrations list with the Add integration button

Select Criteo Ads from the list of available integrations.

Integration catalog with Criteo Ads selected

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

Collect name field filled in with the example name 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.

Authorize button next to the Criteo authorization field

Grant the necessary permissions in the Criteo window.

Criteo permissions consent screen

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").

Select advertisers drop-down open with two example Criteo advertisers

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

Currency drop-down open with currency codes

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.

Advanced settings open with the Tables to collect field

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.

Historical Data field filled in with 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.

Data collection settings with the Create button

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 NameModeType
AdvertiserIdNULLABLESTRING
AdvertiserNULLABLESTRING
CampaignIdNULLABLESTRING
CampaignNULLABLESTRING
AdsetIdNULLABLESTRING
AdsetNULLABLESTRING
CategoryIdNULLABLESTRING
CategoryNULLABLESTRING
ChannelIdNULLABLESTRING
ChannelNULLABLESTRING
CouponIdNULLABLESTRING
CouponNULLABLESTRING
DeviceNULLABLESTRING
OsNULLABLESTRING
DayNULLABLESTRING
CurrencyNULLABLESTRING
ClicksNULLABLEINTEGER
DisplaysNULLABLEINTEGER
ViewableDisplaysNULLABLEINTEGER
NonViewableDisplaysNULLABLEINTEGER
UntrackableDisplaysNULLABLEINTEGER
AdvertiserCostNULLABLEFLOAT
QualifiedVisitsNULLABLEINTEGER
VisitsNULLABLEINTEGER
CostPerVisitNULLABLEFLOAT
BounceRateNULLABLEFLOAT
PotentialDisplaysNULLABLEINTEGER
OverallCompetitionWinNULLABLEFLOAT
SalesClientAttributionNULLABLEFLOAT
SalesAllClientAttributionNULLABLEFLOAT
SalesPc30dNULLABLEFLOAT
SalesAllPc30dNULLABLEFLOAT
SalesPv24hNULLABLEFLOAT
SalesAllPv24hNULLABLEFLOAT
SalesPc30dPv24hNULLABLEFLOAT
SalesAllPc30dPv24hNULLABLEFLOAT
SalesPc1dNULLABLEFLOAT
SalesAllPc1dNULLABLEFLOAT
SalesPc7dNULLABLEFLOAT
SalesAllPc7dNULLABLEFLOAT
RevenueGeneratedClientAttributionNULLABLEFLOAT
RevenueGeneratedAllClientAttributionNULLABLEFLOAT
RevenueGeneratedPc30dNULLABLEFLOAT
RevenueGeneratedAllPc30dNULLABLEFLOAT
RevenueGeneratedPv24hNULLABLEFLOAT
RevenueGeneratedAllPv24hNULLABLEFLOAT
RevenueGeneratedPc30dPv24hNULLABLEFLOAT
RevenueGeneratedAllPc30dPv24hNULLABLEFLOAT
RevenueGeneratedPc1dNULLABLEFLOAT
RevenueGeneratedAllPc1dNULLABLEFLOAT
RevenueGeneratedPc7dNULLABLEFLOAT
RevenueGeneratedAllPc7dNULLABLEFLOAT
ExposedUsersNULLABLEFLOAT
AudienceNULLABLEINTEGER
ReachNULLABLEFLOAT
AverageCartClientAttributionNULLABLEFLOAT
AverageCartAllClientAttributionNULLABLEFLOAT
AverageCartPc30dNULLABLEFLOAT
AverageCartAllPc30dNULLABLEFLOAT
AverageCartPv24hNULLABLEFLOAT
AverageCartAllPv24hNULLABLEFLOAT
AverageCartPc30dPv24hNULLABLEFLOAT
AverageCartAllPc30dPv24hNULLABLEFLOAT
AverageCartPc1dNULLABLEFLOAT
AverageCartAllPc1dNULLABLEFLOAT
AverageCartPc7dNULLABLEFLOAT
AverageCartAllPc7dNULLABLEFLOAT
ConversionRateClientAttributionNULLABLEFLOAT
ConversionRateAllClientAttributionNULLABLEFLOAT
ConversionRatePc30dNULLABLEFLOAT
ConversionRateAllPc30dNULLABLEFLOAT
ConversionRatePv24hNULLABLEFLOAT
ConversionRateAllPv24hNULLABLEFLOAT
ConversionRatePc30dPv24hNULLABLEFLOAT
ConversionRateAllPc30dPv24hNULLABLEFLOAT
ConversionRatePc1dNULLABLEFLOAT
ConversionRateAllPc1dNULLABLEFLOAT
ConversionRatePc7dNULLABLEFLOAT
ConversionRateAllPc7dNULLABLEFLOAT
ECosClientAttributionNULLABLEFLOAT
ECosAllClientAttributionNULLABLEFLOAT
ECosPc30dNULLABLEFLOAT
ECosAllPc30dNULLABLEFLOAT
ECosPv24hNULLABLEFLOAT
ECosAllPv24hNULLABLEFLOAT
ECosPc30dPv24hNULLABLEFLOAT
ECosAllPc30dPv24hNULLABLEFLOAT
ECosPc1dNULLABLEFLOAT
ECosAllPc1dNULLABLEFLOAT
ECosPc7dNULLABLEFLOAT
ECosAllPc7dNULLABLEFLOAT
CostPerOrderClientAttributionNULLABLEFLOAT
CostPerOrderAllClientAttributionNULLABLEFLOAT
CostPerOrderPc30dNULLABLEFLOAT
CostPerOrderAllPc30dNULLABLEFLOAT
CostPerOrderPv24hNULLABLEFLOAT
CostPerOrderAllPv24hNULLABLEFLOAT
CostPerOrderPc30dPv24hNULLABLEFLOAT
CostPerOrderAllPc30dPv24hNULLABLEFLOAT
CostPerOrderPc1dNULLABLEFLOAT
CostPerOrderAllPc1dNULLABLEFLOAT
CostPerOrderPc7dNULLABLEFLOAT
CostPerOrderAllPc7dNULLABLEFLOAT
CpcNULLABLEFLOAT
ECpmNULLABLEFLOAT
RoasClientAttributionNULLABLEFLOAT
RoasAllClientAttributionNULLABLEFLOAT
RoasPc30dNULLABLEFLOAT
RoasAllPc30dNULLABLEFLOAT
RoasPv24hNULLABLEFLOAT
RoasAllPv24hNULLABLEFLOAT
RoasPc30dPv24hNULLABLEFLOAT
RoasAllPc30dPv24hNULLABLEFLOAT
RoasPc1dNULLABLEFLOAT
RoasAllPc1dNULLABLEFLOAT
RoasPc7dNULLABLEFLOAT
RoasAllPc7dNULLABLEFLOAT
AdvertiserValueNULLABLEFLOAT
AdvertiserAllValueNULLABLEFLOAT
CostOfAdvertiserValueNULLABLEFLOAT
PostInstallSalesNULLABLEFLOAT
AppInstallsNULLABLEFLOAT
PostInstallConversionRateNULLABLEFLOAT
PostInstallCostOfSaleNULLABLEFLOAT
PostInstallOrderValueNULLABLEFLOAT
CostPerInstallNULLABLEFLOAT
InstallRateNULLABLEFLOAT
PostInstallCostPerOrderNULLABLEFLOAT
PostInstallRoasNULLABLEFLOAT
OmnichannelRoasClientAttributionNULLABLEFLOAT
OmnichannelRoasPc30dNULLABLEFLOAT
OmnichannelRoasAllPc30dNULLABLEFLOAT
OmnichannelRoasPv24hNULLABLEFLOAT
OmnichannelRoasAllPv24hNULLABLEFLOAT
OmnichannelRevenueClientAttributionNULLABLEFLOAT
OmnichannelRevenuePc30dNULLABLEFLOAT
OmnichannelRevenueAllPc30dNULLABLEFLOAT
OmnichannelRevenuePv24hNULLABLEFLOAT
OmnichannelRevenueAllPv24hNULLABLEFLOAT
OmnichannelsalesClientAttributionNULLABLEFLOAT
OmnichannelSalesPc30dNULLABLEFLOAT
OmnichannelSalesAllPc30dNULLABLEFLOAT
OmnichannelSalesPv24hNULLABLEFLOAT
OmnichannelSalesAllPv24hNULLABLEFLOAT
RoasOfflinePc30dNULLABLEFLOAT
RoasOfflinePv24hNULLABLEFLOAT
SalesOfflinePc30dNULLABLEFLOAT
SalesOfflinePv24hNULLABLEFLOAT
RevenueGeneratedOfflinePc30dNULLABLEFLOAT
RevenueGeneratedOfflinePv24hNULLABLEFLOAT