Discrepancies with Criteo Results

This guide covers some known causes for discrepancies in Criteo data in the new REST API and how to address them.

Quick links to the sections below:

• Currency and Cost Discrepancies
• Timezone Settings Mismatch

Currency and Cost Discrepancies

There's a known issue that the API does not retrieve the account's currency setting, and if the Supermetrics query is not set to match, it can lead to mismatching values for currency-based metrics, like cost. Below are the ways to set this for each product.

For Google Sheets

You can set the currency for the query under Options - this ideally should match the same currency setting as your account/report settings:

For Data Studio

You can set the currency in the data source main configuration under the Currency (default EUR) drop-down - this ideally should match the same currency setting as your account/report settings:

For Excel

You can add a custom Advanced setting under Options. It will be the value: CURRENCY_<currencycode>. This ideally should match the same currency setting as your account/report settings:

Timezone Mismatch Discrepancies

There is a known issue that Criteo's internal reporting UI only reports in the timezones GMT, PST, and JST, but the API can report in any. So if the Supermetrics product timezone is not set to match one of those values in the reporting UI, you can get mismatched values. To address this then, you can update the Supermetrics product location to work with your reporting timezone (or change the reporting UI to match). Below are the ways to correct this in each product.

For Criteo's Own Reporting UI

The option to check and change the timezone is under the User settings.

For Google Sheets

The timezone is set per the Sheet file settings. See this guide for more details on how to check and change this: https://support.google.com/docs/answer/58515

For Data Studio

Data Studio is fixed to use GMT.

For Excel

The timezone for the Excel Online file is defined by the Office 365 settings for the Microsoft user account. To check and change that, please see this guide:

https://support.office.com/en-us/article/change-your-display-language-and-time-zone-in-office-365-for-business-6f238bff-5252-441e-b32b-655d5d85d15b

If using Excel for Desktop, the timezone is defined by the local computer's date/time settings.