# Criteo

# Introduction

The Criteo module allows you to automatically collect advertising data from Criteo.

# An example of operation

  1. We configure the module in the platform by granting access to the Criteo
  2. We set the module on the schedule - the data will be collected and stored in witcloud dataset
  3. After the table is processed, you can use other reporting modules or combine it with analytics

# Data schema

The new table will appear in the WitCloud dataset

image alt text

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

# Configuration

# Before you start

Make sure you have adequate access to your Criteo advertising account.

You must have administrator access

# Start creating the module

From the menu on the left, select the "Collect" tab, then click the "Add new data Collect" button.

image alt text

Select "Criteo" from the list of available modules

image alt text

# Initial settings

In the first step of the form, we complete the name of our collect

Collect name - the name of our module. It will be visible under this name elsewhere on the platform.

image alt text

# Authorization with Criteo

In the next step, we need to grant WitCloud access to Criteo. It is necessary for WitCloud to be able to download data. This can be done using the Criteo oauth method

To do this, press the "Sign in with Criteo" button

image alt text

The oauth Criteo form will appear. Select the advertising accounts to which you want to grant access to Witcloud 1* and hit the approve button 2*

image alt text

After proper authorization, select your report currency 1*, advertising accounts whose data you want to collect 2* and click Finish button 3*

image alt text

# Setting the module in the schedule

Your Criteo module is already created in WitCloud 📊. The last step is to establish a schedule and include our module in it. You can read about how to do it here link (opens new window)

Last updated: 4/15/2021, 12:30:11 PM