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.

---

Tables and definition 🔗

Source : https://dbdiagram.io/e/67bf2e04263d6cf9a08d27a6/67c08ae8263d6cf9a0b33078

---

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).

Explanation of the Different Types of Identifiers

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.