Criteo
Criteo ETL connector for data replication
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 |
- 1.Generate Criteo Client Id and Secret for Daton
- 2.
- 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
- 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
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.
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 |
Last modified 3yr ago