JP2003076709A - Method for extracting customer data - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a method that enables a user to easily extract a customer, who may buy a specific product or service, from a customer information database without having any specific knowledge for retrieval conditions. SOLUTION: A method does not set any item but a selection column and a button on a screen of an operation display 3002 so that a user can use all functions by the only selecting operation. The method displays a convenient figure the user intuitively understands on the screen and enables the user to obtain a table, which lists customers who have high potentialities to purchase products or services in an order of purchasing probability, by simply selecting an 'object' for product or service for which customers are recommended to purchase, a 'condition item number' to define a range for extracting targeted items, contents of a 'condition' for each condition item, and a 'conditional range for customers' that shows the products or services for which the customers are recommended to purchase.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention makes it possible to extract the data most suitable for the purpose desired by a user from a database without requiring the user to have any special knowledge other than how to read a Venn diagram. Data extraction method.

[0002]

2. Description of the Related Art In recent years, data mining, data analysis,
Information processing systems or software packages that support various analysis methods such as cross analysis, trend analysis, and rule analysis have become widespread. However, the above-mentioned information processing system or software package provides many functions in order to have versatility. Therefore, the operation method or operation procedure is slightly complicated, and in some cases the user may have a certain level. May require knowledge and know-how. For example, when a company wants to select the most suitable customer for recommending a specific product or service to a customer, when the software package as described above is used, the user side has a unique operation method of the software package. In some cases, the target customer can be extracted only after acquiring a certain level of knowledge and know-how for extracting the optimum customer.

Further, focusing on the method of conditional search, in the conventional method, for example, as found in a search engine on the Internet, "condition items" and ">" for extracting desired data from a combo box. <"
It is possible to perform a search by designating search conditions by selecting equal signs, big and small symbols such as “=” and logical expressions such as “AND” and “OR”. Alternatively, there are sites on the Internet that can be searched using special symbols such as “|” and “&” instead of selecting “AND” and “OR”.

Further, focusing on an example of a method or system for performing a condition search using a Venn diagram, Japanese Patent Laid-Open No. 8-166
As described in “Database Inquiry System Using Venn Diagram” in JP 07 publication, a condition field is provided on the inquiry window, a search condition expression is input in the condition field, and a Venn diagram is provided according to the number of search condition expressions. Is known on the inquiry window, and a part of the closed area of the drawn Venn diagram is clicked with a mouse to display a data list satisfying the conditions of the closed area of the Venn diagram on the screen. As another example of performing a condition search using a Venn diagram, the user himself / herself draws a Venn diagram and a logical expression on the screen as described in "Database Search Method" in Japanese Patent Laid-Open No. 9-81575. A method for performing a conditional search is known. In addition, JP-A-6-3017
With the technique disclosed in the "database search device" of Japanese Patent Publication No. 35-35, in a database search, a search expression input by a user can be analyzed to generate a Venn diagram representing a join condition of the search expressions. Also, when the user inputs only the search condition as a part of the search formula, a Venn diagram is generated according to the search logic, and the user selects an area of the Venn diagram.
A search formula intended by the user can be generated.

[0005]

In the case of the above-mentioned conventional technique, an information processing system or software package that supports various analysis methods such as data mining, data analysis, cross analysis, trend analysis and rule analysis is used. hand,
For example, when a company wants to extract the best customer to recommend a particular product or service to the customer, the user side has a unique operation method of the software package and, in some cases, the best customer. It is necessary to acquire a certain level of knowledge and know-how in advance.

On the other hand, in the condition search method, in the above-described search engine example, the user needs to remember beforehand the grammar of an original expression for condition search for each site on the Internet that provides the search engine.

Further, in the "database search method" of Japanese Unexamined Patent Publication No. 9-81575, in which information is searched using a Venn diagram, a search condition expression for the user to search by himself is provided in a Venn diagram display area drawn by the user. Need to fill in. In the technique disclosed in Japanese Patent Laid-Open No. 6-301735, it is necessary for the user to specify the search condition expression for searching. Also in the example of Japanese Patent Application Laid-Open No. 8-16607, the user first has to input the search condition expression in order to draw the Venn diagram, and the user must remember the method of describing the search condition expression in addition to the knowledge of the Venn diagram. Must be side dish.

[0008] As described above, a search engine on the Internet, JP-A-9-81575, and JP-A-6-30173.
Although the examples of the techniques of the examples of Japanese Patent Laid-Open No. 5 and Japanese Patent Laid-Open No. 8-16607 have been described, the knowledge of the search condition expression is required at least in any method, and the item name that can be used for further searching is given. It is necessary to remember in advance.

An object of the present invention is to focus on business for extracting customers who are likely to be able to provide a specific product or service in a business entity such as a company or a store that provides the product or service, and how to read a Venn diagram. With the knowledge of, it is to provide a means for extracting customers in the order in which they are most likely to purchase a particular product or service.

[0010]

In order to achieve the above object, the present invention focuses on a business for extracting customers who are highly likely to be able to provide goods or services, and searches for conditions related to the business in advance. The condition items are incorporated in the system, and the number of condition items in the Venn diagram is limited to the range of 2 to 4, and the user himself / herself shows it on the screen without drawing the Venn diagram and draws it in the Venn diagram shown on the screen. The method is such that the user can select and specify the two, three, or four condition items that are present from the item candidates. Also, on the Venn diagram shown on the screen, the user can specify which closed area the customer wants to target, and further specify one or more closed areas. By selecting a product or service to be provided as a product, a method for searching, sorting, and displaying a list of customers in descending order of possibility of providing the product or service is provided.

According to this method, when the user wants to provide a particular product or service without having any knowledge other than how to read a Venn diagram, the probability that a customer who has a high probability of purchasing the product or service is You will be able to extract in order. For example, even if the person in charge of using this system is transferred, there is an advantage that the number of man-hours for taking over the work is hardly generated.

That is, the method of extracting customer data according to the present invention is a method of extracting desired customer data from a customer information database in which information about customers is accumulated, and a step of inputting the number of condition items for extracting customer data, The steps of displaying a Venn diagram combining a number of circles corresponding to the number of condition items on the display screen, associating the contents of the condition items with each circle of the Venn diagram, and the conditions of customers who recommend purchasing products or services The step of specifying by the area on the Venn diagram, and the step of, for each customer, using the customer information database, obtaining the probability that a customer belonging to the specified area on the Venn diagram will move to the target area on the Venn diagram satisfying all the condition items. , A list of information about customers belonging to a specified area on the Venn diagram and the probability of the customer is displayed together. Characterized in that it comprises a step. The extracted customer information may be sorted and displayed in descending order of probability.

In the above customer data extraction method, the customer information database has a bitmap table in which a plurality of attribute values representing information about each customer are represented by 0 or 1, and a pattern representing the arrangement of bits in the bitmap table ( Information for grouping customers by a bitmap pattern), and for each customer group having the same bitmap pattern, the first number of customers belonging to a designated area on the Venn diagram and the first number of customers belonging to the target area on the Venn diagram. Two
The ratio of the second number of customers to the sum of the number of customers can be obtained, and the ratio can be the probability of the customers having the bitmap pattern. The customer data extraction method of the present invention may include a step of correcting the probability based on information unique to each customer.

[0014]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described in detail below with reference to the drawings. FIG. 1 shows an example of a block diagram of a system for implementing the method. Figure 1
, 1001 is a system unit of the computer A,
Reference numeral 1002 denotes a CPU device which is a component of the computer A, 1003 a database managed by the computer A, 1004 a network for exchanging information between the computer A and the computer B, 1007 a system device of the computer B, and 1005 a configuration of the computer B. Reference numeral 1006 is an input device which is a component of the computer B, 1008 is a CPU device which is a component of the computer B, and 1009 is a database managed by the computer B. The minimum configuration of the system for implementing the method of the present invention is the computer B (10 in FIG.
It is a stand-alone configuration of only 07). In this case, the database that stores the customer information is 1009, and the data extraction process is performed in the CPU device 1008. However, in the case of the stand-alone configuration, the data input unit for performing registration of new customer information, accumulation of customer contact history information, addition / update processing of customer attribute information, etc. is the input device (1006) of the computer B. ) Will be done only from.

On the other hand, the standard configuration of the system for implementing the method of the present invention is a client-server configuration in which computer A and computer B in FIG. 1 are connected by a network. In FIG. 1, computer A (100
1) becomes a database server, and computer B (1
007) is the client computer. In this case, there may be a plurality of client computers equivalent to the computer B, and they may be connected to the computer A (1001), which is a server, via the network 1004. A database that stores customer information is stored in the database 1003 shown in FIG. In the case of the client server configuration, the computer B (1007) issues a search request to the computer A (1001), which is a server, via the network, and the server side performs customer condition search and customer extraction processing according to the search request, As a result, the computer B (10
07) via the network. The computer B (1007) receiving the result information displays the result information on the result list screen.

FIG. 11 shows an example of the table structure of the customer information table 11001 stored in the database for storing customer information. The customer information table 11001 includes a customer ID, a customer name, a pattern number,
Data items such as attribute 1, attribute 2, attribute 3, ... Are stored. This attribute group may take any form as long as it is an attribute item related to the customer, such as customer address, customer telephone number, salary transfer amount, customer birth date, customer age, and the like.

FIG. 13 is a diagram showing an example of a bitmap table 13001 for managing customer attributes stored in the customer information database as a bit information group. on the other hand,
FIG. 14 shows an example of a bit pattern number table 14001 for identifying an information group in which the attribute information of each customer is expressed as a bit pattern number. The bitmap table 13001 is the customer information table 1100.
The content of the customer attribute information registered in 1 is converted into a bit pattern, all the bitized attribute items are associated with the bit array for each customer, and the pattern number is given as the bit pattern, and the table The pattern number is stored in the "Pattern number" item.

Also, the bit pattern number table 14 of FIG.
Bit pattern numbers managed by 001 are shown in FIG.
Pattern number items in the customer information table 11001 shown in FIG. 13 and the bitmap table 13001 shown in FIG.
It is stored in the pattern number item in the table, and can be updated whenever the customer attribute is changed.

Customer information table 1100 shown in FIG.
1 and the contents of the “customer ID” data item stored in both the bitmap table 13001 shown in FIG. It doesn't matter.

Next, a screen example of the information processing system according to the present invention will be described. FIG. 2 shows an example of a menu screen on a display device for the user of the system to refer to in the system for implementing the present invention. In FIG. 2, reference numeral 2001 denotes a display frame on the display device (1005) of the computer B, and 2002 is an example of a menu screen displayed on the display frame. Reference numeral 2003 denotes a “1 target customer extraction” button which is the first menu item among the menus displayed on the menu screen.
Reference numeral 4 represents a second menu button which is a second menu item. Reference numeral 2005 also represents a third menu button, which is also the third menu item, and reference numeral 2006 in FIG. 2 represents an end button for ending the system.

When the "1 target customer extraction" button is pressed (or called as a click) from the screen shown in FIG. 2 with a pointing device such as a mouse, the screen changes to the goal setting screen shown in FIGS. 7 and 8. In FIG. 7, 7001 is a display device (1005) of the computer B.
Represents a display frame, and 7002 represents an example of a purpose setting screen. 7003 represents a combo box for purpose selection for the user of the system to set a purpose, 7004 is a “Next →” button for displaying the next screen to transition to the next screen, and 7005 ends the screen. Each shows a cancel button for returning to the menu screen.

FIG. 8 is the same screen as the screen shown in FIG. 7, but shows an example in which a selection item is opened in the purpose selection combo box on the screen. In FIG. 8, reference numeral 8001 denotes a display frame in the display device (1005) of the computer B, and 8
002 is an example of a purpose setting screen, and 8003 is a purpose selecting combo box, in which selection items are displayed from the combo box. Reference numeral 8004 denotes a “next →” button for displaying the next screen for transition to the next screen, and 8005 denotes a cancel button.

In the screen shown in FIG. 7 or FIG. 8, after the purpose is selected in the combo box indicated by 7003 in FIG. 7 or 8003 in FIG. 8, 7004 in FIG. 7 or 800 in FIG.
When the “Next →” button shown by 4 is pressed (or clicked) by a pointing device such as a mouse, the screen changes to the selection screen for the number of condition items shown in FIGS. 9 and 10.

In FIG. 9, 9001 is a computer B
The display frame of the display device (1005) of
Reference numeral 02 represents an example of a condition item number selection screen. 90
Reference numeral 03 denotes a condition item selection combo box for setting the number of condition items for the user of the system to search and extract a desired customer list. Or, "← Back" button for transition to previous screen for transition to Fig. 8), 9005 "Next →" button for next screen display to transition to next screen, 9006
Indicates a cancel button for ending the screen and returning to the menu screen.

FIG. 10 shows the same screen as the screen shown in FIG. 9, but shows an example in which a selection item is opened in the purpose selection combo box on the screen. In FIG. 10, 10001
Is a display frame on the display device (1005) of computer B, and 10002 is an example of a purpose setting screen.
Reference numeral 3 denotes a condition item selection combo box for setting the number of condition items for the user of the system to search and extract the desired customer list. The condition item selection combo box is selected from the combo box. Examples of displaying items are shown below. The condition items can be selected within a range of 2 or more and 4 or less. Reference numeral 10004 denotes a previous screen transition “← return” button for transitioning to the target setting screen (FIG. 7 or 8) which is the previous screen, and 10005 denotes a next screen display “next →” button for transition to the next screen. Reference numerals 10006 respectively indicate cancel buttons for ending the screen and returning to the menu screen.

After selecting an object in the combo box shown by 9005 in FIG. 9 or 10005 in FIG. 10, 9 in FIG.
When the "next->" button indicated by 005 or 10005 in FIG. 10 is pressed (or clicked) by a pointing device such as a mouse, 9005 in FIG.
No. 10005 shown in FIG. 3, FIG. 4, FIG. 5 or FIG. 25, FIG. 27, and FIG. Transit to group specification screen.

FIGS. 3, 25, 27, and 28 are examples of screens displayed when the user specifies 2 as the number of condition items. In FIGS. 3, 25, 27, and 28, 3001, 4001, 25001, 27001, 280
Reference numeral 01 denotes a display frame on the display device (1005 in FIG. 1) of the computer B, and 3002, 25002, 270.
02 and 28002 indicate an example of the target customer group designation screen for 2 condition items displayed when the number of designated condition items is 2 on the previous screen (FIG. 9 or FIG. 10). In each figure, combo boxes 3003 and 250
Reference numerals 03, 27003, and 28003 represent a population A selecting combo box for selecting a population that is a prerequisite for extracting a target customer from all the customers. Here, “population A” is a name used for convenience in the present invention. Therefore, when the system is actually realized, it may not be displayed or a description example such as “(select population)” may be displayed first in the combo box. Also, combo boxes 3004, 25004, 27
004, 27005 is the previous screen (FIG. 9 or 10)
Represents the combo box for selecting condition A, which is the first condition item of the two condition items designated by the user. Combo box 3005, 25006, 27005, 28
Reference numeral 005 represents a condition B selection combo box which is the second condition item of the two condition items designated by the user on the previous screen (FIG. 9 or 10). Here, "condition A" and "condition B" are names used for convenience in the present invention, as in the case described in "population A". Therefore, if you actually implement the system, it will not be displayed,
A description example such as “(selection of first condition)” or “(selection of second condition)” may be displayed first in the combo box.

In the screen of FIG. 3, reference numeral 3008 utilizes all three selection items of a population A selection combo box (3003), a condition A selection combo box (3004), and a condition B selection combo box (3005). This is a text box for displaying the number of search results for displaying the number of search results when the user selects and presses the search button indicated by 3009 to execute the search. Thirty
10 is for the next screen display to move to the next screen "Next →"
Buttons 3011 respectively indicate cancel buttons for ending the screen and returning to the menu screen.

FIG. 25 shows the population A on the screen of FIG.
Selection combo box 3003, condition A selection combo box 3004, condition B selection combo box 3005
7 shows an example of a screen when the user selects the three selection items. In FIG. 25, the combo box 250
In 03, the customer age is set as the population, and the user has already selected "customer age: 35 to 39 years old". FIG. 26 shows an example in which the selection items of the combo box 25003 are displayed.

In FIG. 26, reference numeral 26001 indicates a population A selection combo box, and 26002 indicates a pointer by a mouse cursor or a pointing device. As the selection item of the combo box, the customer age,
"18 to 24 years old", "25 to 29 years old", "30 years old to
34 years old, 35 years old to 39 years old, 40 years old to 44 years old,
"45-49", "50-54", "55-
In this example, the items "59 years old", "60 years old to 64 years old", and "65 years old or older" are displayed.

The selection items of the population are set in the system in advance, and the user selects the population within this range. In FIG. 3, the combo box 30 for selecting the population A
03, a combo box 3004 for selecting condition A, and a combo box 3005 for selecting condition B are selected by the user, the search button 3009 is pressed, and a screen example of the result of executing the search is shown in FIG. 27. .. On the screen of FIG. 27, in the range of “customer age: 35 to 39 years old” as a population (227003 in FIG. 27), of the two condition items, condition A is “with mortgage” and condition B is “car loan”. The user specifies "Yes" and the search button (Fig. 27
No. 27010) is pressed and the search result is displayed.

In 27006 of FIG. 27, the age is 35-3.
Among customers within the age range of 9 years, the number of customers who have applied for a mortgage and have not provided a car loan is displayed. In this figure, there are 235 customers who satisfy the condition.
It is shown that there are two. In 27007 of FIG. 27, the number of customers who are applying for a mortgage and are also providing a car loan among customers whose ages are in the range of 35 to 39 are displayed. This figure shows that there are 1042 customers who satisfy the condition. 27 of FIG.
In 7008, the number of customers who have not applied for a mortgage and who have a personal car loan among the customers aged between 35 and 39 is displayed. This figure shows that there are 6798 customers who satisfy the condition. In 27090 of FIG. 27, the number of customers who do not make a mortgage or a car loan among the customers in the age range of 35 to 39 are displayed. This figure shows that there are 22192 customers who satisfy the condition. In FIG. 27, reference numeral 27011 denotes a “next →” button for displaying the next screen for transition to the next screen, and 27012 denotes a cancel button for ending the screen and returning to the menu screen.

FIG. 28 is the same as FIG. 3 and FIG.
2 shows a target customer group designation screen for two condition items, but in particular, the screen shown as an example in which the user of the system wants to provide a specific product or service, that is, the region of the customer who wants to be targeted. Is an example of. The text box 28007 is 2700 in FIG.
The text box for displaying the number of search results that displays the number of customers who are the same as 8 and who do not apply for mortgage among customers who are in the range of 35 to 39 years old and who have a car loan Is. In 28006, among the customers whose ages are in the range of 35 to 39 years old, the user of the system indicates the area of the customer who has not applied for a mortgage and is making a car loan by pressing the Ctrl key +
By clicking the left mouse button, the state is designated as the range of customers to be targeted. It is shown in this figure that the area 28006 has been changed in color with respect to the surrounding area because the user of the system has designated it as a customer to be targeted. 28008 indicates a pointer by a mouse cursor or a pointing device. Also 28
Reference numeral 009 denotes a “next →” button for displaying the next screen for transition to the next screen, and reference numeral 28010 denotes a cancel button for ending the screen and returning to the menu screen.

As shown in FIG. 28, when the area of the customer to be targeted is designated by the user of the system, by pressing the “Next →” button 28090, the example of FIG. , That is, the screen for "Confirm target customer condition" screen for two condition items.
In FIG. 17, reference numeral 17001 indicates a display frame on the display device 1005 of the computer B, and reference numeral 17002 indicates the range of target customer conditions in the case where the number of condition items for determining the customer range targeted by the system user is two. 7 shows an example of a screen for the user to specify, that is, a "target customer condition confirmation" screen for two condition items. Reference numeral 17004 represents a Venn diagram display area for two condition items, 17005 represents a condition A, that is, a display area of the first condition content, and 17006 represents a condition B, that is, a display area of the second condition content. Reference numeral 17007 represents the target customer condition display area designated by the user of the system on the previous screen, and also in the Venn diagram display area 17004, the area designated by the user of the system on the previous screen (FIG. 28) (28006 of FIG. 28). Similar to the above), it is displayed in a color different from the surrounding area and inherits the specified area information.

An area 17003 is an area for displaying the designated condition of the target customer, and is an area for displaying the condition content of the target customer designated as an area by the user of the system on the previous screen (FIG. 28) as a sentence. . Again 17
Reference numeral 008 denotes a combo box for the user of the system to select what kind of product or service the customer wants to promote on the current screen. By default, the combo box is 700 in FIG. 7 and FIG.
The contents of the purpose selected in 3, 8003 are displayed. If the user of the system wants to change the purpose, this can be changed using the combo box 17008. Button 17009 is a “yes” button for executing customer extraction for executing customer extraction, button 1
Reference numeral 7009 denotes a "return" button and button 1 for transition to the previous screen for transitioning to the target customer group designation screen for two condition items (FIG. 28, FIG. 27, FIG. 25 or FIG. 3) which is the previous screen.
Reference numeral 7011 denotes a cancel button for ending the screen and returning to the menu screen. If the user of the system is
The content of the "purpose" shown in the 17008 combo box of FIG. 17 is judged "OK" and "Yes"
When the button 17009 is pressed, the screen example shown in FIG. 12 is entered, the system executes the customer search and extraction process, and the result is displayed as a list on the screen.

In FIG. 12, reference numeral 12001 denotes a display frame on the display device 1005 of the computer B, and 12
002 searches the customer who wants to be a target on the system side,
An example of a result list display screen that displays a list of extracted results is shown. An area 12003 is a condition of a customer who the user of the system wants to set as a target specified on the previous screen,
That is, an area for describing and displaying the condition of the population for extracting the customer who is the target as a text is displayed.
Reference numeral 004 represents an area for displaying the purpose designated by the user of the system on the previous screen. Area 12
Reference numeral 005 represents an area for displaying a list of results searched by the system based on the conditions specified by the user of the system, that is, a result list display area. Further, a button 12006 is a “print” button for printing a result list for printing the content of the result list 12005 displayed on the screen, and a button 12007 is a content of the result list 12005 displayed on the screen. Is displayed on the screen as a configuration graph, the “configuration graph” button for displaying the configuration graph, and the button 12008 are displayed on the previous screen (FIG. 17 when the number of condition items selected by the user of the system is 2, When the number of condition items selected by the user of the system is 3, it is shown in FIG. 16, and when the number of condition items selected by the user of the system is 4, FIG. The “button” and the button 12009 are “to menu screen” buttons for returning to the menu screen (FIG. 2).

In the screen of FIG. 12, when the "configuration graph" button 12007 for displaying the configuration graph is pressed,
The screen transitions to the configuration graph display screen 15002 shown in FIG. In FIG. 15, 15001 is a display frame in the display device 1005 of the computer B, and 15002 is the above-mentioned configuration graph display screen. In this screen example, the horizontal axis shows the number of bitmap patterns in the order of purchase probabilities of services or products, and the vertical axis shows the number of customers for each bitmap pattern. By referring to the graph shown on the screen 15002, the user of the system can know the success probability when a specific product or service is recommended to the customer and the distribution status for each probability. In FIG. 15, a button 15003 is a “return” button for returning to the result list display screen (FIG. 12) which is the previous screen.

By the way, in FIG. 4, when the purpose setting screen shown in FIG. 9 or FIG. Button (9005 in FIG. 9 or FIG. 10)
No. 10005) is displayed, an example of a target customer group designation screen for three condition items displayed.

In FIG. 4, a combo box 4003 is shown.
Represents a population A selecting combo box for selecting a population that is a prerequisite for extracting a target customer from all the customers. I repeat here, "Population A"
Is a name used for convenience in the present invention. Therefore, if you actually implement the system, it will not be displayed,
A description example such as “(select population)” may be displayed first in the combo box. A combo box 4004 represents a combo box for selecting condition A, which is the first condition item among the three condition items designated by the user on the previous screen (FIG. 9 or 10). A combo box 4005 represents a condition B selection combo box which is the second condition item. In this case as well, the “condition B” is the name used for convenience in the present invention as in the case of the “population A”. Therefore, if you actually realize the system,
It may not be displayed, or a description example such as “(selection of second condition)” may be displayed first in the combo box. A combo box 4006 represents a condition C selection combo box which is the third condition item. In this case as well, the “condition C” is a name used for convenience in the present invention as in the case of the “population A”. Therefore, when the system is actually realized, it is not displayed or "(3rd
A description example such as "selection of condition)" may be displayed first in the combo box.

The text box 4010 includes a population A selection combo box 4003, a condition A selection combo box 4004, a condition B selection combo box 4005,
Text for displaying the number of search results for displaying the number of search results when the user selects all four selection items of the combo box 4006 for selecting the condition C and presses the search button 4011 to execute the search It's a box.
A button 4012 is a “Next →” button for displaying the next screen for transition to the next screen, and a button 4013 is a cancel button for ending the screen and returning to the menu screen. On the screen of FIG. 4, by pressing the “Next →” button 4012 while the area of the customer to be targeted is designated by the user of the system, the screen shown in the example of FIG. 3 Transition to the "Confirm target customer conditions" screen for condition items.

In FIG. 16, reference numeral 16001 represents a display frame on the display device 1005 of the computer B, and 16
002 is a screen for the user to specify the range of target customer conditions when the number of condition items for determining the customer range targeted by the system user is 3, that is, “target for three condition items” This shows an example of the "Confirm customer condition" screen. 16004 is a Venn diagram display area for 3 condition items, 16005 is condition A, that is, the display area of the first condition content, 16006 is condition B, that is, the display area of the second condition content, 16007 is condition C, that is, the third condition Each display area of the contents is shown. 16008 represents the target customer condition display area designated by the user of the system on the previous screen, and the designated area information designated by the user of the system on the previous screen (FIG. 4) is taken over and displayed in a color different from the surrounding area. It 16003
Is an area for displaying the specified condition of the target customer, and is an area for displaying the condition contents of the target customer specified as an area by the user of the system on the previous screen (FIG. 4) as a sentence. Further, 16009 is a combo box for the user of the system to select what kind of product or service the customer wants to promote on the current screen. By default the combo box is
The contents of the purpose selected in 7003 and 8003 of FIGS. 7 and 8 are displayed. If the user of the system wants to change the purpose, this can be changed with this combo box 16009. Button 16
010 is a “yes” button for executing customer extraction for executing customer extraction, and button 16011 is a previous screen transition for returning to the target customer group designation screen for three condition items (FIG. 4) which is the previous screen, “return”. Button, button 160
Reference numeral 12 is a cancel button for ending the screen and returning to the menu screen. The user of the system determines that “this is fine” for the content of “purpose” shown in the combo box 16009, and clicks the “Yes” button 160.
When 10 is pressed, the screen transitions to the screen example shown in FIG. 12, the system executes the customer search and extraction processing, and the result is displayed as a list on the screen.

On the other hand, in FIG. 5, when the purpose setting screen shown in FIG. 9 or 10 is displayed on the display device, the user of the system selects 4 as the number of condition items, and clicks "Next". → button (9005 in FIG. 9 or 1 in FIG. 10)
This is an example of a target customer group designation screen for four condition items that is displayed when (5) is pressed.

In FIG. 5, a combo box 5015 represents a population A selecting combo box for selecting a population that is a prerequisite for extracting a target customer from all customers. Here again, “population A” is a name used for convenience in the present invention, and when the system is actually realized, it is not displayed or there is a description example such as “(select population)”. It may be displayed first in the combo box. A combo box 5003 represents a condition A selection combo box which is the first condition item among the four condition items designated by the user on the previous screen (FIG. 9 or 10). Combo box 5004 has 2
A combo box for selecting condition B, which is the second condition item, is shown. Also here, the “condition B” is the name used for convenience in the present invention as in the case of the “population A”, and is not displayed when the system is actually realized,
A description example such as “(selection of second condition)” may be displayed first in the combo box. A combo box 5005 represents a condition C selection combo box which is the third condition item. In this case as well, the "condition C" is not displayed or "(the third condition is not satisfied when the system is actually realized by the name used for convenience in the present invention as in the case of the" population A ". A description example such as “selection” ”may be displayed first in the combo box. A combo box 5006 represents a combo box for selecting condition D, which is the fourth condition item. Again, "Condition D"
In the same way as in the case of "population A", when the system is actually realized by the name used for convenience in the present invention,
It may not be displayed, or a description example such as “(selection of fourth condition)” may be displayed first in the combo box. 5011 is a combo box 5 for selecting a population A
015, condition A selection combo box 5003, condition B
Selection combo box 5004, condition C selection combo box 5005, condition D selection combo box 5006
When the user selects all of the five selection items, the search button 5012 is pressed, and the search is executed, a search result number display text box for displaying the number of search results is shown. A button 5013 is a “Next →” button for displaying the next screen for transition to the next screen, and a button 50.
Reference numeral 14 is a cancel button for ending the screen and returning to the menu screen. On the screen of FIG. 5, when the area of the customer to be targeted is designated by the user of the system, by pressing the “Next →” button 5013, the four condition items shown in the example of FIG. 18 are displayed. Transit to "Confirm target customer conditions" screen.

FIG. 6 shows an example of a Venn diagram when the number of condition items for determining the customer range targeted by the system user is four. 6001 represents the area of the population in the Venn diagram in the case of four condition items,
Reference numeral 02 represents a region (region 1) of an element that satisfies the condition A and does not satisfy the condition B. Further, 6003 represents a region (region 2) of elements that satisfy all of the conditions A and B, do not satisfy the condition C, and do not satisfy the condition D, and 6004 satisfies all of the conditions A, B, and C, Further, 6005 represents an area (area 3) of an element which does not satisfy the condition D, 6005 represents an area (area 4) of an element which satisfies all the conditions A, B and D and does not satisfy the condition C, and 6006 represents the condition A. , Condition B, Condition C, and Condition D are all represented as regions (region 5).

On the screen shown in FIG. 5, when the area of the customer to be targeted is specified, the left mouse button is clicked while pressing the Ctrl key, and the areas 1 and 1 in the Venn diagram of FIG. Areas indicated by 2, area 3, and area 4 can be freely designated. However, the area 5 in FIG.
It is a customer who satisfies all of the conditions B, C, and D, in other words, a customer who has already achieved the "purpose", and thus is excluded from the target. Therefore,
The user of the system cannot specify the area 5 in FIG. 6 as the area of the customer to be targeted.

In FIG. 18, reference numeral 18001 denotes a display frame on the display device 1005 of the computer B, and 18
002 is a screen for the user to specify the range of target customer conditions when the number of condition items for determining the customer range targeted by the system user is 4, that is, “target for four condition items”. This shows an example of the "Confirm customer condition" screen. 18004 is a Venn diagram display area for four condition items, 18005 is condition A, that is, the display area of the first condition content, 18006 is condition B, that is, the display area of the second condition content, 18007 is condition C, that is, the third condition. Display area of contents, 18008 is condition D,
That is, the display areas of the fourth condition contents are displayed. Reference numeral 18009 represents a target customer condition display area designated by the user of the system on the previous screen, and the designated area information designated on the previous screen (FIG. 5) is taken over and displayed in a color different from the surrounding area. Reference numeral 18003 is a target customer specified condition display area, which is an area for displaying the condition contents of the target customer specified as an area by the user of the system on the previous screen (FIG. 5) as a sentence. 18
Reference numeral 010 is a combo box for the user of the system to select what kind of product or service to promote to the customer on the current screen. By default, the combo box is 7003 in FIG. 7 and FIG.
The contents of the purpose selected in 8003 are displayed. If the user of the system wants to change the purpose, this can be changed with this combo box 18010. A button 18011 is a customer extraction execution “yes” button for executing customer extraction, and a button 180.
12 is a "return" button for transitioning to the previous screen for transitioning to the target customer group designation screen for four condition items (FIG. 5) which is the previous screen, and button 18013 is a cancel button for exiting the screen and returning to the menu screen. Is. When the user of the system determines that “this is ok” with respect to the content of the “purpose” shown in the combo box 18010, and presses the “Yes” button 18011,
Transitioning to the screen example shown in FIG. 12, the system executes customer search and extraction processing, and the results are displayed as a list.

After changing to the screen of FIG. 12, it is as described above. To repeat, if the “configuration graph” button 12007 for displaying the configuration graph is pressed on the screen of FIG. 12, the screen transitions to the configuration graph display screen (FIG. 15) shown in FIG. 15 and “return” on the configuration graph display screen. Button is pressed, the search result list display screen (Fig. 1
Transition to 2).

Next, with reference to each image diagram and FIG. 19, the concrete processing flow in the case where the user of the system extracts the customer information to promote the product or service by the information processing system already described This will be described using the flowcharts shown in FIGS. 24 and 29 to 32.

An environment having the configuration shown in FIG. 1 exists,
In the computer B (1007) in FIG. 1, the information processing system is activated and the display device 100
The state in which the menu screen shown in FIG. 2 is open on the screen of FIG. 5 will be described with reference to the flowcharts shown in FIGS. 19 to 24. By the way, regarding the database that stores the customer information, the computer A side (1003 in FIG. 1) is used to realize the function of the system.
Computer B side (100 in FIG. 1)
It goes without saying that they may be arranged in 9) or may exist in both.

On the display device 1005 of the computer B,
When the menu screen of FIG. 2 is displayed and the system user (hereinafter referred to as a user) is in an event input waiting state (step 19001 of FIG. 19), the user selects the “1 target customer extraction” button of FIG. When the user presses 2003, the system detects an event (step 19).
002), the type of event is determined (step 190).
03). Since the user has pressed the "extract one target customer" button, the system displays the purpose setting screen and waits for a new input from the user (step 1900).
4). If the user presses the "end" button 2006 on the menu screen (FIG. 2), the system receives an event (step 19002) and detects that the event type is the "end" button being pressed (step 19003). ), Close the above menu screen (Fig. 2),
The program of the system ends (step 190).
18, 19019).

When the user presses the "Next →" button,
The system detects an event (step 19004)
a) It is detected that the "Next →" button has been pressed as the event type (step 19005). When the “Next →” button is pressed, the user has already selected the “purpose” from the purpose selection combo box (7003 in FIG. 7 or 8003 in FIG. 8) on the purpose setting screen (FIG. 7 or 8). If the content has been selected (step 19006), the condition item number selection screen (FIG. 9 or FIG. 10) is displayed, and the condition item number selection combo box (9003 in FIG. 9) is displayed to the user.
Alternatively, it is urged to select the number of condition items in the range of 2 items to 4 items from 10003 in FIG. 10 (step 1900).
7). If the purpose selection combo box (70 in FIG. 7)
03, or 8003 in FIG. 8), if the content of “purpose” is not selected, a message prompting the user to select “purpose” is displayed on the screen (step 19021) and the purpose setting screen continues to be displayed (step 19021). 19004). When the user presses the "cancel" button while the condition item number selection screen (FIG. 9 or 10) is displayed, the system side receives an event (step 19004a), and the event presses the "cancel" button. Is determined (step 19005), and a transition is made to the display of the menu screen (FIG. 2) (steps 19020, 19001).

When the user presses the "send" button,
The system detects an event (step 1900
8) It is detected that the type of event is "press send button" (step 19009). Next, it is determined whether the number of condition items is already selected in the condition selecting combo box (step 19010). If the number of condition items is not selected in the condition selecting combo box, the number of condition items is selected. A message for prompting is displayed on the screen (step 19022), and the purpose setting screen continues to be displayed (step 19007).

If already selected, the number of selected items is discriminated (step 19011). If the number of selected condition items is 2, target customer group designation screen for 2 items (FIGS. 3 and 25). 27, or 28) is displayed (steps 19012, 19015). If the number of selected condition items is 3, a target customer group designation screen for 3 items is displayed (steps 19013 and 19).
016). If the number of selected condition items is 4, a target customer group designation screen for 4 items is displayed (steps 19014 and 19017).

The flow of processing after the user selects 2 as the number of condition items will be described with reference to the flowchart of FIG. As a result of the user selecting 2 as the number of condition items,
Target customer group designation screen for 2 condition items (Fig. 3,
25, 27, or 28) is displayed, and an event input from the user is waited for (step 20001). Here, when the user presses any button, the system detects an event (step 20002), and when the "search" button is pressed (step 2000).
3), the population is selected in the population A selection combo box (3003 in FIG. 3) on the screen (step 20).
004), and condition A is selected on the condition A selection combo box (3004 in FIG. 3) on the screen (step 20005), and on the condition B selection combo box (step 20005) on the screen. If condition B is selected (3005, etc. in FIG. 3) (step 20006), the number of applicable customers is searched from the customer information database based on the population A, condition A, and condition B (step 20007), The number of the corresponding search results is displayed in each number display area (3008, etc. of FIG. 3) on the Venn diagram shown in the screen (step 20008).

If no population is selected in the population A selection combo box (3003 in FIG. 3) on the screen, or in the condition A selection combo box (3 in FIG. 3).
004), condition A is not selected, or condition B
Condition B on the selection combo box (3005, etc. in FIG. 3)
If is not selected, an error message prompting selection is displayed on the screen (20009) and target customer group designation screen for 2 condition items (FIGS. 3 and 2).
5, FIG. 27 or FIG. 28), the process waits for an event input from the user again (step 20001).

The processing is returned to step 20003, and if the input event from the user is the pressing of the “Next →” button, the area of the customer group that the user wants to target has already been designated in the Venn diagram on the screen. It is detected whether it is done (step 20010). If the area is not designated, a message prompting the designation of the area is displayed on the screen (20014), and the target customer group designation screen for 2 condition items (FIGS. 3 and 2).
5, FIG. 27 or FIG. 28), the process waits for an event input from the user again (step 20001). If the area of the customer group that the user wants to target is already specified in the Venn diagram on the screen, the two condition items are both satisfied as the area of the customer group that the user wants to target in the Venn diagram on the screen. It is also checked whether or not the customer is designated as the target (step 20011). If the user specifies an area that satisfies both of the two condition items as the area of the customer group to be targeted, a message indicating that the area is not specified is displayed because the area is a customer who has achieved the purpose. Display (2001
4) On the target customer group designation screen for 2 condition items (FIG. 3, FIG. 25, FIG. 27 or FIG. 28), again,
Waiting for event input from the user (step 200)
01). By the way, it is also possible to have a specification in which the user side cannot specify the area that satisfies both of the two condition items as the area of the customer group from the beginning.

The processing is returned to step 20011, and if the area of the customer group that the user wants to target is 2
If an area that satisfies both condition items is not specified, the screen transitions to the target customer condition confirmation screen for two condition items (FIG. 17) (steps 20012 and 2001).
3).

After that, the processing is moved to the flowchart of FIG. 29, and the target customer condition confirmation screen for the two condition items (see FIG. 1).
7) is displayed, and the process waits for an event input from the user (step 29001). In this state, when the user presses any button on the screen, the system detects an event (step 29002). Then, the type of the detected event is determined (step 29003), and if the result of the determination is that the user has clicked the “Next →” button, the purpose selection combo box ( If the purpose is selected and set by the user in 17008) of FIG. 17, the screen transitions to the search result list screen (FIG. 12) (step 290).
04, 29008). If the target selection combo box (17008 in FIG. 17) on the screen (FIG. 17),
If no purpose is set, an error message prompting the user to select a purpose is displayed on the screen (step 29005), and the user waits for an event to be input again (step 29001).

Here, returning to the process (step 29002) when the event input from the user is detected, if the content of the event is the click of the "cancel" button, the screen is changed to the menu screen. (Steps 29003, 29006). If the content of the event is the click of the "return" button, the screen transitions to the target customer group designation screen for 2 condition items (FIG. 3) (steps 29003, 29007).

Again, step 1 of the flowchart of FIG.
Returning to the description of the processing of 9013 and 19016, the flow of processing after the user selects 3 as the number of condition items will be described with reference to the flowchart of FIG. As a result of the user selecting 3 as the number of condition items, the target customer group designation screen for 3 condition items (FIG. 4) is displayed, and an event input from the user is awaited (step 21001). Here, when the user presses any button, the system detects an event (step 21002), and when the "search" button is pressed (step 2100).
3), the population is selected in the population A selection combo box (4003 in FIG. 4) on the screen (step 210).
04), and condition A is selected on the condition A selection combo box (4004 in FIG. 4) on the screen (step 21005), and on the condition B selection combo box (FIG. 4). If the condition B is selected in 4005) of 4 (step 21006) and the condition C is selected in the condition C selection combo box (4006 in FIG. 4) on the screen (step 21007), From the customer information database, the number of applicable customers is searched based on the population A, condition A, condition B, and condition C (step 2
1008), the number of corresponding search results is displayed in each number display area (4010 in FIG. 4) on the Venn diagram shown in the screen (step 2100).
9).

If the population is not selected in the population A selection combo box (4003 in FIG. 4) on the screen, or if the condition A selection combo box (40 in FIG. 4) is selected.
04), condition A is not selected, condition B is not selected in the condition B selection combo box (4005 in FIG. 4), or condition C is selected in the condition C selection combo box (4006 in FIG. 4). If C is not selected, an error message prompting selection is displayed on the screen (21010), and the event input from the user is again input on the target customer group designation screen for 3 condition items (FIG. 4). It waits (step 21001).

The process is returned to step 21003, and if the input event from the user is the pressing of the "Next →" button, the area of the customer group that the user wants to target has already been designated in the Venn diagram on the screen. It is detected (step 21011). If the area is not designated, a message prompting the designation of the area is displayed on the screen (step 21015), 3
In the target customer group designation screen for condition items (FIG. 4), the user again waits for an event input (step 21001). In the Venn diagram on the screen, if the area of the customer group that the user wants to target has already been specified, the customer who specifies all three conditions as the area of the customer group that the user wants to target has been specified as the target. It is also checked whether or not there is any (step 21012). If the user specifies an area that satisfies all three condition items as the area of the customer group to be targeted, it means that the area is a customer who has already achieved the purpose, and the area is not specified. A message is displayed (step 21015), and an event input from the user is awaited again on the 3 condition item target customer group designation screen (FIG. 4) (step 21001). An area that satisfies all the three condition items as an area of the customer group may not be designated by the user from the beginning.

When the process returns to step 21012 and the user has not specified an area that satisfies all three condition items as the area of the customer group to be targeted, the condition confirmation screen for the target customer for the three condition items ( 16) (steps 21013, 2101)
4).

After that, the processing is moved to the flowchart of FIG. 30, and the target customer condition confirmation screen for three condition items (see FIG. 1).
6) is displayed, and an event input waiting state from the user is entered (30001). When the user presses any button on the screen in this state, the system detects an event (step 30002). Then, the type of the detected event is determined (step 30003), and if the result of the determination is that the user has clicked the “Next →” button, the combo box () for selecting a purpose on the screen (FIG. 16) ( When the purpose is selected and set by the user in 16009) of FIG. 16, the screen transits to the search result list screen (FIG. 12) (step 30004,
30008).

If no purpose is set in the purpose selection combo box (16009 in FIG. 16) on the screen (FIG. 16), an error message prompting selection of the purpose is displayed on the screen. Display on top (step 3000
5) Then, the state of waiting for an event input from the user is resumed (step 30001). Here, processing when an event input from the user is detected (step 30002)
If the content of the event is the click of the "cancel" button, the screen transitions to the menu screen (step 30003, 30006). If the content of the event is the click of the "return" button, the screen transitions to the target customer group designation screen for three condition items (FIG. 4) (step 30003, 30007).

Again, step 1 of the flowchart of FIG.
Returning to the description of the processing of 9014 and 19017, the flow of the processing after the user selects 4 as the number of condition items will be described with reference to the flowchart of FIG. As a result of the user selecting 4 as the number of condition items, the target customer group designation screen for 4 condition items (FIG. 5) is displayed and the user waits for an event input (step 22001). Here, when the user presses any button, the system detects an event (step 22002), and when the "search" button is pressed (step 2200).
3), a population is selected in the population A selection combo box (5015 in FIG. 5) on the screen (step 220).
04), and condition A is selected on the condition A selection combo box (5003 in FIG. 5) on the screen (step 22005), and on the condition B selection combo box on the screen (see FIG. 5, the condition B is selected (step 22006), and the condition C is selected on the condition C selection combo box (5005 in FIG. 5) on the screen (step 22007), and ,
On the combo box for selecting the condition D on the screen (5 in FIG. 5).
If condition D is selected in (006) (step 220)
08), the number of applicable customers is searched from the customer information database based on the population A, the condition A, the condition B, the condition C, and the condition D (step 22009), and the search result is shown in the screen. The number of corresponding search results is displayed in each number display area (5011 in FIG. 5) on the Venn diagram (step 22010).

If no population is selected in the population A selection combo box (5015 in FIG. 5) on the screen, or in the condition A selection combo box (50 in FIG. 5).
03), condition A is not selected, condition B is not selected in the condition B selection combo box (5004 in FIG. 5), or condition C is selected in the condition C selection combo box (5005 in FIG. 5). C is not selected, or on the combo box for selecting condition D (5006 in FIG. 5)
If condition D is not selected in step 2, an error message prompting selection is displayed on the screen (2201
1) On the target customer group designation screen for 4 condition items (5002 in FIG. 5), the user waits for an event input again (step 22001).

The process is returned to step 22003, and when the input event from the user is the pressing of the “Next →” button, the area of the customer group that the user wants to target has already been designated in the Venn diagram on the screen. It is detected (step 22012). If the area is not designated, a message prompting the designation of the area is displayed on the screen (step 22016), 4
Target customer group designation screen for condition items (5 in FIG. 5)
In 002), it again waits for an event input from the user (step 22001). In the Venn diagram on the screen, if the area of the customer group that the user wants to target has already been specified, the customer who specifies all four condition items as the area of the customer group that the user wants to target is specified as the target. It is also checked whether or not there is any (step 2201).
3). If the user has specified an area that satisfies both of the four condition items as the area of the customer group to be targeted, a message notifying that the area is not specified because the area has already achieved the purpose Is displayed (step 22016), and on the target customer group designation screen for four condition items (FIG. 5), the user waits again for an event input (step 22001).
An area that satisfies all of the four condition items as an area of the customer group may not be designated by the user from the beginning.

The process is returned to step 22013, and if the area of the customer group that the user wants to target is 4
If an area that satisfies both condition items is not specified, the condition confirmation screen (FIG. 18) of the target customer for the four condition items is displayed (steps 22014 and 2201).
5).

Thereafter, the processing is shifted to the flowchart of FIG. 31, and the target customer condition confirmation screen for 4 condition items (see FIG. 1).
8) is displayed, and the process waits for an event input from the user (step 31001). In this state, when the user presses any button on the screen, the system detects an event (step 31002). Then, the type of the detected event is determined (step 31003), and if the result of the determination is that the user has clicked the “Next →” button, a combo box for selecting a purpose on the screen (FIG. 18) ( When the purpose is selected and set by the user in 18010) of FIG. 18, the screen transits to the search result list screen (FIG. 12) (step 310).
04, 31008). If the target selection combo box (18010 in FIG. 18) on the screen (FIG. 18),
If no purpose is set, an error message prompting the user to select a purpose is displayed on the screen (step 31005), and the user waits for an event input again (step 31001).

Here, returning to the processing when the event input from the user is detected (step 31002), when the content of the event is the click of the "Cancel" button, the screen is changed to the menu screen (step. 310
03, 31006). When the content of the event is the click of the "return" button, the screen transitions to the target customer group designation screen for four condition items (FIG. 5) (steps 31003 and 31007).

Steps 29004 and 2900 in FIG.
8, steps 30004 and 30008 in FIG. 30, FIG.
The processing after transitioning to the search result list screen through steps 30004 and 30008 will be described with reference to the flowchart of FIG. A search result list display screen is displayed in step 23001, and a message indicating that the current results are currently being extracted is displayed on the screen (step 230).
02). During this time, inside the system, 130 in FIG.
From the bitmap table indicated by 01, all the customers who satisfy all the conditions specified by the user are searched (step 2300).
3). As a result of the search, if one or more hits are found (step 23004), the bit pattern is referred to only for the other attributes except the attribute of "purpose", and the customers are grouped for each pattern (step 23005). After grouping, the composition ratio is calculated to find the proportion of customers who have achieved the "purpose" in each group (step 23006). If necessary, a correction is added to the calculated composition ratio for each customer who has not achieved the "purpose" in each group. This is the "goal achievement probability" (Step 2
3007).

The obtained “goal achievement probability” is given to each customer who has not achieved the “goal” in each group. In other words, the "objective achievement probability" is given to all the customers who satisfy the conditions specified by the user and who have not yet achieved the "objective" (step 23008). Then, the customer information provided is sorted in the descending order of the value of the "goal achievement probability" (step 23010). When the processing up to this point is completed, the message "Extracting" displayed on the search result list screen (FIG. 12) is deleted (step 2301).
1), the sorted customer information list is displayed on the search result list screen (FIG. 12) (step 2301).
3). After that, on the search result list screen (FIG. 12), the process waits for an input event from the user (step 230).
14, 23017).

Steps 23003 and 230 will be used to explain the processing.
Returning to 04, if there is no hit as a result of the search, that is, if the number of search results is 0 (step 23004), the "extracting" status displayed on the search result list screen (FIG. 12) is displayed. The message to the effect is erased (step 23015), and a message to the effect that "the search did not hit" is displayed on the screen (step 23016). After that, on the search result list screen (FIG. 12), the process waits for an input event from the user (steps 23014 and 23).
017).

In the processing described in FIG. 23, a specific example of obtaining the “goal achievement probability” will be described using the flow of FIG. 32 and the screen example of FIG. 28. In FIG. 28, the conditions of the target customer designated by the user are “age is 35 to 39 years old” (28003 in FIG. 28), “car rental is available” (28005 in FIG. 28), and “housing” No loan ”(area 28006 in FIG. 28). The "purpose" for this target customer is to attach a "mortgage".

When the “Next →” button 2809 is pressed from the state of the screen of FIG. 28 and the extraction is carried out (= “Yes” button is pressed) via the screen shown in FIG. 17, the system performs the steps of the flowchart of FIG. 23001, 2300
After 2, the process transits to the process shown in step 23003b of FIG. That is, all the customers having the attributes of "age 35 to 39" and "car loan available" are searched from the bit map table as shown in FIG. 13 (step 23003b). If the search hits (Step 2
3004b), referring to the bit pattern from the search result with an attribute other than "presence or absence of mortgage", groups the customers by the bit pattern (step 23005).
b). After grouping, the ratio of customers having the attribute of "mortgage loan" among the customers belonging to the same group, that is, (the number of customers who belong to the group and have the attribute of "mortgage loan") / ( The total number of customers who belong to the group) is calculated, and this is set as the "mortgage loan probability" (step 23006b).

Here, the “probability of mortgage attachment” is
It is the "probability of being able to apply for a mortgage", that is, the "probability of achieving the purpose" described in the flowchart of FIG. The calculated “probability of mortgage loan” is given to a customer who has the attribute “no mortgage” in the same group (step 23007b).
After granting, it is judged whether or not to correct the “mortgage loan probability” for each granted customer (step 2
3008b) If necessary, the "mortgage loan probability" is corrected for each customer based on past transaction history and transaction record information other than the customer attribute information (step 2300).
9b). The correction is, for example, in consideration of information such as past transaction history and transaction history that cannot be known only by the attribute information of the customer, and if it is good, a numerical value arbitrarily determined in advance, for example, “5% If it means “raise”, it means performing processing such as adding 5% to the “probability of mortgage attachment” at the step 23006b.
Any correction method may be used.

The final value of the "probability of mortgage loan" is obtained, and for all customers who are "aged 35 to 39 years old", "with a car loan" and "without mortgage",
When the final value of the “mortgage loan probability” is given, the customer information is sorted in descending order of the probability (step 2301).
0b). Although the message "Extracting" is currently displayed on the screen, the message is deleted (step 23011b), and the sorted customer list information is displayed on the search result list screen (step 23013
b). The specific display image of the search result list screen is as shown in FIG. The subsequent processing, that is, step 23014b and subsequent steps is the same as step 23014 and subsequent steps in FIG. Also, when the search result is not hit in step 23004b, the subsequent processing (from step 23015b to step 23017b)
Also, it is the same as step 23015 and subsequent steps in FIG.

The process after the flowchart of FIG. 23 or 32 will be described with reference to FIG. When the result is displayed on the search result list screen (FIG. 12), the screen waits for an input event from the user. When the user then presses the “print” button on the search result list screen (FIG. 12), the system detects an event (step 24001) and checks the event type (step 24002). As a result of the check, if it is confirmed that the event is one in which the "print" button is pressed, the search result list information displayed on the screen (FIG. 12) is printed (step 24003). After printing, the process waits for an input event from the user again (step 24008).

The description of the processing is returned to step 24002,
If the detected event type is the user pressing the “configuration graph” button, the pattern-based configuration graph display screen (FIG. 15) based on the search result data is displayed (step 24004) and the user waits for an event input. (Step 24005). When an event of pressing the "back" button is detected on the pattern-based composition graph display screen (FIG. 15) (step 24006), the search result list display screen (FIG. 12) is also returned to display (step 240).
07). After that, the process waits for an input event from the user again (step 24008).

Returning the description of the processing to step 24002,
When the detected event type is pressing the "← Back" button (that is, when the "← Back" button is clicked)
Determines the caller of the screen (FIG. 12) (step 24009), and if the caller is the two-condition item target customer condition confirmation screen (FIG. 17), the two-condition item target customer condition confirmation screen ( 17) is displayed (step 24010). In step 24009, if the caller is the target customer condition confirmation screen for three condition items (FIG. 16), the target customer condition confirmation screen for three condition items (FIG. 16) is displayed (step 2401).
1). In step 24009, if the calling source is the four-condition item target customer condition confirmation screen (FIG. 18), the four-condition item target customer condition confirmation screen (FIG. 1).
8) is displayed (step 24012). Step 24
Returning to the explanation of the process of 002, when the detected event type is the “menu” button being pressed, the screen transitions to the menu screen and waits for an event input from the user again (step 24013).

[0082]

As described above, according to the present invention,
Even if the user has no knowledge other than how to read the Venn diagram, the customers who want to provide a particular product or service are extracted in the order in which they are more likely to purchase that product or service.
You will be able to view. In particular, when a company wants to send a direct mail to recommend a certain product or service to a customer, by using the present invention, it is possible to issue a direct mail to a customer who is likely to be purchased. , It is possible to improve the efficiency of direct mail with a limited number of circulations.

[Brief description of drawings]

FIG. 1 is a block configuration diagram showing an example of an information processing system for realizing the present invention.

FIG. 2 is a diagram showing an example of a menu screen for extracting target customer data.

FIG. 3 is a diagram showing an example of a screen for designating a customer group as an extraction target from two condition items in order to extract target customer data.

FIG. 4 is a diagram showing an example of a screen for designating a customer group to be an extraction target from three condition items in order to extract target customer data.

FIG. 5 is a diagram showing an example of a screen for designating a customer group as an extraction target from four condition items in order to extract target customer data.

FIG. 6 is a diagram showing a Venn diagram that distinguishes regions in which four condition items satisfy each other's condition items among the four condition items.

FIG. 7 is a diagram showing an example of a screen for selecting and specifying the purpose itself in order to extract target customer data.

FIG. 8 is a diagram showing a state in which a choice of a purpose is displayed in a screen example for selecting and designating the purpose itself in order to extract target customer data.

FIG. 9 is a diagram showing an example of a screen for selecting and specifying the number of condition items for determining a data extraction range in order to extract target customer data.

[FIG. 10] In order to extract target customer data,
FIG. 6 is a diagram showing a state in which options are displayed in a screen example for selecting and specifying the number of condition items for determining a data extraction range.

FIG. 11 is a diagram showing a table image of customer information stored in a customer information database that stores customer information.

FIG. 12 is a diagram showing a screen example and an example of displaying extraction result information as a list for extracting target customers and displaying a list of the results.

FIG. 13 is a diagram showing an example of a bitmap table which manages customer attributes stored in a customer information database as bitmap information.

FIG. 14 is a diagram showing an example of a bit pattern ID table used for identifying a customer attribute as a pattern based on the attribute.

FIG. 15 is a diagram showing a screen example in which a result of extracting a target customer, that is, a target customer who promotes purchase of a specific service or product, that is, a target customer is displayed in a graph.

FIG. 16 is a diagram showing an example of a screen for the user to specify the range of target customer conditions (when the number of condition items is 3).

FIG. 17 is a diagram showing an example of a screen for the user to specify the range of target customer conditions (when the number of condition items is 2).

FIG. 18 is a diagram showing an example of a screen for the user to specify the range of target customer conditions (when the number of condition items is 4).

FIG. 19 is a flowchart showing a flow of a target customer data extraction process.

FIG. 20 is a flowchart (continuation) showing the flow of target customer data extraction processing.

FIG. 21 is a flowchart (continuation) showing the flow of a target customer data extraction process.

FIG. 22 is a flowchart (continuation) showing the flow of target customer data extraction processing.

FIG. 23 is a flowchart (continuation) showing the flow of target customer data extraction processing.

FIG. 24 is a flowchart (continuation) showing the flow of target customer data extraction processing.

FIG. 25 is a diagram showing an example of a screen for designating a customer group as an extraction target from two condition items for the purpose of extracting target customer data.

FIG. 26 is a diagram showing a display example of selection items of a combo box for selecting a population.

FIG. 27 is a diagram showing an example of a screen for designating a customer group to be an extraction target from two condition items in order to extract target customer data.

FIG. 28 is a diagram showing a screen example for designating a customer group to be an extraction target from two condition items for the purpose of extracting target customer data.

FIG. 29 is a flowchart (continuation) showing the flow of target customer data extraction processing.

FIG. 30 is a flowchart (continuation) showing the flow of a target customer data extraction process.

FIG. 31 is a flowchart (continuation) showing the flow of target customer data extraction processing.

FIG. 32 is a flowchart (continuation) showing the flow of target customer data extraction processing.

[Simple explanation of symbols]

1001 ... System device 1002 of computer A ... CPU device 1003 ... Database 1004 ... Network 1005 ... Display device 1006 ... Input device 1007 ... System device 1008 of computer B ... CPU device 1009 ... Database 2002 ... Menu screen example 2003 ... “1 target customer Extraction button 2004 ... Second menu button 2005 ... Third menu button 3002 ... 2 Target item customer target group designation screen example 3003 ... Population A selection combo box 3004 ... Condition A selection combo box 3005 ... Condition B selection Combo box 3006 ... Elliptical frame 3007 indicating range satisfying condition A ... Elliptical frame 3008 indicating range satisfying condition B ... Text box for displaying number of search results 3009 ... Search button 3010 ... Next screen table Show “Next →” button 4002 ... Example of target customer group designation screen for 3 condition items 4003 ... Population A selection combo box 4004 ... Condition A selection combo box 4005 ... Condition B selection combo box 4006 ... Condition C selection Combo box 4007 ... Elliptical frame 4008 indicating a range satisfying condition A ... Elliptical frame 4009 indicating a range satisfying condition B ... Elliptical frame 4010 indicating a range satisfying condition C ... Text box for displaying the number of search results 4011 ... Search button 4012 … Next screen display “Next →” button 5002… 4 condition item target customer group designation screen example 5003… Condition A selection combo box 5004… Condition B selection combo box 5005… Condition C selection combo box 5006… Condition D selection combo box 5007 ... Ellipse frame 5008 indicating the range satisfying condition B ... ellipse frame 5010 indicating the range satisfying condition C ... ellipse frame indicating the range satisfying condition D 5011 ... text box for displaying the number of search results 5012 ... search button 5013 ... Next screen display "Next →" button 5015 ... Population A selection combo box 6001 ... Area of population 6002 in Venn diagram in the case of 4 condition items ... Area of elements that satisfy condition A but not condition B (Area 1) 6003 ... An area of an element that satisfies all the conditions A and B and does not satisfy the conditions C and D (area 2) 6004 ... 3) 6005 ... An area of an element that satisfies all the conditions A, B, and D but does not satisfy the condition C (area 4) 6006 ... All the conditions A, B, C, and D are satisfied. Element area (area 5) 7002 ... Objective setting screen example 7003 ... Objective selection combo box 7004 ... Next screen display "Next →" button 8002 ... Objective setting screen example 9002 ... Condition item number selection screen example 9003 ... Condition Item number selection combo box 10002 ... Conditional item number selection screen example 10003 ... Conditional item number selection combo box 10004 ... Previous screen move “← Back” button 10005… Next screen display “Next →” button 11001… Customer information Example table 12002 ... Result list display screen example 12003 ... Population condition display area 12004 ... Objective display area 12005 ... Result list display area 12006 ... Result list print "Print" button 12007 ... Configuration graph display "Configuration graph Button 13001 ... Example of bitmap table 14001 ... Bit pattern number For example 16002 ... 3 conditions item "check target customers conditions"
Example screen 16003 ... Target customer specified condition display area 16004 ... 3 condition item Venn diagram display area 16005 ... First condition (condition A) condition content display area 16006 ... Second condition (condition B) Content display area 16007 ... Condition content display area 16008 of third condition (condition C) ... Example of target customer condition display area by user designation 16009 ... Object selection combo box 17002 ... For 2 condition items "Target customer condition confirmation""
Screen example 17003 ... Target customer designated condition display area 17004 ... 2 condition item Venn diagram display area 17005 ... First condition (condition A) condition content display area 17006 ... Second condition (condition B) condition Content display area 17007 ... Example of target customer condition display area specified by user 17008 ... Combo box for purpose selection 18002 ... For 4 condition items "Target customer condition confirmation"
Screen example 18003 ... Target customer specified condition display area 18004 ... 4 condition item Venn diagram display area 18005 ... First condition (condition A) condition content display area 18006 ... Second condition (condition B) Content display area 18007 ... Condition content display area 18008 for third condition (condition C) ... Condition content display area 18009 for fourth condition (condition D) ... Example of target customer condition display area by user's designation 18010 ... Purpose Combo box for selection

   ─────────────────────────────────────────────────── ─── Continued front page    (72) Inventor Yuko Morino             890 Kashimada, Sachi-ku, Kawasaki City, Kanagawa Stock             Hitachi, Ltd. Financial Systems Division (72) Inventor Yuko Matsuda             890 Kashimada, Sachi-ku, Kawasaki City, Kanagawa Stock             Hitachi, Ltd. Financial Systems Division F term (reference) 5B075 ND20 NS10 PP02 PP03 PP13                       PQ02 PQ34 PQ46 UU40

Claims (3)

[Claims] 1. A method of extracting desired customer data from a customer information database in which information about customers is stored, the step of inputting the number of condition items for extracting customer data, and the number of circles corresponding to the number of condition items. Displaying a Venn diagram in which the above are combined on the display screen, associating the contents of the condition items with each circle of the Venn diagram, and specifying the conditions of the customer who recommends the purchase of goods or services by the area on the Venn diagram. Using the customer information database, determining for each customer the probability that a customer belonging to a specified area on the Venn diagram will move to a target area on the Venn diagram that satisfies all the condition items; Step for displaying a list of information on customers belonging to the above designated area and the probability of the customers together A method for extracting customer data, comprising: 2. The method for extracting customer data according to claim 1, wherein the customer information database is a bitmap table in which a plurality of attribute values representing information about each customer are represented by 0 or 1, respectively, and the bitmap table. Information for grouping customers by a pattern (bitmap pattern) representing the arrangement of bits of the above, and the first number of customers belonging to a specified area on the Venn diagram for each customer group having the same bitmap pattern. And customer data, wherein the ratio of the second number of customers to the sum of the second number of customers belonging to the target area on the Venn diagram is calculated, and the ratio is used as the probability of customers having the bitmap pattern. Extraction method. 3. The method for extracting customer data according to claim 2, further comprising the step of correcting the probability based on information unique to each customer.