When working with unique count metrics — like Facebook’s “Reach” metrics, for example — you might see this error appear in a cell in Google Sheets:
- Can’t be calculated, would require summing deduplicated values
Looker Studio (formerly Data Studio) might show 0 or “null” instead of this error message.
This error occurs when the data source calculates that the metric you’re using is a unique count. When it does this, it counts a specific object (like an ad, campaign, account, or post, for example). If the query isn’t split based on unique metrics, or if it’s not split at all, you’ll see the error. It’ll also appear if it’s split by unique objects that have identical names.
Instructions
To solve this error, modify the query to include another dimension field that’s unique, like Ad ID, Campaign ID, or Post ID. The sums will then be split according to their unique object, clearing the error.
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 that the results given by the ALLOW_SUM_UNIQUE setting are not correct, as this setting forces the summing of non-summable metrics.