Sessions Table

The Sessions Table captures data on each visitor's session, including session duration. A session concludes when there has been no activity by the user for 30 minutes. See table structure below.

*For users who want to parse results by match type—similar to how they’re displayed in the front-end application—use the File Type column values as your delimiters.

Table Structure

Column	Description
hem	Hashed email (SHA256) associated with a tag fire
tag_id	The ID associated with the tag
*file_type	File type associated with the tag fire (B2B, B2C, PTE)
session_id	The ID associated with a session. The session ends when there has been no activity for 30 minutes
session_start	Timestamp (YYYY-MM-DD HH:MM:SS.sss) of when the session started
session_end	Timestamp (YYYY-MM-DD HH:MM:SS.sss) of when the session ended
est_session_duration	The estimated session duration in seconds. This is estimated because we don’t know how long someone was on the last page for
entry_url	The first URL someone visited in a session
exit_url	The last URL someone visited in a session
total_pages_visited	The total number of pages someone visited in a session
unique_pages_visited	The unique number of pages someone visited in a session
un_processed_timestamp	Unix timestamp of when the record was processed
un_updated_timestamp	Unix timestamp of when the record was last updated