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