raw_sessions
The raw_sessions table is a "session" scope table. It records every sessions of all users, which are defined by a succession of events within a given time.
Last updated
Was this helpful?
The raw_sessions table is a "session" scope table. It records every sessions of all users, which are defined by a succession of events within a given time.
Last updated
Was this helpful?
The new sessions appear in the raw_sessions table once the session has expired, which occurs after a 30-minute period of inactivity following the last hit.
Date and time of the start of the session. The datetime of a session is calculated from raw_hits table: Quanti: takes the datetime's value from session's first hit.
Unique session identifier. A session (also called visit) is a set of events from the same visitor within a given amount of time. It ends when the tag does not record any events for 30 minutes. session_id is automatically created by Quanti:. A visitor can make multiple sessions. session_id can be overridable
Unique visitor identifier. Automatically created by Quanti: based on the value of the cookie placed on the user's browser, by the tag itself. One visitor = one browser. A visitor can make multiple hits and sessions. Its value is overridable if needed.
Unique user identifier from the client / contact base. This identifier has to be specified in the tag. It is typically based on a hashed version of the user's email address (using SHA256, for example).
The user_id of a session is calculated from raw_hits table. Quanti: takes the last known value (different from empty or null values).
The type of the device used to navigate. 3 possible choices: desktop, mobile, or tablet. The device_type of a session is calculated from the raw_hits table. For each session, the value is taken from the last hit.
First page of a session. The landing_url of a session is calculated from raw_hits table.
Last page of a session. The exit_url of a session is calculated from raw_hits table.
The s_source field is the traffic source of a session. It is calculated from raw_hits table. Quanti: applies rules to determine its value based on information contained in the url field and the referrer field of session's first hit.
The s_medium field is the traffic medium of a session. It is calculated from raw_hits table. Quanti: applies rules to determine its value based on information contained in the url field and referrer field of session's first hit.
The s_campaign of a session is calculated from raw_hits table. Quanti: extract value of utm_campaign parameter of session's first hit.
The s_content of a session is calculated from raw_hits table. Quanti: extract value of utm_content parameter of session's first hit.
The s_keyword of a session is calculated from raw_hits table. Quanti: extract value of utm_term parameter of session's first hit.
The s_keyword of a session is calculated from raw_hits table. Quanti: extract value of utm_id parameter of session's first hit.
The value of consent given by the user upon arrival through your consent management platform. The s_consent of a session is calculated from raw_hits table. Quanti: keeps the last value known from session's hits.
The referrer is the visitor's originating page, or in other words, the page that precedes the opening of the session. The s_referrer of a session is calculated from raw_hits table: Quanti: takes the referrer's value from session's first hit.
The number of page views counted during the session.
The number of events counted during the session.
The number of conversions counted during the session.
The sum of conversions values counted during the session.
Unique account identifier given by Quanti: during tag creation. It can't be modified.
Calculated from the raw_hits table. For each session, we keep the last known value.
Calculated from the raw_hits table. For each session, we keep the last known value.
Calculated from the raw_hits table. For each session, we keep the last known value.
Calculated from the raw_hits table. For each session, we keep the last known value.
