---
title: "How to fix Supermetrics deduplicated values errors"
slug: "how-to-fix-supermetrics-deduplicated-values-errors"
description: "Resolve Google Sheets' unique count metric errors by adding unique dimensions like Ad ID or Campaign ID for accurate data analysis."
updated: 2026-10-29T12:12:07Z
published: 2026-10-29T12:12:07Z
canonical: "docs.supermetrics.com/how-to-fix-supermetrics-deduplicated-values-errors"
---

> ## 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 Supermetrics deduplicated values errors

Unique count metrics, such as Reach in Facebook Ads, count each person once, so you can't add them up across rows. Follow these steps to set up your query if you see this message in Google Sheets:

- `Can’t be calculated, would require summing deduplicated values`

Data Studio (formerly Looker Studio) might show 0 or “null” instead of this error message.

![Spreadsheet showing ad metrics with highlighted cell indicating calculation issues.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/deduplicated-values-error.png)

This error occurs when the data source calculates that the metric you’re using is a unique count. The unique metric count is based on a specific object, such as date, campaign, ad, post, or email, for example. The unique count metric returns an error in the following cases:

- Unique count metric isn't split in a unique way enough.
- Unique count metric isn't split at all.
- Metric is split by unique objects (ads, campaigns, or objects) that have identical names.

## Instructions

To solve this error, modify the query to include another dimension field that's unique. Unique fields include, but are not limited to, Ad ID, Campaign ID, Post ID, or Date, for example. The sums will then be split according to their unique object, clearing the error.

![Table displaying ad names, IDs, and reach metrics for various advertisements.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/unique-fields-deduplicated-values.png)

In Supermetrics for Google Sheets, adding the `ALLOW_SUM_UNIQUE` setting under **Options → Advanced settings** in the Supermetrics sidebar allows you to clear this error message.

> [!NOTE]
> Note
> 
> The results given by the **ALLOW_SUM_UNIQUE** setting are not correct, as this setting forces the summing of non-summable metrics.

## More resources

- [About Reach](/v1/docs/about-reach)
- [About aggregatable and non-aggregatable metrics](/v1/docs/about-aggregatable-and-non-aggregatable-metrics)