This is the main table into which all the other dimensions feed into (join) to create the atomic entity of a journey. Defining a viewing session is a fundamental metric to understand UI navigation and usage.
fact_navigation_journeys
Field Name | Description | Field Type |
timestamp_formatted | The date of the navigation journey | Text |
uid | Unique ID of the UI navigation journey |
Text |
user_id | Unique household identification | Text |
device_id | Unique device identification | Text |
device_type | The device type as given by the customer application, for example: STB, Mobile, Tablet, PC, or CTV. | Text |
navigation_start_time | Time at which user starts the navigation journey | Text |
navigation_end_time | Time at which user ends the navigation journey | Text |
duration_seconds | Duration of each navigation journey | Integer |
step_count | The number of steps the user takes to complete the navigation journey | Integer |
start_reason | The reason for starting a new navigation journey. | Text |
end_reason | The reason for ending a new navigation journey. | Text |
lead_to_view | true\false | Text |
next_viewing_source_name | The application feature that leads to playback at the end of the navigation journey. This field will be empty if the navigation journey does not end with playback. | Text |
next_viewing_session_id | The ID of the playback session that was initiated after the navigation session. This field will be empty if the navigation journey did not end with playback. | Text |
next_viewing_session_type | The type of playback session that was initiated after the navigation session. Values are supplied by the application, such as: VOD or Live. This field will be empty if the navigation journey did not end with playback. | Text |
next_viewing_session_duration | The duration in seconds of the playback session that was initiated after the navigation session. This field will be empty if the navigation journey did not end with playback. | Integer |
next_viewing_content | The content of the playback session that was initiated after the navigation session, that is Program or VOD title. This field will be empty if the navigation journey did not end with playback. | Text |
next_viewing_content_source | The content sources of the playback session that was initiated after the navigation journey that is: the Channel name for live content or “VOD” for VOD content. This field will be empty if the navigation journey did not end with playback. | Text |
prev_viewing_session_id | The ID of the playback session that happened prior to the navigation session. This field will be empty if there were no playback sessions. | Text |
prev_viewing_session_type | The type of the playback session that happened prior to the navigation session. This field will be empty if there were no playback sessions. | Text |
prev_viewing_session_duration | The duration of the playback session that happened prior to the navigation session. This field will be empty if there were no playback sessions. | Integer |
journey_type | The type of the journey | Text |
ingest_timestamp | The time at which the transaction record was ingested into the Clarissa Data Warehouse | Timestamp |
rep_hourly_journey_aggregation
Field Name | Description | Field Type |
timestamp_formatted | The date of the aggregated line | Timestamp |
device_type | The device type as given by the customer application, for example: STB, Mobile, Tablet, PC, or CTV. | Text |
hour | The hour of the aggregated line | Integer |
lead_to_view | true\false | Text |
next_viewing_session_type | The type of the playback session that happened prior to the navigation session. This field will be empty if there were no playback sessions. | Text |
next_viewing_content_source | The content sources of the playback session that was initiated after the navigation journey that is: the Channel name for live content or “VOD” for VOD content. This field will be empty if the navigation journey did not end with playback. | Text |
next_viewing_content | The content of the playback session that was initiated after the navigation session, that is Program or VOD title. This field will be empty if the navigation journey did not end with playback. | Text |
journey_type | Can be one of the following types of journey: Decisive, Opportunity, Browsing, Binge, Passive More types can be added in future releases. | Text |
total_seconds | The total number of seconds spent on this journey type and the base parameters. | Integer |
total_steps | The total number of steps occurred during this journey type and the base parameters. | Integer |
devices | The number of unique devices executed this journey type by the above base values. | Integer |
users | The number of unique households executed this journey type by the above base values. | Integer |
total_journeys | The number of journeys categorized by the above base values. | Integer |
rep_hourly_screens_aggregation
Field Name | Description | Field Type |
timestamp_formatted | The date of the aggregated line | Timestamp |
hour | The hour of the aggregated line | Integer |
device_type | The device type as given by the customer application, for example: STB, Mobile, Tablet, PC, or CTV. | Text |
screen | The screen name as provided by application (CCL screenName field). | Text |
hits | The number of times a specific screen or page was accessed or displayed within the app in the context of the above base parameters. | Integer |
duration_seconds | The total duration spent on the screen for the specific device type | Integer |
rep_hourly_swimlane_aggregation
Field Name | Description | Field Type |
timestamp_formatted | The date of the aggregated line | Timestamp |
hour | The hour of the aggregated line | Integer |
device_type | The device type as given by the customer application, for example: STB, Mobile, Tablet, PC, or CTV. | Text |
swimlane | The swimlane name as provided by application (CCL swimlane.id field) | Text |
user_actions | The number of user actions done from the specific swimlane, device type, and hour. | Integer |