The Sessions table tracks individual visits to your website, including traffic source, device, timing, and geography. One row per session.

📋
Table Guide
What You Can Answer With This Table

How many sessions did we get by traffic source or landing page? — group by channel, utm_source, or landing_page

How many visitors are new vs returning? — group by is_new_visitor

Which traffic sources drive the longest sessions? — group by channel with session_elapsed_time, session_page_views

Before You Query

Required field: event_date

A session in Triple Whale is a visit 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. Counts may differ from your sales platform due to differing session definitions. Learn more

Key Relationships

Table Join Key Use This Join To
Pixel Orders session_id Identify which sessions led to attributed purchases
Customer Journey session_id Connect session summaries to the detailed on-site steps within each session

When to Use a Different Table

Need aggregated web metrics (conversion rate, bounce rate by landing page) without individual sessions → Web Analytics table.

Need GA4 session data → GA4 Sessions Agg table.

View the full Triple Whale Data Ontology →

Table	Join Key	Use This Join To
Pixel Orders	`session_id`	Identify which sessions led to attributed purchases
Customer Journey	`session_id`	Connect session summaries to the detailed on-site steps within each session

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 website session started, according to a 24-hour clock. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected). Example values: `07`, `16`, `21`
Event Date	`event_date`	date	The date the website session started. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
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. See list of countries. Example values: `United States`, `Canada`, `United Kingdom`
Country Code	`country_code`	string	The country code of the session. See list of countries. Example values: `US`, `CA`, `GB`
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`
Keyword ID	`keyword_id`	string	The unique ID assigned to the keyword by the ad platform, captured by Triple Pixel from the ad URL. Example value: `313990984637674`
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`
Marketplace Country	`ms_country`	string	The marketplace country code of the marketplace environment for the session, based on shop settings. See list of countries. Example values: `US`, `CA`, `GB`
Marketplace Country Name	`ms_country_name`	string	The marketplace country name of the marketplace environment for the session, based on shop settings. See list of countries. Example values: `United States`, `Canada`, `United Kingdom`
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`
Shop ID	`shop_id`	string	The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: `example-US.myshopify.com`, `example-EU.myshopify.com`
Shop Name	`shop_name`	string	The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: `example-US`, `example-EU`
Triple Pixel ID	`triple_id`	string	The unique ID assigned by Triple Pixel to track visitors across sessions. Example value: `cltlok4y634IRw62AZ`
URL Query Parameters	`url_query_params`	string	The query parameters contained in the URL of the first page viewed in a session (the page the visitor initially landed after clicking on an ad or link). Example values: `{"tw_adid":"83906898178855", "tw_campaign":"103306890", "tw_source":"bing"," utm_campaign":"Bing Shopping", "utm_content":"HERO SKU Summer Book Run", "utm_medium":"cpc", "utm_source":"bing", "utm_term":"1342506080190763", "variant":"44042133111001"}`
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 UTM source parameter captured by Triple Pixel from the ad URL. Example values: `web`, `pos`, `tiktok`, `facebook`, `google`, `newsletter`

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

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.

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.