Amplitude: Sessions

Description

• Each record represents a distinct session with aggregated metrics for that session.

Supported Data Sources

• Amplitude

Columns

Type	Name	Description
STRING	unique_session_id	Unique key of each session, concatenating user_id and session_id
STRING	user_id	A readable ID specified by you. Amplitude uses a combination of three different methods to identify your users: device IDs, Amplitude ID, and user IDs. The first comes directly from your users' devices, while the second is an ID that Amplitude automatically creates once it has enough information to conclusively identify a unique user. The user ID, however, is something you'd set up. In Amplitude, a user ID is a unique identifier applied to individual users. Using them is optional, but recommended: your product should set a user ID once a user has created an account, logged in, or is otherwise identified in your product. Amplitude can use a user ID to reconcile events across multiple devices under the same user ID. Additionally, a user's event data will be merged on the backend so that all anonymous events prior to the assignment of a user ID will be connected to the correct user. For this reason, you can wait to assign user IDs if that makes sense for your product. Conversely, this is also why you should not set user IDs for anonymous users. Once set, user IDs in Amplitude cannot be changed.Once set, user IDs in Amplitude cannot be changed.
INTEGER	events_per_session	The count of events in a session
DATETIME	session_started_at	The time of the first event in a session
DATETIME	session_ended_at	The time of the last event in a session
DECIMAL	session_length_in_minutes
DATETIME	session_started_at_day	The day the session started
DATETIME	session_ended_at_day	The day the session ended
INTEGER	user_session_number	The number of the session, within a user's lifetime
DATETIME	last_session_ended_at	The time the prior session ended at
DATETIME	last_session_ended_at_day	The day the prior session ended
INTEGER	is_first_user_session	Boolean of whether or not a session is the user's first session
DECIMAL	minutes_in_between_sessions	The minutes in between sessions of a user