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