Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Criteo Retail Media

Criteo Retail Media, ETL connector for data replication

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      • Saras IQ

        Need help with something?

        Talk to data expert

        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
        ecommerce marketing criteo advertising

        Was this article helpful?

        Yes
        No
        Give feedback about this article

        Related Articles

        • Criteo
        • Constant Contact
        • Ascend
        • Calendly V2

        Table of Contents

        Snapshot Tables/APIs Supported Integrate Criteo Retail Media with Daton Workflow Criteo Retail Media Data LineItems

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Experts
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Follow Us

        Linkedin Youtube

        Company

        • Customers
        • Partner With Us
        • Contact Us

        Culture

        • About
        • People
        • Careers

        Offerings

        • Daton
        • For Brands
        • For Agencies

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA

        Follow Us

        Linkedin Youtube

        DISCLAIMER: Various trademarks are held by their respective owners

        © 2023 sarasanalytics.com

        Sitemap

        Get Started on your Data Journey Today!

        Get a free 14-day trial of Daton today, no credit card is required.

        Start Free Trial
        Talk To Sales
        DISCLAIMER: Trademarks are held by their respective owners
        • Quick & Easy Setup
        • Secure & Reliable
        • No-Code Platform
        • Auto Updates
        • 24/7 Support

        Company

        • Customers
        • Partners
        • About
        • People
        • Careers
        • Contact Us

        Offerings

        • Daton
        • Solution for Brands
        • Solution for Agencies
        • Dashboards
        • Founder's Note
        • Status

        Policies

        • Terms of Service
        • Privacy Policy
        • MSA
        • Sitemap

        © 2023 sarasanalytics.com

        Linkedin Youtube

        Knowledge Base Software powered by Helpjuice

        Expand