AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
1.8K members online now
1.8K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Calculated metric COUNT_DISTINCT(Product) not working

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I am trying to visualize the amount of active products in an online store. "Active" by my definition are products which appear in GA (= generate at least one product list impression per day).

To do that, I created a calculated field with the formula COUNT_DISTINCT(Product) but this does not yield the desired result and returns no data at all. COUNT(Product) fails equally.

 

If I however select dimensions which are not part of GA's eCommerce tracking, it works as expected. Example for COUNT_DISTINCT(City):

Bildschirmfoto 2017-07-06 um 13.06.52.png

Is this a known limitation of Data Studio or even a bug? I couldn't find this anywhere in the documentation.

 

Best regards,

Justus