Pages Table

The Pages Table records details about the pages viewed by individuals during their session. See table structure below.

Table Structure

Column	Description
session_id	The ID associated with a session. The session ends when there has been no activity for 30 minutes
external_id	The ID associated with the tag fire
ref_url	Reference URL of the tag fire; page of tag fire
referer_url	URL visited before the tag fire (when available)
est_time_on_page	The estimated time spent on a page in seconds. This is estimated because we don’t know how long someone was on the last page for
event_date	Timestamp (YYYY-MM-DD HH:MM:SS.sss) of the tag fire
un_processed_timestamp	Unix timestamp of when the record was processed
un_updated_timestamp	Unix timestamp of when the record was last updated