UKOUG Scotland 2018 – Targeted Marketing: How Marketing Companies can use Big Data to Target Customers

Disclaimer: The writing and musings of the author do not necessarily reflect the views of his employer.

This presentation will show how an outdoor advertising company used the Oracle Big Data environment to provide real time statistics and high-value insights to their customers. Using data from providers such as Pinsight Media and Perconix data from Axciom, they are able to accurately show the demographics of the consumers in the viewshed of their billboards and other digital assets.

With the need to get useful information out of the terabyte of data they were receiving, our client used Oracle BDCS, specifically, Hive to create external tables connecting to flat files or MongoDB and Impala to analyze the data. The data was then loaded into Oracle DBCS to be accessed by OACS for further analysis and dashboarding.