Scorecard for COUNT_DISTINCT Hostnames Not Lining Up[ Edited ]
April 2017 - last edited April 2017
Client is trying to compare the unique number of hostnames to a Google Analytics view and the numbers we are seeing do not line up.
We created a Custom Metric in Data Studio titled Count of Domains that is: COUNT_DISTINCT(Hostname)
I'm assuming this should return the distinct number of hostnames that have visited the site. When I create a Scorecard with this metric I receive 6,289. However if I create a table with the standard hostname dimension, I can see the table returns 5,782 results. (screen shot below).
Maybe these numbers shouldn't be 100% lined up, but I would certainly expect them to be much closer.
Are we misinterpreting what COUNT_DISTINCT(Hostname) should return? And/or what is the better way to measure the number of hostnames to the site?
Scorecard for COUNT_DISTINCT Hostnames Not Lining Up
I've been having some issues as well. It appears that Studio first groups/aggregates the table on some dimension and then adds up the COUNT_UNIQUE for all values of that dimension. I really wish that I could switch off "aggregate" from "Auto" to "none" on everything...