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
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:
If using Excel for Desktop, the timezone is defined by the local computer's date/time settings.