JP2001249972A - Purchasing analysis method and device - Google Patents

Abstract

(57) [Summary] [Problem] This is an analysis method and apparatus for analyzing usage patterns of customers in a shopping district, a shopping district in a department store, etc., and taking measures to improve sales. It is an object of the present invention to provide a method and an apparatus for visually expressing the spatial arrangement between shops in a shopping street so that the spatial arrangement can be grasped. Each time a member customer uses a member store, a first step of creating purchase data created by recording the member number, the store used, and the date and time of use and storing it as a database, a certain period is determined. A second step of retrieving the purchase data and counting two sets of stores that have been used consecutively by the same member customer for each combination; and a second step of displaying a member store map displayed on a computer screen. The above-mentioned problem is solved by the method according to the third step, in which a combination of stores in which the same customer consecutively uses the number of times obtained in the step is not less than a certain number of times is visually represented.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an analysis method and apparatus for analyzing a use form of a customer in a shopping street, a shopping mall in a department store, etc., and taking measures to improve sales.

[0002]

2. Description of the Related Art An analysis method for analyzing a customer's usage pattern in a shopping district or a shopping mall in a department store and taking measures to improve sales.
Conventionally, as an apparatus, a pair of stores used by the same customer at the same time (consecutively) is output and a list is output in descending order, or as shown in FIG. 3, a set of stores is expressed in a two-dimensional graph. There is a device.

[0003]

However, since the spatial arrangement of the shop 1 and the shop 2 cannot be understood only from the graph shown in FIG. 3, it is necessary to determine what flow line the customer uses the shopping street. It is difficult to grasp.

[0004] The present invention has been made in view of such problems, and a method and apparatus for conducting a buying and selling analysis and visually expressing the results so that the spatial arrangement between shops in a shopping street can be grasped. The task is to provide

[0005]

A first invention for solving the above-mentioned problem is a buying and selling analysis method shown in the block diagram of FIG. 2, wherein a member number is used every time a member customer uses a member store. , A first step (S1 in FIG. 2) of creating purchase data that is created by recording the store and date of use, and accumulating the purchase data as a database. In the second step (S2 in FIG. 2) for counting the pair of two stores that the customer has used consecutively for each combination, and in the member store map displayed on the computer screen, the second step The third step (S in FIG. 2) of visually expressing the obtained combination of stores in which the same customer uses the store continuously for a certain number of times or more.
According to 3), the point is to visually represent a pair of stores to be used simultaneously on the member store map.

A second invention for solving the above-mentioned problem is a buying and selling analyzing apparatus, wherein each time a member customer uses a member store, the purchase number is created by recording a member number, a store used, and a use date and time. A customer database storing data, a purchase data analyzing means for searching the purchase data and counting a pair of two stores continuously used by the same member customer for each combination, and a member store map are displayed. And a buying graph creating means for visually representing the buying analysis result.

A third invention for solving the above-mentioned problem is a computer-readable recording medium in which a purchase graph obtained by the method or the apparatus of the invention is stored as digital data.

[0008]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, an embodiment of a buying and selling analyzing apparatus based on the method of the present invention will be described in detail. FIG.
Is a buying and selling analysis system 1 according to an embodiment of the present invention.
FIG. Reference numeral 10 (10a, 10b,...) Denotes an analysis terminal. The analysis terminal 10 includes a buying graph creation unit 11, a graphic display 12, and a printer 1.
3. An input unit 14 is provided. Reference numeral 20 denotes a center server. The system includes a database management unit 22 for managing the customer database 31 and a buying and selling analysis unit 21. An external storage device 30 stores a customer database 31.
40 (40a, 40b,...) Are store terminals. For one use (one purchase with a point card) of a member customer, one record of purchase data to be described later is created and notified to the center server through the network 9.

Next, the customer database will be described. The customer database includes a customer master, purchase data, a customer point table, and daily performance data. FIG. 5 is a diagram showing the contents of one record of the customer master. One customer's information constitutes one record. Member number (C1), e-mail address (C2), kana name (C
3), Kanji name (C4), zip code (C5), address (C
6), phone number (C7), gender (C8), date of birth (C
9), enrollment date (C10), attributes such as occupation (C11),
It has a field of family attribute (C12). These data are entered when the customer becomes a loyalty card member,
It will not be changed unless the member customer explicitly notifies the change.

FIG. 6 shows the contents of one record of purchase data. One record is created at the store terminal 40 for one use (one purchase with a point card) of the member customer.
Use store code (B1), use date and time (B2), member number (B3), use amount (B4), grant point (B5),
It has fields of an exchange point (B6) and a product classification (B7).

FIG. 7 shows the contents of one record of customer point data. Each field includes a member number (D1), a cumulative point (D2) indicating the cumulative number of points of the customer up to the present, and a point exchange count (D3) indicating the number of points exchanged by the customer so far. Each time the member customer uses the point card, the customer point data is updated according to the contents of the purchase data generated at that time.

FIGS. 9 and 10 are diagrams for explaining the operation of the buying and selling graph creating means. Hereinafter, FIGS. 9 and 10
The following describes a specific execution procedure of the buying and selling analysis.

First, when the analyst activates the analysis terminal 10, the buying and selling graph creating means operates, and FIG.
The initial screen of appears. Here, when the shopping mall registration button is selected, a shopping mall input screen shown in FIG. 9C is displayed. At the time of shopping street registration, a shopping street map is created on the screen, a shop code (item B1 of purchase data) is associated with each shop section on the map, and when coordinates are input on the map, the corresponding shop (store) is created. Create and register a coordinate / store code conversion table that returns the code) with a unique name for the shopping street.

When the analysis button is selected on the initial screen shown in FIG. 9A, a screen for setting up a buying and selling analysis condition shown in FIG. 9B is displayed. Here, a shopping street is selected and an analysis period is set. When the analysis start button is selected, the buying and selling analysis condition information is sent to the center server 20 via the network 9,
It is passed to the buying and selling analyzing means 21. The buying and selling analysis means starts the analysis according to the buying and selling analysis condition information.

FIG. 8 is an operation flowchart of the buying and selling analysis means 21. As a result of this processing, during the analysis period of the designated shopping street, data is obtained in which the number of times of use of the same customer is continuously counted within a certain period of time for each combination of all two stores in the shopping street. This result is returned to the buying and selling analysis graph creating means 11 of the analysis terminal 10.

The operation of the buying and selling analyzing means 21 will be described with reference to FIG. First, necessary initialization is performed, and the date is set as the first day of the set period (S100). All the purchase data for the day is extracted (S103). The own store number (store code) is set to 1 (S106). The partner store number (store code) is set to the own store number plus one (S109). The purchase data record is searched to determine whether the same customer has used both stores within one hour in the own store and the partner store within one hour (S112). If there is such a purchase record, the contents of the store pair count array (own store number, partner store number) are incremented by 1 (S115). This is repeated until the other store number ends (S121), and further until the own store number ends (S127). When the count for one day is completed, the date is incremented (S130), and until all the analysis designated periods are completed. It repeats (S133). The finally obtained store pair count array (own store number, partner store number) is returned to the requesting analysis terminal as an analysis result (S13).
6).

Then, the buying graph creation means 11
First, 10 screens 600 are displayed, and based on the analysis results,
This is a screen that supports creation of a buying graph. In FIG. 10, the analyst sequentially selects the store numbers as 1, 2,... In FIG. 10, the store 2 is selected (the number of the store 2 is circled to indicate that it is selected. The coordinates on the shopping mall map are designated by the coordinate / store code conversion table. And the corresponding store is recognized). Then, a window 602 is displayed.
Store numbers frequently used at the same time as store 2 are displayed for each frequency stage. This display is created based on the analysis result of the buying and selling analysis means 21. The analyst looks at the window 602 and connects a store that is frequently used simultaneously with the store 2 with an arrow on the shopping street map. When the arrow is drawn, the store number in the window 602 is clicked. In FIG. 10, since an arrow line between the store 2 and the store 47 is drawn, as a result of clicking the button of the store 47, the display color of the button is changed. By displaying in this way, it is possible to prevent forgetting to create an arrow line. When the drawing of the arrow lines is completed for all the stores displayed in the window 602, the next store (store 3) is selected on the shopping mall map, and the same operation is repeated.

If the above operation is repeated for all stores, a buying graph is completed. When the print button is pressed, a buying graph as shown in FIG. If you select the file save button, you can save the created buying and selling graph as a data file, circulate it among the concerned parties by floppy (registered trademark) disk or e-mail, analyze the customer's flow line, store location in the shopping street It can be used for planning.

Although one embodiment of the buying and selling analysis system has been described above, it goes without saying that other embodiments are possible within the scope of the present invention. For example, the analysis terminal 10 and the center server 20 may be unified, and both may be integrated, and a process may be performed on the center server 20 up to creation of a buying graph. In addition, the store terminal 40
Instead of being connected by a network between the center servers, purchase data and analysis result data may be stored in a magnetic medium and delivered offline. Further, the operation flow of the buying and selling analysis means 21 shows one implementation example, and if there is a more efficient analysis method, it may be implemented by another procedure.

In the buying and selling graph of FIG. 1, the simultaneous use tendency of the two stores is represented by the difference in frequency step by the thickness of the arrow and the dotted line, but may be represented by the difference in the color of the arrow.

[0021]

The obtained buying and selling graph retains the actual spatial arrangement information between stores as it is, so that it can be effectively used for analyzing the traffic flow of customers and formulating an effective store arrangement plan.

[Brief description of the drawings]

FIG. 1 is an example of a buying graph.

FIG. 2 is a schematic block diagram of a buying and selling analysis method.

FIG. 3 is an explanatory diagram of a conventional technique.

FIG. 4 is an overall configuration diagram

FIG. 5 is one record of a customer master in a customer database.

FIG. 6 shows one record of purchase data in a customer database.

[Fig. 7] 1 of customer point data of customer database
It is a record.

FIG. 8 is a flowchart illustrating an operation of a buying and selling analysis means.

FIG. 9 is an interactive screen of a buying graph creation means.

FIG. 10 is a graph creation screen of a buying graph creation means.

[Explanation of symbols]

 DESCRIPTION OF REFERENCE NUMERALS 10 analysis terminal 11 buying graph creation means 12 graphic display 13 printer 14 input unit 40 store terminal 20 center server 21 buying analysis means 22 database management means 30 external storage device 31 customer database

Claims (3)

[Claims] 1. Each time a member customer uses a member store, a first step of creating purchase data created by recording a member number, a store used, and a use date and time and storing it as a database; The second step of searching for the purchase data and counting the number of pairs of two stores continuously used by the same member customer for each combination, and the member store map displayed on the computer screen. And a third step of visually expressing a combination of stores obtained by the second step that are continuously used by the same customer a certain number of times or more in such a manner that the spatial relationship of the actual store arrangement can be grasped. This is a buying and selling analysis method in which a pair of stores used at the same time is visually represented on a member store map. 2. Each time a member customer uses a member store, a customer database storing purchase data created by recording a member number, a store used, and a date and time of use, and searching the purchase data for the same member A purchase analysis means for counting the combination of two stores that the customer has used consecutively for each combination, and displaying a member store map, and grasping the spatial relationship of the actual store arrangement based on the purchase analysis result. And a buying graph creating means for visually expressing in a form that can be made. 3. A computer-readable recording medium on which a buying graph created by the method of claim 1 is recorded.