Log-Level

Introduction

https://api.criteo.com/2023-01/log-level/advertisers/{advertiser-id}/report

The Criteo API can provide log-level, publisher-oriented information on your ad impressions and clicks in the form of daily reports.

These reports include publisher domains where ads are displayed, timestamps of displayed ads, the price you are paying for each click, and contextual information such as user environment and device.
 
You can retrieve this information at any time through the Criteo API in the form of reports that can integrate back into your systems. Reports are available for up to 30 days, starting from yesterday.

Below is an example using a basic cURL request:

curl -X POST "https://api.criteo.com/2023-01/log-level/advertisers/{advertiser-id}/report" 
  -H "accept: text/plain"
  -H "Content-Type: application/json-patch+json"
  -H "Authorization: Bearer XXXXX " 
  -d "{ \"startDate\": \"2021-02-03\", \"endDate\": \"2021-02-04\"}"

The call above will return an array of objects containing links to download the reports. The reports will be split out by advertiser and day. No result will be returned if the query pre-dates a 30-day period (starting from yesterday).

Due to the high volume of impression date, this query only supports daily files.

{
  "data": [
    {
      "type": "TransparencyReport",
      "attributes": {
        "advertiserId": "XXXXX",
        "tokenValidUntil": "2021-02-04T22:42:44.3437476Z",
        "files": [
          {
            "fileName": "2021-02-03_v1.csv.gz",
            "url": "https://criteocpp.blob.core.windows.net/XXXXX
          },
          {
            "fileName": "2021-02-04_v1.csv.gz",
            "url": "https://criteocpp.blob.core.windows.net/XXXXX
          },
        ]
      }
    }
  ]
}

In the array returned, the report address will be located in the 'stats' section under the 'url' parameter. You will need to retrieve the report from this location to see the data.

There are many ways to retrieve this report but in this example, we will be using curl.

curl -o "saved_report.csv.gz" "#link from the url param#"

Once the report is downloaded, you will need to un-compress it and open it. The downloaded report will not contain column headers; please refer to the documentation below.

Data specification

When reading over the report, there are a few things to note. They are listed below in a table for easy reference.

Example of parsing

The CSV file is produced with no quotes, Newline as a line terminator, backslash as an escape character, and comma as a separator. Please see below an example of parsing.

import csv
 
csv.register_dialect('crto', delimiter=',' ,quoting=csv.QUOTE_NONE,escapechar='\\',lineterminator = '\n')
with open('test_om.csv', newline='') as csvfile:
       spamreader = csv.reader(csvfile, dialect='crto')
       for row in spamreader:
             print('rowcount ', len(row))
             print(', '.join(row))

If you notice any issues don't hesitate to reach out through the Discussion section or your dedicated account representative.