Our typical business users vary quite broadly from technical leads, product managers, and UX designers with no technical background, to data and business analysts within your organisation. This breadth has ensured that we have built dashboards and metrics that are intuitive and aligned to the business of running a video service.
As part of empowering data teams to do better analysis with high-quality data, Clarissa also provides data sets in the form of aggregates for each of the products. Part of increasing the efficiency and utility of the data in the Data Warehouse lies in data aggregation. Each of the products are mapped to specific aggregate tables that are relevant for the applicable features. There are tables relating to Content Insights (Viewing sessions), Operational Insights (QoE, Error Analytics) and App Insights Navigation and User journeys).
Viewing aggregates 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. Clarissa offers a default viewing session of two minutes that can be configured to reflect the metrics prevalent in either the geography or the video service’s reporting methodology. Device Aggregations ensure that the number of devices that are active are captured in a specific, fit-for-purpose, metric. We aggregate this at a daily level to understand change in device reach from the previous day.
Content Aggregations capture the popularity and viewing of individual programmes. Since content viewing (especially on linear) is driven by the schedule we additionally aggregate this at a weekly level to find patterns.
Channel Aggregations capture the popularity and viewing of channels. Since content viewing on linear is driven by the schedule, we additionally aggregate this at a weekly level to find patterns of viewing behaviour.
Journey aggregates is the main table into which all the other dimensions feed into (join) to create the atomic entity of a navigation session. Defining a navigation session is a fundamental metric to understand how viewers find content and the time spent on the product.
Journey Aggregations ensure that the steps and duration spent between two viewing sessions are captured in a specific, fit-for-purpose, metric. We aggregate this at a device level and then classify this according to the well-defined Clarissa journey types. Filtering by device allow to compare journeys across different product UI on devices to capture the impact of UI and screen size on content discovery.
Content Launch Aggregations capture the launch of content from different parts of the user interface, including content rails, which are used to group content into categories (e.g., Cartoons, Recommended, Just Released, Oscar Winners, etc.). This data enables product and UX managers to curate and position content more effectively, reducing navigation journey steps and time.
Search Aggregations capture the search terms that both lead to a view (on VOD or linear) but also and more importantly, the searches that did not lead to a viewing outcome.
This is the upcoming feature. Error aggregates is the main table into which all the other dimensions feed into (join) to create the occurrence of an error.
Error Aggregations Identify and classify multiple types of errors. These error datasets also include a variety of parameters (e.g., device type, software version, ISP, location, CDN, etc.) that allow for filtering and analysis to understand trends and systemic issues.