Follow these steps to resolve discrepancies in different types of Criteo data when creating reports with Supermetrics.
Currency and cost data
Criteo’s API doesn’t retrieve the account’s currency settings, which can create mismatched values if the currency setting in Supermetrics isn’t the same.
Instructions
- Google Sheets: Open the Supermetrics sidebar, and navigate to Options. In the Advanced settings field, enter CURRENCY_<ISO 4217 code for the currency>, for example, CURRENCY_EUR or CURRENCY_USD.
- Looker Studio (formerly Data Studio): Open the data source’s configuration panel, and set the currency setting under the Currency dropdown.
- Excel: Open the Supermetrics sidebar and navigate to Options. Select Custom..., and in the Advanced setting field, enter CURRENCY_<ISO 4217 code for the currency>, for example, CURRENCY_EUR or CURRENCY_USD.
Timezone data
Criteo’s user interface reports timezones in GMT, PST, and JST, but its API can’t report in any timezone. If your Supermetrics product timezone isn’t set to one of the timezones in the interface, mismatched values can result.
Instructions
- Criteo: Check and change timezones in User settings.
- Google Sheets: Timezones are set in a Sheet’s file settings. Read Google’s documentation to learn how to make changes.
- Looker Studio: Looker Studio uses GMT by default.
- Excel Online: An Excel Online file’s timezone is defined by the Office 365 settings in the Microsoft user account. Read Microsoft’s documentation to learn how to update this.
- Excel Desktop: On desktop, Excel’s timezone will match the local computer’s date and time settings.