Criteo

Criteo is a demand-side platform (DSP) provider built on the open internet, which enables retailers, brands, and big and small publishers to display personalized online ad campaigns to users who have previously visited their website.

You can replicate your campaign information and campaign performance statistics to your Destination database or data warehouse using Hevo Pipelines.

Prerequisites

  • An active Criteo account.

  • Criteo API key and secret for authorizing Hevo to access the data in Criteo.

Configuring Criteo as a Source

Perform the following steps to configure Criteo as a Source in Hevo:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipeline List View.

  3. In the Select Source Type page, select Criteo.

  4. In the Configure your Criteo Source page, specify the following:

    Conf Source

    1. Pipeline Name: A unique name for your Pipeline.

    2. Client ID: The API token that you created in Criteo to enable Hevo to read data from your Criteo account.

    3. Client Secret: The API Secret for the API Key that you created in Criteo.

    4. Historical Sync Duration: The duration for which the past data must be ingested.

  5. Click TEST & CONTINUE.

  6. Proceed to configuring the data ingestion and setting up the Destination.

Obtaining the API Key and Secret

To provide Hevo access to your Criteo data, you need to create an API user in Criteo, and log in to Hevo using that user’s API key and secret.

  1. Sign in to your Criteo Marketing Console.

  2. Click on the hamburger menu and scroll down and click Team.

    Navigation to Team page

  3. In the Team page, click Add API User.

    Option to add API user

  4. In the Contact Email field, specify the Email ID to which you wish to give the API access, and assign a role to this user. Available roles include Business Manager, Financial Manager, and Technical Manager.

  5. Click Add User.

    Add the user

    The new user is created. Copy the Client ID and Client Secret. You will be using it to configure Criteo in Hevo.

  6. Select the confirmation check box and click Close.

    Confirmation screen

You can now view the list of API users in the page:

Newly added user

Data Replication

  • Historical Data: Hevo ingests the historical data for the campaign report object on the basis of the historical sync duration selected at the time of creating the Pipeline.

  • Incremental Data: Once the historical data ingestion is complete, every subsequent run of the Pipeline fetches the entire data for the objects. In case of the campaign report object though, only the new and modified data is ingested.

  • Refresher Data: All reporting data for the campaign report object is refreshed on a rolling basis to update any conversions attributed to clicks for the past 30 days.

Note: The time taken to fetch historical data depends on how many days are selected at the time of creating a Pipeline. Hence, Hevo defaults this period to one year before today, and if required you may customize it to any date, with the earliest being January 01, 2010.

Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination database:

Criteo ERD

Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Object Description
Advertiser Retrieve list of specific advertisers for your user. (Advertiser Portfolio)
Bid All bids associated to each campaign category are stored in the Bid object.
Budget Budget details such as name, amount, balance etc associated to an advertisers profile are stored in the Budget object. A budget is the maximum amount of money you would like to spend to show people your ads. It also helps you control your overall spend across your Criteo campaigns.
Campaign The complete list of campaigns for Advertiser(s) along with activity and bid statuses are stored in the Campaign Object. Campaigns include Running, Inactive as well as Archived campaigns.
Campaign Report Daily level reports showcasing all statistical metrics, available in the following dimensions:
- Campaign ID
- Category ID
- Day
Note: To keep the data sanitised, we will update the data for the last 30 days for the campaign report object.
Category All campaign categories for a specific advertiser’s campaigns are stored in this object along with pricing, bid, names, and activity status.

Limitations

None.

Last updated on 16 Nov 2020