|
|
Artificial Intelligence for Sales Prediction
marketing icon

Artificial Intelligence for Sales Prediction

Can retail sales managers predict how much sales they're going to make in-store? Online? Accurate sales forecast is a significant challenge for retailers. It gives the means to the retailer to plan its staffing for the sales team and its product inventory based on historical sales data. Hence it aims to improve its revenue.

Industry

Marketing

Project Duration and Effort

One week

Type of Prediction

Regression

Customer Benefits

  • A global score of 85% in delivering accurate forecasts for sales
  • No need to be a data scientist. Sales reps can generate a forecast based on their store’s data.
  • Ability to understand what factors improve the sales and by how much, i.e., the distance to the competitors’ shops

Problem to solve

In a 2020 research of North American grocers, 70% of respondents said they could not consider all the relevant aspects of a promotion—such as price, promotion type, or in-store display— when projecting promotional operations. But they wish they could.

That’s the point with using predictive analytics for sales prediction. It is possible to understand the impact of each factor on the total sales.
But, for most businesses getting an exact sales forecast is nevertheless a significant challenge. Thanks to incorrect forecasting methods based on hunches, companies end up getting little understanding of projected sales. According to Clari, a revenue services platform, 93 percent of sales managers cannot anticipate revenue within 5 percent, even at the end of the quarter.

We have gathered sales historical data from various retail stores for several days. The data collected includes 20 criteria for each record, for instance:

  • the day of the week,
  • the numbers of customers,
  • whether a promotion is running in the store or not,
  • whether it is a public holiday,
  • the distance to the competitors’ shops,
  • the type of shop (size, brick-and-mortar, or online).

There are 6569 records in the dataset used.

Quaartz machine learning’s approach is an excellent forecasting method. It can provide accurate sales predictions and help understand the factors influencing sales.

Objectives

  • Estimate the future sales accurately to staff and stock accordingly.
  • Understand the main factors influencing sales forecasting.
  • Increase revenue.

It poses the following sales and marketing question: Can daily sales be accurately predicted with machine learning?

Solution

Sales forecasting is a crucial ingredient of every expanding retail business. Without a precise sales forecast system, it becomes almost unmanageable to have the correct quantity of stock on hand at any given moment.

Too many products in the warehouse mean more money strapped in inventory, and not enough could result in out-of-stocks — and drive customers to use solutions from your competitors.

Quaartz has selected the following four main criteria out of the twenty available in the dataset:

  • the number of customers in the store, with a weight of 60% in Quaartz’ estimate,
  • the store type (size and e-commerce or brick and mortar), with a weight of 17% in Quaartz’ prediction,
  • the distance between the store and the closest competitor, with a weight of 13%,
  • whether promotions are running in the store, with a weight of 10%.

Not only does the sales manager obtain an accurate forecast, but Quaartz makes it possible to understand the rationale behind this sales forecast. And here, Quaartz is full of common sense. The number of customers entering the store is by far the most important influencing factor.
In other words, to increase sales and revenues, the number one objective for sales teams is to get more people in the store.

Another influencing factor in the predictive analytics tool is the distance to the closest competitor, with a weight of 13%. It is not the most critical factor. But it is interesting to note.

For instance, the dataset comprises the opening year of the competitors’ shops. And it does not matter in the prediction made whether the competitor has been around one year or five. Using the ‘live predict’ feature from Quaartz, we can analyze this criterion one step further.

We can see that competitors’ stores impact sales up to a distance of 2635 meters. Beyond this threshold, a competing store has little effect on sales predictions. Too far to count?
Improved predictability has two direct consequences. It prevents the merchandising team from launching bountiful promotions that would never give an ROI, thus avoiding expensive mistakes; two, it enables more informed negotiations on ordering inventory, preventing over-or under-ordering.

Customer Benefits

In one week, sales teams gained significant help in achieving their total sales by:

  • Getting accurate sales forecasts to manage stock and staff better.
  • Understanding what factors impacted their future sales.
  • Obtain an immediate “what-if” analysis linking the sales to the distance to the competing shops….up to 2635 meters.