Model for Personalization of Sales Promotions Based on Beacon Technology

Companies are making great efforts to develop personalized offers for customers. However, many customers consider that it is inappropriate to receive offers that they are not interested in, to receive an excessive number of simultaneous sales promotions, or receive them frequently, or even to receive promotions in an untimely manner. Although online shopping is constantly on the rise, when it comes to retail sales, the number of online purchases is still signifi- cantly lower compared to the number of in-store purchases. In this paper, we present a model of a smart retail environment that tracks customer activity inside the store and sends them personalized promotions while they are still at the store. The smart environment is based on the use of beacon technology and an appropriate relational database. The main benefits of this approach are increasing the company profits by sending personalized promotions to customers at the right time, increasing customer satisfaction, and collecting data on customer behaviour in the store for future analysis. For the purposes of experimental verification of the model, a test database was created, and the paper shows a number of queries executed in it.