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

1. Sign in to Daton

2. Select CriteoRetailMedia 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. 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.

5. Post successful authentication you will be prompted to choose required tables from the list

6. Then select all required fields

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 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