Criteo walkthrough

Prerequisite

Ensure you have Criteo connection.

Pulling data from Criteo into Data Integration

You can retrieve the Criteo reports in Data Integration.

Step 1: Select the connection

• Choose the appropriate Criteo connection from the available list in the Source tab of the River.

• If the desired connection does not exist, create or update an existing connection.

Step 2: Choose reports

• Select a report in the Report drop-down.
• Use the Advertisers filter to narrow the report. Leave it empty to include all advertisers.

Campaigns performance report

• Reports Columns: Select the report's dimensions, metrics, and currency:

note

Some metric/dimension combinations might not work. An error message appears when you try to run unsupported combinations.

Step 3: Choose report time period

Select the time period of the report.

All the reports support the following time period types:

• Date range:

  • Pulls data in the date range between the start and end date provided, including the end date.
  • You must select a start date.
  • Leaving the end date empty will pull data according to the current river run time.
  • Select a timezone offset to send dates based on the offset.
  • Use the Last Days Back For Each Run to expand the start date and pull data from a specified number of days before the chosen start date.

• Predefined date- A date range defined by Data Integration:

  • Day: Yesterday.
  • Week (From Monday to Sunday): Week to date, Previous week, Previous week to date.
  • Month: Month to date, Previous month, Previous month to date.
  • Year: Year to date.

Step 4: Split data using interval chunks

Data Integration can run over the increment using chunks to make the loading efficient and precise. You can choose from:

• Don't Split: Data Integration will pull the data from the chosen start date to the end date in one bulk.
• Daily: The run will be chunked daily from the start to the end date.
• Monthly: The run will be chunked monthly from the start to the end date.
• Yearly (Less Recommended): The run will be chunked yearly from the start to the end date.

Interval Size: Set the size of each interval. Define how many days, months, or years each chunk should include.

For example, setting the Interval Size to 4 with a Daily Interval Chunk will split the date period into 4-day chunks. The period from January 1, 2020, to January 8, 2020, will be split into two intervals: from January 1, 2020, to April 1, 2020, and from May 1, 2020, to January 8, 2020.

Known limitation in v2021-01

The maximum number of rows returned per request is limited to 100,000. You may need to make multiple smaller requests to fetch highly granular data. You can split the data with the Interval Chunks.

This limitation will be addressed in future updates of the /statistics/report endpoint, available in the 'Statistics' report.