Criteo is an ad-network for Display Ads that allows you to run campaigns and show display ads across a number of different websites and devices.
INTEGRATION OVERVIEW
The Daasity<>Criteo integration enables merchants to extract key metrics from display campaigns on a daily basis to easily track and compare performance across various ad platforms. Data is transformed as part of Daasity's Unified Marketing Schema (UMS) that enables multi-platform reporting in one schema.
This integration is available for Growth & Pro 2.0 Daasity Merchants with an active Daasity subscription.
SUPPORTED ENDPOINTS
| Audiences | https://api.criteo.com/v1/audiences |
| Budgets | https://api.criteo.com/v1/budgets |
| Campaigns | https://api.criteo.com/v1/campaigns |
| Categories | https://api.criteo.com/v1/categories |
| Portfolios | https://api.criteo.com/v1/portfolios |
| Statistics (Performance) |
https://api.criteo.com/v1/statistics |
CRITEO ERD
ENDPOINT: AUDIENCES
Data mapping from source JSON to database columns:
|
JSON Element |
Database Column |
|
id |
audience_id |
|
advertiserId |
advertiser_id |
|
name |
name |
|
description |
description |
|
created |
created_at |
|
updated |
updated_at |
|
nbLines |
nb_lines |
|
nbLinesEmail |
nb_lines_email |
|
nbMatchesEmail |
nb_matches_email |
Incremental data extraction
|
Business Rule |
Value |
|
Load type |
UPSERT |
|
Extraction Frequency |
Daily |
Sync Key definition: MD5 Hash of the following fields
- audience_id
ENDPOINT: BUDGET
Data mapping from source JSON to database columns:
|
JSON Element |
Database Column |
|
advertiserId |
advertiser_id |
|
budgetId |
budget_id |
|
budgetName |
budget_name |
|
type |
type |
|
totalAmount |
total_amount |
|
remainingBudget |
remaining_budget |
|
remainingBudgetUpdated |
remaining_budget_updated |
|
active |
active |
Incremental data extraction
|
Business Rule |
Value |
|
Load type |
UPSERT |
|
Extraction Frequency |
Daily |
Sync Key definition: MD5 Hash of the following fields
- budget_id
ENDPOINT: CAMPAIGNS
Data mapping from source JSON to database columns:
|
JSON Element |
Database Column |
|
campaignType |
campaign_type |
|
advertiserName |
advertiser_name |
|
categories |
categories |
|
budgetId |
budget_id |
|
campaignId |
campaign_id |
|
campaignName |
campaign_name |
|
advertiserId |
advertiser_id |
|
campaignStatus |
campaign_status |
|
campaign::bidValue |
campaign_bid_value |
|
campaign::bidCurrency |
campaign_bid_currency |
|
campaign::bidType |
campaign_bid_type |
|
campaign::bidIsPending |
campaign_bid_is_pending |
Incremental data extraction
|
Business Rule |
Value |
|
Load type |
UPSERT |
|
Extraction Frequency |
Daily |
Sync Key definition: MD5 Hash of the following fields
- campaign_id
ENDPOINT: STATISTICS (CAMPAIGN PERFORMANCE)
Data mapping from source JSON to database columns:
|
JSON Element |
Database Column |
|
advertiser_id |
advertiser_id |
|
advertiser_name |
advertiser_name |
|
campaign_id |
campaign_id |
|
campaign_name |
campaign_name |
|
day |
day |
|
currency |
currency |
|
clicks |
clicks |
|
impressions |
impressions |
|
ctr |
ctr |
|
sales |
sales |
|
all_sales |
all_sales |
|
cost |
cost |
|
cpo |
cpo |
|
cpc |
cpc |
|
revenue |
revenue |
|
factsnamesrevenuegeneratedpv |
revenue_generated_pv |
|
exposed_users |
exposed_users |
|
sales_pv |
sales_pv |
|
samedevice_sales |
same_device_sales |
|
factsnamessalespcpv |
sales_pc_pv |
|
audience |
audience |
|
reach |
reach |
|
comp_win |
overall_competition_win |
|
cvr |
conversion_rate |
|
cvr_pv |
conversion_rate_pv |
|
adv_value |
advertiser_value |
|
cov |
cost_of_advertiser_value |
|
roas |
return_on_advertising_spending |
|
advertiser_id |
advertiser_id |
|
advertiser_name |
advertiser_name |
Incremental data extraction
|
Business Rule |
Value |
|
Load type |
UPSERT |
|
Extraction Frequency |
Daily |
Sync Key definition: MD5 Hash of the following fields
- campaign_id
ENDPOINT: CATEGORIES
Data mapping from source JSON to database columns:
|
JSON Element |
Database Column |
|
categoryHashCode |
category_hash_code |
|
categoryName |
category_name |
|
catalogId |
catalog_id |
|
catalogName |
catalog_name |
|
advertiserId |
advertiser_id |
|
advertiserName |
advertiser_name |
|
campaignId |
campaign_id |
|
campaignName |
campaign_name |
|
averagePrice |
average_price |
|
numberOfProducts |
number_of_products |
|
enabled |
enabled |
|
categoryBid::bidValue |
category_bid_value |
|
categoryBid::bidCurrency |
category_bid_currency |
|
categoryBid::bidType |
category_bid_type |
|
categoryBid::bidIsPending |
category_bid_is_pending |
Incremental data extraction
|
Business Rule |
Value |
|
Load type |
UPSERT |
|
Extraction Frequency |
Daily |
Sync Key definition: MD5 Hash of the following fields
- catalog_id
- advertiser_id
- campaign_id
- category_hash_code
ENDPOINT: PORTFOLIOS
Data mapping from source JSON to database columns:
|
JSON Element |
Database Column |
|
advertiserId |
advertiser_id |
|
advertiserName |
advertiser_name |
Incremental data extraction
|
Business Rule |
Value |
|
Load type |
UPSERT |
|
Extraction Frequency |
Daily |
Sync Key definition: MD5 Hash of the following fields
- advertiser_id