FORM 2
THE PATENTS ACT, 1970
(39 of 1970)
&
THE PATENT RULES, 2003
COMPLETE SPECIFICATION
(See Section 10 and Rule 13)
Title of invention:
PERSONALIZED PROMOTION OFFER GENERATION BY UNDERSTANDING CUSTOMER BUYING INTENT TO MAXIMIZE RETURN ON INVESTMENT
Applicant
Tata Consultancy Services Limited
A company Incorporated in India under the Companies Act, 1956
Having address:
Nirmal Building, 9th floor,
Nariman point, Mumbai 400021,
Maharashtra, India
Preamble to the description:
The following specification particularly describes the invention and the manner in which it is to be performed.
2
TECHNICAL FIELD
[001]
The embodiments herein generally relate to the field of data science for automated promotion offer generation and, more particularly, to a method and system for personalized promotion offer generation by understanding customer buying intent to maximize Return On Investment (ROI). 5
BACKGROUND
[002]
Availability of consumer data, and rapid advancement data analytics techniques, has enabled entities, for example retailers to acquire insights on customers’ shopping behavior and preferences and provide personalized services 10 with the aim of generating more sales. Promotion offers is one of the strategies to boost the sales.
[003]
In the world of retail, the competition between different stores to promote their merchandise is necessary to increase their profit margin. If the objective is to increase profit margin, one of the important way is to decrease the 15 churn rate and increase conversions, which can be attained by promotions via gift cards and different offers. Even though there should be a positive correlation between offers and customer buying habits, it is also observed that even though companies spend 25% of their revenue on promotions, it results in a very little increase in conversions. The reason behind this is that for customers there are too 20 many offers with less relevance and personalization resulting in poor ROI (return on investment). Promotions are mainly classified into two categories: 1. Segment based: Manual, rule-based promotions by tiers or segments resulting in lack of relevance to many. 2. Siloed: Channel centricity as there are different promotion/offer systems for different channels (Online, Store). This gap not only 25 affects the retailers in terms of churn rate and yield margin but also customers are dissatisfied due to relevance. Generating only the relevant offers instead of allocating offers to customers is more critical to improve yield margin in turn ROI for the retailer.
[004]
The existing solutions consider offering allocation mainly in terms 30 of rules or loyalty programs. But the solutions are unable to bridge the gap between
3
what a customer wants and what the customer can buy.
Normal paradigms of customer segmentation is not effective in comparison to RFM based segmentation, wherein RFM analysis is a model for segmenting customers based on three parameters that define their purchase habits: Recency (Number of days since last purchase), Frequency (Number of purchases for each customer), and Monetary 5 value (Total value of all purchases for each customer).
[005]
A recent work titled “Price discounts and personalized product assortments under multinomial logit choice model: A robust approach” analyzes customer behavior data. It jointly focusses on offer and an assortment of products. However, the offers or price discounts generated are non-personalized price 10 discounts for each product and then upon the arrival of customers, the retailer offers a personalized assortment to each type of customer. The non-personalized price discount lacks relevance to customer, also has reduced effectiveness, and lowers customer engagement. Based on this assortment, the customer then makes a purchase decision according to the Multinomial logit choice model. This approach 15 focusses on the customer’s want but may not ensure customer buying intent, thus rate of conversion of discount to sales is not guaranteed.
SUMMARY 20
[006]
Embodiments of the present disclosure present technological improvements as solutions to one or more of the above-mentioned technical problems recognized by the inventors in conventional systems.
[007]
For example, in one embodiment, a method for personalized promotion offer generation is provided. The method includes generating merged 25 data from a product catalog and transaction data of an entity, wherein the product catalogue comprises a product id, a category, a subcategory, and an actual price of each of a plurality of products, and the transaction data comprises a customer id, the product id, the actual price, a promotion price, an order id and appended with a promotion redemption flag of each of a plurality of transacted products bought by 30 a plurality of customers from among the plurality of products.
4
[008]
Further, the method comprises obtaining a promotion percentage based on a customer benefit received by one or more customers among the plurality of customers for one or more transacted products if the promotion redemption flag is set for the product id associated with the customer id, wherein the customer benefit is difference between the actual price and the promotion price in accordance 5 with existing promotion offers for each of the plurality of transacted products.
[009]
Further, the method comprises generating a plurality of customer segments within the plurality of customers based on one of Recency, Monetary, Frequency (RFM) and Average Order Value (AOV) score derived for each of the plurality of customers by processing the transaction data. 10
[010]
Furthermore, the method comprises binning a plurality of promotion offers associated with the transaction data into a plurality of bins by grouping of the promotion percentage based on predefined bin ranges, wherein one or more promotion bins are associated with each customer segment within each category, and wherein an average actual price per category for each of a plurality of categories 15 is determined from the product catalog.
[011]
Further, the method comprises predicting promotion offer redemption probability for each combination among a plurality of combinations of customer segment-promotion bin-category by applying a pretrained tree-based ensemble classifier on a first set of promotion associated features extracted by 20 processing the plurality of customer segments, the plurality of promotion bins, and the plurality of categories.
[012]
Furthermore, the method comprises extracting a second set of promotion associated features derived from the predicted promotion offer redemption probability for each of the customer segments. 25
[013]
Further, the method comprises generating an optimal number of promotion offers for each combination of the plurality of combinations of customer segment-promotion bin-category that that maximize yield of the entity by processing the second set of promotion associated features by a linear programming model, under a plurality of constraints. 30
5
[014]
Further, the method comprises allocating the one or more promotion offers to each customer within each of the plurality of customer segments based on a (i) customer score computed for each customer using one of RFM or the AOV, and (ii) a category score representation number of unique categories products the customer has purchased, wherein the customer with lower RFM or AOV score is 5 allocated higher promotion bins of promotion offers.
[015]
Further, allocating the one or more offers is based on one or more rules set by the entity, wherein the rules comprise (i) allocating a single promotion offer is to a customer from a collection of multiple eligible offers, wherein the single promotion offer is selected based on a highest inventory, and (ii) allocating one or 10 more promotion offer based on a brand of the product the customer has transacted using category-based offers.
[016]
Furthermore, the method comprises generating gift cards based on percentage of the allocated promotion offers and a minimum spend requirement from the customer, and an expected AOV uplift set by the entity. 15
[017]
In another aspect, a system for personalized promotion offer generation is provided. The system comprises a memory storing instructions; one or more Input/Output (I/O) interfaces; and one or more hardware processors coupled to the memory via the one or more I/O interfaces, wherein the one or more hardware processors are configured by the instructions generate merged data from 20 a product catalog and transaction data of an entity, wherein the product catalogue comprises a product id, a category, a subcategory, and an actual price of each of a plurality of products, and the transaction data comprises a customer id, the product id, the actual price, a promotion price, an order id and appended with a promotion redemption flag of each of a plurality of transacted products bought by a plurality 25 of customers from among the plurality of products.
[018]
Further, the one or more hardware processors are configured to obtain a promotion percentage based on a customer benefit received by one or more customers among the plurality of customers for one or more transacted products if the promotion redemption flag is set for the product id associated with the customer 30 id, wherein the customer benefit is difference between the actual price and the
6
promotion price in accordance with existing promotion offers for each of the
plurality of transacted products.
[019]
Further, the one or more hardware processors are configured to generate a plurality of customer segments within the plurality of customers based on one of Recency, Monetary, Frequency (RFM) and Average Order Value (AOV) 5 score derived for each of the plurality of customers by processing the transaction data.
[020]
Furthermore, the one or more hardware processors are configured to bin a plurality of promotion offers associated with the transaction data into a plurality of bins by grouping of the promotion percentage based on predefined bin 10 ranges, wherein one or more promotion bins are associated with each customer segment within each category, and wherein an average actual price per category for each of a plurality of categories is determined from the product catalog.
[021]
Further, the one or more hardware processors are configured to predict promotion offer redemption probability for each combination among a 15 plurality of combinations of customer segment-promotion bin-category by applying a pretrained tree-based ensemble classifier on a first set of promotion associated features extracted by processing the plurality of customer segments, the plurality of promotion bins, and the plurality of categories.
[022]
Furthermore, the one or more hardware processors are configured to 20 extract a second set of promotion associated features derived from the predicted promotion offer redemption probability for each of the customer segment.
[023]
Further, the one or more hardware processors are configured to generate an optimal number of promotion offers for each combination of the plurality of combinations of customer segment-promotion bin-category that that 25 maximize yield of the entity by processing the second set of promotion associated features by a linear programming model, under a plurality of constraints.
[024]
Further, the one or more hardware processors are configured to allocate the one or more promotion offers to each customer within each of the plurality of customer segments based on a (i) customer score computed for each 30 customer using one of RFM or the AOV, and (ii) a category score representation
7
number of unique categories products
the customer has purchased, wherein the customer with lower RFM or AOV score is allocated higher promotion bins of promotion offers.
[025]
Further, the one or more hardware processors are configured to allocate the one or more offers based on one or more rules set by the entity, wherein 5 the rules comprise (i) allocating a single promotion offer is to a customer from a collection of multiple eligible offers, wherein the single promotion offer is selected based on a highest inventory, and (ii) allocating one or more promotion offer based on a brand of the product the customer has transacted using category-based offers.
[026]
Furthermore, the one or more hardware processors are configured to 10 generate gift cards based on percentage of the allocated promotion offers and a minimum spend requirement from the customer, and an expected AOV uplift set by the entity.
[027]
In yet another aspect, there are provided one or more non-transitory machine-readable information storage mediums comprising one or more 15 instructions, which when executed by one or more hardware processors causes a method for personalized promotion offer generation. The method includes generating merged data from a product catalog and transaction data of an entity, wherein the product catalogue comprises a product id, a category, a subcategory, and an actual price of each of a plurality of products, and the transaction data 20 comprises a customer id, the product id, the actual price, a promotion price, an order id and appended with a promotion redemption flag of each of a plurality of transacted products bought by a plurality of customers from among the plurality of products.
[028]
Further, the method comprises obtaining a promotion percentage 25 based on a customer benefit received by one or more customers among the plurality of customers for one or more transacted products if the promotion redemption flag is set for the product id associated with the customer id, wherein the customer benefit is difference between the actual price and the promotion price in accordance with existing promotion offers for each of the plurality of transacted products. 30
8
[029]
Further, the method comprises generating a plurality of customer segments within the plurality of customers based on one of Recency, Monetary, Frequency (RFM) and Average Order Value (AOV) score derived for each of the plurality of customers by processing the transaction data.
[030]
Furthermore, the method comprises binning a plurality of promotion 5 offers associated with the transaction data into a plurality of bins by grouping of the promotion percentage based on predefined bin ranges, wherein one or more promotion bins are associated with each customer segment within each category, and wherein an average actual price per category for each of a plurality of categories is determined from the product catalog. 10
[031]
Further, the method comprises predicting promotion offer redemption probability for each combination among a plurality of combinations of customer segment-promotion bin-category by applying a pretrained tree-based ensemble classifier on a first set of promotion associated features extracted by processing the plurality of customer segments, the plurality of promotion bins, and 15 the plurality of categories.
[032]
Furthermore, the method comprises extracting a second set of promotion associated features derived from the predicted promotion offer redemption probability for each of the customer segment.
[033]
Further, the method comprises generating an optimal number of 20 promotion offers for each combination of the plurality of combinations of customer segment-promotion bin-category that that maximize yield of the entity by processing the second set of promotion associated features by a linear programming model, under a plurality of constraints.
[034]
Further, the method comprises allocating the one or more promotion 25 offers to each customer within each of the plurality of customer segments based on a (i) customer score computed for each customer using one of RFM or the AOV, and (ii) a category score representation number of unique categories products the customer has purchased, wherein the customer with lower RFM or AOV score is allocated higher promotion bins of promotion offers. 30
9
[035]
Further, allocating the one or more offers is based on one or more rules set by the entity, wherein the rules comprise (i) allocating a single promotion offer is to a customer from a collection of multiple eligible offers, wherein the single promotion offer is selected based on a highest inventory, and (ii) allocating one or more promotion offer based on a brand of the product the customer has transacted 5 using category-based offers.
[036]
Furthermore, the method comprises generating gift cards based on percentage of the allocated promotion offers and a minimum spend requirement from the customer, and an expected AOV uplift set by the entity.
[037]
It is to be understood that both the foregoing general description and 10 the following detailed description are exemplary and explanatory only and are not restrictive of the invention, as claimed.
BRIEF DESCRIPTION OF THE DRAWINGS
[038]
The accompanying drawings, which are incorporated in and 15 constitute a part of this disclosure, illustrate exemplary embodiments and, together with the description, serve to explain the disclosed principles:
[039]
FIG. 1A is a functional block diagram of a system, for personalized promotion offer generation by understanding customer buying intent to maximize Return On Investment (ROI), in accordance with some embodiments of the present 20 disclosure.
[040]
FIG. 1B illustrates an architectural and process overview of the system of FIG. 1A, in accordance with some embodiments of the present disclosure.
[041]
FIGS. 2A through 2B (collectively referred as FIG. 2) is a flow diagram illustrating a method for personalized promotion offer generation by 25 understanding customer buying intent to maximize the ROI, using the system depicted in FIG. 1A and 1B, in accordance with some embodiments of the present disclosure.
[042]
FIG. 3 depicts the process for predicting promotion offer redemption probability per customer segment per category per promotion tier, by applying a 30 pretrained tree based ensemble classifier of the system of FIG. 1 on a first set of
10
promotion associated features
, in accordance with some embodiments of the present disclosure.
[043]
FIG. 4 depicts the process for assigning optimal number of promotion offers per customer segment per category per promotion tier, via a linear programming model, by the system of FIG. 1 based on a second set of promotion 5 associated features, in accordance with some embodiments of the present disclosure.
[044]
FIG. 5 depicts the process for gift card allocation, where the system of FIG. 1 sets how much customer needs to spend to get eligible for the promotion offer, in accordance with some embodiments of the present disclosure.
[045]
It should be appreciated by those skilled in the art that any block 10 diagrams herein represent conceptual views of illustrative systems and devices embodying the principles of the present subject matter. Similarly, it will be appreciated that any flow charts, flow diagrams, and the like represent various processes which may be substantially represented in computer readable medium and so executed by a computer or processor, whether or not such computer or processor 15 is explicitly shown.
DETAILED DESCRIPTION OF EMBODIMENTS
[046]
Exemplary embodiments are described with reference to the accompanying drawings. In the figures, the left-most digit(s) of a reference number 20 identifies the figure in which the reference number first appears. Wherever convenient, the same reference numbers are used throughout the drawings to refer to the same or like parts. While examples and features of disclosed principles are described herein, modifications, adaptations, and other implementations are possible without departing from the scope of the disclosed embodiments. 25
[047]
Embodiments of the present disclosure provide a method and system for personalized promotion offer generation by understanding customer buying intent to maximize Return On Investment (ROI). The method disclosed bridges the gap between what the customer wants and what the customer can buy and makes advances on the pre allocation stage of offers by generating at scale how many 30 coupons can be allocated to enhance the yield margin of an entity, such as the
11
retailer.
The method generate offers based on what category retailers' focus to increase Average Order Value (AOV) across different customer segments. The method and system herein addresses customer segmentation using transaction data by using consumer habits, like purchasing decision, promotion redemption habits, their brand/category affinity, Recency, Frequency and Monetary scores (RFM). 5 Recency (R) is a score indicating how recent is the customer. Frequency (F) is a score indicating the number of times each customer has purchased. Monetary (M) is a score indicating total Sales by each customer.
[048]
So along with personalized promotion offer allocation, or simply based on segments, the method generates personalized, optimized, and automated 10 offers. The method utilizes product catalogue and transaction data to obtain product and associated customer details. Computes Recency, Monetary, Frequency (RFM) and Average Order Value (AOV) score on transaction data to create customer segments, wherein each customer fits into the segment according to demography, behavior, spending habits and promo purchase habits. The RFM/ AOV measures 15 the behavior on the quantity of orders a certain customer places, the frequency and recency, which captures the buying patterns i.e. demographics behavioral data for customer, which is then passed on to create customer groupings (segments) by creating RFM or AOV scores to perform grouping or segments. A pretrained tree based ensemble classifier may predict promotion offer redemption probability for 20 each customer segment. Further, a linear optimization model may assign an optimal number of promotion offers, to attain an increasing profit margin (maximum yield), thereby generating offers as per relevance (customer buying interest). A budget constraint may be applied so that maximum revenue can be attained. The final per customer allocation of the offer may be based on different rules of personalization 25 as required from the industry. The eligibility of getting a gift card may be computed by setting a threshold of what a customer should spend to get a gift card.
[049]
Referring now to the drawings, and more particularly to FIGS. 1A through 5, where similar reference characters denote corresponding features consistently throughout the figures, there are shown preferred embodiments, and 30
12
these embodiments are described in the context of the following exemplary system
and/or method.
[050]
FIG. 1A is a functional block diagram of a system, for personalized promotion offer generation by understanding customer buying intent to maximize Return On Investment (ROI), in accordance with some embodiments of the present 5 disclosure.
[051]
In an embodiment, the system 100 includes a processor(s) 104, communication interface device(s), alternatively referred as input/output (I/O) interface(s) 106, and one or more data storage devices or a memory 102 operatively coupled to the processor(s) 104. The system 100 with one or more hardware 10 processors is configured to execute functions of one or more functional blocks of the system 100.
[052]
Referring to the components of system 100, in an embodiment, the processor(s) 104, can be one or more hardware processors 104. In an embodiment, the one or more hardware processors 104 can be implemented as one or more 15 microprocessors, microcomputers, microcontrollers, digital signal processors, central processing units, state machines, logic circuitries, and/or any devices that manipulate signals based on operational instructions. Among other capabilities, the one or more hardware processors 104 are configured to fetch and execute computer-readable instructions stored in the memory 102. In an embodiment, the system 100 20 can be implemented in a variety of computing systems including laptop computers, notebooks, hand-held devices such as mobile phones, workstations, mainframe computers, servers, and the like.
[053]
The I/O interface(s) 106 can include a variety of software and hardware interfaces, for example, a web interface, a graphical user interface and the 25 like and can facilitate multiple communications within a wide variety of networks N/W and protocol types, including wired networks, for example, LAN, cable, etc., and wireless networks, such as WLAN, cellular and the like. In an embodiment, the I/O interface (s) 106 can include one or more ports for connecting to a number of external devices or to another server or devices such as user end devices (mobile 30 devices). The system 100 can extend to user end (customer end) as lightweight
13
software on an end consumer
mobile device as an add-in with the mobile application of the entity (retailer) app or bundled with Loyalty Programs. The allocated offers and gift card notification is communicated to the customer on his/her mobile device.
[054]
The memory 102 may include any computer-readable medium known in the art including, for example, volatile memory, such as static random 5 access memory (SRAM) and dynamic random access memory (DRAM), and/or non-volatile memory, such as read only memory (ROM), erasable programmable ROM, flash memories, hard disks, optical disks, and magnetic tapes.
[055]
In an embodiment, the memory 102 includes a plurality of modules 110. The modules 110 includes a tree based ensemble classifier such as a Light 10 Gradient Boosted Machine (LGBM),which is pretrained for predicting promotion offer redemption probability of a customer segment, a linear programming model, and the like.
[056]
The plurality of modules 110 include programs or coded instructions that supplement applications or functions performed by the system 100 for executing 15 different steps involved in the process of personalized promotion offer generation, being performed by the system 100. The plurality of modules 110, amongst other things, can include routines, programs, objects, components, and data structures, which performs particular tasks or implement particular abstract data types. The plurality of modules 110 may also be used as, signal processor(s), node machine(s), 20 logic circuitries, and/or any other device or component that manipulates signals based on operational instructions. Further, the plurality of modules 110 can be used by hardware, by computer-readable instructions executed by the one or more hardware processors 104, or by a combination thereof. The plurality of modules 110 can include various sub-modules (not shown). 25
[057]
Further, the memory 102 may comprise information pertaining to input(s)/output(s) of each step performed by the processor(s) 104 of the system100 and methods of the present disclosure.
[001]
Further, the memory 102 includes a database 108. The database (or repository) 108 may include a plurality of abstracted pieces of code for refinement 30 and data that is processed, received, or generated as a result of the execution of the
14
plurality of modules in the module(s) 1
10. The database may include the product catalogue of the entity (the retailer), transaction data of the customer, RFM scores, AOV scores, customer scores and the like computed by the system 102.
[002]
Although the data base 108 is shown internal to the system 100, it will be noted that, in alternate embodiments, the database 108 can also be 5 implemented external to the system 100, and communicatively coupled to the system 100. The data contained within such an external database may be periodically updated. For example, new data may be added into the database (not shown in FIG. 1A) and/or existing data may be modified and/or non-useful data may be deleted from the database. In one example, the data may be stored in an 10 external system, such as a Lightweight Directory Access Protocol (LDAP) directory and a Relational Database Management System (RDBMS). Functions of the components of the system 100 are now explained with reference to steps in flow diagrams in FIG. 2 through FIG. 5.
[058]
FIG. 1B illustrates an architectural and process overview of the 15 system 100 of FIG. 1A, in accordance with some embodiments of the present disclosure and is understood in conjunction with steps of a method of FIG. 2
[059]
FIGS. 2A through 2B (collectively referred as FIG. 2) is a flow diagram illustrating a method for personalized promotion offer generation by understanding customer buying intent to maximize the ROI, using the system 20 depicted in FIG. 1A and 1B, in accordance with some embodiments of the present disclosure.
[060]
In an embodiment, the system 100 comprises one or more data storage devices or the memory 102 operatively coupled to the processor(s) 104 and is configured to store instructions for execution of steps of the method 200 by the 25 processor(s) or one or more hardware processors 104. The steps of the method 200 of the present disclosure will now be explained with reference to the components or blocks of the system 100 as depicted in FIG. 1A and 1B and the steps of flow diagram as depicted in FIG. 2. Although process steps, method steps, techniques or the like may be described in a sequential order, such processes, methods, and 30 techniques may be configured to work in alternate orders. In other words, any
15
sequence or order of steps that may be described does not necessarily indicate a
requirement that the steps be performed in that order. The steps of processes described herein may be performed in any order practical. Further, some steps may be performed simultaneously.
[061]
Referring to the steps of the method 200, at step 202 of the method 5 200, the one or more hardware processors 104 are configured to generate merged data from the product catalog ( also referred to as category data) and the transaction data of an entity, say a retailer. As depicted in Table 1 below, the product catalogue comprises a product id, a category, a subcategory, and an actual price of each of a plurality of products. As depicted in Table 2 below, the transaction data comprises 10 a customer id, the product id, the actual price, a promotion price, and an order id. The transaction data (merged data) is further appended with a promotion redemption flag for each of a plurality of transacted products bought by a plurality of customers from among the plurality of products, wherein a set flag indicates promotion redeemed by the customer. 15
Table 1
PRODUCT_ID (or item ID)
Category
BRAND_NAME
Sub Category
Item price/
actual price)
Product 1
Category 1
Brand 1
Sub Category 1
750
Product 2
Category 1
Brand 2
Sub Category 2
275
Product 3
Category 2
Brand 3
Sub Category 3
494
Product 4
Category 3
Brand 4
Sub Category 4
15
Product 5
Category 1
Brand 5
Sub Category 5
250
Table 2
16
customer_id
product id
item_price
(product price)
ORDER_DATE
TRANSACTION_TYPE
order id
promo_sale_price
Customer 1
Prod 1
750
3/12/2023
SALE
1
375
Customer 1
Prod 2
275
4/5/2021
SALE
2
69
Customer 2
Prod 3
494
8/28/2020
SALE
3
226
Customer 2
Prod 4
15
9/21/2019
SALE
4
9
Customer 3
Prod 4
250
12/10/2020
SALE
5
93
[062]
At step 204 of the method 200, the one or more hardware processors 104 are configured to obtain a promotion percentage based on a customer benefit received by one or more customers among the plurality of customers for one or more transacted products if the promotion redemption flag is set for the product id 5 associated with the customer id. The customer benefit is the difference between the actual price and the promotion price in accordance with existing promotion offers for each of the plurality of transacted products. Table 3 below depicts the additional parameters appended to the transaction data that includes the promotion redemption flag ( promo purchase) and the promotion percentage. 10
Table 3
17
customer_id
Product _id or (item_id)
item_regular_price
promo_price
promo_purchase
ORDER_ID
category
sub category
ORDER_DATE
BRAND_NAME
promo%
customer 1
Product 1
1445
373.74
1
1
Sub Category 1
Category 1
2/15/2022
Brand 1
74.13564
customer 1
Product 2
1495
444
1
2
Sub Category 2
Category 1
2/12/2022
Brand 2
70.301
customer 1
Product 3
1495
444
1
3
Sub Category 2
Category 1
2/14/2022
Brand 3
70.301
customer 1
Product 4
1495
266.4
1
4
Sub Category 3
Category 1
2/14/2022
Brand 4
82.1806
customer 1
Product 5
1495
399
1
5
Sub Category 1
Category 1
2/20/2022
Brand 5
73.31104
18
1. Promo purchase: promo is purchased ( flag set) or not ( flag reset)
2. Promotion percentage: if a promo is purchased what is the benefit to the customer
Promotion percentage = (actual price - promo price)*100/(actual price).
[063]
At step 206 of the method 200, the one or more hardware processors 5 104 are configured to generate a plurality of customer segments within the plurality of customers based on one of Recency, Monetary, Frequency (RFM) and Average Order Value (AOV) score derived for each of the plurality of customers by processing the transaction data of Table 3, that includes the promotion percentage and the promotion redemption flag. Table 4 indicates the customer segments 10 generated based on RFM score.
Table 4
customer_id
Customer segment
RFM_Score
R_Score
M_Score
F_Score
customer 1
seg0
4
2
1
1
Customer 2
seg2
8
2
3
3
Customer 3
seg0
3
1
1
1
Customer 4
seg1
6
3
1
2
Customer 5
seg1
6
3
1
2
[064]
As is understood by person having ordinary skill in the art, the Recency (R) is computed based on the number of days past after the customer has 15 made last purchase, the Frequency (F) is computed based on the number of orders made by the customer, the Monetary (M) is computed based on the total sales for the customer and the final RFM score is obtained by summing them. Similarly AOV is an ecommerce metric that measures the average total of every order placed with a merchant over a defined period of time. AOV is one of the most important metrics 20 for online stores to be aware of, driving key business decisions such as advertising
19
spend, store layout, and product pricing.
AOV is revenue divided by number of orders.
[065]
At step 208 of the method 200, the one or more hardware processors 104 are configured to bin a plurality of promotion offers associated with the transaction data into a plurality of bins (depicted in Table 5) by grouping of the 5 promotion percentage based on predefined bin ranges. The observed promotion percentage calculated from the data are observed as continuous float numbers. Thus some discrete values ( predefined bin ranges) suitable are defined to perform binning of the floats to those integers. The floats are converted to the nearest bin values. 10
Table 5
customer_id
Product _id or
item_id
promo_purchase
ORDER_ID
Sub category
Category
BRAND_NAME
segment
promotion_bin
item_price
Customer 1
Product 1
1
1
Sub Category 1
Category 1
Brand 1
seg0
20
235
Customer 2
Product 2
1
2
Sub Category 2
Category 1
Brand 2
seg0
20
295
Customer 3
Product 3
1
3
Sub Category 2
Category 1
Brand 3
seg0
20
295
Customer 4
Product 4
1
4
Sub Category 2
Category 1
Brand 4
seg0
20
295
Customer 5
Product 5
1
5
Sub Category 1
Category 1
Brand 5
seg0
20
235
20
[066]
One or more promotion bins are associated with each customer segment within each category. Further, an average actual price per category for each of a plurality of categories is determined from the product catalog.
[067]
At step 210 of the method 200, the one or more hardware processors 104 are configured to predict promotion offer redemption probability for each 5 combination among a plurality of combinations of customer segment-promotion bin-category by applying a pretrained tree based ensemble classifier (for example, LGBM model) on a first set of promotion associated features extracted by processing the plurality of customer segments, the plurality of promotion bins, and the plurality of categories. 10
[068]
Generating first set of features
a.
Input:
i.
Processed Transaction from Table 5
ii.
Category wise average prices
iii.
Customer and their corresponding segments 15
b.
Generating all possible categories, customer segments, tier (also referred to as promotion bin or bin) combination (plurality of combinations of customer segment-promotion bin-category) to generate required features.
c.
Output: 20
i.
Feature set:
1.
Product Category
2.
Customer segment ( also referred to as segment)
3.
Promotion Bin
4.
Promo Purchase -promo purchased or not 25 (redemption flag set/reset)
5.
Category – segment total purchase: Total purchase (total purchase for a category and a customer segment)
21
6.
Category – segment promotion purchase: Total promo purchase (total promotion offer purchase of products for the category-customer segment )
7.
Price mean in a category (average actual price per category ) 5
8.
No of purchases in a segment
9.
No of promo purchases in a segment
10.
Price mean in a segment
ii.
Number of customers in a segment: Customer segment distribution 10
[069]
Generating first set of features (Continued)
a.
Input: Processed Output from last stage (first set of features)
b.
Output:
i.
Final Feature Set ( depicted in Table 6A and 6B): Additionally following features are calculated and 15 appended to the last set:
1.
Price after discount (promotion price)
2.
Number of promo purchases in a segment
3.
Segment discount purchase
4.
Max promo purchase 20
Table 6A
Sub catgeory
segment
promotion_bin
promo_purchase
level_2_seg_total_purchase
level_2_seg_promo_purchase
22
Sub catgeory 1
seg0
20
0.296640552
0.219129753
0.219129753
Sub catgeory 1
seg0
10
0
0.219129753
0.219129753
Sub catgeory 1
seg0
15
0.000265569
0.219129753
0.219129753
Sub catgeory 1
seg2
20
0.043981901
0.023814191
0.023814191
Sub catgeory 1
seg2
10
0
0.023814191
0.023814191
Table 6B
price_after_discount
no_of_purchases_segment
no_of_promo_purchases_segment
price_mean
seg_disc_purchase
max_promo_purchase
0.103567319
1
1
1
1
1
0.117088608
1
1
1
1
1
0.110327963
1
1
1
1
1
0.103567319
0
0
0
0
0
0.117088608
0
0
0
0
0
Final Feature Data from the last stage are used by the pretrained LGBM model for prediction. The LGBM model is trained using the same set of features derived 5 from a training data and validated using a testing data.
23
Model Target variable: Promo purchase or not. 1 or 0, 1 if promo is used in purchase 0 otherwise
Features:
a.
Category - segment total purchase
b.
Category – segment promo purchase 5
c.
Price after discount
d.
Number of purchases in a segment
e.
Number of promo purchases in a segment
f.
Price mean in a category
g.
Segment discount purchase 10
h.
Max promo purchase
[070]
At step 212 of the method 200 and process flow of FIG. 3, the one or more hardware processors 104 are configured to extract a second set of promotion associated features derived from the predicted promotion offer redemption probability for each of the customer segment 15
LGBM prediction:
a.
Input: Data frame (first set of features) generated in the preprocessing stage.
b.
The input data is being used along with the LightGBM (LGBM) model to generate the probability for all category – promotion bin 20 – customer segment combination
c.
Output:
i.
Redemption Probability prediction by the LGBM model for all combinations as in step 212, is depicted in Table 7.
Table 7 25
Offers (category_promotion bin_customer segment)
Probability
Shoes_10_seg0
0.1
Pants_20_seg1
0.2
24
Dress_15_seg2
0.3
Inventory:
d.
Input:
i.
Data frame (first set of features) generated in the preprocessing stage.
ii.
Inventory data: average cost/price, unit cost/price and 5 product id of products
iii.
Redemption Probability output from last stage
e.
Output:
i.
Second set of features (partial):
1.
For all combinations of Category, Promotion Bin/ Promotion 10 tier and Customer Segment
a.
probability
b.
cost/price: Mean (average) cost of products
c.
Item regular price: Mean (average) price of products
d.
Loss of margin: Represents the loss that will be 15 incurred upon offer redemption. Loss of margin, or the expected loss incurred due to the promotion is calculated as the difference between actual cost (price) and the expected cost (price) of the product after promotion. For instance, a buyer uses the promotion with probability p and pays the 20 discounted cost or pays the whole price, so the expected cost becomes 𝑐𝑜𝑠𝑡 − (𝑐𝑜𝑠𝑡∗𝑑𝑖𝑠𝑐𝑜𝑢𝑛𝑡∗𝑝) 100 which gives us the loss margin as (𝑐𝑜𝑠𝑡∗𝑑𝑖𝑠𝑐𝑜𝑢𝑛𝑡∗𝑝) 100 .
e.
Incremental revenue: Incremental revenue upon redemption of the coupon-Incremental revenue is the 25 additional revenue generated by certain product and is calculated by number of products times the price. So, considering the discount (discount(d)), probability of
25
purchase (p) of promo gives us the fraction of products sold
at the price, 𝑝 ∗ (1 − 𝑑/100 ) ∗ 𝑝𝑟𝑖𝑐e for the single product.
f.
Incremental Margin: This is defined on the same lines as incremental revenue as the increase in profit margin for a specific single product given by p*((1-d/100)actual 5 price-promo price)
Calculating second set of features continued
Input:
i.
Output features from last stage (partial second set of features computed above (a through e) 10
Calculations:
ii.
Calculation of Incremental Yield, Yield margin Ratio and Number of Max offers
iii.
Calculation of max number of offers
Output: 15
iv.
Final second set of features (in Table 8A and 8B)): for each set of promotion bin– customer segment and category the following is calculated and append it to the existing partial second feature set:
1.
incremental yield: Yield is calculated as a weighted 20 mean between revenue and profit margin.
2.
Yield margin ratio (YMR): yield margin ratio is described as the increase in yield per loss of margin
3.
No of Customers
4.
YMR sum : It is group sum of the YMR based on 25 category and customer segment
5.
Constant: It is the ratio of the YMR and YMR sum
6.
Inverted constants : The Yield Margin Ratio (ymr) is inversely proportional to the max number of offers. Based on the YMR. A constant is calculated, which 30
26
is the proportion of offers needs to be allocated, and
inverted constant allocates the proportion in reverse order enforcing the inverse proportionality.
7.
No of max offers number of offers that can be allocated to a category, segment, promotion tier/bin 5 combination: Number of Max offers: . The upper limit on number of offers per item category, segment and discount are calculated by multiplying inverted constant with the number of customers.
Table 8A 10
item_id
segment
probability
cost/ price
item_regular_price
loss of margin
incremental revenue
Sub Category1_10_seg0
seg0
0.05764185
102.20305
270
1.55632989
14.006969
Sub Category1_10_seg1
seg1
0.03548174
102.20305
270
0.95800707
8.6220636
Sub Category1_10_seg2
seg2
0.03548174
102.20305
270
0.95800707
8.6220636
Sub Category1_15_seg0
seg0
0.05764185
102.20305
270
2.33449483
13.228804
27
Sub Category1_15_seg1
seg1
0.03548174
102.20305
270
1.43701061
8.1430601
Table 8B
incremental margin
incremental yelid
yeild_margin_ratio
No_of_Customers
ymr_sum
constant
inverted_constants
No_of_max_offers
8.11579631
9.2940308
5.97176147
7531
12.10548
0.49331
0.2053516
1546
4.99572123
5.7209897
5.97176147
6639
12.10548
0.49331
0.2053516
1363
4.99572123
5.7209897
5.97176147
5525
12.10548
0.49331
0.2053516
1134
7.33763137
8.5158659
3.64784098
7531
12.10548
0.301338
0.3013379
2269
4.51671769
5.2419862
3.64784098
6639
12.10548
0.301338
0.3013379
2000
[071]
At step 214 of the method 200, the one or more hardware processors 104 are configured to generate optimal number of promotion offers for each 5 combination of the plurality of combinations of ‘customer segment-promotion bin-category’ that are profitable (maximize yield for the entity), via the linear programming (LP) model, by processing the second set of promotion associated
28
features under a plurality of constraints
, as depicted in FIG. 4. The LGBM gives output of probability of redemption of all possible combinations of category, segment, promotion bins or promotion tiers. The probability is used to calculate the loss of margin, incremental margin, and incremental revenue. Thereafter the incremental yield obtained from it and other features create the second set of 5 features
1.
Input:
a.
Data frame with input from last stage
b.
Input value: budget input
2.
Calculation Code: 10
a.
Objective: Maximizing yield
b.
Constraints:
i.
Loss of margin is within the budget input: Thus minimum loss margin is capped at the value given by the business user budget). This ensures the budget allocated by the 15 retailer/merchant is not crossed, otherwise loss can cross the retailer budget, which is not recommended or intended.
ii.
The number of offers to be less than the number of customers in the segment. If there are more offers than the number of customers then there will be extra coupons which will not be 20 used resulting in inefficient budget usage.
c.
Decision variables: How many offers can be allocated for a specific customer segment – category – promotion tier.
3.
Output:
a.
Data frame consisting of second set of features with new feature 25 appended 'optimum_no_of_offers' as depicted in Table 9A and 9B.
29
Table 9A
item_id
segment
probability
cost
item_regular_price
loss of margin
incremental revenue
Sub Category_10_seg0
seg0
0.057642
102.2031
270
1.55633
14.00697
Sub Category_10_seg1
seg1
0.035482
102.2031
270
0.958007
8.622064
Sub Category_10_seg2
seg2
0.035482
102.2031
270
0.958007
8.622064
Sub Category_15_seg0
seg0
0.057642
102.2031
270
2.334495
13.2288
Sub Category_15_seg1
seg1
0.035482
102.2031
270
1.437011
8.14306
Sub Category_15_seg2
seg2
0.035482
102.2031
270
1.437011
8.14306
30
Table 9B
incremental margin
incremental yield
yeild_margin_ratio
No_of_Customers
ymr_sum
constant
inverted_constants
No_of_max_offers
optimum_no_of_offers
8.115796
9.294031
5.971761
7531
12.10548
0.49331
0.205352
1546
1546
4.995721
5.72099
5.971761
6639
12.10548
0.49331
0.205352
1363
1363
4.995721
5.72099
5.971761
5525
12.10548
0.49331
0.205352
1134
1134
7.337631
8.515866
3.647841
7531
12.10548
0.301338
0.301338
2269
0
4.516718
5.241986
3.647841
6639
12.10548
0.301338
0.301338
2000
0
4.516718
5.241986
3.647841
5525
12.10548
0.301338
0.301338
1664
0
[072]
At step 216 of the method 200, the one or more hardware processors 104 are configured to allocate the one or more promotion offers to each customer within each of the plurality of customer segments based on a (i) customer score 5 computed for each customer using one of RFM or the AOV, and (ii) a category score representation number of unique categories products the customer has purchased. The customer with a lower RFM or AOV score is allocated higher tiers of promotion offers.
31
[073]
Allocating the one or more offers is based on one or more rules set by the entity, wherein the rules comprise (i) allocating a single promotion offer is to a customer from a collection of multiple eligible offers, wherein the single promotion offer is selected based on a highest inventory, and (ii) allocating one or more promotion offer based on a brand of the product the customer has transacted 5 using category-based offers.
[074]
Further, gift cards are generated based on percentage of the allocated promotion offers and a minimum spend requirement from the customer, and an expected AOV uplift set by the entity.
[075]
The table 9B depicts the fact that for a combination of customer 10 segment-promotion bin- category, how much offers can be allocated to maximize the yield of the entity, keeping loss to the entity within a bound. Then the customer score is calculated using category and the RFM score and to be sorted a descending order to enforce the fact that the higher score customer gets a lower promotion tier/bin and the vice versa. Along with this the gift cards are created for the customer 15 in accordance with using the following steps.
1. An user input of how much expected AOV uplift is needed is taken
2. The ‘minimum spend’ threshold is calculated as the offer percentage more than the expected AOV, so that the AOV of the customer can be increased, thereby increasing the profit margin. The number of tiers or bins 20 are generated of the minimum of it based on the user requirement.
3. Finally the gift card value is calculated as the offer percentage multiplied with the expected AOV. The final output has been demonstrated in the Table 10.
[076]
As depicted in FIG. 5… allocation is done based on percentage of 25 the promotion offers. How much percentage of offer which customer will get. As use case this allocation of one or more promotion offers was enhanced it to cater to customer, by generating gift cards. For gift cards, obviously all customers may not respond. When promotion offers are communicated to customers via different channels onto the mobile device of the customer, some percentage of customers 30 will notice the offers while for some customers it may go unnoticed. Thus, in one
32
example implementation
, 80% of customers are selected for gift cards (wherein the customer percentage is configurable) .
1.
Input:
a.
Optimum number of offer per category per promotion tier per customer segment 5
b.
Transaction data,
c.
Customer segmentation
2.
Calculations in Code
a.
Allocation
i.
Considering all customers 10
ii.
Creating customer score, Customer Score = RFM score + category segment
iii.
Sort the customer data based on the values in the customer score in ascending order of the customer score
iv.
Looping over the customer set, if the customer has no 15 transaction in that category, allocate offer from it
b.
Calculation of minimum spend needed for gift card generation this will create three stages of minimum spend and which gift card to allocate to a customer for what spend
3.
Final Output: 20
•
Gift card allocation (as in Table 10)
Table 10
customer_id
Minimum_spend
discount
1
725
25
2
50
5
3
250
15
4
500
5
33
5
525
25
6
175
30
7
650
15
8
1000
5
•
Redemption and projected revenue and loss depicted in Table 11.
Table 11
Redeem Rate
Expected Budget Utilization
Revenue
gift_card_budget
0.05
101035
878806.3
6000000
0.1
198923.8
1725322
6000000
0.15
297239.4
2603716
6000000
0.2
400240.6
3484881
6000000
•
Aggregate data: The predictive analytics Table 12 shows count of 5 distribution of customer across different minimum spend discount tiers (promotion bins).
Table 12
Minimum_spend
discount
start_date
end_date
customer_count
25
5
10/3/2023 0:00
31/03/23 23:59
515
50
5
10/3/2023 0:00
31/03/23 23:59
889
34
75
5
10/3/2023 0:00
31/03/23 23:59
305
75
15
10/3/2023 0:00
31/03/23 23:59
199
75
25
10/3/2023 0:00
31/03/23 23:59
79
75
30
10/3/2023 0:00
31/03/23 23:59
64
100
5
10/3/2023 0:00
31/03/23 23:59
360
100
15
10/3/2023 0:00
31/03/23 23:59
294
[077]
The method and system disclosed herein provides scalable automated generation of promotion offers using ML techniques, given customer transactions, product catalog and a budget value set by the retailer. The method enables optimized offers to allocate over high number of offer variants with 5 differing offer tiers or promotion bins, category, and customer segments to customers so that invested budget results in maximizing yield and keeping the loss margin less than the budget. In a typical use case implementation, for a defined approved budget of 3.5Million for the gift cards received an expected return of over 8 Million in the holiday period as a result of increase in sales. The method generated 10 gift cards to ensure spend at the edge of their spending limit to get a gift card resulting in an overall increase in AOV.
[078]
The written description describes the subject matter herein to enable any person skilled in the art to make and use the embodiments. The scope of the subject matter embodiments is defined by the claims and may include other 15 modifications that occur to those skilled in the art. Such other modifications are
35
intended to be within the scope of the claims if they have similar elements that do
not differ from the literal language of the claims or if they include equivalent elements with insubstantial differences from the literal language of the claims.
[079]
It is to be understood that the scope of the protection is extended to such a program and in addition to a computer-readable means having a message 5 therein; such computer-readable storage means contain program-code means for implementation of one or more steps of the method, when the program runs on a server or mobile device or any suitable programmable device. The hardware device can be any kind of device which can be programmed including e.g. any kind of computer like a server or a personal computer, or the like, or any combination 10 thereof. The device may also include means which could be e.g. hardware means like e.g. an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA), or a combination of hardware and software means, e.g. an ASIC and an FPGA, or at least one microprocessor and at least one memory with software processing components located therein. Thus, the means can include both hardware 15 means, and software means. The method embodiments described herein could be implemented in hardware and software. The device may also include software means. Alternatively, the embodiments may be implemented on different hardware devices, e.g. using a plurality of CPUs.
[080]
The embodiments herein can comprise hardware and software 20 elements. The embodiments that are implemented in software include but are not limited to, firmware, resident software, microcode, etc. The functions performed by various components described herein may be implemented in other components or combinations of other components. For the purposes of this description, a computer-usable or computer readable medium can be any apparatus that can 25 comprise, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device.
[081]
The illustrated steps are set out to explain the exemplary embodiments shown, and it should be anticipated that ongoing technological development will change the manner in which particular functions are performed. 30 These examples are presented herein for purposes of illustration, and not limitation.
36
Further, the boundaries of the functional building blocks have been arbitrarily
defined herein for the convenience of the description. Alternative boundaries can be defined so long as the specified functions and relationships thereof are appropriately performed. Alternatives (including equivalents, extensions, variations, deviations, etc., of those described herein) will be apparent to persons 5 skilled in the relevant art(s) based on the teachings contained herein. Such alternatives fall within the scope of the disclosed embodiments. Also, the words “comprising,” “having,” “containing,” and “including,” and other similar forms are intended to be equivalent in meaning and be open ended in that an item or items following any one of these words is not meant to be an exhaustive listing of such 10 item or items or meant to be limited to only the listed item or items. It must also be noted that as used herein and in the appended claims, the singular forms “a,” “an,” and “the” include plural references unless the context clearly dictates otherwise.
[082]
Furthermore, one or more computer-readable storage media may be utilized in implementing embodiments consistent with the present disclosure. A 15 computer-readable storage medium refers to any type of physical memory on which information or data readable by a processor may be stored. Thus, a computer-readable storage medium may store instructions for execution by one or more processors, including instructions for causing the processor(s) to perform steps or stages consistent with the embodiments described herein. The term “computer-20 readable medium” should be understood to include tangible items and exclude carrier waves and transient signals, i.e., be non-transitory. Examples include random access memory (RAM), read-only memory (ROM), volatile memory, nonvolatile memory, hard drives, CD ROMs, DVDs, flash drives, disks, and any other known physical storage media. 25
[083]
It is intended that the disclosure and examples be considered as exemplary only, with a true scope of disclosed embodiments being indicated by the following claims.
We Claim:
1. A processor implemented method (200) for promotion offer generation, the method comprising:
generating (202), via one or more hardware processors, merged data from a product catalog and transaction data of an entity, wherein the product catalogue comprises a product id, a category, a subcategory, and an actual price of each of a plurality of products, and the transaction data comprises a customer id, the product id, the actual price, a promotion price, an order id, and wherein a promotion redemption flag for each of a plurality of transacted products bought by a plurality of customers from among the plurality of products is appended to the merged data;
obtaining (204), via one or more hardware processors, a promotion percentage based on a customer benefit received by one or more customers among the plurality of customers for one or more transacted products if the promotion redemption flag is set for the product id associated with the customer id, wherein the customer benefit is difference between the actual price and the promotion price in accordance with existing promotion offers for each of the plurality of transacted products;
generating (206), via one or more hardware processors, a plurality of customer segments within the plurality of customers based on one of (i) Recency, Monetary, Frequency (RFM), and (ii) Average Order Value (AOV) score derived for each of the plurality of customers by processing the transaction data;
binning (208), via one or more hardware processors, a plurality of promotion offers associated with the transaction data into a plurality of bins by grouping of the promotion percentage based on predefined bin ranges, wherein one or more promotion bins are associated with each customer segment within each category, and wherein an average actual price per category for each of a plurality of categories is determined from the product catalog;

predicting (210), via one or more hardware processors, promotion offer redemption probability for each combination among a plurality of combinations of customer segment-promotion bin-category by applying a pretrained tree-based ensemble classifier on a first set of promotion associated features extracted by processing the plurality of customer segments, the plurality of promotion bins, and the plurality of categories;
extracting (212), via one or more hardware processors, a second set of promotion associated features derived from the predicted promotion offer redemption probability for each of the customer segment;
generating (214), via one or more hardware processors, an optimal number of promotion offers for each combination of the plurality of combinations of customer segment-promotion bin-category that maximizes yield of the entity by processing the second set of promotion associated features by a linear programming model, under a plurality of constraints; and
allocating (216), via one or more hardware processors, the one or more promotion offers to each customer within each of the plurality of customer segments based on a (i) customer score computed for each customer using one of the RFM or the AOV, and (ii) a category score representation number of unique categories products the customer has purchased, wherein the customer with lower RFM or AOV score is allocated higher promotion bins of promotion offers.
2. The method as claimed in claim 1, wherein allocating the one or more offers is based on one or more rules set by the entity, wherein the rules comprise (i) allocating a single promotion offer is to a customer from a collection of multiple eligible offers, wherein the single promotion offer is selected based on a highest inventory, and (ii) allocating one or more promotion offer based on a brand of the product the customer has transacted using category-based offers.
3. The method as claimed in claim 1, comprises generating gift cards based on percentage of the allocated promotion offers and a minimum spend

requirement from the customer, and an expected AOV uplift set by the entity.
4. The method as claimed in claim 1, wherein the first set of promotion
associated features extracted by processing the plurality of customer
segments, the plurality of promotion bins, and the plurality of categories
comprises:
total purchase for a category and a customer segment, total promotion offer purchase of products for the category-customer segment , the promotion price, number of purchases of products in the customer segment, number of promotion offer purchases of the products in the customer segment, the average actual price in the customer segment, customer segment discount purchase, and maximum promotion offer purchase
5. The method as claimed in claim 1, wherein the second set of promotion
associated features extracted by processing the plurality of customer
segments, the plurality of promotion bins, and the plurality of categories
comprises:
incremental margin, incremental yield margin ratio (ymr), number of customers, ymr sum, constant, inverted constants, number of maximum promotion offers, and number of promotion offers that can be allocated to a customer segment-promotion bin-category combination.
6. The method as claimed in claim 1, wherein the plurality of constraints
comprise:
maximize yield based on budget constraints of the entity;
a loss margin, indicating expected loss incurred due to the difference between actual price and the promotion price promotion is capped at a predetermined value; and
number of promotion offers for each product in the customer segment not to exceed the number of customers in the customer segment.

7. A system (100) for promotion offer generation, the system (100) comprising:
a memory (102) storing instructions;
one or more Input/Output (I/O) interfaces (106); and
one or more hardware processors (104) coupled to the memory (102) via the
one or more I/O interfaces (106), wherein the one or more hardware
processors (104) are configured by the instructions to:
generate merged data from a product catalog and transaction data of an entity, wherein the product catalogue comprises a product id, a category, a subcategory, and an actual price of each of a plurality of products, and the transaction data comprises a customer id, the product id, the actual price, a promotion price, an order id, and wherein a promotion redemption flag for each of a plurality of transacted products bought by a plurality of customers from among the plurality of products is appended to the merged data;
obtain a promotion percentage based on a customer benefit received by one or more customers among the plurality of customers for one or more transacted products if the promotion redemption flag is set for the product id associated with the customer id, wherein the customer benefit is difference between the actual price and the promotion price in accordance with existing promotion offers for each of the plurality of transacted products;
generate a plurality of customer segments within the plurality of customers based on one of Recency, Monetary, Frequency (RFM) and Average Order Value (AOV) score derived for each of the plurality of customers by processing the transaction data;
bin a plurality of promotion offers associated with the transaction data into a plurality of bins by grouping of the promotion percentage based on predefined bin ranges, wherein one or more promotion bins are associated with each customer segment within each category, and wherein

an average actual price per category for each of a plurality of categories is determined from the product catalog;
predict promotion offer redemption probability for each combination among a plurality of combinations of customer segment-promotion bin-category by applying a pretrained tree-based ensemble classifier on a first set of promotion associated features extracted by processing the plurality of customer segments, the plurality of promotion bins, and the plurality of categories;
extract a second set of promotion associated features derived from the predicted promotion offer redemption probability for each of the customer segment;
generate an optimal number of promotion offers for each combination of the plurality of combinations of customer segment-promotion bin-category that that maximize yield of the entity by processing the second set of promotion associated features by a linear programming model, under a plurality of constraints; and
allocate the one or more promotion offers to each customer within each of the plurality of customer segments based on a (i) customer score computed for each customer using one of RFM or the AOV, and (ii) a category score representation number of unique categories products the customer has purchased, wherein the customer with lower RFM or AOV score is allocated higher promotion bins of promotion offers.
8. The system as claimed in claim 7, wherein allocating the one or more offers is based on one or more rules set by the entity, wherein the rules comprise (i) allocating a single promotion offer is to a customer from a collection of multiple eligible offers, wherein the single promotion offer is selected based on a highest inventory, and (ii) allocating one or more promotion offer based on a brand of the product the customer has transacted using category-based offers.
9. The system as claimed in claim 7, comprises generating gift cards based on percentage of the allocated promotion offers and a minimum spend

requirement from the customer, and an expected AOV uplift set by the entity.
10. The system as claimed in claim 7, wherein the first set of promotion
associated features extracted by processing the plurality of customer
segments, the plurality of promotion bins, and the plurality of categories
comprises:
total purchase for a category and a customer segment, total promotion offer purchase of products for the category-customer segment, the promotion price, number of purchases of products in the customer segment, number of promotion offer purchases of the products in the customer segment, the average actual price in the customer segment, customer segment discount purchase, and maximum promotion offer purchase.
11. The system as claimed in claim 7, wherein the second set of promotion
associated features extracted by processing the plurality of customer
segments, the plurality of promotion bins, and the plurality of categories
comprises:
incremental margin, incremental yield margin ratio (ymr), number of customers, ymr sum, constant, inverted constants, number of maximum promotion offers, and number of promotion offers that can be allocated to a customer segment-promotion bin-category combination.
12. The system as claimed in claim 7, wherein the plurality of constraints
comprise:
maximize yield based on budget constraints of the entity;
a loss margin, indicating expected loss incurred due to the difference between actual price and the promotion price promotion is capped at a predetermined value; and
number of promotion offers for each product in the customer segment not to exceed the number of customers in the customer segment.