The Web Analytics table tracks user interactions on your website, including page views, session lengths, and actions like adding items to carts or completing purchases. Querying this table helps uncover patterns in visitor behavior, website performance, and the effectiveness of marketing strategies, guiding optimizations for better engagement and conversion rates.

📘
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. Learn more

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 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 website 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`.
Web Browser	`browser`	string	The web browser of the session where the order originated. Example values: `Chrome`, `Firefox`, `Safari`
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`
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`

Measures

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

Title	ID	Type	Description
Add to Carts	`add_to_carts`	numeric	The Pixel-reported number of Add To Carts from unique customers.
Annual Recurring Revenue (ARR)	`arr`	numeric	The Pixel-reported annual recurring revenue (ARR) from new subscriptions during a website session.
Bounces	`bounces`	numeric	The Pixel-reported number of single-page sessions where the visitor left the site after a single page view.
Monthly Recurring Revenue (MRR)	`mrr`	numeric	The Pixel-reported monthly recurring revenue (MRR) from new subscriptions during a website session.
New Subscriptions	`new_subscriptions`	numeric	The Pixel-reported number of new subscriptions during a website session.
New Visitors	`new_users`	numeric	The Pixel-reported number of first-time visitors to the site.
Order Revenue	`order_revenue`	numeric	Pixel-reported conversion value (order revenue), after adjustments such as discounts, shipping, fees, and taxes (but before refunds). Order Revenue = Gross Sales - Discounts + Shipping + Tax
Website Purchases	`orders_quantity`	numeric	The total number of Pixel-reported purchases (orders) during a website session. Excludes recurring subscription purchases.
Session Page Views	`session_page_views`	numeric	The Pixel-reported number of pages viewed during a website session.
Pixel Sessions	`sessions`	numeric	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.
Time on Site	`time_on_site`	numeric	The Pixel-reported time spent by users on the site during a session, measured in seconds.
Unique Visitors	`users`	numeric	The Pixel-reported number of unique visitors to the site.

Derived

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

Title	ID	Type	Description
Add To Cart Percent	`add_to_cart_percent`	formula	The percentage of add-to-carts out of total sessions. Add To Cart Percent = Number of Add To Carts / Number of Sessions
Average Page Views Per Session	`average_page_views_per_session`	formula	The average number of pages viewed by users during each session. Average Page Views Per Session = Session Page Views / Number of Sessions
Average Session Duration	`average_session_duration`	formula	The average time users spend on your site per session. Average Session Duration (in seconds) = Time on Site / (Number of Sessions - Number of Bounces)
Bounce Rate	`bounce_rate`	formula	The percentage of single-page visits (bounces) out of total sessions. Bounce Rate = Number of Bounces / Number of Sessions
Conversion Rate	`conversion_rate`	formula	The percentage of website sessions that result in purchases, as reported by Pixel. Conversion Rate = Number of Website Purchases / Number of Sessions

Web Analytics Table

📘
Note

Dimensions

Measures

Derived

📘Note

Dimensions

Measures

Derived

📘
Note