EN


Optimizing Promotional Activities in Azerbaijan

Get the best selection of products for your promotional campaign or sale to maximize your profit margin or sales volume in Azerbaijan

Optimization of promotional activity
Business Issues
The labor-intensive nature of the process of assembling a promotional basket
  • Don’t limit yourself to just one promotional basket option. Get 4–6 options at once for different scenarios and choose the one that best suits your tactical goals.
Time required to receive the promotional basket
  • Don’t wait hours for updated promotional offers from category managers. Get instant access to lists of promotional items for the coming weeks
Insufficient accuracy in predicting the outcome of the campaign
  • You don’t have to guess when determining the optimal discount level to maximize sales volume or profit margin. Get an objective forecast of promotional sales for different discount levels
The labor-intensive nature of the process of assembling a promotional basket
  • Don’t limit yourself to just one promotional basket option. Get 4–6 options at once for different scenarios and choose the one that best suits your tactical goals.
Time required to receive the promotional basket
  • Don’t wait hours for updated promotional offers from category managers. Get instant access to lists of promotional items for the coming weeks
Insufficient accuracy in predicting the outcome of the campaign
  • You don’t have to guess when determining the optimal discount level to maximize sales volume or profit margin. Get an objective forecast of promotional sales for different discount levels
Background on the creation of
a new promotional basket model
  • A large number of SKUs
  • Low accuracy in predicting the results of the planned campaign
  • Labor-intensive
  • Low speed
  • Lack of flexibility
  • Compliance with suppliers' promotional policies
Optimization of promotional activity
Key Features of Creating a Promotional Basket
Four Scenarios
  • The promotional basket model generates four scenarios at once, each with different objective functions:
  • Maximizing margin growth
  • Trade balance
  • Margin balance
Rules and Restrictions
  • An item cannot be on sale more than once every 30 days
  • The total number of items in the promotion must not exceed N
  • No more than two items may be selected from a single category
  • The level of intra-group cannibalization should be kept to a minimum
  • The proportion of products from segments A, B, and C must be maintained
Adding new products
  • The option to fill part of the promotional cart with items that have never been included in promotions
  • Selecting products that are as similar as possible to those with known promotional features
  • Criteria used to determine product similarity: product category, average demand, price, weight, volume, consumer properties, and others
Four Scenarios
  • The promotional basket model generates four scenarios at once, each with different objective functions:
  • Maximizing margin growth
  • Trade balance
  • Margin balance
Rules and Restrictions
  • An item cannot be on sale more than once every 30 days
  • The total number of items in the promotion must not exceed N
  • No more than two items may be selected from a single category
  • The level of intra-group cannibalization should be kept to a minimum
  • The proportion of products from segments A, B, and C must be maintained
Adding new products
  • The option to fill part of the promotional cart with items that have never been included in promotions
  • Selecting products that are as similar as possible to those with known promotional features
  • Criteria used to determine product similarity: product category, average demand, price, weight, volume, consumer properties, and others
Let's discuss your data challenges
Please leave your contact information and we will get in touch with you
Optimization of promotional activity
Stages of a typical project
Calculation of reference tables
Development of a forecasting model
Development of a promotional basket model
Calculation of reference tables
Development of a forecasting model
Development of a promotional basket model
  • Calculation of all necessary reference tables for forecasting models and promotional basket generation. Examples of reference tables: elasticity, cannibalization, complementarity, seasonality, trend, product classification
  • Develop a single model for forecasting demand at the SKU/point-of-sale level in accordance with the requirements established for the promotional basket model. Alternatively, the demand forecasting model will be used if it has been developed and implemented previously.
  • Development of a model for creating multiple promotional baskets in accordance with the rules and restrictions:
  • An item cannot be on sale more than once every 30 days
  • No more than N items in the promotion
  • No more than two items from the same category
  • Minimal level of intra-group cannibalization
  • Maintaining the right balance of products from segments A, B, and C
Benefits of the solution
  • Compliance with Rules and Policies
    Compliance with all company and supplier rules and policies when conducting promotional activities

  • Increase in sales volume
    A 1–3 percentage point reduction in the average promotional discount, accompanied by a 50% increase in the sales volume delta
  • Increase in margin
    A 35–50% increase in margin while maintaining sales growth at the average promotional level
Business solutions

RBC Group enhances its clients' competitiveness by implementing modern business analytics, data integration and management, artificial intelligence, and advanced analytics systems.

Let's discuss your data challenges
contact-block-2-photo

Promotional campaigns are a key tool for driving sales growth and can give a company a significant competitive advantage. The success of a promotional campaign depends on the ability to select the right products, adjust discount levels, monitor inventory levels on time, and allocate products appropriately across retail locations. By entrusting the management of your company’s potential to managers whose analytical capabilities are severely limited due to the lack of powerful and reliable data processing applications, you risk compromising the effectiveness and competitiveness of your business. This is due to the large volumes of information that must be collected, processed, and taken into account when developing a campaign.

To achieve the desired result, you must:

  • Use high-quality data—up-to-date information sourced from a single source of truth;
  • Extend the analysis period—the longer the period, the more reliable the forecast will be;
  • Examine trends over time to assess seasonal demand and identify the most promising products;
  • Use ABC-XYZ and RFM analysis to compile a promotional basket;
  • Consider sales geography for the rational distribution of inventory;
  • Make the right pricing decisions and plan sales volumes.

Promotion optimization is an advanced analytics tool that enables you to manage sales processes, make effective use of your advertising budget, and build long-term loyalty among your target audience.

Why promotional campaigns fail

A marketing campaign is considered unsuccessful if its goals and targets are not met. The main reason for this is selective data analysis.

Managers will be required to:

  • determine how customer behavior will change in response to an offer of certain products at a reduced price;
  • determine what those products should be and the size of the discounts;
  • predict how such an offer will affect sales of other items

Often, the task is complicated by the time-consuming process of collecting and analyzing data, as well as by data distortion and inaccuracies.

When the time available for decision-making is limited and the volume of information is too great, one must abandon the idea of finding the optimal solution and instead settle for a compromise that meets the basic requirements. Such campaigns do yield results, but they can only be evaluated in terms of whether they are profitable or break even. It is impossible to conclude that current opportunities have been fully exploited.

The results of campaigns depend on how well the input data is handled

It is not possible to develop an effective promotional offer based solely on knowledge of product categories, margin levels, and demand patterns. To launch a campaign that truly delivers results, you must take into account a range of equally important factors. These include the interrelationships between different product categories, the specific composition of consumer shopping baskets, regional characteristics, and other factors.

The main challenge lies in the need to collect, process, and utilize large volumes of diverse data. Without advanced analytics, a manual, comprehensive analysis of every potential item that meets the basic criteria would take far too long. In the food sector, there may be several thousand such items. Therefore, selecting a list of products for a promotion that could have the greatest impact on demand and revenue seems unrealistic, as it would require analyzing every single item.

To address this challenge, we offer a tool for optimizing promotional activities. By leveraging advanced data analytics algorithms, we can monitor behavioral factors and identify associations and patterns.

Under the proposed solution, the promotional basket is assembled in four stages:

  1. Development of Key Performance Indicator (KPI) Databases. At the initial stage of optimization, it is important to identify key metrics and establish a methodology for their application, which enables the selection of a list of products that are potential candidates for promotional campaigns. To this end, we analyze demand elasticity, seasonal factors, cannibalization, trends, product classifications, and other business-critical metrics.
  2. Development of a forecasting model. Based on the defined requirements, a forecasting model is built that includes SKU levels and individual point-of-sale data.
  3. Promotional basket models are created that take into account the company’s internal marketing policy.
  4. Based on the specified criteria, four scenario options are developed to maximize turnover, margin, or a balance of these indicators.

This customizable solution is flexible and allows you to account for the specifics of your organization’s data structure, the goals of your advertising campaign, and the unique aspects of your marketing strategy. Promotional activity is optimized in two stages. First, products that meet a set of internal criteria and campaign objectives are selected from the entire product list. In the second stage, prices and quantities of products that must be in stock to achieve the best results are specified.

How Optimizing Your Promotional Activities Benefits Your Business

The use of cutting-edge data collection and analysis technologies enables managers to effectively manage marketing campaigns and maximize the impact of their implementation.

Promotional activities are optimized through:

  • processing massive amounts of data accumulated over several years or even the entire history of the organization, which is regularly updated. You can be confident in the accuracy and reliability of this data;
  • simplification and visualization, which allow managers to use the information most effectively. Forecasting and the calculation of key performance indicators are performed in the background; the user receives only the result of complex sequential calculations;
  • capabilities for accurate forecasting that take into account a large number of factors and criteria—something that is practically impossible to do manually.

By implementing a solution to optimize promotional activities, managers can take into account as many key metrics as possible when planning promotional campaigns, while spending a minimum of time and effort on the process. If there is a need to increase the number of products for promotional campaigns, there is no need to expand the staff involved in selecting items.

A key advantage of automated promotion optimization is the ability to generate multiple shopping cart options at once, each of which meets key criteria. This way, managers simply need to evaluate the ready-made proposals and select the one that best aligns with current goals and priorities. Thanks to analytics optimization, you can plan promotional campaigns, which will allow you to discuss issues related to increasing product shipments with suppliers in advance, as well as organize logistics for all retail locations.

Читать полностью