Interactive Analytics at MoPub (Twitter): Using Druid and Imply to Query Terabytes of Data in Seconds

Jul 05, 2019
Rick Bilodeau

MoPub, a Twitter company, provides monetization solutions for mobile app publishers and developers around the globe. They operate at a massive scale. The MoPub platform addresses over 1.7 billion monthly unique devices, 1 trillion monthly ad requests, 52,000 apps, and 180 demand side partners.

MoPub has just launched a new solution called MoPub Analytics based on the Apache Druid real-time analytics database and using Imply Pivot as the drag-and-drop UI. The solution allows MoPub customers to answer business questions, troubleshoot issues and optimize revenue. Users can determine the root cause of new data trends by interactively analyzing the data across many different time slices, dimensions, and metrics.

Every day, MoPub runs over 30 billion ad requests, which generate over 150 terabytes of raw logs. Even after aggregation they ingest over 9 billion rows into the analytics engine each day. Queries on MoPub Analytics return in seconds.

You can find the MoPub Analytics post on the Twitter Engineering blog.

A great way to get hands-on with Druid is through a Free Imply Download or Imply Cloud Trial.

MoPub Analytics Architecture

architecture-diagram-mopub-analytics-twitter

Other blogs you might find interesting

No records found...
Nov 14, 2024

Recap: Druid Summit 2024 – A Vibrant Community Shaping the Future of Data Analytics

In today’s fast-paced world, organizations rely on real-time analytics to make critical decisions. With millions of events streaming in per second, having an intuitive, high-speed data exploration tool to...

Learn More
Oct 29, 2024

Pivot by Imply: A High-Speed Data Exploration UI for Druid

In today’s fast-paced world, organizations rely on real-time analytics to make critical decisions. With millions of events streaming in per second, having an intuitive, high-speed data exploration tool to...

Learn More
Oct 22, 2024

Introducing Apache Druid® 31.0

We are excited to announce the release of Apache Druid 31.0. This release contains over 525 commits from 45 contributors.

Learn More

Let us help with your analytics apps

Request a Demo