Fact_viewing_sessions is the main table into which all the other dimensions feed into (join) to create the atomic entity of a viewing session. Defining a viewing session is a fundamental metric to understand viewing consumption. A viewing session captures all viewing at 1x speed with capping implemented based on event interaction and splitting this by % viewed of total event duration. The definition of viewing session is configurable.
The fact_viewing_session is an identifiable data set that can pinpoint to individual households and devices. The default time period of retention for this data set is 1 month although increasing this is possible through optional commercial add-ons.
The following table describes.all the fields of the fact_viewing_table:
Field Name | Field Type |
|---|---|
uid |
Text |
day_id | Integer |
hour_id | Integer |
user_id | Text |
device_id | Text |
device_type | Text |
device_desc | Text |
country | Text |
state | Text |
city | Text |
event_type | Text |
event_start | timestamp |
timeevent_end | timestamp |
event_start_tz | timestamp |
event_end_tz | timestamp |
local_timezone | Text |
duration_seconds | Integer |
content_type | Text |
content | Text |
content_id | Text |
content_details | JSON |
content_desc | Text |
content_desc_ex | Text |
content_source | Text |
content_source_desc | Text |
ingest_timestamp | timestamp |
