Criteo
Criteo ETL connector for data replication
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
- Generate Criteo Client Id and Secret for Daton
- Read more on How to create Criteo Client Id and Secret here
Integrate Criteo with Daton
- Signin to Daton
- Select Criteo from Integrations page
- Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
- Provide Client ID, Client Secret, and Criteo Email Address for authorizing Daton to extract data periodically
- Post successful authentication, you will be prompted to choose from the list of available tables
- Then select all required fields for each table
- Submit the integration
Workflow
- 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
- Users would be able to edit/pause/re-activate/delete integration anytime
- 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 |