WTF are data lakes?

This article is a WTF explainer, in which we break down media and marketing’s most confusing terms. More from the series →

Bewildering jargon is as much a part of big data as endless reams of spreadsheets. A new term businesses have to wrap their heads around is data lakes.

Data lakes are for businesses looking for an efficient way to store massive amounts of information. But there are costs to building these platforms, and it can become difficult for analysts to find what they are looking for in these big pools of information. Here’s a cheat sheet:

So WTF are data lakes?
Data lakes are repositories where large chunks of multiple types of data are stored in their native format.

Why do they matter?
Most other data platforms will only store data once it has been formatted to fit a particular structure. For example, data warehouses will only accept data once it has been structured into rows and columns, so unstructured data such as phone call transcripts typically can’t be uploaded.

But data lakes ingest data in its raw form, regardless of how the data is structured, which means that a data lake can take in unstructured data like call transcripts, said Trevor Paulsen, a product manager at Adobe. By taking in all formats, data lakes have more data at their disposal.

This allows data-lake users to “keep all of your data, save it and then figure out what to use,” said Michael Hiskey, CMO of data-management firm Semarchy.

Who uses these data lakes?
Theoretically, anyone who wants to mesh together various types of data, like media and marketing companies but also universities, hospitals and businesses in general.

OK. So what’s an example of how they are used?
Imagine you are a CPG company trying to analyze data from many different sources. To determine if certain ads drove more sales at brick-and-mortar stores, you could combine various data formats like the user ID and browsing data from ad servers with your shipment data.

“If an analyst says, ‘I want to create a data set out of these things,’ I can more easily do that because the data lake can hold all of it,” said Max Knight, vp of marketing science services at demand-side platform Turn. “Before, that information existed in disparate systems. The data lake gives you a more universal access.”

Isn’t that what a data-management platform is for?
Sort of. But DMPs are structured around user and media-related data such as cookie IDs and audience segments. Data lakes are more encompassing and can include offline data related to topics like logistics and production, Knight said.

What makes this different from having a huge Dropbox folder?
From a pure storage standpoint, not a whole lot. But unlike consumer-facing file-hosting services, data lakes offer a lot of analytics tools like SQL, R, BigML and Python so that analysts can quickly run through millions of data points, Paulsen said.

Sounds good. Are there any drawbacks?
Cost. If you are storing 100 terabytes with a cloud service like Microsoft Azure, it will cost about $3,000 per month. Data lakes can also be built using free, open-source software like Apache Hadoop, but you still have to pay web developers to build out the data lake.

Another drawback is data overload. Big data doesn’t do any good if the people gathering the data don’t have an idea of what to do with it. And with so much data in one location, it can become difficult for analysts to quickly find the exact data set they need.

“If everything is stored, it’s easy for the true insights that can solve problems to get lost, or even worse, never discovered,” said Michael Collins, an independent ad tech consultant.

More in Marketing

‘Everything is AI now’: Amid AI reality check, agencies navigate data security, stability and fairness

AI tools and platforms, whether they’re built on generative AI or glorified machine learning, have flooded the marketplace. In response, agencies are wading through them via sandboxes, internal AI task forces and client contracts.

The header image shows a silhouette of a mans head.

Confessions of a DTC investor on the difficulty of dealing with the ‘increasingly common’ founder-influencer

In the latest edition of our Confessions series, in which we trade anonymity for candor, we hear from a DTC investor on what it’s like to work with founder-influencers and why it’s a difficult balance to navigate. 

Ad execs sound the alarm over Google’s risky Privacy Sandbox terms

Google’s Privacy Sandbox outage sparks contractual concerns since its terms of service leave users footing the bill even when it doesn’t work.