Criteo Extractor Documentation

criteo-logo.pngCriteo 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 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful