Why We Built a Marketing Data Lake

Why We Built a Marketing Data Lake

Posted on April 20, 2017 0 Comments
Marketing Data Lake
Find out how a data geek turned marketer built a data lake across many different systems, along with the good and not-so-good results.

As a geek turned marketer, my goal is to provide high-value technical content to my fellow data geeks. To better understand them, we started with our corporate data warehouse (EDW) and data management platform (DMP), but it was missing a lot of detailed data.

In addition to that, insights are fragmented across many different systems. Just thinking about a schema and the right questions to ask made my head spin.

So we decided to build a data lake for more flexibility in asking any questions with an ad hoc schema or read approach, against any customer data sets to better understand what our audience wants to consume. We also wanted a foundation for new and advanced analytics techniques against data sets we have yet to derive value from.


Check out this article to find out how I did it, along with all the good and not-so-good results, including some of the things we’re now able to analyze, such as best target audience, lead routing effectiveness and popular data connectivity scenarios.

Invited to Present On Stage at Oracle Modern Customer Experience

If you’re going to Oracle’s Modern Customer Experience event on April 26 in Las Vegas, don’t miss my presentation on this same topic: Journey to Marketing Data Lake.

I’ll be discussing how we leveraged standard SQL (JDBC) and REST (OData) interfaces for simple, secure access to cloud marketing data for the data lake, such as Salesforce, Oracle Service Cloud, Eloqua, Marketo and Google Analytics.


Sumit Sakar

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.


Comments are disabled in preview mode.

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

Loading animation