Retail Data Analytics Platform for Brand and Marketing Professionals

A modern web-based advanced analytics system that facilitates campaign design, Test Store selection and campaign Return-On-Investment analysis.

The Client

A marketing campaigns focused on packaged goods distributed through retail channels in the United States.

Overview

Our client relied on manual workflows and disjoint spreadsheets to manage marketing campaigns on behalf of the brands they represented. The amount of sales data from retail channels was prohibitively large for manual analysis and the process was error-prone.

To modernize and standardized this repetitive process, we created a web-based solution which is easy-to-use for brand users to create, strategize and analyze their campaigns. Users can upload large sales data files into the system to get recommendations for Test and Control stores through Advanced Analytics algorithms. Furthermore, once campaigns conclude, the system conveniently offers a variety of analysis methodologies and reporting options to evaluate the ROI of campaigns.

The Solution

Design

We worked closely with client to ensure top-notch UX/UI design appropriate for the consumer marketing industry.

Architecture

A database-backed web-application in 3 layers: persistent storage, backend service and a user-facing Frontend application.

Persistent Storage: The point-of-sales data, user-management and campaign organization data is stored in a managed-service relational database.

Backend Service: The backend service enables access to application data. It also contains the AI/Analytics module. The backend service provides a REST API for the Frontend app to enable users to view and interact with the system. Additionally, the Backend service provides a functional user-interface for administration of data within the system.

Frontend Application: the in-browser app for Brand Managers to set-up and analyze their campaigns.

Cloud Deployment

The solution has been released and operationalized in a container-based, in-the-Cloud deployment profile. This profile is highly reliable and available. Furthermore, it allows for relatively low-cost of delivery business value.

If you would like to learn more about how our software engineering teams can accelerate your data analytics and software development roadmap, please get in touch with us via email: hello@askintegral.com.