Using BIME and BigQuery, Zype Channels Next Generation Video Publishing and Distribution

Background

In the current media landscape, streaming video channels and delivery systems proliferate almost as rapidly as content. There’s too much to see and barely enough time to sort through all the videos that are suddenly available, whenever and wherever we want them. And for content providers and distributors, it’s becoming increasingly difficult to get noticed. How do you establish a brand in an exploding and complex video marketplace?

That’s where Zype comes in. As a cloud platform dedicated to video publishing and distribution, Zype makes it easy for anyone to build and generate money from their own branded streaming destinations.

Challenge

Zype had accumulated millions of rows of valuable video performance data, including revenue partners, devices, geography, and even metadata about the videos themselves (such as actors, directors and plots). Disseminating this data in a repeatable, reliable, and scalable fashion for their enterprise customers was already time consuming and expensive.

Then Zype won the SXSW 2015 Accelerator award, and almost overnight, the company experienced a double-digit growth for its unique video publishing cloud platform, with two to three times the amount of accrued data as before. As this data mounted from month to month, so did the needs to analyze and issue reports about it. Zype’s existing system, a collection of reports written directly to a MongoDB database and a third-party log management system, wasn’t able to meet the demand for scalable data collection. And to create reports for stakeholders, developers had to copy databases and run queries manually, which took valuable resources away from core product development.

Zype required a single, scalable database, one with powerful analytical and reporting tools. And they needed it fast.

Solution

Zype evaluated several analytics and reporting options. BIME was the only one able to integrate with all of the various data production points Zype used - BigQuery, Intercom, MongoDB, Google Sheets - and also didn’t require a lengthy onboarding process. In addition, BIME’s per-user pricing allowed Zype to start with a low-risk, low-cost entry point and grow from there.

Working directly with BIME Analytics as well as experienced customer success leaders at Google, Zype put together an integrated Google BigQuery and BIME solution for data collection and reporting. This team was able to quickly build a reliable ETL (Extract, Transform, and Load) process from core MongoDB, Intercom.io, and Google Analytics databases, construct reliable reports in familiar SQL language in BigQuery, and design compelling visualizations for customers.

All ETL processes run on an “as available” or “on schedule” basis, taking data from ad revenue partners, CRM systems, and core analytics databases and importing them into BigQuery. From there, Zype is able to build a series of dashboards in BIME to query this data.

Results

By using Google BigQuery (and planned use of Google Bigtable), Zype now has up-to-date analytics and reports available to key stakeholders both inside and outside of the company. In just a few weeks, Zype was able to solve a key customer pain point – access to detailed video performance metrics without having to divert resources or outsource a complex analytics development project.

“Zype is a great example of how today’s modern companies are leveraging cloud BI not only as an internal gauge of their business, but as a crucial value-add service to their end-customers,” said Jim Lysinger, Vice President, North America at BIME.

Today, Zype distributes a daily dashboard report, “Zype Unleashed,” to the entire company that includes all KPIs. Executives, sales, marketing, customer service, operations, and engineering use this data to make daily decisions and understand the health and growth of the company.zypeunleashed-image

Using the combined BIME and BigQuery solution, Zype also has built several customer-facing dashboards. These dashboards fulfill customers’ key data requirements, such as global video revenue, engagement and performance across web, mobile, and set top devices. Business executives and customers are also able to design and execute reports without having to use precious product development resources.