Search DAS42.com

Get Started
Background

A leading international media and entertainment company launched an over-the-top (OTT) subscription video-on-demand (SVOD) streaming service in the United States, then expanded into international markets across 2021 and 2022.

By the end of Q1 2022, the service had built a large global subscriber base across a wide range of content brands.

THE CHALLENGE

Fragmented data and reporting.


The new service generated a high volume of data across content, subscribers, acquisition, viewership, and retention. Leadership had no reliable way to turn that data into decisions.

Without proper tools, workflows, and processes, business users were working around data quality issues, delays from manual processes, and inconsistent definitions across data sources.

The Solution

Reporting leadership could see in one place.


DDAS42 architected, built, and optimized the platform, workflows, and visualizations behind automated leadership BI reporting, using Snowflake, Airflow, Looker, and dbt.

Reports covered:

  • Subscribers: retail and wholesale activations, paid subscribers by channel, churn, revenue
  • Activations: paid subscribers, retail provider composition, activations by SKU
  • Product: tracking for major launch titles and their performance
  • Acquisition and marketing (“customer journey”): web visits, conversion, total media spend, subscriber acquisition cost (SAC), cost per web visit
  • Viewership: daily and weekly active users, total viewers, hours and minutes viewed, views by device, top 20 series, movies, episodes, and specials by viewers
  • Retention and cancel: monthly retention rate by tenure, one-month retention drivers, paid cancels by provider, tenure, and subscriber type

DAS42 also provided strategic direction on how the organization used data and analytics, closing a gap between business and technical stakeholders that had been slowing decisions down.

THE RESULT

Faster data-driven decisions


With self-serve access to governed, enriched datasets on a single cloud platform, leadership got direct visibility into subscriber counts, channel mix, acquisition cost, and churn drivers, presented in a format built for quick, confident decisions at both the individual and organizational level.

What leadership could now answer directly:

  • Total paid subscribers, and, combined with growth and churn projections, what the revenue forecast looked like
  • How subscribers were accessing the service across retail and wholesale channels
  • What was driving churn, and how promotional activity affected retention
  • Which content and editorial choices to make based on what subscribers watched and what kept them subscribed
  • Where to put marketing spend, based on subscriber behavior, demographics, and region
  • Content that was driving up usage enough to impact bandwidth and therefore customer experience
  • How rollouts of the streaming service or new versions thereof were performing in new regions

With reporting this accessible, leadership had what it needed to analyze the business, move faster on fixes, and set strategy in near real time, instead of waiting on a manual pull each time a question came up.