JP5463125B2 - Customer information management server and customer information management program - Google Patents

Description

  The present invention relates to a customer information management server for managing customer information including purchase history information indicating a purchase history of a product purchased by a customer, and a customer information management program.

  Conventionally, various customer information management systems that accumulate and manage customer information of customers who have purchased products have been proposed (see, for example, Patent Document 1). By using such a customer information management system, sales and sales activities can be carried out smoothly.

JP 2009-181156 A

  However, in the conventional customer information management system, there is a problem that various behaviors of consumers, who are customers, are converted into data and bundled with a certain tendency, and cannot be properly arranged as sales targets of new products.

  Specifically, if you decide to narrow down behavior data that contains various behaviors of consumers under many conditions, you can narrow down to consumers who are suitable for sales, but sales There was a problem that the economic efficiency was lowered due to the decrease in volume.

  SUMMARY OF THE INVENTION An object of the present invention is to solve the above-described problems and to properly grasp customer information by properly organizing customer information and to be a sales target of a new product.

The customer information management server of the present invention is a customer information management server for managing customer information including purchase history information indicating a purchase history of a product purchased by a customer, the customer information storage means for storing the customer information, and a new Competing product specifying information receiving means for receiving competing product specifying information capable of specifying a product competing with the product, and referring to the purchase history information, the product of the product indicated by the competing product specifying information received by the competing product specifying information receiving means A purchase frequency calculating means for calculating a purchase frequency for each customer, and the purchase history information is referred to, and a product category different from the product indicated by the competitive product specifying information received by the competitive product specifying information receiving means is purchased. and the shop stay prediction time calculating means for calculating the total number of product categories of goods as stores stay prediction time you are, calculated by the purchase frequency calculation means And purchase frequency, which, by using the the shop stay prediction time calculated shop stay prediction time calculated by means, ranking value calculating means for calculating a ranking value for each customer that shows the proper degree as a sales target of new products A ranking table generating means for generating a ranking table in which the customers are arranged in order from the highest ranking value calculated by the ranking value calculating means, and a ranking for outputting the ranking table generated by the ranking table generating means And a table output means.

  With the above configuration, customer information can be properly organized to accurately grasp customers who are the target of sales of new products.

  Request level calculation means for calculating the number of purchases of products in the same product category as the product indicated by the competitive product specification information received by the competitive product specification information reception means with reference to the purchase history information as the request level of new products. In addition, the ranking value calculation unit may be configured to calculate a ranking value using the request level calculated by the request level calculation unit.

  A search target period receiving unit that receives a search target period may be included, and purchase history information within the search target period may be referred to in the purchase history information.

  The ranking table generating means may be configured to generate a ranking table in which each customer is arranged in order from the highest ranking value calculated by the ranking value calculating means up to a predetermined upper limit number.

  The competing product specifying information receiving means receives competing product specifying information from a user terminal via a communication network, and a ranking table output means gives the ranking table generated by the ranking table generating means to the user terminal. You may be set as the structure transmitted via a communication network.

  The purchase history information includes, for example, product specifying information that can specify a purchased product, a product category of the purchased product, and a purchase date and time of the purchased product.

The customer information management program of the present invention is a customer information management program for managing customer information including purchase history information indicating purchase history of a product purchased by a customer, wherein the product competes with a new product on a computer. In the competitive product identification information receiving process, referring to the competitive product identification information receiving process for receiving the competitive product specifying information that can identify the customer information and the purchase history information stored in the customer information storage means for storing the customer information. The purchase frequency calculation process for calculating the purchase frequency of the product indicated by the received competitive product specification information for each customer, and the competitive product specification information received by the competitive product specification information reception process with reference to the purchase history information Store stay prediction time calculation processing for calculating the total number of product categories of the purchased product among product categories different from the product as store visit prediction time , And purchase frequency calculated in the purchase frequency calculation process, by using the store stay prediction time calculated in the store stay prediction time calculation process, each customer a ranking value that indicates the proper degree as a sales target of new products A ranking value calculation process to calculate for each, a ranking table generation process to generate a ranking table in which each customer is arranged in order from the highest ranking value calculated in the ranking value calculation process, and the ranking table generation process This is for executing a ranking table output process for outputting the generated ranking table.

  According to the present invention, customer information can be appropriately arranged to accurately grasp customers who are sales targets of new products.

It is a block diagram which shows the example of a structure of the customer information management system in one embodiment of this invention. It is explanatory drawing which shows the example of customer information. It is explanatory drawing which shows the example of purchase history information. It is a flowchart which shows the example of a ranking table provision process. It is explanatory drawing which shows the example of a ranking table request | requirement screen. It is explanatory drawing which shows the example of a ranking table display screen.

Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
FIG. 1 is a block diagram showing an example of the configuration of a customer information management system 100 according to an embodiment of the present invention. As shown in FIG. 1, the customer information management system 100 includes a customer information management server 10 and user terminals 21 to 2N (N: any positive integer).

  The customer information management server 10 and the user terminals 21 to 2N are respectively connected to a communication network 30 such as the Internet.

  The customer information management server 10 is a server managed by a system administrator of the system 100, for example, and is configured by an information processing apparatus such as a WWW server. The customer information management server 10 includes a customer DB 11 in which customer information, which is various information related to customers, is stored. The customer DB 11 may be inside or outside the customer information management server 10.

  The user terminals 31 to 3N are managed by, for example, a user of the system 100 who desires to obtain a sales target customer list indicating a list of customers suitable for being a sales target of a new product. It is configured by an information processing device such as a communication terminal. This user corresponds to, for example, a product manufacturer or a product seller.

  FIG. 2 is an explanatory diagram illustrating an example of customer information stored in the customer DB 11. As shown in FIG. 2, the customer information includes a customer name indicating the customer's name, a customer ID assigned to uniquely identify the customer, purchase history information described later, and the customer's age (here, age). Classification) and customer address.

  FIG. 3 is an explanatory diagram illustrating an example of purchase history information included in customer information of each customer. FIG. 3 shows purchase history information of the customer A. The purchase history information is information indicating the purchase history of the product by the corresponding customer. As shown in FIG. 3, the purchase history information indicates the name of the store where the product is purchased for each purchase unit (for example, payment unit at the cash register). Indicates the store name to be displayed, the purchase area indicating the area in which the store exists, the purchase date and time when the product was purchased, the product name indicating the name of the purchased product, the product code assigned to the purchased product, and the category of the purchased product Includes various information such as product categories. Note that other information such as the price of the product may be included.

  “Purchase history information” is, for example, information that is added and updated each time a certain customer makes a purchase. Specifically, first, when a certain customer makes a purchase, information regarding a product purchased at a store terminal installed in the store by a cashier or information (for example, customer ID) that can identify the customer is input. The Next, customer information including information related to the purchased product and information that can identify the customer is transmitted from the store terminal to the customer information management server 10 via the store server. Then, the customer information management server 10 performs processing for adding the received purchase information as purchase history information of the customer. The customer information management server 10 receives and receives purchase information when purchasing a product at a product sales site established on the communication network 30 from the server device operating the product sales site. You may make it perform the process which adds purchase information as purchase history information of an applicable customer.

Next, the operation of the customer information management system 100 of this example will be described.
FIG. 4 is a flowchart showing an example of ranking table provision processing executed by the customer information management server 10 in the customer information management system 100 of this example. Here, in response to a ranking table acquisition request from the user terminal 21 based on the operation of the user X, the customer information management server 10 generates a ranking table as a sales target customer list for the new product G and provides it to the user terminal 21 Will be described as an example. It should be noted that explanations may be omitted except for processing particularly related to the present invention.

  In the ranking table providing process, first, when the customer information management server 10 receives access from the user terminal 21, the customer information management server 10 generates a ranking table request screen and transmits it to the user terminal 21. When the user terminal 21 receives the ranking table request screen from the customer information management server 10, the user terminal 21 displays the received ranking table request screen on its own display device.

  In the ranking table request screen, for example, as shown in FIG. 5, an input area 101 for receiving the input of the most competitive product that most competes with the new product G, and an input of a search target period indicating a period to be searched for history information are input. An input area 102 to be accepted and an OK button 103 to be pressed when requesting a ranking table are provided.

  The user terminal 21 displays the product name (may be a product ID) of the most competitive product of the new product G input by the input operation by the user X of the input device provided in the input area 101 on the ranking table request screen. Then, the input search target period is displayed in the input area 102 on the ranking table request screen. In the example shown in FIG. 5, chocolate A is displayed as the product name of the most competitive product, and the period from April 2009 to November 2009 is displayed as the search target period.

  When the OK button 103 is pressed after the most competitive product and the search target period are input, the user terminal 21 sends a ranking table acquisition request indicating the most competitive product and the search target period to the customer information management server 10. To send.

  When receiving the ranking table acquisition request, the customer information management server 10 receives the most competitive product and the search target period presented in the ranking table acquisition request (steps S101 and S102).

  Next, the customer information management server 10 refers to the customer information stored in the customer DB 11 and uses the purchase history information included in the customer information for each customer to receive the most competitive product received in step S101. The purchase frequency is calculated (step S103). In this example, the purchase frequency (for example, the number of purchases per week, the number of purchases per day, etc.) of the most competitive product within the search target period received in step S102 is calculated.

  Next, the customer information management server 10 refers to the customer information stored in the customer DB 11, and uses the purchase history information included in the customer information for each customer to find the most competitive product received in step S101. Of the other products purchased at the time of purchase, the number of purchases of products classified in the same product category as the most competitive product is calculated as the required degree (step S104). The “request level” indicates the degree of purchase request for a product in the product category based on the number of products purchased in the same product category as the most competitive product (that is, the same product category as the new product). In this example, the total number of products purchased in the same product category as the most competitive product within the search target period received in step S102 is calculated as the request level.

  Next, the customer information management server 10 refers to the customer information stored in the customer DB 11, and uses the purchase history information included in the customer information for each customer to find the most competitive product received in step S101. Of the other products purchased at the time of purchase, the number of product categories of products classified in a product category different from the most competitive product is calculated as the store residence prediction time (step S105). Generally, in a store, products in the same product category are displayed on the same product display shelf or a product display shelf in a nearby location, so that the store residence time can be predicted by the number of categories of purchased products. Therefore, in this example, the total number of product categories of products classified in the product category different from the most competitive product within the search target period received in step S102 is calculated as the store residence prediction time.

  Note that the processes of steps S103 to S105 described above may be performed in any order, and may be performed collectively.

  When the processing of steps S103 to S105 is completed, the customer information management server 10 performs each calculation operation using the purchase frequency, the degree of request, and the estimated store residence time for each customer calculated in steps S103 to S105. A ranking value for the customer is calculated (step S106). The predetermined calculation processing, for example, calculates the product of the sum of the purchase frequency, the request level, and the estimated store residence time, the purchase frequency, the request level, and the estimated store residence time (for example, a product with a separate proportionality constant). This is a process for calculating the sum after performing.

  Specifically, when the sum of the purchase frequency, the request degree, and the store residence prediction time is set as the ranking value, the purchase frequency is 35, the request degree is 85, and the store residence prediction time is 30 for the customer P. The ranking value of the customer P is 150.

  When the ranking value for each customer is calculated, the customer information management server 10 generates a ranking table in which the customer names of the customers are arranged in descending order of the calculated ranking value (step S107).

  And the customer information management server 10 produces | generates the ranking table display screen which displays the ranking table produced | generated in step S107 (step S108), and transmits to the user terminal 21 via the communication network 30 (step S109). .

  When the user terminal 21 receives the ranking table display screen from the customer information management server 10, the user terminal 21 displays the received ranking table display screen on its own display device.

  For example, as shown in FIG. 6, the ranking table display screen includes a display area 201 for displaying the most competitive product designated by the user X, a display area 202 for displaying the search target period designated by the user X, and a ranking. A display area 203 for displaying a table and an OK button 204 that is pressed when the display of the ranking table display screen is ended are provided. Chocolate A is displayed as the product name of the most competitive product, and the period from April 2009 to November 2009 is displayed as the search target period.

  For example, as shown in FIG. 6, the ranking table is a sales target customer list for the new product G, and the sales target customer information including the customer name, customer ID, and ranking value for each customer is the ranking value. It is a table arranged in high order. The sales target customer information may include other customer information in addition to the customer name, customer ID, ranking value, ranking value ranking. In addition, the sales target customer information of all customers may be arranged in the ranking table. For example, the sales target customers of the customers whose ranking values are from the top to a predetermined number (for example, up to 10000, up to 50000) Information may be arranged.

  As described above, a ranking table which is a sales target customer list for a new product is generated and provided. This ranking table is effective for sales for the sale of a specific new product because each customer is arranged in the order in which the degree of suitability for a specific new product is high. It can be expected to be used.

  In the above example, three values of the purchase frequency, the request level, and the predicted store residence time are used for calculating the ranking value. However, any one of the purchase frequency, the request level, and the predicted store residence time can be selected. One or two values may be used for calculating the ranking value.

  In the above example, a ranking table is generated and output (output to the communication network 30) in response to a request from the user terminal 21, but a request by an input operation of an operator who operates the customer information management server 10 is used. A ranking table may be generated and output (output to a display device included in the device) according to the above.

  As described above, in the above-described embodiment, the customer information management server 10 that manages the customer information including the purchase history information indicating the purchase history of the product purchased by the customer stores the customer DB 11 that stores the customer information. Preparation, receiving competitive product identification information (for example, the product name and product ID of the most competitive product) that can identify a product that competes with the new product, referring to the purchase history information, and purchasing the product indicated by the received competitive product identification information The frequency is calculated for each customer, and using the calculated purchase frequency, a ranking value indicating the appropriateness of the new product as a sales target is calculated for each customer, and each customer is ranked in descending order of the calculated ranking value. The configuration is such that the ranking table is generated and the generated ranking table is output, so that customer information can be properly organized to accurately grasp the customers who are the target of sales of new products. Uninaru.

  That is, the customer information management server 10 refers to the purchase history information, calculates the ranking value for each customer using the purchase frequency of the product indicated by the competitive product specifying information, and sequentially calculates the ranking value from the highest ranking value. Since it is configured to generate and output a ranking table that arranges customers, sales are performed using a ranking table that properly organizes customer information by collecting the appropriate customers as sales targets for new products in the order of their appropriateness. It becomes possible to carry out activities, and it becomes possible to accurately grasp the customers who are the target of sales of new products.

  In the above-described embodiment, the customer information management server 10 refers to the purchase history information, and calculates the number of purchases of the product in the same product category as the product indicated by the received competitive product specifying information as the request level of the new product. And since it was set as the structure which calculates a ranking value also using the calculated request | requirement degree, it becomes possible to produce | generate the ranking table which arranged customer information more appropriately also considering the request | requirement degree.

  In the above-described embodiment, the customer information management server 10 refers to the purchase history information, and stores the total number of product categories of products purchased out of the product categories different from the products indicated by the received competitive product specifying information in the store. Calculated as predicted stay time, and the calculated store stay time is also used to calculate the ranking value, so that a ranking table can be generated that better organizes customer information, taking into account predicted store stay time. Is possible.

  In the above-described embodiment, the customer information management server 10 receives the search target period and refers to purchase history information within the search target period in the purchase history information. Accordingly, it is possible to generate a ranking table in which customer information is arranged more appropriately.

  In the above-described embodiment, when the customer information management server 10 is configured to generate a ranking table in which each customer is arranged up to a predetermined upper limit in order from the highest ranking value calculated. The number of customers to be listed in the ranking table can be narrowed down, and even when the total number of customers is enormous, it is possible to generate a ranking table in which customer information is properly arranged.

  Although not particularly mentioned in the above-described embodiment, the customer information management server 10 constituting the customer information management system 100 is in accordance with a processing program (customer information management program) stored in a storage medium included in the customer information management server 10. The various processes described above (see FIG. 4) are executed.

  According to the present invention, it is useful for properly grasping customers who are targeted for sales of new products by properly organizing customer information.

10 Customer Information Management Server 11 Customer DB
21 to 2N user terminal 30 communication network 100 customer information management system

Claims (12)

A customer information management server for managing customer information including purchase history information indicating purchase history of products purchased by a customer,
Customer information storage means for storing the customer information;
A competitive product identification information receiving means for receiving competitive product identification information capable of identifying a product that competes with the new product;
Referring to the purchase history information, a purchase frequency calculating means for calculating the purchase frequency of the product indicated by the competitive product specifying information received by the competitive product specifying information receiving means for each customer;
With reference to the purchase history information, the total number of product categories of products purchased out of the product categories different from the products indicated by the competitive product specification information received by the competitive product specification information receiving means is calculated as the estimated store stay time. Means for calculating estimated store stay time;
Using the purchase frequency calculated by the purchase frequency calculation means and the predicted store stay time calculated by the store stay prediction time calculation means , a ranking value indicating the appropriateness of the new product as a business target is determined for each customer. Ranking value calculating means for calculating
Ranking table generating means for generating a ranking table in which each customer is arranged in order from the highest ranking value calculated by the ranking value calculating means;
A customer information management server, comprising: a ranking table output unit that outputs the ranking table generated by the ranking table generation unit. Request level calculation means for calculating the number of purchases of products in the same product category as the product indicated by the competitive product specification information received by the competitive product specification information reception means with reference to the purchase history information as the request level of new products. Including
The customer information management server according to claim 1, wherein the ranking value calculation means calculates a ranking value also using the request degree calculated by the request degree calculation means. Including a search target period receiving means for receiving a search target period,
The search referring to the purchase history information in the period and to the claim 1 or claim 2 Symbol placing customer information management server of the purchase history information. The ranking table generating means, in order from the Index value is high, which is calculated by the Index value calculation means, from the claims 1 to generate a ranking table having an array of each customer to the upper limit number of predetermined according to claim 3 The customer information management server described in any one of them. The competing product specifying information receiving means receives competing product specifying information from a user terminal via a communication network,
The ranking table output means, the customer information management server according to any one of claims 1 to 4 for transmitting a ranking table generated by the Index table generating means through the communication network to the user terminal . The customer according to any one of claims 1 to 5 , wherein the purchase history information includes product specifying information for specifying a purchased product, a product category of the purchased product, and a purchase date and time of the purchased product. Information management server. A customer information management program for managing customer information including purchase history information indicating a purchase history of a product purchased by a customer,
On the computer,
Competing product identification information receiving process for receiving competing product identification information that can identify products that compete with the new product,
Referring to the purchase history information stored in the customer information storage means for storing the customer information, the purchase frequency of the product indicated by the competitive product specifying information received in the competitive product specifying information receiving process is calculated for each customer. Purchase frequency calculation processing,
With reference to the purchase history information, the total number of product categories of products purchased out of the product categories different from the products indicated by the competitive product specification information received in the competitive product specification information reception process is calculated as the estimated store stay time. Store stay prediction time calculation processing,
Using each of the purchase frequency calculated in the purchase frequency calculation process and the predicted store stay time calculated in the store stay predicted time calculation process , a ranking value indicating the appropriateness of the new product as a business target is set for each customer. Ranking value calculation processing to be calculated,
A ranking table generation process for generating a ranking table in which each customer is arranged in order from the highest ranking value calculated in the ranking value calculation process;
A customer information management program for executing ranking table output processing for outputting the ranking table generated by the ranking table generation processing. On the computer,
Furthermore, referring to the purchase history information, a request degree calculation that calculates the number of purchases of products in the same product category as the product indicated by the competitive product specification information received in the competitive product specification information reception process as the request level of the new product Let the process run,
The customer information management program according to claim 7, wherein in the ranking value calculation process, a process for calculating a ranking value is executed also using the request degree calculated in the request degree calculation process. On the computer,
Furthermore, the search target period receiving process for receiving the search target period is executed,
The purchase history information said search target period in the purchase history information referenced to it with claims 7 or claim 8 Symbol mounting customer information management program of the. In the ranking table generation processing, in order from the Index value higher calculated in the Index value calculation process, from the claims 7 to execute a process of generating a ranking table having an array of each customer to the upper limit number of predetermined The customer information management program according to claim 9 . In the competitive product identification information reception process, a process of receiving competitive product identification information from the user terminal via the communication network is executed,
The ranking table output process, according to any one of claims 10 ranking table generated by the ranking table generation process of claims 7 to execute the process of transmitting through the communication network to the user terminal Customer information management program. The customer according to any one of claims 7 to 11 , wherein the purchase history information includes product specifying information for specifying a purchased product, a product category of the purchased product, and a purchase date and time of the purchased product. Information management program.

Images