Daasity Knowledge Base
Daasity Knowledge Base
  • Start here
    • Daasity Overview
    • Important Concepts
      • Attribution Overview
      • What is a Daasity Valid Order?
      • Customer Householding
      • Timezones in Daasity
      • Ecommerce Glossary
      • Daasity Data Security Overview
    • Retail Analytics 101
      • Understanding the Basics: POS Data 101
      • How to use Syndicated Data
    • Product Changelog
    • Feature Requests
  • 🔌Extract
    • Extract your data with Daasity
    • All Integrations
      • Alchemer
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Algolia
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Amazon Advertising
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Amazon Seller Central
        • Validating Your Amazon Data in Daasity
          • Comparing Your Amazon Seller Central Orders to Daasity
        • Integration Setup
          • Configure Amazon Reports
          • Monitor Amazon Reports
        • Integration Specifications
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Sales Reports
          • FBA Inventory Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Performance Reports
          • Returns Reports
          • Settlement Reports
          • Seller Retail Analytics Reports
        • Workflow Configuration Setup
          • Orders API
          • FBA Customer Concession Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removal Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
        • Transformation Configuration Setup
          • Orders API
          • FBA Customer Concessions Reports
          • FBA Inventory Reports
          • Performance Reports
          • FBA Sales Reports
          • FBA Removals Reports
          • Inventory Reports
          • Order Tracking Reports
          • Returns Reports
          • Seller Retail Analytics Reports
          • Settlement Reports
      • Amazon Vendor Central
        • Integration Setup
        • Integration Specifications
        • How to use
        • ASIN Mapping Configuration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
          • Vendor Sales & Inventory Report
          • Vendor Traffic Report
      • AppLovin
        • Integration Setup
      • Attentive Mobile
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Azure SQL Database
      • Back In Stock
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Big Commerce
        • Integration Setup
          • Connect Daasity From BigCommerce Marketplace
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • BigQuery Datasource
      • Bing Ads
        • Integration Setup
        • Integration Specifications
      • Circana
        • Integration Setup
        • Integration Specifications
        • Data Release Calendar
        • H-E-B Circana
      • Cordial
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Criteo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • D​ata File (CSV, XLS)
      • Emplifi
        • Integration Specifications
      • Extensiv (Skubana)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Facebook Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Where to Find Your Data
      • Fairing V2
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Important Notes
      • Google Ads
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Google Analytics 4
        • API vs BigQuery
        • API Integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Custom Reports
          • Validating GA4 Data in Daasity
          • Blending Universal Analytics & GA4 Data
        • BigQuery integration
          • Integration Setup
          • Integration Specifications
          • Workflow Configuration Setup
          • Transformation Configuration Instructions
          • Important Notes
          • Creating a Custom Report
      • Google Sheet
      • Gorgias
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Impact Radius (Beta)
        • Integration Specifications
      • Iterable
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Klaviyo Summary Statistics
        • Integration Setup
        • Integration Specifications
      • Klaviyo V2
        • Integration Setup
        • Integration Specifications
      • KnoCommerce
        • Integration Setup
        • Integration Specifications
      • Loop Returns
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Microsoft SQL Server Database
      • Mongo Database
      • MySQL Database
      • Narvar
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • NetSuite
      • Newstore
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Northbeam
        • Integration Setup
      • Okendo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Ometria
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Order Desk
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pepperjam
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Pinterest
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Postgres Database
      • Postscript (beta)
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Important Notes
      • Recharge
        • Integration Setup
        • Integration Specifications
        • Integration Specifications (2021-11 Beta)
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Recharge Data and Known Discrepancies
      • Retail Next
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Rockerbox
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Salesforce Commerce Cloud
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SFTP
      • ShipBob
        • Integration Setup
        • Integration Specifications
      • Shipstation
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Shopify
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
        • Shopify B2B Data
      • SKIO
        • Integration Setup
        • Integration Specifications
      • Snapchat
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • SPINS
        • Integration Setup
        • Integration Specifications
        • How to Use
        • Data Release Calendar
      • Stay Ai
        • Integration Setup
        • Integration Specifications
      • Target Plus
        • Integration Setup
      • Thankful
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • TikTok
        • Integration Setup
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Walmart Marketplace
        • Integration Setup
        • Integration Specifications
      • Whole Foods Market
        • Integration Setup
        • Integration Specifications
        • How to use
      • Yotpo
        • Integration Setup
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
      • Zendesk
        • Integration Specifications
        • Workflow Configuration Setup
        • Transformation Configuration Setup
    • Brand Supplied Data (BSD)
      • BSD Overview
      • Monitoring Your BSD Progress
      • Revenue Plan
      • Marketing Budget
      • Marketing Spend
      • RFM Values
      • Shipping & Fulfillment Cost
      • SKU Hierarchy
      • SKU Mapping
      • SKU Cost
      • Discount Code Mapping
      • Other Order Sources
      • Channel Mapping
        • Overview & Setup
        • Filling out Channel Mapping
        • Missing from GA & Missing from BSD
      • Configuration
  • 📊VISUALIZE
    • Dashboards
      • Dashboard Overview
      • Standard Dashboards
        • Daasity 101 Overview Dashboards
          • Flashes
          • Shopify Sales Report
          • Account Health
        • Digital Product & Revenue
          • Orders and Revenue
          • Amazon Settlement Report
          • Product Repurchase Rate
          • Product
            • Product Dimensions
              • Why is a Product Name NULL?
          • Inventory
          • Operations
            • Fulfilment Status Options
        • Retention Marketing Dashboards
          • Notifications (Email/SMS)
          • Retention
          • Customer Performance (Email/SMS)
          • Site Funnels
        • Acquisition Marketing Dashboards
          • Attribution Deep Dive
            • Marketing Attribution
              • Attribution Overview
              • Survey-Based Attribution
              • Discount Code Attribution
              • First Click, Last Click, and Assisted Attribution
              • Custom Attribution
              • Vendor-Reported Attribution
              • CPO, CPA, and CAC
              • Missing from GA & Missing from BSD
          • LTV & RFM
            • RFM
              • RFM in the Daasity App
              • Understanding RFM
              • Time on Books (TOB)
          • Marketing
          • Vendor-Reported Marketing Performance
          • Site Analytics & Attribution
      • Integration Dashboards
        • Amazon All Orders Report
        • Amazon Seller Central Business Reports
        • Gorgias
        • Klaviyo Campaign & Flow Performance
        • Loop Returns
        • Okendo Reviews
        • ShipBob
        • Shipstation
        • Subscription
        • Walmart Marketplace Account Sales Report
        • Yotpo
    • Explores
      • Explore Overview
      • Order Line Revenue vs. Transactional Sales Report
      • How to Access An Explore
      • Standard Daasity Explores
        • Current Inventory Level Explore
        • Customer Details Explore
        • Daily Company Metrics Explore
        • Daily Marketing Plan To Actual Marketing Performance Explore
        • Daily Plan to Actual Explore
        • Lifetime Value Explore
        • Marketing Attribution Explore
        • Multi-Channel Transaction Explore
        • Order and Order Line Revenue Explore
        • Product Page Explore
        • Shopping Stage Explore
        • SKU Level Repurchase Rates Explore
        • Traffic Explore
        • Transactional Sales Report Explore
        • UA vs G4 Explore
      • Integration Explores
        • Algolia
        • Amazon Settlement Explore
        • Fairing Survey Responses Explore
        • Gorgias Tickets Explore
        • Loop Returns Explore
        • Okendo Reviews Explore
        • Subscribers and Subscription Monthly Churn Rates Explores (Recharge)
        • Shipstation Explore
        • Yotpo
        • Zen Desk
    • Looker Guides
      • Building visualizations
      • Working with Date Dimensions
      • Schedule a Report or Dashboard
      • Exporting Data
    • Looker Guides (Developer)
      • Daasity Hub & Spoke Introduction
      • Hub & Spoke File Structure
      • Working with LookML Dashboards
      • Customizing Base Daasity Code
    • Visualize using other BI tools
  • 🔀Transform
    • Transforming Data with Daasity
    • Daasity Data Models
      • Daasity Data Model Overview
      • Unified Data Schemas
        • Unified Schema Introduction
        • Unified Order Schema (UOS)
        • Unified Notification Schema (UNS)
        • Unified Subscription Schema (USS)
        • Unified Marketing Schema (UMS)
        • Unified Traffic Schema (UTS)
        • Unified Wholesale Schema (UWS)
      • Data Mart Models
        • Data Mart Introduction
        • Data Reporting Platform (DRP)
        • Channel Attribution Data Mart
        • Marketing Data Mart
      • Transform Code
        • Transform Code Introduction
        • Transform Code Sequence - DRP
        • Initialization Code
        • Householding Code
        • Order Status Code
        • Order Channel and Marketing Code
        • Daily Plan Code
        • Order and Order Line Revenue
        • Plan to Actual Code
        • Customer Code
        • Subscription Code
        • Reviews
        • Life-Time Value Code
        • Returns
        • Product and Inventory Code
        • Email & SMS
        • Transform Code Sequence - Data Mart
        • Unified Order Schema (UOS) Code
        • Unified Marketing Schema (UMS) Code
        • Unified Notification Schema (UNS)
        • Channel Attribution Data Mart Code
        • Marketing Data Mart Code
      • Source to Final Destination
    • Code Repository
      • Code Repository Overview
      • Getting Access to Your Code Repository
      • Code Repository Branches
      • Custom SQL Code
      • Custom Script Manifest Files
    • Script Manifest (YAML) Files
  • 🎵Data Orchestration
    • Workflows
      • Getting Started with Workflows
      • Creating Workflows
      • Managing Workflows
      • Workflow Metrics
    • Notifications
      • Introduction to Notifications
      • Enabling Notification Emails
      • Notifications UI
      • Managing Notifications
      • Authorization List
  • Audiences
    • Audiences Overview
    • Pushing Audience Data to Targets
      • Targets Overview
      • Attentive
        • Events Target
        • Subscribers Target
        • Target Endpoint Documentation
      • Facebook Ads
        • Facebook Target
        • Target Endpoint Documentation
      • Google Ads
        • Google Ads Target
        • Target Endpoint Documentation
      • Klaviyo
        • Events Target
        • Profiles Target
        • Target Endpoint Documentation
      • Sailthru
        • Events Target
        • Users Target
        • Target Endpoint Documentation
      • Tiktok Ads
        • TikTok Target
        • Target Endpoint Documentation
    • Building Audiences
  • warehouse
    • BigQuery
    • Redshift
    • Snowflake
    • Test Data Warehouse
      • Test Data Warehouse Overview
      • Create a Snowflake Test Warehouse
      • Create a Redshift Test Warehouse
  • —
    • Go to Daasity App
    • Contact Support
    • ✍️Feature Requests
Powered by GitBook
On this page
  • Integration Overview
  • Integration Availability
  • API Endpoints
  • Entity Relationship Diagram (ERD)
  • Criteo Schema
  • Ad Sets
  • Ad Set Geo-Targeting Countries
  • Ad Set Geo-Targeting Subdivisions
  • Ad Set Geo-Targeting Zipcodes
  • Ad Set Performance Reports
  • Categories
  • Advertisers
  • Audiences
  • Transactions

Was this helpful?

  1. Extract
  2. All Integrations
  3. Criteo

Integration Specifications

This page will help you learn about how Daasity replicates data from Criteo, limitations to the data we can extract and where the data is stored in the Criteo schema.

PreviousIntegration SetupNextWorkflow Configuration Setup

Last updated 1 year ago

Was this helpful?

Integration Overview

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.

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 that enables multi-platform reporting in one schema.

Integration Availability

This integration is available for:

  • Enterprise

  • Growth

API Endpoints

The Daasity Criteo extractor is built based on this . The following endpoints are used by Daasity to replicate data from Criteo:

Entity Relationship Diagram (ERD)

Criteo Schema

The Daasity Criteo extractor creates these tables using the endpoints and replication methods listed. The data is mapped from the source API endpoint to the table based on the mapping logic outlined in each table.

Ad Sets

  • Update Method: TRUNCSERT

  • Table Name: [criteo.adsets]

JSON Element
Database Column

id

adset_id

attributes::advertiserId

advertiser_id

attributes::campaignID

campaign_id

attributes::name

adset_name

attributes::schedule::startDate::value

schedule_start_date

attributes::schedule::endDate::value

schedule_end_date

attributes::schedule::activationStatus

schedule_activation_status

attributes::schedule::deliveryStatus

schedule_delivery_status

attributes::bidding::bidAmount::value

bid_amount

attributes::bidding::bidStrategy

bid_strategy

attributes::bidding::costController

bid_cost_controller

attributes::targeting::deliveryLimitations::environments::inApp

delivery_inapp

attributes::targeting::deliveryLimitations::environments::web

delivery_web

attributes::targeting::deliveryLimitations::devices::desktop

delivery_desktop

attributes::targeting::deliveryLimitations::devices::tablet

delivery_tablet

attributes::targeting::deliveryLimitations::devices::mobile

delivery_mobile

attributes::targeting::deliveryLimitations::devices::other

delivery_other_devices

attributes::targeting::deliveryLimitations::operatingSystems::android

delivery_android

attributes::targeting::deliveryLimitations::operatingSystems::ios

delivery_ios

attributes::targeting::deliveryLimitations::operatingSystems::other

delivery_other_os

attributes::targeting::frequencyCapping::maximumImpressions

maximum_impressions

attributes::targeting::frequencyCapping::frequency

frequency

attributes::budget::budgetStrategy

budget_strategy

attributes::budget::budgetRenewal

budget_renewal

attributes::budget::budgetDeliverySmoothing

budget_delivery_smoothing

attributes::budget::budgetDeliveryWeek

budget_delivery_week

attributes::budget::budgetAmount::value

budget_amount

MD5(adset_id + ':' + __source_id)

__sync_key

Ad Set Geo-Targeting Countries

  • Update Method: TRUNCSERT

  • Table Name: [criteo.adset_geotargeting_countries]

JSON Element
Database Column

id

adset_id

operand

operand

country

country

MD5(id + ':' + operand + ':' + country + ':' + __source_id)

__sync_key

Ad Set Geo-Targeting Subdivisions

  • Update Method: TRUNCSERT

  • Table Name: [criteo.adset_geotargeting_subdivisions]

JSON Element
Database Column

id

adset_id

operand

operand

subdivision

subdivision

MD5(id + ':' + operand + ':' + subdivision + ':' + __source_id)

sync_key

Ad Set Geo-Targeting Zipcodes

  • Update Method: TRUNCSERT

  • Table Name: [criteo.adset_geotargeting_zipcodes]

JSON Element
Database Column

id

adset_id

operand

operand

zipcode

zipcode

MD5(id + ':' + operand + ':' + zipcode + ':' + __source_id)

__sync_key

Ad Set Performance Reports

  • Update Method: TRUNCSERT

  • Table Name: [criteo.adset_performance_reports]

JSON Element
Database Column

adsetId

adset_id

Adset

adset_name

AdvertiserId

advertiser_id

Advertiser

advertiser_name

AverageCartClientAttribution

aov_client

AverageCartAllClientAttribution

aov_client_xdevice

AverageCartPc30d

aov_click30d

AverageCartAllPc30d

aov_click30d_xdevice

AverageCartPv24h

aov_view1d

AverageCartAllPv24h

aov_view1d_xdevice

AverageCartPc30dPv24h

aov_click30d_view1d

AverageCartAllPc30dPv24h

aov_click30d_view1d_xdevice

AverageCartPc1d

aov_click1d

AverageCartAllPc1d

aov_click1d_xdevice

AverageCartPc7d

aov_click7d

AverageCartAllPc7d

aov_click7d_xdevice

AppInstalls

app_installs

Audience

audience

BounceRate

bounce_rate

Clicks

clicks

ConversionRateClientAttribution

cvr_client

ConversionRateAllClientAttribution

cvr_client_xdevice

ConversionRatePc30d

cvr_click30d

ConversionRateAllPc30d

cvr_click30d_xdevice

ConversionRatePv24h

cvr_view1d

ConversionRateAllPv24h

cvr_view1d_xdevice

ConversionRatePc30dPv24h

cvr_click30d_view1d

ConversionRateAllPc30dPv24h

cvr_click30d_view1d_xdevice

ConversionRatePc1d

cvr_click1d

ConversionRateAllPc1d

cvr_click1d_xdevice

ConversionRatePc7d

cvr_click7d

ConversionRateAllPc7d

cvr_click7d_xdevice

PostInstallConversionRate

cvr_postinstall

AdvertiserCost

cost

CostPerInstall

cost_per_app_install

CostOfAdvertiserValue

cost_per_product_revenue

CostOfAdvertiserValueAll

cost_per_product_revenue_xdevice

CostPerVisit

cost_per_visit

Cpc

cpc

ECpm

cpm

CostPerOrderClientAttribution

cpo_client

CostPerOrderAllClientAttribution

cpo_client_xdevice

CostPerOrderPc30d

cpo_click30d

CostPerOrderAllPc30d

cpo_click30d_xdevice

CostPerOrderPv24h

cpo_view1d

CostPerOrderAllPv24h

cpo_view1d_xdevice

CostPerOrderPc30dPv24h

cpo_click30d_view1d_xdevice

CostPerOrderPc1d

cpo_click1d

CostPerOrderAllPc1d

cpo_click1d_xdevice

CostPerOrderPc7d

cpo_click7d

CostPerOrderAllPc7d

cpo_click7d_xdevice

PostInstallCostPerOrder

cpo_postinstall

ClickThroughRate

ctr

currency

currency

Day

day

ExposedUsers

exposed_users

Displays

impressions

ViewableDisplays

impressions_viewed

NonViewableDisplays

impressions_nonviewed

UntrackableDisplays

impressions_untracked

PotentialDisplays

impressions_potential

InstallRate

install_rate

OverallCompetitionWin

overall_competition_win

AdvertiserValue

product_revenue

AdvertiserAllValue

product_revenue_xdevice

Reach

reach

RevenueGeneratedClientAttribution

revenue_client

RevenueGeneratedAllClientAttribution

revenue_client_xdevice

OmnichannelRevenueClientAttribution

revenue_client_omnichannel

RevenueGeneratedPc30d

revenue_click30d

RevenueGeneratedAllPc30d

revenue_click30d_xdevice

RevenueGeneratedOfflinePc30d

revenue_click30d_offline

OmnichannelRevenuePc30d

revenue_click30d_omnichannel

OmnichannelRevenueAllPc30d

revenue_click30d_omnichannel_xdevice

RevenueGeneratedPv24h

revenue_view1d

RevenueGeneratedAllPv24h

revenue_view1d_xdevice

RevenueGeneratedOfflinePv24h

revenue_view1d_offline

OmnichannelRevenuePv24h

revenue_view1d_omnichannel

OmnichannelRevenueAllPv24h

revenue_view1d_omnichannel_xdevice

RevenueGeneratedPc30dPv24h

revenue_click30d_view1d

RevenueGeneratedAllPc30dPv24h

revenue_click30d_view1d_xdevice

RevenueGeneratedPc1d

revenue_click1d

RevenueGeneratedAllPc1d

revenue_click1d_xdevice

RevenueGeneratedPc7d

revenue_click7d

RevenueGeneratedAllPc7d

revenue_click7d_xdevice

PostInstallOrderValue

revenue_postinstall

RoasClientAttribution

roas_client

RoasAllClientAttribution

roas_client_xdevice

OmnichannelRoasClientAttribution

roas_client_omnichannel

RoasPc30d

roas_click30d

RoasAllPc30d

roas_click30d_xdevice

RoasOfflinePc30d

roas_click30d_offline

OmnichannelRoasPc30d

roas_click30d_omnichannel

OmnichannelRoasAllPc30d

roas_click30d_omnichannel_xdevice

RoasPv24h

roas_view1d

RoasAllPv24h

roas_view1d_xdevice

RoasOfflinePv24h

roas_view1d_offline

OmnichannelRoasPv24h

roas_view1d_omnichannel

OmnichannelRoasAllPv24h

roas_view1d_omnichannel_xdevice

RoasPc30dPv24h

roas_click30d_view1d

RoasAllPc30dPv24h

roas_click30d_view1d_xdevice

RoasPc1d

roas_click1d

RoasAllPc1d

roas_click1d_xdevice

RoasPc7d

roas_click7d

RoasAllPc7d

roas_click7d_xdevice

PostInstallRoas

roas_postinstall

ECosClientAttribution

roi_client

ECosAllClientAttribution

roi_client_xdevice

ECosPc30d

roi_click30d

ECosAllPc30d

roi_click30d_xdevice

ECosPv24h

roi_view1d

ECosAllPv24h

roi_view1d_xdevice

ECosPc30dPv24h

roi_click30d_view1d

ECosAllPc30dPv24h

roi_click30d_view1d_xdevice

ECosPc1d

roi_click1d

ECosAllPc1d

roi_click1d_xdevice

ECosPc7d

roi_click7d

ECosAllPc7d

roi_click7d_xdevice

PostInstallCostOfSale

roi_postinstall

SalesClientAttribution

sales_client

SalesAllClientAttribution

sales_client_xdevice

OmnichannelSalesClientAttribution

sales_client_omnichannel

SalesPc30d

sales_click30d

SalesAllPc30d

sales_click30d_xdevice

SalesOfflinePc30d

sales_click30d_offline

OmnichannelSalesPc30d

sales_click30d_omnichannel

OmnichannelSalesAllPc30d

sales_click30d_omnichannel_xdevice

SalesPv24h

sales_view1d

SalesAllPv24h

sales_view1d_xdevice

SalesOfflinePv24h

sales_view1d_offline

OmnichannelSalesPv24h

sales_view1d_omnichannel

OmnichannelSalesAllPv24h

sales_view1d_omnichannel_xdevice

SalesPc30dPv24h

sales_click30d_view1d

SalesAllPc30dPv24h

sales_click30d_view1d_xdevice

SalesPc1d

sales_click1d

SalesAllPc1d

sales_click1d_xdevice

SalesPc7d

sales_click7d

SalesAllPc7d

sales_click7d_xdevice

PostInstallSales

sales_postinstall

Visits

visits

MD5(adsetId + ':' + Day + ':' + __source_id)

__sync_key

Categories

  • Update Method: TRUNCSERT

  • Table Name: [criteo.categories]

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

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

MD5(catalogId + advertiserId + campaignId + categoryHashCode)

key

MD5(catalogId + advertiserId + campaignId + categoryHashCode)

__sync_key

Advertisers

  • Update Method: TRUNCSERT

  • Table Name: [criteo.advertisers]

JSON Element
Database Column

id

advertiser_id

attributes::advertiserName

advertiser_name

MD5(id + __source_id)

__sync_key

Audiences

  • Update Method: TRUNCSERT

  • Table Name: [criteo.audiences]

JSON Element
Database Column

id

audience_id

attributes::advertiserId

advertiser_id

attributes::name

name

attributes::description

description

attributes::created

created_at

attributes::updated

updated_at

attributes::nbLines

nb_lines

attributes::nbLinesEmail

nb_lines_email

attributes::nbMathcesEmail

nb_matches_email

MD5(id + ':' + __source_id)

__sync_key

Transactions

  • Update Method: TRUNCSERT

  • Table Name: [criteo.transactions]

JSON Element
Database Column

advertiserId

advertiser_id

transactionId

transaction_id

transactionDate

transaction_date

adsetName

adset_name

advertiserName

advertiser_name

eventType

event_type

eventDate

event_date

attributedTransaction

attributed_transaction

currency

currency

amount

amount

crossDeviceTransaction

cross_device_transaction

MD5(transactionId + ':' + __source_id)

__sync_key

illustrating the different tables and keys to join across tables.

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

Endpoint:

🔌
Unified Marketing Schema (UMS)
Criteo API documentation
Ad Sets
Advertisers
Audiences
Statistics
Click here to view the ERD for the Daasity Criteo integration
Ad Sets
Ad Sets
Ad Sets
Ad Sets
Statistics
Advertisers
Advertisers
Audiences
Transactions
Ad Sets
Ad Set Geo-Targeting Countries
Ad Set Geo-Targeting Subdivisions
Ad Set Geo-Targeting Zipcodes
Ad Set Performance Reports
Categories
Advertisers
Audiences
Transactions