Use this query to track a user’s average session duration. The session_duration is the length of session time in milliseconds. This can be useful for comparing session durations between different segments, and can be used in any CQL query.
So for example, if the session took one minute, the session_duration will show 60,000 milliseconds).
SELECT avg(session_duration) as avg_session_duration FROM cooladata WHERE date_range(context) and filters(context)
You can add groupings (for example, 1-5, 6-10, or 11-15), to get more meaningful results. For an example, see the sample syntax in the Loyalty Segments – Session Counter.