---
title: "How to fix discrepancies in Criteo data in Supermetrics"
slug: "how-to-fix-discrepancies-in-criteo-data-in-supermetrics"
description: "Resolve Criteo data discrepancies in Supermetrics by adjusting currency and timezone settings across Google Sheets, Looker Studio, Excel, and Power BI."
updated: 2026-05-06T13:12:31Z
published: 2026-05-06T13:25:57Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to fix discrepancies in Criteo data in Supermetrics

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`.
- **Data Studio (formerly Looker Studio):** Open the data source's configuration panel, and set the currency setting under the **Currency** drop-down.
- **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`.
- **Power BI**: Open the [query list on the Supermetrics Hub](https://hub.supermetrics.com/power-bi) and select a Criteo query to modify. In the sidebar, click **Options**. In the **Advanced settings** field, enter `CURRENCY_<ISO 4217 code for the currency>`, for example, `CURRENCY_EUR` or `CURRENCY_USD`.
- **The Supermetrics API**: On the [Supermetrics Hub](https://hub.supermetrics.com/query-manager), open the sidebar in Query Manager, and navigate to **Options**. In the **Advanced settings** field, enter `CURRENCY_<ISO 4217 code for the currency>`, for example,` CURRENCY_EUR` or `CURRENCY_USD`.
- **Data warehouse**: On the [Supermetrics Hub](https://hub.supermetrics.com/transfers), select a data warehouse transfer to edit, and under **General settings**, select the correct currency from the drop-down menu.

## 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](https://support.google.com/docs/answer/58515).
- **Data Studio**: Data 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](https://support.office.com/en-us/article/change-your-display-language-and-time-zone-in-office-365-for-business-6f238bff-5252-441e-b32b-655d5d85d15b).
- **Excel Desktop**: On desktop, Excel's timezone will match the local computer's date and time settings.
- **Power BI**: Open the [query list on the Supermetrics Hub](https://hub.supermetrics.com/power-bi) and select a Criteo query to modify. In the sidebar, click **Options** and scroll down to select the correct reporting timezone from the drop-down menu.
- **The Supermetrics API**: On the [Supermetrics Hub](https://hub.supermetrics.com/query-manager), open the sidebar in Query Manager, and under **Options**, select the correct reporting timezone from the drop-down menu.
- **Data warehouse**: On the [Supermetrics Hub](https://hub.supermetrics.com/transfers), select a data warehouse transfer to edit, and under **General settings**, select the correct reporting timezone from the drop-down menu.