Supermetrics Support Forum

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

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:

Orange arrow points to "Select currency" setting under Options for Google Sheets version of Criteo

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:

Example currency setting in Data Studio for Criteo connector

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:

Example advanced setting for EUR currency in Excel for the Criteo connector

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.

Orange box highlighting the Display options for the report, focusing on the "Preferred Timezone".

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.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.