Insights

Take a deeper dive into our thoughts about data analytics, technology, strategy, and developments.

DAS42 Image
Insights

The Snowflake Media Data Cloud in Action

2/24/2022
DAS42 Image
Ben Reid

There’s been a lot of excitement about Snowflake‘s new Media Data Cloud and its potential to transform the way companies in the media and entertainment industry store and use data. But how does it work in practice? 

Using subscriber analytics as an example, we can see how Snowflake’s Media Data Cloud enables intelligent, data driven decision making. Leveraging the Media Data Cloud, an organization focused on improving customer lifetime value, or the total revenue associated with a customer from acquisition to churn, is able to:

  • Understand and quantify all subscribers and their value to the organization
  • Improve the effectiveness of marketing and acquisition efforts
  • Make optimal marketing decisions driven by intelligent machine learning models

The key to effective decision making is removing data silos and seamlessly integrating external data sources via the Snowflake Media Data Cloud. The organization continuously streams first-party data, PII, subscription revenue, and marketing assets into a privacy-compliant secure raw zone hosted in Snowflake. Then the data is automatically and continuously validated and transformed using streams and tasks in the harmonized layer.

Analyzing first party data isn’t enough, though. The organization needs to seamlessly integrate additional external sources (such as identity, demographic, or psychographic data) to improve marketing effectiveness. This is done in the harmonized layer using the Snowflake Media Data Cloud and data sharing. Finally, they can get a unified view of first- and third-party data in the analytics layer, providing the entire organization with a single version of truth that is always up to date. 

Data Model and Media Data Cloud

The Media Data Cloud facilitates highly effective data models that integrate external data for identity resolution, enrichment, and analysis. 

Starting with first-party data sets, we can build a logical, well organized model that integrates several domains – subscription, marketing, and viewership data, for example.

But in order to layer in additional data assets from the Media Data Cloud, we take a step to resolve identities natively in Snowflake. For example, Experian has built and deployed a Snowflake-native ID Resolution Solution that operates directly inside a cleanroom environment. The data is stored and analyzed in a controlled environment for a predetermined amount of time, after which the data expires, which ensures improved data security and privacy. Experian is already an industry leader in Identity Resolution, and now with the Media Data Cloud we can capitalize on their high match rates directly using Snowflake.

With an expanded identity graph and common identifier in the Snowflake Media Data Cloud, we can easily access enriched audience and segment data instantly through simple joins from other providers to the relational data model.

Using the Media Data Cloud for Customer Lifetime Value

A leading streaming video company is focused on improving Customer Lifetime Value. By leveraging the Snowflake Media Data Cloud, DAS42 is able to pre-build dashboards that help decision makers understand, in near-real time, CLV performance across all subscribers, and then break it out by various campaigns and cohorts to see which ones have outperformed or underperformed against the average. Download the dashboard below.

Data Engineering

One of the most powerful and underestimated aspects of Snowflake is the fact that everything is represented in ANSI-SQL and is relational. We can click into our first-party database, view table structures, and even take a sampling of our first-party data. For data engineers, implementing streaming ingest, continuous data pipelines, and data governance using native Snowflake features like Snowpipe, Streams, Tasks, and secure views is simple, lightweight, and requires zero ongoing maintenance.

Data Marketplace

With the tools to ingest, transform, and conform first-party data, we can take a look at integrating third-party data. Accessing data sets via the Snowflake Media Data Cloud can be configured with a few clicks and does not require any infrastructure or code. 

Media Data Cloud partners publish a considerable amount of live, ready-to-query data on Snowflake’s Data Marketplace. This data is delivered instantly to customers through Snowflake secure Data Sharing, meaning that it is all live without the need for physical data movement or SFTPs. This is what creates Snowflake’s unique Media Data Cloud workflow.

Telling the Story Through Tableau

But data isn’t valuable unless it tells a story. Leveraging Tableau makes the enriched data set more easily explorable and understandable. Using pre-built dashboards, we can start to understand, in near-real time, how customer lifetime value is performing across all subscribers and then break it out by various campaigns and cohorts to see which ones have outperformed or underperformed against the average. We can also start to overlay third-party demographic data to gain deeper insight with virtually no effort.

ML Model

Snowflake can provide holistic subscriber insights with unlimited data and instant access to the Media Data Cloud. But Snowflake really starts to drive unparalleled ROI by bringing machine learning models directly to the data as opposed to the old approach of shipping data out to an ML environment and waiting for results.

As an example, let’s take a look at a marketing leader responsible for maximizing customer lifetime value and delivering marketing ROI. Our data scientists and data engineers have leveraged historical content, release, campaign, and acquisition data to train a model that intelligently predicts the expected CLV for any new release broken out by segment. This model has been packaged up and deployed for production use in Snowflake as a User-Defined Function. This function can be used by anyone in Snowflake using basic, standard SQL. In the case of this marketing leader, he or she can leverage the model to understand the expected CLV for all targeted audience segments and use that to optimize spend. In executing related queries, Snowflake runs Python, Scala, or Java code directly in the platform with cloud scale, quickly generating the predicted CLV. The marketing team can immediately make informed decisions about where their spend might drive better results.

Subscriber analytics is just one of many use cases where the Snowflake Media Data Cloud enables organizations to have a more holistic and accurate view of their customers, optimize spend and increase revenue. Snowflake’s unique ability to analyze all your data, seamlessly integrate third party identity and audience data, and leverage machine learning models directly in the platform are empowering media and advertising organizations to achieve results that were not possible before.

See how the Media Data Cloud can add value in subscriber analytics - watch Snowflake’s demo video below.

Sign up for our newsletter

DAS42 Image

Ready to talk about your data?

Contact us to start building a data culture.

Ready to talk about your data needs?

Contact us to start building a data culture.