Open navigation

How to fix Supermetrics deduplicated values errors

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

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 ALLOW_SUM_UNIQUE under Options → Advanced settings in the Supermetrics sidebar will also solve this problem.

Did you find it helpful? Yes No

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