Criteo Retail Media
Criteo Retail Media, ETL connector for data replication
Criteo Retail Media
Criteo Retail Media, ETL connector for data replication
Snapshot
| Features | Details |
Release Status |
Released |
Source API Version |
2023-04 |
Table Selection |
Yes |
Column Selection |
Yes |
Edit Integration |
Yes |
Replication Type Selection |
No |
Authentication Parameters |
Oauth(Criteo Retail Medialogin email and password) |
Replication Type |
Key Based Replication, Full Replication |
Replication Key |
Date |
Suggested Replication Frequency |
1 hour |
Tables/APIs Supported
| CampaignsByKeywordsReports |
| Campaigns |
| LineItemsByKeywordsReports |
| LineItems |
Integrate Criteo Retail Media with Daton
- Sign in to Daton
- Select CriteoRetailMedia 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
- In the next step you will be asked to authenticate using your account email and password for criteo. Then you'll be directed to grant required access to daton.
- Post successful authentication you will be prompted to choose required tables from the list
- Then select all required fields
- 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 Retail Media Data
CampaignsByKeywordReport
Purpose: This Report gives the analytical data of all Campaigns break down by keyword.
Source API Documentation: https://developers.criteo.com/retail-media/v2022.07/docs/get-started
Replication: Key Based Incremental
Replication Key: startDate, endDate
Fields
| Name | Data Type |
campaignId |
STRING |
campaignName |
STRING |
campaignTypeName |
STRING |
keyword |
STRING |
date |
DATE |
impressions |
NUMERIC |
clicks |
NUMERIC |
attributedOrders |
NUMERIC |
attributedUnits |
NUMERIC |
attributedSales |
NUMERIC |
ctr |
NUMERIC |
spends |
NUMERIC |
cpc |
NUMERIC |
roas |
NUMERIC |
Campaigns
Purpose: This API is used to fetch data related to all campaigns.
Source API Documentation: https://developers.criteo.com/retail-media/v2022.07/docs/campaigns
Replication: Full Replication
Replication Key: N/A
Fields
| Name | Data Type |
id |
STRING |
type |
STRING |
accountId |
STRING |
promotedBrandIds |
STRING |
budgetSpent |
NUMERIC |
status |
STRING |
createdAt |
TIMESTAMP |
updatedAt |
TIMESTAMP |
drawableBalanceIds |
STRING |
clickAttributionWindow |
STRING |
viewAttributionWindow |
STRING |
name |
STRING |
isAutoDailyPacing |
BOOLEAN |
clickAttributionScope |
STRING |
viewAttributionScope |
STRING |
LineItemsByKeywordReport
Purpose: This Report gives the analytical data of all LineItems break down by keyword.
Source API Documentation: https://developers.criteo.com/retail-media/v2022.07/docs/get-started
Replication: Key Based Incremental
Replication Key: startDate, endDate
Fields
| Name | Data Type |
campaignId |
STRING |
campaignName |
STRING |
lineItemId |
STRING |
lineItemName |
STRING |
campaignTypeName |
STRING |
retailerId |
NUMERIC |
retailerName |
STRING |
keyword |
STRING |
date |
DATE |
impressions |
NUMERIC |
clicks |
NUMERIC |
attributedOrders |
NUMERIC |
attributedUnits |
NUMERIC |
attributedSales |
NUMERIC |
assistedSales |
NUMERIC |
assistedUnits |
NUMERIC |
spends |
NUMERIC |
cpo |
NUMERIC |
LineItems
Purpose: This API is used to fetch data related to all LineItems.
Source API Documentation: https://developers.criteo.com/retail-media/v2022.07/docs/line-items
Replication: Full Replication
Replication Key: N/A
Fields
| Name | Data Type |
id |
STRING |
type |
STRING |
name |
STRING |
startDate |
DATE |
status |
STRING |
targetRetailerId |
STRING |
campaignId |
STRING |
budgetSpent |
NUMERIC |
createdAt |
TIMESTAMP |
updatedAt |
TIMESTAMP |