CODEWITHSUNDEEP
google-analyticsgoogle-bigquery
amysong
amysong

Reputation: 143

Beginner GA export bigquery questions

I am new to bigquery. Have a couple of rookie questions --

Is there any way to do a select top x * query, laid out kind of like the preview pane in table details? It can be a lot easier to understand when you can visually see the data and structure.

You can create a unique visit ID by concatenating VisitId and FullVisitorId. Why doesn't this match count of sessions? How do unique visits differ from sessions definitionally?

Thanks!

Upvotes: 1

Views: 451

Answers (1)

Michael Sheldon
Michael Sheldon

Reputation: 2057

COUNT(DISTINCT field[, N]) is a statistical approximation. For counts less than N, it is exact.

To get an exact count for large values, use count(*) on a group each by, however this may be a much slower query.

See COUNT documentation at https://cloud.google.com/bigquery/query-reference.

Upvotes: 3

Related Questions