Custom Dimension count data discrepancy in Custom Reports vs. BigQuery
We track a custom dimension at the hit level for which "client" was selected. This could be 1 or more clients and can change throughout a session. When I run a Custom Report in GA, wanting to look at all unique values for that CD I get 7K results. When I run a count(distinct hits.customDimensions.value) from table where hits.customDimensions.index = my cd number, I get 80K+!!
Does GA not handle all the different CD's within a single session? I have GA 360, even tried running an unfiltered report, and still get HUGE count differences.
Any idea what's going on here?