More ways to contact us

ETL: The Most Important Acronym You've Never Heard Of

Filed in Technology

This article originally appeared on AdExchanger on Thursday, February 27, 2014 Data is the fuel and the exhaust of programmatic advertising. It informs every transaction, and every transaction generates more of it. As impression volumes rise into the trillions across all manner of devices, the focus of many ad tech engineering teams isn’t on ethereal machine learning algorithms, but something far less glamorous. The process is called ETL — the critical, painstaking work of cleansing and consolidating disparate datasets. As the worlds of marketing and enterprise software collide, ETL could be the most important acronym you’ve never heard of. ETL […]

ETL: The Most Important Acronym You've Never Heard Of
Read Post Comments

How We Scaled HyperLogLog: Three Real-World Optimizations

Filed in Corporate, Druid, Technology

At Metamarkets, we specialize in converting mountains of programmatic ad data into real-time, explorable views. Because these datasets are so large and complex, we’re always looking for ways to maximize the speed and efficiency of how we deliver them to our clients.  In this post, we’re going to continue our discussion of some of the techniques we use to calculate critical metrics such as unique users and device IDs with maximum performance and accuracy. Approximation algorithms are rapidly gaining traction as the preferred way to determine the unique number of elements in high cardinality sets. In the space of cardinality […]

How We Scaled HyperLogLog: Three Real-World Optimizations
Read Post Comments

The Art of Approximating Distributions: Histograms and Quantiles at Scale

Filed in Algorithms, Data Visualization, Druid, Technology

I'd like to acknowledge Xavier Léauté for his extensive contributions (in particular, for suggesting several algorithmic improvements and work on implementation), helpful comments, and fruitful discussions.  Featured image courtesy of CERN. Many businesses care about accurately computing quantiles over their key metrics, which can pose several interesting challenges at scale. For example, many service level agreements hinge on these metrics, such as guaranteeing that 95% of queries return in < 500ms. Internet service providers routinely use burstable billing, a fact that Google famously exploited to transfer terabytes of data across the US for free. Quantile calculations just involve sorting the data, which can be […]

The Art of Approximating Distributions: Histograms and Quantiles at Scale
Read Post Comments

Build It v. Buy It? How to Save Your Ad-Tech Business $2 Million in Six Weeks

Filed in Corporate, Technology

With hundreds of ad-tech companies competing to gain market share and seeking to distinguish themselves, product managers are constantly weighing the costs and benefits of introducing new product features. Often, the challenge isn’t how to build the functionality, but rather how to prioritize items on their roadmaps and deploy their resources. In many cases, a product feature will fall out of scope of the core mission of the enterprise, so managers ultimately need to decide on whether they should outsource a feature or dedicate valuable manpower to build it internally. With limited resources and bandwidth, analytics-based product enhancements always seem […]

Build It v. Buy It? How to Save Your Ad-Tech Business $2 Million in Six Weeks
Read Post Comments

March Release: Time Zone Support and Other Goodies

Filed in Corporate, Technology

Metamarkets is proud to announce the release of two major new features and a slew of small tweaks and bug fixes.

March Release: Time Zone Support and Other Goodies
Read Post Comments