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.
Syncing
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.
Fields definition
datetime
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.
session_id
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
visitor_id
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.
user_id
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).
A user (identified by a user_id) can make sessions (identified by multiple session_id) on multiple devices, and as a result, several browsers (identified by different visitors_id). For each user, pages and events are recorded (identified by different hit_id).
device_type
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.
landing_url
First page of a session. The landing_url of a session is calculated from raw_hits table.
exit_url
Last page of a session. The exit_url of a session is calculated from raw_hits table.
s_source
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.
To learn more about Campaign parameters calculated rules, read this attribution calculated rules.
s_medium
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.
To learn more about Campaign parameters calculated rules, read this article.
s_campaign
The s_campaign of a session is calculated from raw_hits table. Quanti: extract value of utm_campaign parameter of session's first hit.
s_content
The s_content of a session is calculated from raw_hits table. Quanti: extract value of utm_content parameter of session's first hit.
s_keyword
The s_keyword of a session is calculated from raw_hits table. Quanti: extract value of utm_term parameter of session's first hit.
s_utm_id
The s_keyword of a session is calculated from raw_hits table. Quanti: extract value of utm_id parameter of session's first hit.
s_consent
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.
s_referrer
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.
page_views
The number of page views counted during the session.
events
The number of events counted during the session.
total_conversions
The number of conversions counted during the session.
total_conversion_values
The sum of conversions values counted during the session.
account_id
Unique account identifier given by Quanti: during tag creation. It can't be modified.
s_ad_user_data
Calculated from the raw_hits table. For each session, we keep the last known value.
s_ad_personalization
Calculated from the raw_hits table. For each session, we keep the last known value.
s_ad_storage
Calculated from the raw_hits table. For each session, we keep the last known value.
s_analytics_storage
Calculated from the raw_hits table. For each session, we keep the last known value.
Last updated