fullVisitorId : fullVisitorId is a field in the hits table of the Google Analytics data schema. It represents a unique identifier for each visitor to a website, and it is a string data type. The fullVisitorId is assigned to each visitor by Google Analytics when they first visit the website, and it persists for each subsequent visit from the same device or browser until the cookie expires or is deleted.
The fullVisitorId field is used to track the behavior of individual visitors on the website and to group hits from the same visitor together in the Google Analytics data. It allows you to analyze visitor-level metrics such as the number of unique visitors, the frequency and recency of visits, and the conversion rate.
In addition to fullVisitorId, the hits table in BigQuery also contains other fields that are associated with visitor-level data, such as visitId (a unique identifier for each visit), visitorType (whether the visitor is a new or returning visitor), and visitStartTime (the timestamp of the start of the visit).
By analyzing visitor-level data in BigQuery, you can gain insights into visitor behavior and preferences, which can help you optimize your website’s user experience and increase conversions. For example, you can identify which pages and content are most popular among visitors, which traffic sources are driving the most valuable visitors, and which visitor segments are most likely to convert.
ClientId : clientId is a field in the Google Analytics data schema that represents a unique identifier for each user of a website or mobile app. The clientId is a string data type, and it is assigned to each user by Google Analytics when they first visit the website or use the app. It is stored as a cookie or device identifier and persists across sessions, allowing Google Analytics to track user behavior over time. The clientId is used to group hits and sessions from the same user together, enabling analysis of user-level metrics such as user acquisition, engagement, and retention. By analyzing clientId data in BigQuery, you can gain insights into user behavior and preferences, which can inform marketing, product development, and user experience optimization strategies.
visitorId : visitorId is a field in the Google Analytics data schema that represents a unique identifier for each visitor to a website. The visitorId is a string data type, and it is assigned to each visitor by Google Analytics when they first visit the website. It is stored as a first-party cookie and persists across sessions, allowing Google Analytics to track visitor behavior over time. The visitorId is used to group hits and sessions from the same visitor together, enabling analysis of visitor-level metrics such as visit frequency, recency, and engagement. By analyzing visitorId data in BigQuery, you can gain insights into visitor behavior and preferences, which can inform website design, content strategy, and marketing initiatives.
visitStartTime : visitStartTime is a field in the Google Analytics data schema that represents the timestamp of the start of a visit to a website or mobile app. It is stored as a UNIX timestamp, which is the number of seconds that have elapsed since January 1, 1970, at 00:00:00 UTC. By analyzing visitStartTime data in BigQuery, you can gain insights into visitor behavior and engagement over time.
totals.bounce : Totals.bounces in the Google Analytics data schema in BigQuery indicates the count of single-page sessions on a website. A bounce refers to a session where a visitor exits the website after viewing just one page.