25Q3 Release Notes

OpenTV Analytics 25Q3 STD1.1 - Release Notes

What's New

1. Tableau Dashboard updates:

   1. Account Statistics enhancements:

      1. Account Overview: implemented calculation to group NULL account IDs as “Not Selected”.

      2. Account Overview: tooltip issue fixed in “Top 10 Accounts by Content Views”.

      3. Account QOE: tooltip issue fixed in “Average Bitrate” QOE metrics.

   2. Entitlement and Rights Status:

      1. Fixed the Status column to always display the latest entitlement status.

   3. Recording Popularity

      1. Previously, the dashboard counted eventcaptureid to calculate recordings per event.
         Fix: Now counts distinct account IDs to accurately reflect the number of recordings per event.

   4. Billing Report

      1. Replaced old Billing Report with an enhanced Billing Report dashboard showing the number of active accounts per month/week.

2. DWH enhancements:

   1. Added new column accountprofileid to the account_summary model.

   2. Introduced new model Contentgroupparentalrating containing parental rating details for content groups.

   3. Created a unified view combining UAV and OTVAA SDK data for operators with OTVAA SDK integration.

   4. Added new columns for pack feature in the following models:

      1. product – packSaleOnly, clientPurchasable, ClientPurchaseInfo, sortOrder, isPartOfPack

      2. entitlement – partOfPack, parentEntitlement

      3. productpacks (new table) – productid, childproductid, providerid, providerResourceId, operatorid, modifieddatetime, isdeleted, ingestion_datetime

      4. productlocalizedattributes – text

Known Issues

1. Audience Measurement Dashboard – displays Consumption Hours data from either UAV or OTVAA SDK. To view data from the corresponding source, use the following SQL query:

   SQL

   SELECT sum(played_duration_in_secs)/3600 as consumption_in_hours FROM "<schema_name>"."content_consumption" where source = 'insight' and date_day = '<YYYY-MM-DD>' 

2. Account Statistics – “Account Player Error” may display error details twice for the same event – once from the Insight pipeline and once from the OPF data pipeline.