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...
Jul 23, 2024

Streamlining Time Series Analysis with Imply Polaris

We are excited to share the latest enhancements in Imply Polaris, introducing time series analysis to revolutionize your analytics capabilities across vast amounts of data in real time.

Learn More
Jul 03, 2024

Using Upserts in Imply Polaris

Transform your data management with upserts in Imply Polaris! Ensure data consistency and supercharge efficiency by seamlessly combining insert and update operations into one powerful action. Discover how Polaris’s...

Learn More
Jul 01, 2024

Make Imply Polaris the New Home for your Rockset Data

Rockset is deprecating its services—so where should you go? Try Imply Polaris, the database built for speed, scale, and streaming data.

Learn More

Let us help with your analytics apps

Request a Demo