Session Duration
Session Duration: Average time spent per session.
Formula
Session Duration = Total session time / Total sessions Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
avg(field.session_duration) Unit: minutes
Notes: Equivalent to total session time divided by total sessions. Unit of the session_duration field assumed minutes.
Data requirements
Grain: Per event, aggregate monthly · Frequency: Daily · Aggregation: aggregate (month) · Staged: no · Main source: Product Analytics.
| Field | Dataset | Type |
|---|---|---|
event_date | product_event | date |
session_duration | product_event | integer |
Example SQL (Postgres)
SELECT (SELECT AVG(session_duration) FROM product_event WHERE event_date >= :period_start AND event_date <= :period_end) AS session_duration From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Session Duration" }) or generate_query({ "metric": "Session Duration", "adapter": "<your adapter JSON>" }).
Benchmarks
Highly product-dependent. Track trend over time.
What It Tells You
Depth of engagement per visit.