JPH0612426A - Customer management system using segment record history - Google Patents

Abstract

PURPOSE:To facilitate sales plan framing and an analysis, to improve the efficiency of a segmentation work, and to shorten the time for operating a result, with respect to the system for performing the segmentation of a customer from transaction data with respect to the customer management. CONSTITUTION:By means of customer attribute data 1, customer transaction data 2, and segment condition data 3 which is inputted and set, the customer segmentation by a processing part 4 is performed. According to this customer management system, its result is contained as a segment record 5, and at the time of executing the processing concerned, data for executing sales plan framing and an analysis is fetched to a display part 6 and an output part 7 by a work instruction from an input part 8.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION The present invention is applied to a segmentation work relating to customer management and its application work.

[0002]

2. Description of the Related Art In the conventional segmentation, points are collected from transaction detail data and used as one item of customer attribute data. Therefore, it was necessary to re-aggregate and process all cases as to how the customers were changing over time. Furthermore, in order to specify the segment from the input condition and print it, recalculation and all-items processing were also required.
Related to this type of technology, for example, JP-A-59-170953 and JP-A-63-3146.
There is a technique described in Japanese Patent Publication No. 52-52.

[0003]

In the above-mentioned prior art, the latest customer transaction points were recorded. Therefore, in order to analyze in time series for each customer, it took time for reprocessing and the like, and there was a problem in screen display and time series analysis. Also, it was difficult to extract and print the previous specific segment depending on the input conditions.

An object of the present invention is to periodically record a customer segmentation result based on segment condition data.
It is a history of the history, which allows the screen display for each customer and
The purpose is to perform totalized printing in a short time and to process specific segment data according to input conditions.

[0005]

In order to achieve the above object, the following may be done.

Before the customer segmentation process, the segment number is added to the data designating the condition of the segment and registered, and the customer attribute data for each segment,
The segment number that matches the conditions is stored from the customer transaction data together with the customer number, date and the like. Therefore, it becomes possible by operating the segmentation results in time series, reading the record history from the customer number on the screen display of the designated customer, and reading the stored record history for the aggregate print for each segment number.

Then, the segment number can be used to output the specific record of the segment for which the input condition is designated.

[0008]

The function of storing the segment condition and the segment record is to store the condition and the result of the regular segmentation for a long period of time. It is possible to shorten the time for extracting the data to grasp the segment contents in time series.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is a system configuration diagram showing an embodiment of the present invention, FIG. 2 is a flow chart of customer segment record creation processing, and FIG. 3 is an operation of segmentation result data and screen display. FIG. 4 shows a flow chart of print processing, FIG. 4 shows a flow chart of customer data print processing by segment records, and FIG. 5 shows a data configuration diagram.

In FIG. 1, the segment condition registration process 9 of the processing unit 4 inputs the customer attribute data 1 and the customer transaction data 2 from the input unit 8 and outputs the segment condition data 3 to the storage unit. The customer segment record creating process 10 inputs the segment condition data 3 and outputs the result as a segment record 5 to the storage unit. After such segmentation is completed, the data operation processing 11 and the data selection processing 12 of the processing unit 4 display the time-series segment status of the customer on the display unit 6 according to the designation of the input unit, and the customer distribution It is output to the customer data output unit 7 of the situation and the specified segment. Figure 5 shows the record format of each data.
The customer attribute data 1 has various customer data with the customer number 30 and the segment number 31 as keys, the customer transaction data 2 has the customer number 30 and transaction detail data for each transaction, and the segment condition data 3 is the segment number. The segment record 5 is a record having a segment condition with 31 as a key, and the segmentation result with the customer number 30 and the segment number 31 as keys.

FIG. 2 is a customer segment record creation process 1
It shows a processing flow of 0. In the segment condition registration processing 9, data such as the segment condition registration screen 13 is input from the input unit 8 and the segment condition data 3 is output. The segment record creating process 10 obtains a segment number to be segmented through the segment execution screen 14 and starts the process. The segment condition stack 15 of the flow chart inputs all the specified segment condition data to the processing unit 4, and after the customer transaction data input 16, the target data is extracted according to the condition and the calculation processing is performed. After inputting the customer attribute data 17, the house under the condition 3 is collated, and if they match, the customer number 30 and the segment number 31 are output as the segment record 5.

In FIG. 3, after the customer key is set 20 by the data from the customer history inquiry screen 19, the segment records and the customer transaction data are arranged in descending order of date until the number of lines on the screen is reached. , Customer history inquiry result 21 is displayed. Furthermore, the segment analysis output execution screen 22
Then, after the execution data input 23, the segment records are sequentially input, and if the segment number is specified in the execution data, the segment number and the customer number are paired and output to the work area. After the input is completed, the work area data classification 24 classifies the data into customer numbers and segment numbers, prints out the total for the segment analysis table and outputs the segment analysis table 25.

In FIG. 4, the data selection processing 12 obtains the data on the promotion label extraction condition screen 26 by the extraction condition input 27, and then the segment condition data stack of the segment number specified in the condition. 28 in the processing unit 4, the segment records are sequentially input, and the segment number record of the extraction condition designation is output to the work area, and then the customer number is classified 29, and then the segment is added to the customer attribute data. The data that matches the specified conditions other than the number is output as a label.

[0015]

According to the present invention, the following effects can be expected.

(1) It is possible to record the condition setting data of the customer segment, and it becomes possible to refer to the customer purchasing situation in time series from the result of segmentation under this condition, which facilitates sales planning and analysis.

(2) To improve the efficiency of the customer segmentation work and shorten the time for the result operation processing.

[Brief description of drawings]

FIG. 1 is a system configuration diagram of the present invention.

FIG. 2 is a flowchart of a customer segment record creation process.

FIG. 3 is a flow chart of an operation of segmentation result data and a screen display printing process.

FIG. 4 is a flow chart of a customer data printing process by a segment record.

FIG. 5 is a data block diagram.

[Explanation of symbols]

1 ... Customer attribute data, 2 ... Customer transaction data, 3 ... Segment condition data, 5 ... Segment record, 9 ... Segment condition registration processing, 10 ... Segment record creation processing, 11 ... Data Operation processing, 12 ... Data selection processing, 3
0 ... Customer number, 31 ... Segment number

Claims (3)

[Claims] 1. A segment condition data and a segmented result data for recording a segmentation in a customer management process based on a customer attribute data and a customer transaction data. A customer management method using a segment record history, which has a storage unit for storing the. 2. In the customer management processing based on the customer attribute data and the customer transaction data, the result of the customer segmentation is operated in chronological order and displayed or printed. Customer management method using segment record history. 3. In the customer management process based on the customer attribute data and the customer transaction data, the segment data specified by the condition from the input section is extracted and printed on the output section. Customer management method using segment record history.