JP2015052957A - Coupon issue support system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a technology for increasing the effects of sales promotion or the like by suitably issuing a coupon to a customer by a store concerning coupon issue support.SOLUTION: A coupon issue support system includes: a coupon information input section for inputting coupon information designating the application object of a coupon to be issued to the customer of an affiliated store and an issue object customer; a customer information storage section for storing customer information including the customer attributes of each of a plurality of customers of the affiliated store; and a coupon cost calculation section for selecting the issue object customer to whom the coupon is issued by using the coupon information and the customer information, and for performing calculation to estimate coupon costs as costs related to the issue of the coupon.

Description

  The present invention relates to a computer and information processing technology. The present invention also relates to a technique for issuing an electronic coupon.

  Regarding coupon business, various stores such as retail stores and other organizations issue coupons to customers for sales promotion and marketing. The coupon is also called a discount ticket. Coupons are issued in paper or electronic form. The contents of the coupon are contents that provide services such as discounts and free gifts for specific stores, products, services, and the like. The store issues and provides coupons to predetermined target customers. For example, a store or a coupon business operator issues an electronic coupon and distributes it to a user who is a customer or its terminal. When a customer purchases a product in a store, the customer receives a service such as a discount by presenting and using a coupon.

  JP, 2003-248774, A (patent documents 1) is mentioned as a prior art example concerning issue of an electronic coupon. Patent Document 1 is a method of providing a customer-specific coupon to a customer's mobile terminal by a supplier, setting an applicable product or discount as an incentive for each customer segment according to the customer's purchase performance, Estimating and creating coupons for each customer are described.

JP 2003-248774 A

  A conventional information processing system related to electronic coupon issuance can manage the issuance of store coupons as in the example of Patent Document 1. However, the conventional system has an insufficient coupon issue support function for supporting the issue of coupons to customers by stores. In particular, the conventional system does not provide a function for suitably adjusting the coupon issuance conditions and contents based on the consideration of the sales promotion budget and the grasp of the state from the issuance of the coupon to its use and the actual results.

  A store that issues coupons wants to keep the cost of issuing and operating coupons within the range of the promotional budget. The store wants to increase the overall effect of sales promotion, including attracting customers to the store and profits from sales of products, etc. as the effect of the coupon by issuing a suitable coupon after suppressing the above costs. The store wants to maximize the profit of sales of goods, etc., considering the discount amount by coupon. For example, the store wants to maximize the above effect by issuing a coupon with a content such as a suitable discount rate targeting a suitable customer attribute according to the product.

  However, it is difficult for the store to calculate the expenses related to the issue and operation of the coupon. The conventional system does not provide a coupon issuance support function for displaying the information by calculating the above cost to a person in charge of issuing a coupon at a store.

  In addition, patent document 1 calculates the estimated amount of the promotional expense of coupon use from a product normal price, a coupon usage rate, and a discount rate, and the said coupon usage rate is set based on the past performance. Have been described. However, Patent Document 1 does not describe details of calculation of the estimated amount and details of setting of the coupon usage rate. Patent Document 1 describes that when the estimated amount of the sales promotion expense does not satisfy the sales promotion budget, the operator performs the setting again. The conventional system including Patent Document 1 does not provide a function of adjusting coupon issue conditions and the like so that the estimated amount of the sales promotion expenses satisfying the sales promotion budget.

  The objective of this invention is providing the technique which can raise effects, such as sales promotion, by issuing the coupon to the suitable customer by a store regarding the said coupon issue support.

  A representative embodiment of the present invention is a coupon issuance support system that supports issuance of a coupon for issuing a coupon to a customer of a member store based on an instruction from the member store. It is characterized by having.

  A coupon issue support system according to an embodiment includes a coupon information input unit that performs a process of inputting coupon information that specifies an application target and an issue target customer of a coupon issued to the customer, and a plurality of customers of the member store, respectively. A customer information storage unit that holds customer information including customer attributes of the customer, a customer to issue the coupon using the coupon information and the customer information is selected, and a coupon cost that is a cost related to the issue of the coupon is selected. A coupon cost calculation unit for performing calculation for estimation.

  The coupon issue support system of one embodiment has a coupon record storage unit that holds coupon record information for specifying an application target, issued number of issued sheets, used number of used sheets, and issued customer for issued coupons. The coupon information includes information on a discount rate for the application target, and the coupon cost calculation unit includes the number of customers to be applied, the discount rate of the coupon, and an issuance held in the coupon record storage unit. The coupon cost is calculated using the value of the number of used sheets with respect to the number of completed sheets.

  According to a typical embodiment of the present invention, with respect to the coupon issue support, the effect of sales promotion and the like can be enhanced by issuing a coupon to a suitable customer at a store.

It is a figure which shows the structure of the coupon issue assistance system of one embodiment of this invention. It is a figure which shows the structure of the coupon server of this Embodiment. It is a figure which shows the structure of the customer information server of this Embodiment. It is a figure which shows the 1st part of the flow of the issue assistance process of the coupon server of this Embodiment. It is a figure which shows the 2nd part of the flow of the issue support process of the coupon server of this Embodiment. It is a figure which shows the example of the information at the time of calculation of the coupon expense of this Embodiment. It is a figure which shows the example of the information at the time of the search of the existing coupon information at the time of the calculation of the coupon expense of this Embodiment. It is a figure which shows the 1st example of adjustment of the coupon information of this Embodiment. It is a figure which shows the 2nd example of adjustment of the coupon information of this Embodiment. It is a figure which shows the 3rd example of adjustment of the coupon information of this Embodiment. It is a figure which shows the 4th example of adjustment of the coupon information of this Embodiment. It is a figure which shows the example of a display screen of the adjustment proposal of the coupon information of this Embodiment. It is a figure which shows the example of a screen containing the setting of this Embodiment. It is a figure which shows the structural example of the coupon information of this Embodiment. It is a figure which shows the structural example of the customer information of this Embodiment. It is a figure which shows the structural example of the coupon issue information of this Embodiment. It is a figure which shows the structural example of the coupon usage information of this Embodiment. It is a figure which shows the 1st example of the set of the customer attributes of this Embodiment. It is a figure which shows the 2nd example of the set of the customer attributes of this Embodiment. It is a figure which shows the 3rd example of the set of customer attributes of this Embodiment. It is a figure which shows the structural example of the customer attribute analysis information of this Embodiment.

  Hereinafter, an embodiment of the present invention will be described in detail with reference to the drawings. Note that components having the same function are denoted by the same reference symbols throughout the drawings for describing the embodiment, and the repetitive description thereof will be omitted.

  The coupon issue support system of this embodiment shown in FIG. 1 and the like provides a coupon issue support function by the coupon issue support unit 62 that supports the issue and creation of coupons with respect to the issue of coupons to customers by stores. . The coupon issuance support function estimates and calculates the cost of the coupon in consideration of the target customer attribute and the discount rate of the store coupon by the processing shown in FIGS. 4 and 5, and displays the information on the screen viewed by the person in charge of the store. . The coupon issue support function creates proposal and recommendation information for adjusting coupon information including coupon conditions so that the cost of the coupon falls within the range of the promotional budget, and displays the information on the screen.

[System configuration]
FIG. 1 shows a configuration of a coupon issue support system according to the present embodiment. The coupon issue support system of the present embodiment includes a user terminal 10 of each user who is a plurality of customers 1, a client terminal 20 of each store of a plurality of member stores 2, and a coupon operator through a communication network 5 such as the Internet. 3 system and the credit card company 4 system are connected.

  The plurality of customers 1 are indicated by users U <b> 1 to Un and are customers of the member store 2. The user terminal 10 is a mobile terminal such as a smartphone or a tablet that is carried by a user who is a customer. The user terminal 10 includes a communication function, an input function, a display function, and the like. The user terminal 10 may have a coupon processing function and hold the coupon d1.

  The plurality of member stores 2 are stores of business operators indicated by stores T1 to Tm, which are members of the coupon business and independently issue various coupons. The store may be an actual store or an EC site. The client terminal 20 is an information processing apparatus such as a PC or a POS cash register terminal that is installed in a store and operated by a coupon issuer or a store clerk. The client terminal 20 includes a communication function, an input function, a display function, a sales management function, a customer information processing function, and the like.

  The client terminal 20 may have a coupon processing function, hold the coupon d2, and provide it to the customer. The sales management function is a function for managing sales, sales, payment processing, and the like of products and services at a store. The customer information processing function is a function for inputting / outputting customer information in the store, and registers customer information in the customer information DB 52 of the customer information server 32. When the customer uses the coupon at the store, the client terminal 20 transmits information d4 indicating that to the coupon server 31.

  As a coupon business, the coupon business 3 provides a service for managing and supporting the issuance of coupons by each store based on contracts with a plurality of member stores 2, and obtains commissions and the like. The system of the coupon business operator 3 includes a coupon server 31 and a customer information server 32. The coupon server 31 includes a coupon management unit 61, a coupon issue support unit 62, and a coupon DB 51, and issues and holds a coupon d3. The coupon server 31 stores information related to coupon management and issue support in the coupon DB 51. The customer information server 32 stores customer information of each store in the customer information DB 52 and securely manages it.

  The coupon management unit 61 realizes a coupon management function. The coupon management function grasps and manages the status and results from the issue of coupons to customers by each store to the use of coupons by customers. The coupon issue support part 62 implements a coupon issue support function. The coupon issuance support function adjusts coupon issuance conditions, etc. so that the coupon costs are calculated and the coupon expenses satisfy the conditions of the promotional budget, as support for issuing and operating coupons to customers by each store. Proposals, etc. are processed.

  Between the client terminal 20 of the store, the coupon server 31, and the customer information server 32, client-server communication is appropriately performed during coupon issue support and when the coupon is issued and used. The client terminal 20 accesses the coupon server 31 based on the operation of the person in charge at the store, and receives a coupon management service by the coupon management unit 61 and a coupon issue support service by the coupon issue support unit 62.

  The credit card company 4 is an example of a settlement operator. The system of the credit card company 4 includes a settlement server 41 and a usage details server 42. The settlement server 41 receives payment information by the customer's credit card from the client terminal 10 of the store. The settlement server 41 performs a settlement process based on the payment information, stores the result in the DB as the settlement information 53, and responds to the client terminal 10.

  Based on the payment information 53, the usage details server 42 creates usage details information 54 of the customer's credit card at a timing such as monthly, and stores it in the DB. The usage details information 54 includes information such as a credit card number, customer information, purchase date / time, store, product, and amount.

  The coupon business operator 3 cooperates with the credit card company 4 and acquires customer purchase information d5 from the system of the credit card company 4 as information related to coupon issue support. The customer purchase information d5 is information on purchase results of products by customers at stores. The usage details server 42 transmits the processing information of the usage details information 54 to the coupon server 31 or the customer information server 32 of the coupon business operator 3 as customer purchase information d5. When handling customer information, processing for ensuring security, processing for each customer attribute, and the like are performed.

  The coupon issue support system of this embodiment collects and implements the coupon management function and the coupon issue support function in the coupon server 31 instead of each store, and provides each store as a service. The present invention is not limited to this, and the following is possible as another embodiment. The form by which the coupon management function by the coupon management part 61 was abbreviate | omitted may be sufficient. A form in which a store-by-store coupon management function is implemented by a program or the like on the client terminal 20 of the store may be employed. A form in which a coupon issue support function for each store is mounted on the client terminal 20 of the store may be used. The form in which the coupon server 31 and the customer information server 32 are integrated into one may be used. The form in which the coupon management part 61 and the coupon issue support part 62 were mounted by another server may be sufficient.

[coupon]
Coupons handled in the present embodiment include coupons using media such as paper, and electronic coupons. The coupon d1 of the user terminal 10 in FIG. 1, the coupon d2 of the client terminal 20, and the coupon d3 of the coupon server 31 indicate similar information corresponding to each other. Coupons are exchanged in the form of codes or the like. The coupon may be composed of not only a code but also a file such as a text or image representing the content of the coupon, XML, or a program. The form of providing the coupon to the customer is not limited, and can be directly provided at a store, provided by an advertising medium, e-mail, website, or the like, as will be described later.

[Coupon server]
FIG. 2 shows the configuration of the coupon server 31. The coupon server 31 is a server device that includes a calculation control unit 301, a storage unit 302, an input / output unit 303, and the like. The calculation control unit 301 includes a coupon management unit 61, a coupon issue support unit 62, a setting unit 63, and a screen providing unit 64. The coupon management unit 61 includes an issue condition setting unit 111, an issue unit 112, and a use unit 113. The coupon issue support unit 62 includes a range setting unit 120, a sales promotion budget setting unit 121, a coupon cost calculation unit 122, an adjustment unit 123, a usage rate calculation unit 124, and a recommendation unit 125.

  The calculation control unit 301 includes a CPU, a ROM, a RAM, and the like, and implements processing units such as the coupon management unit 61 and the coupon issue support unit 62 by reading and executing the program 311 in the storage unit 302. The input / output unit 303 includes an input device, an output device, a communication device, and the like, and performs information input / output processing.

  The storage unit 302 stores a program 311, setting information 312, coupon DB 51, promotional budget information 71, coupon cost information 72, adjustment information 73, usage rate information 74, recommended information 75, and the like. The coupon DB 51 stores coupon information D1, coupon issue information 82, coupon usage information 83, a coupon d3, and the like. The coupon information D1 is management information that includes the issuance condition information 81 and includes the issuance condition and content definition of the coupon d3. The coupon information D1 may include a format including coupon issue information 82 and the like.

  The setting unit 63 sets setting information 312 related to the coupon issue support system based on the operation of the administrator of the coupon server 31. The setting information 312 includes setting information regarding various functions of the coupon issue support system, and setting information such as an address for communication between apparatuses.

  Based on the control by the coupon management unit 61 and the coupon issue support unit 62, the screen providing unit 64 provides a screen serving as a user interface in the form of a Web page or the like for the access from the client terminal 20 of the person in charge of the store. Perform the process.

[Customer Information Server]
FIG. 3 shows the configuration of the customer information server 32. The customer information server 32 includes a customer information management unit 221, a customer attribute analysis unit 222, a customer purchase information management unit 223, and a purchase unit price calculation unit 224. The storage unit includes a customer information DB 52, customer attribute definition information 91, a customer Stores attribute analysis information 92, customer purchase information 93, and the like. The customer information DB 52 stores customer information D2, and the customer information D2 includes customer attribute information. The customer purchase information 93 includes purchase unit price information 94. The customer information server 32 includes a calculation control unit and the like as with the coupon server 31, but is omitted.

  The customer information management unit 221 stores and manages the information including the customer attribute of the store customer received from the client terminal 20 as the customer information D2 in the customer information DB 52. The customer information management unit 221 registers customer information D2 including customer attribute information based on the operations of the person in charge at the store and the manager of the coupon server 31. In response to a request from the client terminal 20 or the coupon server 31, the customer information management unit 221 reads and responds to the customer information D2 from the customer information DB 52.

  The customer attribute analysis unit 222 sets the customer attribute definition information 91 based on the operations of the person in charge of the store, the manager of the coupon server 31, and the like. In the customer attribute definition information 91, various customer attributes including segments such as sex and age group are logically defined. The customer attribute analysis unit 222 may extract customer attributes by data analysis processing for the customer information D2 and other information and register them in the customer attribute definition information 91.

  The customer attribute analysis unit 222 uses the customer information D2 of the customer information DB 52 and the customer attribute definition information 91 to perform a process of analyzing a logical relationship in the customer set of a plurality of customer attributes in the customer group. The result is stored in the customer attribute analysis information 92.

  The customer purchase information management unit 223 creates customer purchase information 93 based on the customer purchase information d5 from the credit card company 4 or similar information from the client terminal 20, and stores and manages it in the storage unit. The customer purchase information 93 is information on purchase results of products and the like by customers at stores.

  The purchase unit price calculation unit 224 acquires or calculates a purchase unit price described later using the customer purchase information d5 from the credit card company 4 and stores it as purchase unit price information 94 in the customer purchase information 93. When the purchase unit price information is included in the customer purchase information d5, the purchase unit price calculation unit 224 acquires the purchase unit price information.

  The customer attribute analysis unit 222, the customer purchase information management unit 223, and the like constitute part of the coupon issue support function and may be implemented as a part of the coupon server 31. The customer attribute definition information 91 or the like may be stored in the customer information DB 52 or the coupon server 31.

[Coupon management function]
The coupon management function by the coupon management part 61 of FIG. 2 is demonstrated. The coupon management unit 61 performs coupon management processing using the coupon information D1, customer information D2, coupon issue information 82, coupon usage information 83, and the like.

  The issuance condition setting unit 111 performs processing for setting information including the issuance condition and content of the store coupon in the coupon information D1 based on an operation from the client terminal 20 by the person in charge of the store. The issue condition information 81 in the coupon information D1 is information that defines a target customer attribute of the coupon. The issuance condition setting unit 111 sets information defining the coupon contents such as the coupon discount rate, the application target product, and the validity period in the coupon information D1.

  The issuing unit 112 issues a store coupon d3 in accordance with the coupon information D1 including the issuing condition information 81. The issuing unit 112 creates coupon issue information 82 with the issue of the coupon d3. The coupon issue information 82 is information for managing the state of issue of a coupon to each customer in the store. The issuing unit 112 distributes the coupon to the user by transmitting the issued coupon d3 data to the client terminal 20 or the user terminal 10.

  The use unit 113 manages the coupon use information 83 and performs processing when the customer uses the coupon based on access from the client terminal 20 or the user terminal 10. The coupon usage information 83 is information for managing a coupon usage state by each customer of the store. The use unit 113 receives from the client terminal 20 or the user terminal 10 information d4 indicating that the customer has used the coupon at the store. The use unit 113 updates the coupon use information 83 according to the information d4 so as to reflect the actual use of the coupon by the corresponding customer.

[Coupon issue support function]
A coupon issue support function by the coupon issue support unit 62 in FIG. 2 will be described. The coupon issue support unit 62 performs coupon issue support processing as shown in FIGS. 4 and 5 described later using the coupon information D1, customer information D2, and the like. The coupon issue support function processes the promotional budget information 71, the coupon cost information 72, the adjustment information 73, and the like, and provides a screen including the recommended information 74 by the adjustment information 73 to the client terminal 20 of the person in charge of the store.

  The range setting unit 120 sets the target and range of the coupon issue support process based on the operation from the client terminal 20 by the person in charge of the store, and acquires coupon information D1 and customer information D2 corresponding to the target and range. Process.

  The sales promotion budget setting unit 121 performs processing for setting information on the conditions of the sales promotion budget of the store in the sales promotion budget information 71 based on an operation from the client terminal 20 by the person in charge of the store. The sales promotion budget information 71 includes an upper limit value of the sales promotion cost, and may further include a lower limit value of the sales promotion cost. The upper limit value and the lower limit value of the sales promotion expenses are used as threshold values when determining the coupon expenses.

  The coupon cost calculation unit 122 uses the coupon information D1, coupon issue information 82, coupon usage information 83, customer information D2, customer purchase information 93, and the like to estimate the coupon cost and store it as the coupon cost information 72. I do. At this time, the coupon cost calculation unit 122 calculates the coupon cost using information such as the target customer attribute of the coupon, the number of customers, the discount rate, the usage rate, and the purchase unit price.

  The adjustment unit 123 uses the coupon information D1, the coupon cost information 72, the customer attribute analysis information 92, and the like to adjust the coupon information including the coupon issuance condition and content so that the coupon cost satisfies the conditions of the promotional budget. The adjusted information is stored as adjustment information 73. At this time, the adjustment unit 123 creates a plan for changing the target customer attribute of the coupon, the discount rate, and the like.

  The usage rate calculation unit 124 calculates the usage rate of the coupon by the customer using the information d4 from the client terminal 20 and stores it in the coupon usage information 83 as usage rate information 74. The usage rate is a rate at which a customer to whom a coupon is provided actually purchases a product using the coupon at a store.

  The recommendation unit 125 uses the screen providing unit 64, the coupon cost information 72, and the adjustment information 73 to create recommendation information 74 including coupon information to be proposed and recommended for the person in charge of the store. The process which provides the screen which contains to the client terminal 20 is performed.

[Flow from coupon issuance to use]
An example of a flow related to the coupon management function from issuance of coupons to customers by the store and coupon server 31 to use of coupons by the customers will be described.

  (1) (Setting of coupon information D1) The person in charge of a store sets a target customer attribute, a discount rate, etc. as a coupon issue condition and content from the client terminal 20 to the coupon server 31. Correspondingly, coupon information D1 including issue condition information 81 is set by issue condition setting unit 111.

  (2) (Registration of customer information D2) The customer information server 32 appropriately registers information including customer attributes of customers of the store in the customer information DB 52 as customer information D2 based on access from the client terminal 20.

  (3) (Coupon Issue) The store issues and provides coupons to customers through the coupon management function of the coupon server 31. The coupon management unit 61 of the coupon server 31 issues a coupon d3 based on the set coupon information D1, and updates the coupon issue information 82. The coupon management unit 61 provides the data of the issued coupon d3 to the client terminal 20. The coupon processing function of the client terminal 20 provides the coupon d2 issued from the coupon server 31 to the customer.

  The store may provide a coupon in the form of a receipt or the like from the POS cash register terminal that is the client terminal 10 when the customer purchases the product. The store may transmit the data of the coupon d2 from the client terminal 10 to the user terminal 10. The coupon server 31 may provide the coupon d3 to the user terminal 10 that has accessed a predetermined website. The coupon server 31 may distribute the coupon d3 to the user terminal 10 in the form of e-mail or the like. Coupon server 31 may distribute coupon d3 to user terminal 10 near the store based on the location information service.

  The coupon may be provided at the time when a customer purchases a product at a store, or before or after the purchase. The coupon processing function of the user terminal 10 holds data such as a coupon code provided from the coupon server 31 or the client terminal 20 in a memory.

  (4) (Product Purchase and Settlement) A user who is a customer purchases and pays for products at a store. The POS cash register terminal which is the client terminal 20 accepts payment of merchandise purchase by the customer at the store by cash, credit card, electronic money, points or the like by the sales management function and processes it in cooperation with the settlement server 41. . At that time, the POS cash register terminal reads the customer's credit card information with a reader, transmits the payment information to the payment server 41, and receives the result information of the payment process. The payment information includes information such as purchase date / time, credit card number, product ID, and purchase price. The settlement server 41 stores settlement information 53 for settlement processing in the DB. The usage details server 42 creates usage details information 54 of the customer's credit card based on the settlement information 53 and stores it in the DB.

  The sales management function of the client terminal 20 may manage information such as product ID, price, applicable coupon, sales date / time, sales amount, use coupon, etc. as sales management information. Based on the sales management function, the client terminal 20 may transmit the purchase information of the product purchased by the customer to the coupon server 31 or the customer information server 32.

  (5) (Coupon use) A user who is a customer presents and uses a coupon when paying in (4) above. The user presents and uses a paper medium coupon, for example. In that case, the POS cash register terminal which is the client terminal 20 reads the code of the coupon with a reader by the coupon processing function. Alternatively, the user selects and uses the coupon d1 held by the coupon processing function of the user terminal 10. In that case, the data of coupon d1, user information, etc. are transmitted to the client terminal 20 from the user terminal 10 by near field communication. The coupon processing function of the client terminal 20 receives and processes the data of the coupon d1 from the user terminal 10 and the like.

  The client terminal 20 applies the discount rate of the coupon based on the confirmation whether the product purchased by the customer is the product to which the coupon is applied and the coupon is valid, and the discount rate is calculated from the normal price of the product. Offer at a discounted price.

  The coupon processing function of the client terminal 20 transmits, to the coupon server 31, information d4 indicating that the customer has used the coupon for purchasing the product at the store when the use of the customer coupon is applied. The information d4 includes, for example, information such as use date / time, store ID, customer ID or customer attribute, coupon ID, etc., and may include information such as a product ID. The coupon server 31 reflects the information d4 from the client terminal 20 in the coupon usage information 83.

  Thereafter, the coupon server 31 calculates a coupon usage rate and the like based on the coupon usage information 83 and stores it as usage rate information 74. The customer information server 32 calculates the purchase unit price of the customer based on the customer purchase information d5 from the credit card company 4 and stores it as purchase unit price information 94.

[Promotion and coupon costs]
In the present embodiment, a cost related to the issuance and operation of a coupon by a store is referred to as a “coupon cost”, and is calculated by the processing and formula of S9 in FIG. In the present embodiment, the coupon cost is calculated using the usage rate information 74, the purchase unit price information 94, and the like, and is roughly obtained by estimating the total discount of the coupon. The store records the coupon cost as a sales promotion cost or a liability according to accounting standards. The coupon issue support unit 62 calculates the sales promotion cost and the coupon cost for a predetermined period, for example, monthly.

[Coupon issue support processing (1)]
FIG. 4 shows a first part of the flow of coupon issue support processing mainly by the coupon issue support unit 62 of the coupon server 31. S1 etc. represent processing steps.

  (S1) The coupon server 31 reads and acquires the setting information 312 and starts processing according to the setting state of the setting information 312.

  (S2) The coupon issue support unit 62 uses the range setting unit 120 to specify the target and range of the coupon issue support process based on an operation from the client terminal 20 by a person in charge of the store. The target and the range can be specified from the viewpoint of a store, a period, a coupon, a customer attribute, and the like. As coupons as targets and ranges, not only individual coupons but also existing issued coupons, newly issued coupons, or both can be specified as types. In S2, the range setting unit 120 provides the screen as shown in FIG. 13 to the client terminal 20 using the screen providing unit 64, and the store person in charge can specify the target and the range on the screen. . The processing after S4 is performed on the object and range specified in S2.

  (S3) The coupon issuance support unit 62 sets an upper limit of the sales promotion cost in the sales promotion budget based on the operation from the client terminal 20 by the person in charge of the store, and stores it in the sales promotion budget information 71. Still further, a sales promotion cost lower limit may be set.

  In S4 to S7, the coupon issue support unit 62 inputs or acquires coupon information D1, customer information D2, and the like necessary for the coupon issue support process in the target and range specified in S2. S4 and S6 are performed when the existing coupon is the target, and S5 and S7 are performed when the new coupon is the target.

  The coupon issuance support unit 62 uses the coupon information D1 and customer information D2, etc. to determine the validity period of each coupon, the target product, the valid and invalid states, etc., and for the period of the target and range specified in S2. Determine the relevant information. For example, when September 2013 is designated as the period, a coupon valid for that month is determined as the target.

  (S4) In S4, the coupon issuance support unit 62 reads the coupon information D1, including the issuance condition information 81, the coupon issuance information 82, the coupon usage information 83, and the like related to the existing coupon of the target store from the coupon DB 51. get. The coupon information D1 to be acquired includes a target customer attribute, a discount rate, and the like. The coupon issue information 82 to be acquired includes the number of customers for each customer attribute. The coupon usage information 83 to be acquired includes a usage rate and the like.

  (S5) In S5, the coupon issue support unit 62 performs a process of inputting coupon information including a new coupon issue condition and content on the screen based on an operation from the client terminal 20 by a person in charge of the store. In S5, the coupon issue support unit 62 provides a screen for inputting coupon information, similar to the process of the issue condition setting unit 111 of the coupon management unit 61. The person in charge at the store temporarily determines and inputs information such as the target customer attribute, discount rate, applicable product, and effective period as coupon information on the screen. Note that the input in S5 may be a copy from the existing coupon information D1 and an input by partial correction. The coupon issue support unit 62 stores the input coupon information at the time of S5 as assumption information before adjustment.

  (S6) The coupon issue support unit 62 reads and acquires the customer information D2 corresponding to the target customer attribute related to the existing coupon of the target store from the customer information DB 52.

  (S7) The coupon issuance support unit 62 reads and acquires the customer information D2 corresponding to the target customer attribute regarding the new coupon of the target store from the customer information DB 52.

  (S8) The coupon issue support unit 62 acquires the customer purchase information 93 including the purchase unit price information 94 regarding the customers of S6 and S7 from the customer information server 32.

  (S9) In S9, the coupon issuance support unit 62 uses the coupon information D1 and customer information D2 acquired or input in S4 to S8, etc., to calculate the coupon cost in the designated target and range by the coupon cost calculation unit 122. An estimate is calculated and the result is stored in the coupon cost information 72. A rough calculation formula of the coupon cost is [coupon cost CC] = [number of customers N] × [use rate H] × [purchasing unit price K] × [discount rate W]. Details of S9 will be described later.

  (S10) In S10, the coupon issuance support unit 62 displays a screen including information for comparing the promotional cost upper limit value of S3 with the coupon cost calculated in S9 based on the coupon information before adjustment, as a client terminal of the person in charge of the store 20 to provide. The person in charge of the store can check the promotion cost upper limit value and the coupon cost based on the coupon information before adjustment on the screen.

[Coupon issue support processing (2)]
FIG. 5 shows a second part of the coupon issue support processing flow continued from FIG.

  (S11) The coupon issuance support unit 62 determines whether or not the coupon cost calculated in S9 satisfies the conditions of the promotional budget in S3, that is, [coupon cost]> [promotional cost upper limit value]. The coupon issuance support unit 62 proceeds to S12 when the coupon cost exceeds the sales promotion cost upper limit value (Y), and proceeds to S14 when the coupon cost falls below the sales promotion cost upper limit value (N).

  (S12) In S12, the coupon issuance support unit 62 uses the adjustment unit 123 to include the coupon issuance condition and content adjusted so as to satisfy the condition [coupon cost] ≦ [promotional cost upper limit value]. Create information as a draft. The adjustment unit 123 creates, for example, coupon information of a plurality of conditions for changing the target customer attribute and the discount rate before adjustment. The coupon cost calculation unit 122 calculates the coupon cost for each of the above conditions. And the adjustment part 123 memorize | stores the coupon information of the conditions from which a coupon cost becomes below a sales promotion budget upper limit as the adjustment information 73 to propose. Details of S12 will be described later.

  (S13) In S13, the coupon issuance support unit 62 obtains coupon information before adjustment as in S10 and coupon information including proposal and recommended conditions, which are coupon information after adjustment in S12. Is displayed on the screen. At S <b> 13, the recommendation unit 125 creates a screen including the recommendation information 75 using the adjustment information 73 of S <b> 12 and provides the screen to the client terminal 20. In S13, when there are a plurality of coupon information to be proposed and recommended, the coupon issue support unit 62 displays the information in a form such as a list so that the information can be compared in parallel.

  (S14) In S14, the coupon issuance support unit 62 receives the result of S10 or S13 and confirms and selects whether or not to execute adjustment of the coupon information with the content displayed on the screen. When there is a plurality of pieces of coupon information in the case where the adjustment is performed, the coupon issue support unit 62 allows the person in charge of the store to select one to be adopted from those coupon information. Moreover, the coupon issue support part 62 makes it possible to select a change in the coupon information issue condition and contents by the person in charge of the store when the adjustment is not executed. Depending on the selection in S14, the process proceeds to S16 if adjustment is to be performed, and proceeds to S15 if adjustment is not to be performed.

  (S15) In S15, the coupon issuance support unit 62 inputs information for changing coupon information including coupon issuance conditions and contents on the screen based on an operation by a person in charge of the store. The process of S15 is the same as the process of inputting coupon information of a new coupon in S5. After S15, the process returns to S9, and the coupon cost calculation unit 122 calculates the coupon cost using the coupon information changed in S15.

  (S16) The coupon issuance support unit 62 saves the information selected in S14 as confirmed and reflected in the coupon information D1. The above process is similarly repeated according to the time when the coupon information D1 is adjusted.

  If [coupon cost] ≦ [sales promotion cost upper limit value] in S11, depending on the determination of the person in charge of the store, if it is desired to increase the coupon cost within the upper limit of the sales promotion cost, in other words, the coupon cost is set to the upper limit of the promotion cost as much as possible. Sometimes you want to get closer to. In that case, it is possible to instruct adjustment on the screen based on the operation of the person in charge close to the promotion cost upper limit value. In accordance with the instruction, the adjustment unit 123 creates coupon information including a coupon issuance condition and content that brings the coupon cost close to the sales promotion cost upper limit by the same processing as S12, and displays the information on the screen.

[Existing coupons and new coupons]
The person in charge of the store can adjust how to determine the target customer attribute etc. of the new coupon according to the designation for the new coupon in S2. The new coupon has not been issued, and issuance conditions and contents are not defined. The coupon issuance support unit 62 calculates the coupon cost because it knows to which customer attribute the customer will be issued from the information such as the target customer attribute and discount rate of the assumed new coupon input in S5. it can. The person in charge of the store can set the adjustment information according to the coupon cost as the coupon information D1 of the new coupon.

  Further, the person in charge at the store can adjust how to modify the target customer attribute of the existing coupon by specifying the target for the existing coupon in S2. The existing coupon has been issued, and the coupon information D1 has already been defined, and this content is definite. The coupon issuance support unit 62 can calculate the coupon cost because it can be seen from the coupon information D1 of the existing coupon in S4 and the coupon issuance information 82 to which customer attribute the customer is issued. The person in charge of the store can determine how to modify the issuance conditions and contents of the existing coupon with reference to the coupon cost and adjustment information in the existing coupon. And the person in charge of a store can set the information of adjustment based on the issue condition of the said existing coupon, and correction of the contents as coupon information D1 of the new coupon issued in the future.

  In the case of designation for both new and existing in S2, the coupon issuance support unit 62 can similarly calculate the coupon cost within the range of combining the information of the new coupon and the information of the existing coupon, issuance conditions, etc. Can be adjusted, and the adjusted information can be set as the coupon information D1 of the new coupon.

[Coupon cost calculation (S9)]
The coupon cost estimation calculation process in S9 of FIG. 4 will be described. In the coupon cost calculation formula of S9, the number of customers N, the usage rate H, the purchase unit price K, and the discount rate W are determined according to the designation of the target and range of S2. In addition, the coupon cost calculation part 122 should just calculate and add the coupon cost of each coupon, when there exists a some coupon as object.

  The number of customers N is the number of all customers corresponding to the target customer attribute of the coupon of the target store. The number of customers is obtained from the customer information D2, coupon issue information 82, customer attribute analysis information 92, or the like. The usage rate H is obtained from the usage rate information 74 of the coupon usage information 83 and is a rate at which the coupon is actually used in all customers corresponding to the target customer attribute of the target coupon. The purchase unit price K is obtained from the purchase unit price information 94 of the customer purchase information 93, and is a purchase unit price based on an average value of purchase amounts per customer among all customers corresponding to the target customer attribute of the target coupon.

[Information when calculating coupon costs]
FIG. 6 shows an example of information when the coupon cost calculation unit 122 calculates a coupon cost. The table on the upper side of FIG. 6 shows information summarized for each store, and the table on the lower side of FIG. 6 shows information summarized for each coupon of the store. The information in FIG. 6 is based on information obtained from the coupon information D1, customer information D2, and the like by the coupon issue support unit 62.

  In the upper table of FIG. 6, items include store ID 401, period 402, customer number 403, coupon ID 404, customer attribute 405, store unit usage rate 406, store unit purchase unit price 407, and store unit coupon cost 408. . As a specific example, the target and range are store T1, the period is September 2013, the total number of customers of store T1 is 100 (including customers other than the target customer attribute), coupons C1, C2, C3, and target customer attributes P, Q, R, the usage rate in the store T1 unit is HT1, the purchase unit price of the customer in the store T1 unit is KT1, and the coupon cost in the store T1 unit is CCT1.

  In the table on the lower side of FIG. 6, as items, coupon ID 411, customer attribute 412, discount rate 413, target product 414, customer ID 415, customer number 416, customer attribute unit usage rate 417, customer attribute unit purchase unit price 418, There are coupon costs 419 for coupons and customer attributes. The customer ID 415 is the customer ID of the customer corresponding to the target customer attribute 412 of the coupon, and the customer number 415 is also the corresponding number of customers. The usage rate 417 of the customer attribute unit is a usage rate calculated for the set of customers of the customer attribute 412 unit, and depends on the usage rate of a specific period in the past, the average value of the usage rates of the past period, and the like. The purchase unit price 418 of the customer attribute unit is a purchase unit price per customer calculated by the set of customers of the customer attribute unit 412. The purchase unit price of the past specific period and the average purchase unit price of the past period. It depends on the value.

  The unit price of purchase refers to the total amount or average value of the amount of money purchased by the customer at the store, and is also referred to as the unit price of the customer. The purchase unit price can be calculated on a monthly basis as a period. In the coupon cost calculation formula of S9, the purchase unit price K is a value based on the amount of sales at the normal price of a product that does not reflect the coupon discount. In the calculation formula of the coupon cost, a value reflecting the discount by the coupon is obtained by multiplying the purchase unit price K by the discount rate W.

  In the specific example of the calculation of the coupon cost in FIG. 6, the coupon C1 is an existing coupon, the target customer attribute is P, the discount rate is 20%, and the target products are all products. There are customers U1, U3, U5, U7, etc. corresponding to the customer attribute P, and the corresponding number is 50 people. The usage rate in the unit of the customer attribute P is, for example, Hp = 75% until July 2013. The purchase unit price in the unit of the customer attribute P is, for example, Kp = 10,000 yen until July 2013. The coupon cost CC1 related to the existing coupon C1 is CC1 = [50 people] × [75%] × [10,000 yen] × [20%] = 75,000 yen.

  Coupon C2 is an existing coupon, the target customer attribute is Q, the discount rate is 10%, and the target products are all products. There are customers U2, U3, U6, U7, and the like corresponding to the customer attribute Q, and the corresponding number is 40 people. The usage rate in the unit of the customer attribute Q is Hq = 50%. The purchase unit price in the unit of the customer attribute P is Kq = 20,000 yen. The coupon cost CC2 regarding the existing coupon C2 is CC2 = [40 people] × [50%] × [20,000 yen] × [10%] = 40,000 yen.

  Coupon C3 is a new coupon, the target customer attribute is R, the discount rate is 30%, and the target products are all products. There are customers U4 to U7 and the like corresponding to the customer attribute R, and the corresponding number is 30 people. Since the coupon C3 is a new coupon and has not been issued, there is no record information yet, and there is no information on the usage rate and purchase unit price in units of the customer attribute R. When calculating the estimate of the coupon cost of a new coupon, an estimated value based on the actual information of the existing coupon is used for the usage rate and purchase unit price as will be described later. Regarding the customer attribute R of the coupon C3, the estimated usage rate is Hr, and the estimated purchase unit price is Kr. For Hx, for example, the usage rate of another coupon similar to the coupon C3 is used. As Kx, for example, the purchase unit price of a customer having another customer attribute similar to the customer attribute R is used. The coupon cost CC3 regarding the new coupon C3 is CC3 = [30 people] × Hr × Kr × [10%].

[Use rate and unit price of new coupons]
A method for determining the usage rate and the estimated value of the purchase unit price when calculating the estimate of the coupon cost of the new coupon is as follows. The coupon cost calculation unit 122 applies the following methods in order.

  As a first method, the coupon cost calculation unit 122 uses the coupon information D1 of the existing coupon having the same target customer attribute value, etc. for the coupon information including the issuance condition and content of the target new coupon input in S5. Search for. When there is coupon information D1 of an existing coupon corresponding to this, the coupon cost calculation unit 122 reads information on the usage rate and purchase unit price of the existing coupon, and uses the estimated value of the usage rate of the new coupon and the estimated value of the purchase unit price. Use.

  As a second method, the coupon cost calculation unit 122 searches for existing coupon information having a value such as a target customer attribute that is similar or close to the coupon information of the new coupon when there is no match in the first method. , Information on the usage rate and purchase unit price of the corresponding existing coupon is used. In other words, the second method determines the similarity and proximity of the coupon issuance condition and content, and applies the information of the existing coupon determined to have high similarity and proximity. In the customer attribute definition information 91, the similarity and proximity of each of the plurality of customer attributes are logically defined so that the second method can be searched. For example, it is defined that 30's in an age group segment is close to 20's and 40's. Moreover, the coupon cost calculation part 122 may search with the search conditions which gradually relaxed conditions, such as similarity, when the said customer attribute with high similarity etc. is searched as search conditions, and there is no applicable information.

  As a similar method, a method of searching for existing coupon information having another target customer attribute or the like having a deep relationship with the new coupon information may be used. For this reason, in the customer attribute definition information 91, the depth of the relationship between customer attributes is defined by a correlation coefficient or the like. For example, it is defined that there is a deep relationship between different customer attributes A (for example, home ownership) and customer attributes B (with children). For example, if there is no match in the search for the customer attribute A, a search is made with the customer attribute B that is closely related to the customer attribute A.

  As a third method, the coupon cost calculation unit 122 uses a value of a usage rate or a purchase unit price that has already been calculated in units of a specific customer attribute set in advance when there is no corresponding in the second method. For example, the usage rate and the purchase unit price for each store, the usage rate and the purchase unit price for each gender and age group are calculated in advance based on the record information.

  As another method, a method in which the person in charge of the store determines and inputs the usage rate and the purchase unit price to be applied each time the coupon cost is calculated may be used.

  FIG. 7 shows an example of information when processing for searching for existing coupon information is performed in order to determine an estimated value of a usage rate and a purchase unit price when calculating the coupon cost of the new coupon. In the table of FIG. 7, items include a coupon ID 421, a type 422, a target customer attribute 423, a usage rate 424, and a purchase unit price 425. The type 422 indicates existing or new as a coupon type. The target customer attribute 423 indicates a target customer attribute defined by a product set or union of one or more customer attributes. The product set corresponds to the AND condition, and the union set corresponds to the OR condition. Here, the usage rate 424 indicates a value calculated by an average value or the like in a unit of a set of customers of the target customer attribute 423 of interest. Here, the purchase unit price 425 indicates a value calculated by an average value or the like in a unit of a set of customers of the target customer attribute 423 of interest. The usage rate 424 and purchase unit price 425 in the existing coupon of type 422 are already registered.

  In the example of FIG. 7, as the target customer attribute of each coupon, the existing coupon Ca is gender = male, age group = 20s, and credit card rank = normal. Similarly, the existing coupon Cb is female, 40s, and rank = silver. The existing coupon Cc is male, forties, and rank = normal. The existing coupon Cd is male and has a car. The existing coupon Ce has a child.

  It is assumed that the coupon cost calculation target is a new coupon Cx. The new coupon Cx has a target customer attribute of gender = male, age group = 50s, and rank = gold. The coupon cost calculation unit 122 searches for existing coupon information using the target customer attribute information of the new coupon Cx as a search condition in order to determine the estimated value of the usage rate Hx and the purchase unit price Kx related to the new coupon Cx. The coupon cost calculation unit 122 first searches for information on existing coupons having the same customer attributes as men, fifties, and gold in the target customer attributes of the new coupon Cx. Thus, for example, in the existing coupons Ca to Cf, Ca, Cc, Cd are applicable for gender = male, not applicable for age group = 50s, and not applicable for rank = gold. The coupon cost calculation unit 122 uses existing coupons Ca, Cc, and Cd as candidates, and further selects information having the highest similarity or proximity. Thereby, regarding the age group = 50s, the existing coupon Cc corresponding to the age group = 40s corresponds. Therefore, the coupon cost calculation unit 122 uses the usage rate Hc and purchase unit price Kc of the existing coupon Cc as the usage rate Hx and purchase unit price Kx of the new coupon Cx.

  As another example, the target customer attribute in the target new coupon Cy is age group = 30s. In this case, the coupon cost calculation unit 122 first searches for information on the existing coupons Ca to Cf using the age group = 30's as a search condition, but there is no information corresponding to the same customer attribute. Next, the coupon cost calculation unit 122 searches the 20s or 40s as information similar to or close to the age group = 30s. Thereby, two information of the existing coupons Cb and Cc corresponds. The coupon cost calculation unit 122 selects and uses one of the usage rate and the purchase unit price related to these two existing coupons Cb and Cc. Or since the coupon cost calculation part 122 has the information of two candidates, you may use those average values. That is, the usage rate Hy of the new coupon Cy is (Hb + Hc) / 2, and the purchase unit price Ky is (Kb + Kc) / 2.

  As another example, it is assumed that the target customer attribute in the target new coupon Cz is home ownership = “has home”. In this case, the coupon cost calculation unit 122 searches using “owned house” as a search condition, but there is no corresponding information. Therefore, the coupon cost calculation unit 122 extracts another customer attribute closely related to “having a house”, for example, “has a child” based on the customer attribute definition information 91 and searches for the customer attribute. Thereby, since the information of the existing coupon Ce corresponds, the coupon cost calculation unit 122 uses the usage rate He and the purchase unit price Ke of the existing coupon Ce.

  In the above example, the target customer attribute in the coupon information is used as a search condition. Similarly, a value of a product to be applied may be used as a search condition. As in the above example, the coupon cost calculation unit 122 calculates the attributes of the customer to be issued or the products to be applied for the issued coupon, the attributes of the customer to be issued for the coupon to be issued or the products to be applied, etc. Compare. And the coupon cost calculation part 122 uses information, such as a utilization rate about the issued coupon with those similarities and proximity, for the calculation of the coupon cost of a to-be-issued coupon.

[Coupon information creation process (S12)]
Details of the above-described coupon information drafting process in S12 will be described. The adjustment unit 123 creates a coupon information plan according to each condition while changing the discount rate and / or the target customer attribute as a condition. In the specific example of FIG. 6 described above, the adjustment unit 123 changes, for example, the discount rate and the target customer attribute as the condition of the coupon information when the coupon cost by the coupon information of the new coupon C3 does not satisfy the condition of the promotional budget. The adjustment unit 123 creates a plan in which only the discount rate of the existing coupon C3 is changed from 30% to 25%, similarly a plan of 20%, a plan of 15%, and the like. Moreover, the adjustment part 123 creates the plan which changed the target customer attribute of the existing coupon C3 from R to another customer attribute. The customer attribute can be changed by a logical operation related to the set of customers with the customer attribute.

[Coupon cost adjustment (1)]
FIGS. 8-11 shows the specific example of the creation process of the coupon information plan of S12, and the display of the coupon information and coupon cost information of S10 and S13.

  FIG. 8 shows an example of comparison between the upper limit of the promotional cost and the estimated value of the coupon cost in the case of adjusting the discount rate of the existing coupon. The example about two existing coupons C1 and C2 is shown.

  (A) shows the set sales promotion cost upper limit. If the coupon cost is less than or equal to the sales promotion cost upper limit value, it is determined to be acceptable (OK, N in S11), and not (NG, Y in S11).

  (B) shows the coupon cost by the coupon information D1 including the issuance conditions and contents of the existing coupons C1 and C2. In the coupon information D1, the target customer attribute of the coupon C1 is P, the discount rate is 20%, the target customer attribute of the coupon C2 is Q, and the discount rate is 10%. This is the “first condition”. The lower part divided by the line in the bar of (b) shows the coupon cost for the coupon C1, and the upper part shows the coupon cost for the coupon C2. In this example, the value of (b) exceeds the value of (a).

  (C) shows the coupon cost by the 2nd condition which corrected the 1st condition of the existing coupons C1 and C2 of (b). As a second condition, only the discount rate of the coupon C1 is changed from 20% to 15%. In this example, the discount rate of C1 is reduced to some extent, but the value of (c) exceeds the value of (a).

  (D) shows the coupon cost by the 3rd condition which corrected the 1st condition of existing coupons C1 and C2 of (b). As a third condition, only the discount rate of the coupon C2 is changed from 10% to 5%. In this example, the discount rate of C2 is reduced to some extent, but the value of (d) exceeds the value of (a).

  (E) shows the coupon cost by the 4th condition which corrected the 1st condition of the existing coupons C1 and C2 of (b). As a fourth condition, the discount rate of the coupon C1 is changed from 20% to 15%, and the discount rate of the coupon C2 is changed from 10% to 5%. In this example, the value of (e) became below the value of (a) by reducing the discount rate of C1 and C2.

  As in the above example, the coupon issuance support unit 62 calculates the coupon cost by changing the coupon condition, and adjusts one or more conditions that are equal to or less than the sales promotion cost upper limit, for example, the condition (e) after adjustment. Proposed and recommended as information. The adjusted information can be set as a condition for a new coupon. The value for increasing or decreasing the discount rate for the adjustment is not limited to 5%. Further, the present invention is not limited to the example in which the condition for reducing the discount rate is created, and similarly, the process for creating the condition for increasing the discount rate is possible.

[Coupon cost adjustment (2)]
FIG. 9 shows an example of comparison between the sales promotion cost upper limit value and the estimated value of the coupon cost in the case of adjusting the discount rate of the new coupon, as in FIG. FIG. 9 shows an example in which adjustment is made for one new coupon C3 in addition to the two existing coupons C1 and C2 of FIG.

  In (a), as the set sales promotion cost upper limit, the a1 portion is the same as the cost of the existing coupon as in FIG. 8, and the a2 portion is the additional cost of the new coupon. As in this example, the cost may be divided between the existing portion and the new portion, or may not be divided.

  (B) shows the coupon cost by the coupon information D1 of the existing coupons C1 and C2. In this example, the first condition based on the coupon information D1 is the same as the first condition in FIG. 8B, and the size of the coupon cost is the same as the value of a1 in FIG. The first condition and the coupon cost of the existing coupon are fixed, and the condition of the new coupon C3 and the adjustment of the coupon cost are considered.

  (C) shows the coupon cost by the 1st condition of the new coupon C3 added with respect to the 1st condition of the existing coupons C1 and C2 of (b). As the first condition of the new coupon C3, the target customer attribute of the coupon C3 is R, and the discount rate is 30%. In this example, the value of (c) exceeds the value of (a). The coupon cost for the new coupon C3 in (c) exceeds the cost for a2 in (a).

  (D) shows the coupon cost by the 2nd condition which corrected the 1st condition of the new coupon C3 of (c). The second condition is that only the discount rate of the coupon C3 is changed from 30% to 20%. In this example, the value of (d) fell below the value of (a).

  (E) shows the coupon cost by the 3rd condition which corrected the 1st condition of the new coupon C3 of (c). The third condition is that only the discount rate of the coupon C3 is changed from 30% to 10%. In this example, the value of (d) fell below the value of (a), and was smaller than the value of (d).

  As in the above example, the coupon issuance support unit 62 calculates the coupon cost by changing the coupon condition, and one or more conditions such as (d) and (e) that are equal to or lower than the sales promotion cost upper limit value. Are proposed and recommended as adjusted information. When adjustment is considered only for the new coupon C3, the amount of a2 in (a) may be calculated in the same manner as the sales promotion cost upper limit.

  If a plurality of conditions can be proposed as in (d) and (e), these proposals may be ranked and proposed. The ranking policy may be, for example, a policy in which a condition where the coupon cost is as low as possible is set to a high rank, or a policy in which a condition where the coupon cost is as close as possible to the sales promotion upper limit is set as a high rank. In the former case, for example, (e) has a higher rank, and in the latter case, for example, (d) has a higher rank. The ranking policy can be selected and set by the person in charge of the store or the manager of the coupon server 31 on the screen.

  If there are two or more conditions that fall within the range between the upper limit value and the lower limit value of the sales promotion budget, the person in charge of the store can arbitrarily select and employ them. For example, it is possible to adopt a condition that is as close as possible to the sales promotion cost upper limit, and to adopt it if a condition that is as close as possible to the sales promotion cost lower limit is better.

[Coupon cost adjustment (3)]
FIG. 10 shows an example of the comparison between the upper limit of the promotional cost and the estimated value of the coupon cost in the case of adjusting the target customer attribute of the existing coupon. FIG. 10 shows an example of two existing coupons C1 and C2. In this example, a method of adding a logical condition of a set of customer attributes is used as a method of changing the target customer attributes.

  (A) shows the set sales promotion cost upper limit. If the coupon cost is less than or equal to the upper limit of the sales promotion cost, it is determined to be acceptable. (B) shows the coupon cost by the coupon information D1 of the existing coupons C1 and C2. In the coupon information D1, the target customer attribute of the coupon C1 is P, and the customer attribute of the coupon C2 is Q. This is the “first condition”. The discount rate is a predetermined value.

  (C) shows the coupon cost by the 2nd condition which corrected the 1st condition of the existing coupons C1 and C2 of (b). The second condition is that only the target customer attribute of the coupon C1 is changed from P to P∩X. That is, it is limited by adding the condition of the customer attribute X to the customer attribute P and taking the product number of P and X. This may reduce the number of customers corresponding to the set of customer attributes. In this example, the coupon cost has decreased due to the decrease in the number of people due to the limitation of the customer attribute of C1, but the value of (c) exceeds the value of (a).

  (D) shows the coupon cost by the 3rd condition which corrected the 1st condition of existing coupons C1 and C2 of (b). The third condition is that only the customer attribute of the coupon C2 is changed from Q to Q∩X. In this example, the coupon cost decreased from the decrease in the number of people due to the limitation of the customer attribute of C2, and the value of (d) was kept below the value of (a).

  (E) shows the coupon cost by the 4th condition which corrected the 1st condition of the existing coupons C1 and C2 of (b). The fourth condition is that the customer attribute of the coupon C1 is changed to P∩X and the customer attribute of the coupon C2 is changed to Q∩X. In this example, due to the limitation of the customer attributes of C1 and C2, the value of (e) falls below the value of (a) and is smaller than the value of (d).

  As in the above example, the coupon issuance support unit 62 calculates the coupon cost by changing the coupon condition, and one or more conditions such as (d) and (e) that are equal to or lower than the sales promotion cost upper limit value. Are proposed and recommended as adjusted information. Various customer attributes X can be added for the adjustment. In the above example, a method of creating a condition limited by adding a condition of a customer attribute is used. However, processing by other methods such as a method of taking a difference set is also possible.

[Coupon cost adjustment (4)]
FIG. 11 shows an example of comparison between the sales promotion cost upper limit value and the estimated value of the coupon cost in the case of adjusting the target customer attribute of the new coupon, as in FIG. FIG. 11 shows an example in which adjustment is made for one new coupon C3 in addition to the two existing coupons C1 and C2 of FIG.

  (A) is the set promotion cost upper limit, and the portion a1 is the same cost for the existing coupon as in FIG. 10, and the portion a2 is the cost for adding the new coupon. (B) shows the coupon cost by the coupon information D1 of the existing coupons C1 and C2. In this example, the first condition based on the coupon information D1 is the same as the first condition in FIG. 10B, and the size of the coupon cost is the same as the value of a1 in FIG.

  (C) shows the coupon cost by the 1st condition of the new coupon C3 added with respect to the 1st condition of the existing coupons C1 and C2 of (b). The first condition of the new coupon C3 is that the target customer attribute of the coupon C3 is R. In this example, the value of (c) exceeds the value of (a). The coupon cost for the new coupon C3 in (c) exceeds the cost for a2 in (a).

  (D) shows the coupon cost by the 2nd condition which corrected the 1st condition of the new coupon C3 of (c). The second condition is that the customer attribute of the coupon C3 is changed from R to R∩X. In this example, by limiting the customer attribute of C3, the value of (d) was kept below the value of (a).

  (E) shows the coupon cost by the 3rd condition which corrected the 1st condition of the new coupon C3 of (c). The third condition is that the customer attribute of the coupon C3 is changed from R to R∩X∩Y. This is an example in which the condition of the customer attribute Y is further added to the customer attribute R∩X of the second condition for limitation. In this example, by limiting the customer attribute of C3, the value of (d) is less than the value of (a) and is smaller than the value of (d).

  As in the above example, the coupon issuance support unit 62 calculates the coupon cost by changing the coupon condition, and one or more conditions such as (d) and (e) that are equal to or lower than the sales promotion cost upper limit value. Are proposed and recommended as adjusted information.

  Although the above example is a method of determining using the sales promotion cost upper limit value, a method of determining using the sales promotion cost lower limit value is also possible. That is, it is determined as OK (OK) when the coupon cost is equal to or greater than the lower limit of the promotional cost, and determined as No (NG) when the coupon cost is less than the lower limit.

[Display of multiple adjustment proposals (S13)]
FIG. 12 shows an example of a screen when displaying information of a plurality of adjustment plans as adjusted coupon information in S13 described above. In this screen, reference numeral 1201 denotes an item for displaying the set value of the sales promotion budget. Reference numeral 1202 denotes an item for displaying the coupon information to be adjusted. Reference numeral 1203 denotes a table listing a plurality of adjustment proposals. Reference numeral 1204 denotes an item for selecting an adjustment plan to be adopted by the person in charge of the store from the table 1203. In the table of 1203, the identification number of the adjustment plan, the target customer attribute, the discount rate, the coupon cost, and the details are described as items. The item of coupon cost displays the calculated coupon cost. Detailed items are linked to detailed information of the adjustment plan by a selection operation. The detailed information may be displayed as a graph as shown in FIG. In the example of 1203, a plurality of adjustment proposals with different discount rates are displayed.

[Screen example]
FIG. 13 shows an example of a screen provided to the client terminal 20 of the person in charge of the store or the manager of the coupon server 31. Reference numeral 1301 denotes an item that allows specification of the target and range of S2 described above. In the item, a store, a period, a coupon type, an individual coupon, and the like can be designated by a list box or a form.

  Reference numeral 1302 denotes a setting item for the above-described sales promotion budget. In this item, an upper limit value and a lower limit value of the sales promotion expenses can be set. 1303 shows the item which sets the system of adjustment in the case of adjusting coupon information D1 including the issue condition and content of a coupon. For example, the item can be selected from the above-described method for adjusting the discount rate, the method for adjusting the target customer attribute, and the like.

  Reference numeral 1304 denotes an item for displaying coupon information before adjustment, coupon cost, and the like. Reference numeral 1305 denotes an item for displaying adjusted coupon information, coupon costs, and the like. Reference numeral 1306 denotes a button for designating whether or not to execute adjustment based on the contents of the screen to confirm and save.

[Coupon information D1]
FIG. 14 shows a configuration example of the coupon information D1. Coupon information D1 of FIG. 14 shows an example in which information on electronic coupons issued for each store is managed in a table. The coupon information D1 in FIG. 14 includes, as management items, a store ID 501, a coupon ID 502, a target product 503, a discount rate 504, an issue period 505, an effective period 506, and the like. The issue condition information 81 includes, as management items, a target customer attribute 511, the number of issues 512, and the like.

  The store ID 501 is an ID that is store identification information. The coupon ID 502 is information such as coupon identification information, name and type, and is associated with the code of the coupon d3 itself. The target product 503 is information for specifying an application target of the coupon, that is, an applicable product, for example, an individual product, a product type ID, a value for specifying all the products, and the like. The discount rate 504 is a discount rate, a discount amount, or a value designating free of charge, which is a discount content by the coupon.

  The issuance period 505 is information that defines the period and date for issuing the coupon when it is determined. The validity period 506 is information that defines a validity period or a validity period after the coupon is issued.

  The target customer attribute 511 in the issuance condition information 82 is information that defines the issuance target customer, and is related to the coupon indicated by the coupon ID 502. In the target customer attribute 511, a value indicating the customer attribute defined in the customer information D2 or the customer attribute definition information 91 is set. The issued number 512 is set when an upper limit value of the issued number of coupons is defined.

  In the specific example of FIG. 14, the store T1 issues coupons C1 to C4 and the like. Coupon C1 has a target product of p1, a discount rate of 5%, an issue period of September or an issue date of September 1, and an effective period of September to December or an expiration date of December 31. Day, the target customer attribute is P (example: male), and the upper limit of the number of issues is 100.

[Customer information D2]
FIG. 15 shows a configuration example of the customer information D2. The customer information D2 in FIG. 15 shows an example of management items when managing customer information for each store in a table. The customer information D2 in FIG. 15 includes, as management items, store ID 601, store basic information 602, customer ID 603, customer basic information 604, customer attribute information 605, customer coupon information 606, customer purchase information 607, and the like. The customer information D2 may be registered information of store members.

  The store ID 601 is store identification information. The store basic information 602 is basic information regarding the store, the person in charge of issuing a coupon, the client terminal 20, and the like, and includes a name, an address, and the like. The customer ID 603 is identification information of a user who is a customer. The customer ID 603 may be an ID of a store member, an ID of the user terminal 10, or the like. The customer basic information 604 is basic information of a user who is a customer, and includes a name, an address, and the like. The customer basic information 604 may include registration information of customers of store members, information on the user terminal 10, information such as credit cards, and the like.

  The customer attribute information 605 is information of one or more customer attributes to which the customer identified by the customer ID 603 corresponds. Customer attributes include various attributes such as gender, age group, region, occupation, presence / absence of car, presence / absence of children, interest and preference. The customer attribute is set based on the customer attribute definition information 91. In the customer attribute definition information 91, usable customer attributes are logically defined such as, for example, the age group is classified into teens, twenties, etc., and the car is owned or not.

  The customer coupon information 606 is similar information based on the coupon issue information 82 and the coupon usage information 82, and can be omitted. The customer coupon information 606 is a coupon ID or the like of a valid coupon that has been issued and provided to the customer and that the customer currently has and can use. The customer purchase information 607 is the same information as the customer purchase information 93 described above, and can be omitted. The customer purchase information 607 is information on the results of the purchase of products by individual customers or customers in units of customer attributes at the store, and analysis information thereof.

[Coupon issue information 82]
FIG. 16 shows a configuration example of the coupon issue information 82. The coupon issue information 82 on the upper side of FIG. 16 is an example of a customer unit table, and items include a store ID 701, a customer ID 702, a customer attribute 703, an issue coupon ID 704, a coupon number 705, and the like. Store ID701, customer ID702, and customer attribute 703 are the same information based on the contents of customer information D2. The issued coupon ID 704 is an ID of a coupon issued to the customer with the customer ID 702. The number of coupons 705 is the number of all coupons with the issued coupon ID 704 and corresponds to the number of issued coupons for each customer.

  The lower coupon issue information 82 in FIG. 16 is an example of a coupon and customer attribute unit table obtained by converting the upper coupon issue information 82. The coupon issue information 82 on the lower side of FIG. 16 includes items such as a coupon ID 711, a target customer attribute 712, a customer ID 713, and the number of people 714. The coupon ID 711 and the target customer attribute 712 are similar information based on the coupon information D1. The customer ID 713 is the customer ID of the customer corresponding to the target customer attribute 712. The number of people 714 is the number of customers with the customer ID 713 and corresponds to the number of issued coupons in units of customer attributes.

  In the specific example of FIG. 16, the coupon C1 has a target customer attribute of P, and corresponds to N1 customers such as customers U1, U3, U5, U7. For example, customer U7 corresponds to customer attributes P, Q, R, etc., coupons C1, C2, C3 are provided, and the number of coupons is three. The coupon issue support unit 62 may display the contents of the coupon issue information 82 as shown in FIG. 16 on the screen.

[Coupon usage information 83]
FIG. 17 shows a configuration example of the coupon usage information 83. The upper coupon usage information 83 in FIG. 17 is an example of a history information table in order of usage date and time. The coupon use information 83 on the upper side of FIG. 17 includes items such as a use date and time 801, a store ID 802, a customer ID 803, a use coupon ID 804, a use product 805, and the like. The use date 801 is the date when the coupon was used. The store ID 802 indicates the store where the coupon is used, and the customer ID 803 indicates the customer who uses the coupon. Use coupon ID804 is ID of the coupon which the customer used. The used product 805 is an ID of a product for which the coupon is used.

  The lower coupon usage information 83 in FIG. 17 is an example of a coupon information table obtained by converting the upper coupon usage information 83. The coupon usage information 83 on the lower side of FIG. 17 includes items such as a coupon ID 811, a target customer attribute 812, a customer usage ID 813, a number of users 814, a usage rate 815, and the like. The use customer ID 813 is a customer ID of a customer corresponding to the target customer attribute 812 using the coupon with the coupon ID 811. The number of users 814 is the number of customers of the used customer ID 813 and corresponds to the number of coupons used in units of customer attributes. The usage rate 815 indicates the rate of customers who actually used the coupon among the customers with the customer attribute to which the coupon is provided, in other words, the value of the used number with respect to the issued number.

  In the specific example of FIG. 17, the customer Ua of the store T1 used the coupon Ca for the product pa on June 1. The coupon Ca has a target customer attribute of A, is used by x persons such as the corresponding customer Ua, and the usage rate is Ha%. The coupon issue support unit 62 may display the contents of the coupon usage information 83 as shown in FIG. 17 on the screen.

  The coupon server 31 can grasp the coupon in an effective state possessed by each customer of the store at the present time by combining the coupon issue information 82 and the coupon usage information 83. Furthermore, the coupon server 31 can grasp | ascertain which coupon was used when the customer of each attribute of a store purchased what by using customer purchase information 93 together.

[Customer attributes]
Supplement on customer attributes. The concept of customer attribute includes the concept of marketing segment or evaluation axis constituting it. A segment refers to a group or demographic of customers who are likely to have similar purchasing behavior and needs. The customer attribute used for coupon issue support can be registered by the coupon business operator 3, registered based on information from the credit card company 4, registered by a person in charge at the store, registered by the user, and the like.

  As the customer attribute, in addition to the example described above, a rank such as normal or silver in the customer's credit card may be registered. As customer attributes, ranks such as general and excellent according to the number of visits to the store, the purchase amount, and the like among store members may be registered. The customer attribute may be defined by a logical combination of a plurality of customer attributes, for example P and Q, P or Q, etc.

[Customer attribute set (1)]
FIG. 18 shows a Venn diagram representing a logical relationship regarding a set of customers of two customer attributes, and an example of assignment of coupon issuance to the customer attributes. For explanation, 顧客, ∪,-, ^C, etc., which are mathematical set symbols, are used for customer groups with customer attributes. ∩ is a product set, ∪ is a union,-(minus) is a difference set, and ^C is a complement. Further, negation (NOT) of the customer attribute P is represented by “No P”.

The customer attribute P ellipse indicates a set of customers corresponding to the customer attribute P (eg, male), and the customer attribute Q ellipse indicates the set of customers corresponding to the customer attribute Q (eg: there is a car). For example, a coupon C1 is issued for the customer attribute P, and a coupon C2 is issued for the customer attribute Q. PQ is a difference set between P and Q, and indicates a set of customer attributes (for example, male and no car) that are P and not Q. Q−P is a difference set between Q and P, and indicates a set of customer attributes (for example, a woman with a car) that is Q and not P. P∩Q is a product set of P and Q, and indicates a set of customer attributes (for example, men and cars) that are P and Q. ^{(P∪Q) C} is the complement of the union P∪Q of P and Q, in other words, the intersection of the complement ^{Q C} of complement ^{P C} and Q of the ^P (P ^C ∩Q ^C) And a set of customer attributes (eg, female and no car) of No P and No Q.

For example, the number of customers in a customer group in which customer information of a certain store is registered is 100. The set of P has 50 corresponding customers. The set of Q is 40 people, the set of PQ is 40 people, the set of QP is 30 people, the set of P∩Q is 10 people, and the set of (P∪Q) ^C is 20 people. In order to simplify the explanation, one type of coupon is considered to be provided to all customers corresponding to the target customer attribute. Each of 40 customers of PQ is provided with one coupon C1. Each of the 30 Q-P customers is provided with one coupon C2. Each of the ten customers of P∩Q is provided with two coupons C1 and C2. (P∪Q) 20 customers of ^C are not offered any coupons.

[Customer attribute set (2)]
FIG. 19 shows an example of a plurality of segments with gender and age as evaluation axes as another example of a set of customer attributes. As customer attributes, a1 indicates male and a2 indicates female. b1 to b5 etc. indicate teens to 50s as an age group. Each area such as (a1∩b1) can be set as a segment. For example, the coupon C1 is a male whose target customer attribute is a1, and the coupon C2 is a 20s to 30s whose target customer attribute is b2 and b3.

[Customer attribute set (3)]
FIG. 20 shows an example with three customer attributes as another example of the set of customer attributes, similar to FIG. As the coupon issuance conditions, the existing coupon C1 has a target customer attribute of P and the corresponding number of people is 50, and the existing coupon C2 has a customer attribute of Q and the number of applicable people is 40. The new coupon C3 has a customer attribute of R and a corresponding number of people of 30. The total number of customers in the store is 100.

In the state before adjustment, s1 to s8 indicate each set part in the combination of customer attributes P, Q, and R. s1 is a set of P, no Q, and no R, and the number of people is 35. Similarly, s2 is a set of no P, Q, and no R, and is 20 people. s3 is a set of no P, no Q, and R, and is 10 people. s4 is a set of P, Q and not R, and is five people. s5 is a set of P, not Q, and R, and is five people. s6 is a set of No P, Q and R, and is 10 people. s7 is a set of P, Q, and R (P∩Q∩R) and is five people. s8 is a set of P, Q, and R (P 否 Q∪R) ^C, which is 10 people.

[Customer attribute analysis]
The customer attribute analysis unit 222 logically analyzes the state of provision of coupons related to a set of customers in a plurality of customer attribute units in the target and range information of S2, and stores the result in the customer attribute analysis information 92. The coupon cost calculation unit 122 may calculate the coupon cost using information such as the number of customers in the customer attribute unit of the customer attribute analysis information 92. The adjustment unit 123 may use the customer attribute analysis information 92 in the process of changing the target customer attribute.

  FIG. 21 shows a configuration example of the customer attribute analysis information 92. The customer attribute analysis information 92 in FIG. 21 includes items such as an identification number 900, a customer attribute set 901, a description 902, a state 903, a customer number 904, and a coupon number 905. The identification number 900 is an identification number of the row and customer attribute set 901. The customer attribute set 901 is a value representing a set of customer attributes based on a logical combination of customer attributes. For example, the customer attribute set 901 is represented by a set representation as shown in FIG. The description 902 is text describing the customer attribute set 901. The state 903 stores a value indicating the state of the customer attribute set 901. The number of customers 904 is the number of customers corresponding to the customer attribute set 901 and is based on the coupon issue information 82 and the like. The number of coupons 905 is the number of coupons provided to the customer attribute set 901.

  The specific example of FIG. 21 corresponds to the example of the customer attributes P, Q, and R of FIG. 20, and the rows with the identification numbers 900 of 0 to 12 indicate the number of customers in each set of the illustrated attributes. In particular, the rows with identification numbers 900 of s1 to s8 indicate information corresponding to the sets of s1 to s8 in FIG. The coupon issue support unit 62 may display the contents of the customer attribute analysis information 92 as shown in FIG. 21 on the screen. Thereby, the person in charge of a store can confirm the number of persons, the number of coupons, etc. for every set of each customer attribute with information on coupon cost. The customer attribute analysis information 92 may comprehensively calculate a set of combinations of a plurality of customer attributes as in the example of FIG.

[Effects]
As described above, according to the coupon issuance support system of the present embodiment, the coupon issuance support function provides a comprehensive effect such as sales promotion including customer collection and profits by issuing coupons to suitable customers by the store. Can be increased. The coupon issue support function accumulates coupon performance information including the issued number and used number of issued coupons in the DB, and calculates the coupon cost using this information. With the coupon issue support function, the person in charge of the store can easily check the coupon cost according to the setting of the coupon information related to the issue of the coupon to the group of customers at the store on the screen. The person in charge of the store can easily consider the coupon issuance conditions and contents according to the promotional budget. The person in charge of the store can easily review the conditions of existing coupons and adjust the conditions of new coupons.

  Depending on the coupon information including the coupon issuance conditions and contents, the effect of the coupon, for example, the coupon usage rate and the purchase unit price are different. Moreover, since the effect of a coupon changes according to coupon information, the value regarding the issue and operation of a coupon differs in the estimated value. In the conventional system, it is difficult to determine a target customer attribute, a discount rate, and the like of the coupon according to the sales promotion budget, and there is room for improvement in the effect and cost of the coupon. On the other hand, since this embodiment provides a coupon issue support function, it is easy to determine the target customer attribute, discount rate, etc. of the coupon to a suitable value according to the promotion budget, and the effect and cost of the coupon can be improved. .

  As mentioned above, the invention made by the present inventor has been specifically described based on the embodiment. However, the present invention is not limited to the embodiment, and various modifications can be made without departing from the scope of the invention. Needless to say.

  The present invention can be used for coupon business.

  DESCRIPTION OF SYMBOLS 1 ... Customer, 2 ... Member store, 3 ... Coupon company, 4 ... Credit card company, 5 ... Communication network, 10 ... User terminal, 20 ... Client terminal, 31 ... Coupon server, 32 ... Customer information server, 41 ... Settlement server, 42 ... Usage details server, 51 ... Coupon DB, 52 ... Customer information DB, 53 ... Settlement information, 54 ... Usage details information, 61 ... Coupon management unit, 62 ... Coupon issue support unit, 63 ... Setting unit, 64 ... Screen providing unit, 71 ... Promotion budget information, 72 ... Coupon cost information, 73 ... Adjustment information, 74 ... Usage rate information, 75 ... Recommended information, 81 ... Issuance condition information, 82 ... Coupon issuance information, 83 ... Coupon use information 91 ... Customer attribute definition information, 92 ... Customer attribute analysis information, 93 ... Customer purchase information, 94 ... Purchase unit price information, 111 ... Issue condition setting part, 112 ... Issue part, 113 ... Use part, DESCRIPTION OF SYMBOLS 20 ... Range setting part, 121 ... Promotion budget setting part, 122 ... Coupon expense calculation part, 123 ... Adjustment part, 124 ... Usage rate calculation part, 125 ... Recommendation part, 221 ... Customer information management part, 222 ... Customer attribute analysis part 223, customer purchase information management unit, 224, purchase unit price information, D1, coupon information, D2, customer information, d1, d2, d3, coupon.

Claims (10)

A coupon issuance support system that supports issuance of a coupon for issuing a coupon to a customer of the member store based on an instruction from the member store,
A coupon information input unit for performing processing of inputting coupon information for designating an application target and an issue target customer of a coupon issued to the customer;
A customer information storage unit for storing customer information including customer attributes for a plurality of customers of the member store;
A coupon cost calculation unit that selects a customer to be issued to issue the coupon using the coupon information and the customer information, and performs a calculation for estimating a coupon cost that is a cost related to the issue of the coupon;
A coupon issue support system. In the coupon issue support system according to claim 1,
For issued coupons, it has a coupon record storage unit that holds coupon record information for specifying the application target, issued number of issued sheets, used number of used sheets, and customer to be issued,
The coupon information includes information on a discount rate for the application target,
The coupon cost calculation unit calculates the coupon cost by using the number of customers to be applied, the discount rate of the coupon, and the value of the number of used sheets with respect to the issued number stored in the coupon record storage unit. A coupon issue support system. In the coupon issue support system according to claim 1,
Based on an operation from the terminal of the member store, a promotion budget setting unit that sets at least one of an upper limit value or a lower limit value of the promotion cost as a condition of the promotion budget of the member store,
A coupon issuance support system that compares the promotion budget condition of the member store with the coupon cost, and obtains information including a result of the comparison. In the coupon issue support system according to claim 1,
Has a usage rate calculator,
The usage rate calculation unit obtains information indicating a coupon usage record by a customer at the member store from a terminal of the member store or a server of a settlement operator, and uses the information to calculate the number of issued cards. Coupon issuance support system that calculates the number of used sheets. The coupon system according to claim 1,
Have a purchasing unit price calculator,
The purchase unit price calculation unit obtains information indicating a purchase result of a product by a customer at the member store from a terminal of the member store or a server of a settlement operator, and uses the information to obtain information at the member store. Calculate the unit cost of purchasing a product by a customer,
The coupon cost calculation unit is a coupon issue support system that calculates the coupon cost using the purchase unit price. In the coupon issue support system according to claim 3,
Having an adjustment section,
The adjustment unit creates proposed coupon information for changing a discount rate of the coupon so that the coupon cost satisfies the promotion budget condition when the coupon cost does not satisfy the promotion budget condition, A coupon issue support system that adopts and saves the proposed coupon information based on selection from a member store. In the coupon issue support system according to claim 3,
Having an adjustment section,
If the coupon cost does not satisfy the condition of the promotional budget, the adjustment unit may change the coupon information of the proposal to change the customer attribute of the customer to be issued the coupon so that the coupon cost satisfies the condition of the promotional budget. A coupon issue support system that creates and saves the proposed coupon information based on the selection from the member store. In the coupon issue support system according to claim 3,
Having an adjustment section,
The adjustment unit creates coupon information of a plurality of proposals with different coupon costs so that the coupon costs satisfy the conditions of the promotion budget when the coupon costs do not satisfy the conditions of the promotion budget, and selects from the member stores Coupon issue support system that adopts and saves the proposed coupon information based on the above. In the coupon issue support system according to claim 7,
The coordinator may issue the coupon by adding a logical condition of another customer attribute to the customer attribute of the customer to be issued based on a logical analysis of a customer attribute unit customer in the customer of the member store. A coupon issue support system for creating coupon information of the proposal in which the number of customers corresponding to the customer attribute of the target customer is increased or decreased. In the coupon issue support system according to claim 1,
A coupon issue support system comprising: a range setting unit that specifies a target and a range of processing for calculating the coupon cost based on an instruction from the member store in terms of a store, a period, a coupon, and a customer attribute.

Images