CODEWITHSUNDEEP
google-bigquery
Shobhit Vijay Vargiya
Shobhit Vijay Vargiya

Reputation: 21

Calculating Unique events in Google-Bigquery

How can one find the count of unique events in Big Query ? I am having a hard time calculating the count of Unique events and matching it with GA interface.

Upvotes: 2

Views: 2187

Answers (1)

Pentium10
Pentium10

Reputation: 207830

two ways how this is used:

1) One is as the original linked documentation says, to combine full visitor user id, and their different session id: visitId, and count those.

SELECT
  EXACT_COUNT_DISTINCT(combinedVisitorId)
FROM (
  SELECT
    CONCAT(fullVisitorId,string(VisitId)) AS combinedVisitorId
  FROM
    [google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910]
  WHERE
    hits.type='PAGE' )

2) The other is just counting distinct fullVisitorIds

SELECT
  EXACT_COUNT_DISTINCT(fullVisitorId)
FROM
  [google.com:analytics-bigquery:LondonCycleHelmet.ga_sessions_20130910]
WHERE
  hits.type='PAGE'

Upvotes: 2

Related Questions