Case Study Real-time Reporting System Based on MongoDB for Retailers to Measure Sales Challenges ShopperTrak is the world’s largest provider of retail and mall footfall counting services. But the systems that it provides were unable to report traffic and sales information in real-time. In fact, there was also no other company which had a hosted system that was capable of providing real-time data analysis in this segment. ShopperTrak saw an opportunity here and wanted to capture market share by being the first in place with a system that would give retailers access to real-time data. If its customers – retail managers and store owners had access to data that was constantly updating with figures for shopper traffic, sales, conversion rates and average transaction size then that would lead to a better allocation of resources and help them make better business decisions.
Background ShopperTrak is a provider of shopper insights and analytics. Retailers depend upon the company for the most comprehensive and integrated solutions for accurate retail store traffic counting, interior analytics and industry benchmarking to better understand in-store shopper behavior. The company has installed 60,000 units for over 750 global brands across 90 countries. This has made the company a leading provider of information on the movement of shoppers in retail environments. It is an important partner for retail chains and mall owners in understanding traffic patterns.
REAL-TIME REPORTING SYSTEM FREQUENT INFORMATION UPDATES
CONVERSION RATES Solutions Softweb Solutions helped ShopperTrak develop Real-Time Reporting, the first hosted tool in the retail industry that measures traffic and sales information in real-time across a network of stores. The shopper data can be refreshed every 15 minutes which helps retailers to quickly access their store performance and take action to adjust sales strategies and allocate resources as required. The database used was MongoDB which was chosen for its flexible structure when it comes to handling Big Data, making it a cost-effective method for ShopperTrak to handle its data needs. O
AVERAGE TRANSACTION SIZE
The application has been developed in responsive design, making it ideal for viewing on any device.
O
The system displays data for the following categories: shopper traffic, sales, conversion rates and average transaction size (ATS).
O
Users have the ability to customize the graphs and tables to highlight the metrics they are interested in and also set fixed targets for each day.
SHOPPER TRAFFIC & SALES
Case Study Business Benefits Customers can access their entire network of stores and see all the main information in an easy to read format. This helps them to optimize their staff allocation, offer promotions or shift products as per demand. The system allows retailers to benchmark their performance goals by shopper traffic, sales, conversion rates and average transaction size (ATS). Real-time reporting means that retail store managers can get updates on what’s working or not working very quickly and change their course of action.
Summary ShopperTrak wanted to give its customers a hosted real-time reporting tool for their retail businesses. The idea was to provide an easy to understand reporting system using which retail managers would be able to get updates on sales and traffic conversion without having to wait till the end of the day. Softweb Solutions helped ShopperTrak create the Real-Time Reporting system which is increasingly being deployed by retailers throughout the world.
Contact Information Technologies Used O O O O O O O O O
Database: Oracle & MongoDB (Dev) Architecture: MVC Language: Java Middleware: Java Third-party tool: Highcharts, jQuery Web Technology/ Framework: Spring, Hibernate Tools: SpringSource Tool Suite Operating System: Windows / Linux / Mac Languages support: Multilingual
Softweb Solutions 2531 Technology Drive, Suite 312, Elgin, Illinois 60124 US Toll Free Number: 1-866-345-7638 Email: info@softwebsolutions.com
www.softwebsolutions.com