Optimizing Vendor Metadata for Enhanced Content Discoverability

Challenges in Implementing Vendor Agreement

The client had a complex agreement with their vendors, which outlined multiple service agreement levels, with a station assigned to each level along with corresponding metadata Benchmarks. The primary challenge faced by the client was in evaluating the metadata provided by the vendors in accordance with the benchmarks defined by the agreement.

Inconsistency in Metadata checks

The client had an initial logic in place to check the presence of content metadata for various programs, but the checks were not customized for different program types. This caused a gap between the anticipated and actual results.

Defining Metadata Coverage and Monitoring Levels

The client faced challenges in measuring metadata completeness at the program level, as the agreement was structured at the metadata level. They were also uncertain about the levels at which to monitor metadata coverage and how to align this with the existing agreement.

Low Adoption of Existing Tableau Dashboards

The existing Tableau reports faced low user adoption due to ineffective content and uninspiring visualizations. The reports primarily covered basic metrics without delivering meaningful, actionable insights. Additionally, the lack of design expertise resulted in cluttered and non- intuitive dashboards, making it challenging for end users to quickly interpret and act on the data.

01.

Optimized Data Structure for Seamless Agreement Implementation

To effectively implement the client’s agreement with their vendor, we transformed the agreement into a structured table on their server. Additionally, we created a separate table with logical checks to validate the presence of media metadata for each program – an approach aligned with principles of master data management (MDM) to ensure standardized and accurate metadata tracking.. Finally, we designed an optimized data structure that streamlined Tableau development while ensuring a simplified and efficient data model.

02.

Enhanced Metadata Checks with Program-Specific Classification

To resolve this issue, we conducted extensive data analysis to understand variations across different program types. Based on these insights, we established a set of rules to accurately classify program types, ensuring there were no logical gaps. This allowed for precise mapping with the agreement table, improving the accuracy and consistency of content metadata checks.

03.

Dynamic Tracking and Classification for Metadata Completeness

To address this, we defined dynamic metrics that allowed users to customize metadata inclusion and track completeness at program level. At the metadata level, we classified values as "preceding the benchmark" if they fell below the threshold in any service agreement level, and "exceeding the benchmark" if they met or surpassed it across all levels. These enhancements made it easier to identify metadata problems in media and entertainment. Moreover, these metrics not only supported better analysis but also strengthened data quality management by clearly defining metadata benchmarks and tracking deviations effectively.

04.

Optimized Tableau Reports for Better Usability and Insights

To improve user adoption, we first gained a deep understanding of the business requirements from the client’s stakeholders' perspective while keeping the end goal in focus—delivering insights that highlight the factors hindering the end-user experience. Additionally, with the help of NeenOpal’s expert designers we were able to deliver visually appealing and user-friendly reports. This ensured that the dashboards were not only insightful but also engaging and easy to navigate, enhancing their overall effectiveness.

Vendor Accountability

Successfully integrated the client-vendor agreement into the reports, enabling the client to monitor whether the vendor was delivering the agreed-upon media metadata services.

Better Content Delivery

The key metrics in the reports made it easy to identify gaps, allowing the client to address content metadata deficiencies both internally & with their vendor, leading to improved content for their end users.

Scalable and Flexible Reporting

The dynamic reports provided the flexibility to adjust metadata benchmarks and tracking metrics as business needs evolved.

Seamless Integration with Tableau

The structured data model ensured smooth integration with Tableau, enhancing visualization and cross-functional analysis.