5.1K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
Guide Me

Custom Dimension count data discrepancy in Custom Reports vs. BigQuery

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

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?