Sensor (IoT) based Customer Intelligence and
Marketing Automation Solution for a
US-Based Marketing Automation Client



This company wanted to use data collected via wi-fi sensors and beacons on customer traffic and dwell times at retail locations to drive and deliver automated intelligent marketing campaigns. These campaigns are designed to help retain ‘at risk’ customers, increase their visit frequency and loyalty and allow measurement of ROI on their investments. Millions of interactions are captured per day across the company’s client base, therefore requiring a highly resilient and scalable solution to be in place to deliver a robust campaign management platform. The platform had to integrate with third party tools and social media platforms to offer a seamless delivery experience across multiple channels.

The Solution:

An end to end Campaign Management Platform that utilized Uniconnect for Data Management, campaign scheduling, trigger management and generation of specific triggers.

Uniconnect enabled the company to read the customer traffic data in JSON format natively and allowed in memory joins with a mysql database holding customer demographics Leveraging other open source tools such as Quartz which were integrated with Uniconnect, we built the back end of the campaign management platform to deliver near real time triggers that helped the customers (Retailers, Restaurants etc) of our customer engage with their customers and deliver relevant and timely offers.

The solution was conceived and delivered within 6 weeks demonstrating the power of Uniconnect to harness and process data from disparate sources in days and weeks, not months and years. The Retailers using the platform can now identify and proactively engage with customers when they are entering or exiting the outlet as well as identify if the visit happens to be one corresponding to a significant milestone such as 5th in a week, 25th visit, visit on a birthday etc.

As part of the solution, some reports and online processes needed unified access to data from Cassandra and MySQL. Given that Cassandra does not support standard SQL ( it only supports CQL – Cassandra Query Language), a typical brute force and legacy solution would have been to write ETLs to unify data. Instead, UniConnect was used to seamlessly unify both datasources through in memory processing with standard SQL. All the campaign and trigger definitions translate to highly parameterized SQL statements that execute via Uniconnect on mutiple data sources, getting data efficiently in memory from these sources and doing the required processing to identify various trigger conditions and associated actions.

In summary, a typical solution for the above problem would have involved extracting information from multiple sources into a standalone database of the campaign management platform leading to data duplication with associated costs and risks as well as latency in generation of triggers. Using Uniconnect, allowed all of these campaigns to be done on top of and leveraging the underlying raw data without causing an overload on the platform, a very good use case of the paradigm shift from ETL to ELT.

We are now extending the capability to include an ability to identify dwell times and movement within a store based on a store’s location map and enable retailers to identify marketing opportunities associated with such location based data within the store and take action instantly on the same.

Percipient Partners Pte. Ltd. #09-04, LATTICE80, 80 Robinson Road, Singapore 068898

© 2017, Percipient Partners Pte. Ltd., All Rights Reserved. Reproduction Prohibited.