Sessions Table

The Sessions table tracks unique visits to your website, capturing key information like the session's start time, visitor device details, and the source of traffic. Querying this table reveals patterns in site engagement, such as peak visit times, popular devices, and effective marketing channels, enabling targeted improvements and strategic planning.

📘

Note

event_date is a required field for queries on this table.

A session in Triple Whale is defined as a visit on your website from a Direct, Referral, or UTM source. Sessions are unique per visitor and per tab. A new session starts after 30 minutes of inactivity, or when navigating to a URL with different UTM parameters.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Event Hour	event_hour	string	The hour of the day the session started, according to a 24-hour clock. Based on the time zone of the shop at the start time of the session. Example values: 07, 16, 21
Event Date	event_date	date	The date the session started.Based on the time zone of the shop at the start time of the session.
Event Day	event_date.day	date	The day on which the event occurred. Derived from event_date.
Event Week	event_date.week	date	The Sunday of the week during which the event occurred. Derived from event_date.
Event Month	event_date.month	date	The month during which the event occurred. Derived from event_date.
Event Quarter	event_date.quarter	date	The first month of the quarter during which the event occurred. Derived from event_date.
Event Year	event_date.year	date	The year during which the event occurred. Derived from event_date.
Ad ID	ad_id	string	The unique ID for the ad associated with the session. Assigned by the ad platform, captured by Triple Pixel in the UTM query parameters. Example value: 120210439891110007
Ad Set ID	adset_id	string	The unique ID for the ad set associated with the session. Assigned by the ad platform, captured by Triple Pixel in the UTM query parameters. Example value: 120210439890740003
Web Browser	browser	string	The web browser of the session where the order originated. Example values: Chrome, Firefox, Safari
Campaign ID	campaign_id	string	The unique ID for the marketing campaign associated with the session. Assigned by the ad platform, captured by Triple Pixel in the UTM query parameters. Example values: 23852438666180053, 531011533, 20620285829
Channel	channel	string	The platform through which the ad was delivered. Derived from UTM parameters and standardized (e.g. a UTM value of fb is standardized to facebook-ads in Triple Whale). Example values: facebook-ads, tiktok-ads, Direct
Session City	city	string	The city of the session where the order originated. Example values: San Francisco, Tel Aviv, Kyiv
Session Country	country	string	The country of the session where the order originated. Example values: United Kingdom, New Zealand, United Arab Emirates
Device	device	string	The type of device used by the visitor for the session. Example values: mobile, desktop, tablet, wearable
Device Model	device_model	string	The device model used by the visitor for the session. Example values: SM-A022M, CPH2305, Note 12
Domain	domain	string	The domain through which the session was initiated. Example value: exampleshop.com
Event Date Timezone	event_date_timezone	string	The time zone in which the event_date and event_hour are based. Equivalent to the designated timezone of the shop according to the timezone database .
Is New Visitor	is_new_visitor	boolean	True if the session was initiated by a first-time visitor. Possible Values: true, false
Landing Page	landing_page	string	The URL path (without query parameters) of the page the visitor landed after clicking on an ad or link, indicating the first page viewed in a session. Example value: /myshop/collections/green_sweater
Session ID	session_id	string	The unique session ID assigned by Triple Pixel. Example value: cltlok4y634IRw62AZ_1710700966152
Session Start Timestamp	session_start_ts	timestamp	The time at which the visitor initiated the session. Formatted according to the ISO 8601 international standard. Example value: 2022-06-15T19:26:30.000Z
Triple Pixel ID	triple_id	string	The unique ID assigned by Triple Pixel to track visitors across sessions. Example value: cltlok4y634IRw62AZ
UTM Medium	utm_medium	string	The UTM medium parameter captured by Triple Pixel from the ad URL Example values: sponsored, paid, profile_link
UTM Source	utm_source	string	The source of traffic to the site, captured by Triple Pixel in the UTM query parameters. Example values: web, pos, tiktok

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Session Duration	session_elapsed_time	numeric	The total duration of time elapsed during the session, measured in seconds.
Session Page Views	session_page_views	numeric	Number of pages viewed during a website session.

Derived

Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.

Title	ID	Type	Description
Pixel Sessions	session_count	formula	The Pixel-reported number of online store sessions. Note that Triple Whale defines and tracks sessions differently from the main sales platform so there may be variance between the two. Learn how Triple Whale defines and tracks sessions.