CODEWITHSUNDEEP
google-analyticsgoogle-bigquery
Setra Yappi
Setra Yappi

Reputation: 31

What does Visit Number mean in Google Analytics - BigQuery export?

Is `visitNumber the number of times a user visits a site to date? But in the data (see screenshot below), I'm seeing visit numbers skipped, and the visitorId is also null.

Sample Data1

Upvotes: 1

Views: 2816

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 172993

I assume you are dealing with Google Analytics exported to BigQuery

If so:

visitorId is deprecated (thus nulls) and fullVisitorId should be used instead.

visitNumber is an INTEGER that represents session number for the user. If this is the first session, then this is set to 1.

fullVisitorId is a STRING that represents unique visitor ID (also known as client ID).

See more at BigQuery Export schema

Upvotes: 3

Related Questions