Criteo

Criteo ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v1.0
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Criteo Client ID Client Secret Criteo Email Address
Replication Type	Full Replication
Replication Key	NA
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Campaigns	Audiences
Budgets	Categories

Pre-requisites

1. Generate Criteo Client Id and Secret for Daton

2. Read more on How to create Criteo Client Id and Secret here

Integrate Criteo with Daton

1. Signin to Daton

2. Select Criteo from Integrations page

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide Client ID, Client Secret, and Criteo Email Address for authorizing Daton to extract data periodically

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Criteo Data

Campaigns

Purpose: A campaign table consists information about your AdCampaign.

Source API Documentation https://api.criteo.com/marketing/swagger/ui/index#!/Campaigns/Campaigns_GetCampaigns

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
campaignType	STRING
advertiserName	STRING
categories	STRING
budgetId	INTEGER
campaignId	INTEGER
campaignName	STRING
advertiserId	INTEGER
campaignStatus	STRING
campaignBid	RECORD

Audiences

Purpose: This table contains the list of audiences for given advertiser.

Source API Documentation https://api.criteo.com/marketing/swagger/ui/index#!/Audiences/Audiences_GetAudiences

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
id	INTEGER
advertiserId	INTEGER
name	STRING
description	STRING

Budgets

Purpose: This table contains list of all your ad budgets.

Source API Documentation https://api.criteo.com/marketing/swagger/ui/index#!/Budgets/Budgets_Get

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
advertiserId	INTEGER
budgetId	INTEGER
budgetName	STRING
type	STRING
totalAmount	INTEGER
remainingBudget	INTEGER
remainingBudgetUpdated	DATETIME
active	BOOLEAN

Categories

Purpose: This table gives a list of categories for all Ads.

Source API Documentation https://api.criteo.com/marketing/swagger/ui/index#!/Categories/Categories_GetCategories

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
categoryHashCode	INTEGER
categoryName	STRING
catalogId	INTEGER
catalogName	STRING
advertiserId	INTEGER
advertiserName	STRING
campaignId	INTEGER
averagePrice	INTEGER
numberOfProducts	INTEGER
categoryBid	RECORD
enabled	BOOLEAN