JP3865977B2 - Discount charge calculation storage method and apparatus, and computer-readable recording medium recording discount charge calculation storage program - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a discount charge calculation and storage device for calculating charges for various products to which charges are added according to the amount of use, and in particular, sales operations in the case of providing discount service products that reduce product charges under various conditions The present invention relates to a technology that is effective when applied to a discount charge calculation storage device that supports
[0002]
[Prior art]
The usage status data of the pay-as-you-go product contractor may be information on the amount of calls in telecommunications, information on the amount used in electricity, gas, water, and the like. Taking the field of telecommunications as an example, various discount service products have appeared due to intensifying price competition.
In proposing these discount service products, it is most convincing to show how much the billing fee will be reduced when the discount service products are applied based on the actual usage situation of the contractor.
For this purpose, the past usage situation of each contractor is investigated, and the billing fee is calculated again according to the condition of the discount product.
On the other hand, a search for an optimal discount service product for each contractor is also underway. Based on the service request from the contractor, a rule for extracting the communication history characteristics from the contractor's communication history information and the extracted features Japanese Laid-Open Patent Publication No. 6-284201 describes a method for finding an optimal service product for the contractor from a service selection rule for selecting an optimal communication network and communication service.
Japanese Patent Laid-Open No. 7-311799 discloses a method of statistically analyzing the usage status of a contractor and finding a discount service product corresponding to the user model by determining a user model most similar to the usage pattern of the contractor. It is described in the publication.
[0003]
[Problems to be solved by the invention]
Pay-as-you-go discount service products, for example, in the field of telecommunications, are a combination of various factors such as usage amount, usage time zone, communication destination, etc. Has come to be offered.
For this reason, it is not easy for the contractor to determine which discount service product is most advantageous to use, and the service provider asks the service provider. There is a need to investigate the usage status of and to simulate billing charges when discount service products are applied.
[0004]
According to the method described in Japanese Patent Laid-Open No. Hei 6-284201, it is possible to find a discount service product that is optimal for the usage status of the contractor, but when the discount service product is applied to the past usage status Since the billing fee is not calculated, it is necessary to separately calculate how much the billing fee will be.
Similarly, when proposing discount service products to customers, it is necessary to investigate the actual usage status of the contractor and calculate the discount amount.
The contractor often wants a survey based on usage over the past six months or one year rather than in a short period of time, but the usage data is large, so the past data is magnetic tape. Since it is often stored in a device or the like and it is difficult to obtain usage status data online, it is impossible to immediately investigate the usage status of the contractor and calculate the discount amount.
According to the method described in the above-mentioned Japanese Patent Application Laid-Open No. 7-311799, it is possible to find a discount service product that is most suitable for the usage status of a specific contractor for the current month, but the usage status for the past six months or one year. It is not possible to find an optimal discount service product that takes into account the above, and it is necessary to calculate separately.
[0005]
For a contractor with a sales representative, the sales representative checks in advance whether the discount service product is suitable based on the usage status of the contractor and, if necessary, is advantageous to the contractor. If you are a contractor who does not have a sales representative, you do not follow this kind of personal follow-up, and you are not proposing an advantageous product. There is a problem of changing to products offered by.
In addition, some contractors may require proof that they are more advantageous than products offered by other companies, and in that case, the billing fee is simulated based on the conditions of the other company's products based on the usage status of the contractor. Although there is a need to do this, there is a problem that it is not possible to show that it is more advantageous than the products of other companies because simulation of the billing charges when using products of other companies is not performed.
In addition, when there are many contractors who are more advantageous to products of other companies, there is a possibility that those contractors may be transferred to the products of the other companies. Although it is necessary to develop a discount service product, there is a problem that it is difficult to develop a counter product because the number of contractors in which the products of other companies are more advantageous is not clear.
An object of the present invention is to solve the above-described problems and provide a technique capable of quickly responding without inquiring about the usage status of the contractor when inquiring from the contractor or proposing a discount service product. .
[0006]
[Means for Solving the Problems]
In order to achieve the above object, the present invention provides:
It is a charge calculation accumulation method that calculates and accumulates usage charges when each contractor uses various products,
The charge calculation target product information indicating the product subject to charge calculation among a plurality of products including unapplied products set in the contractor's customer data is acquired, and the value of the acquired charge calculation target product information is For products that indicate that they are subject to charge calculation, charge for the use of the product will be calculated before receiving an inquiry about the charge for using the product from the contractor, and calculation for unapplied products The results are stored in the fee calculation database as fee simulation results, and customer profile information is created for each contractor by statistically aggregating the contractor's usage status data for each statistical aggregation item. If there is a change in the customer profile information compared with the previous month, the usage statement for the current month corresponding to the change from the table that associates the type of change with the product Optimum product extracts, and to change the value of the billing Shipping information set in the customer data of the subscriber on the basis of the extraction result.
[0007]
Furthermore, the customer profile information of each contractor is compared to determine the similarity, and each customer profile information is grouped according to the similarity and the threshold, and the standard profile for each group based on the customer profile information within the group Information is extracted, stored in the standard profile information database, the customer profile information of the contractor is compared with the standard profile information in the standard profile information database, and the group to which the customer profile information of the contractor belongs last time When the change is made, the optimal product for the group after the change is extracted from the table in which the group and the product are associated, and the value of the charge calculation target product information set in the customer data of the contractor based on the extraction result I am trying to change it.
[0008]
In addition, it is a charge calculation storage device that calculates and stores usage charges when each contractor uses various products,
The charge calculation target product information indicating the product subject to charge calculation among a plurality of products including unapplied products set in the contractor's customer data is acquired, and the value of the acquired charge calculation target product information is For products that indicate that they are subject to charge calculation, charge for the use of the product will be calculated before receiving an inquiry about the charge for using the product from the contractor, and calculation for unapplied products A charge calculation control processing unit for storing the result in the charge calculation database as a charge simulation result;
A charge calculation processing unit that performs charge calculation using the usage status data of the contractor in accordance with an instruction from the charge calculation control processing unit;
A customer profile extraction processing unit for creating customer profile information obtained by statistically aggregating the usage status data of the contractor for each statistically aggregated item for each contractor;
Compares the contractor's customer profile information for the current month with the previous month, and if there is a change in the customer profile information, it is best suited to the usage situation for the current month corresponding to the change from the table that associates the type of change with the product And a customer profile comparison processing unit that extracts the value of the charge calculation target product information set in the customer data of the contractor based on the extraction result.
[0009]
Furthermore, the customer profile information of each contractor is compared to determine the similarity, and each customer profile information is grouped according to the similarity and the threshold, and the standard profile for each group based on the customer profile information within the group A standard profile management processor that extracts information and stores it in a standard profile information database;
The contractor's customer profile information is compared with the standard profile information in the standard profile information database, and when the group to which the contractor's customer profile information belongs has changed from the group to which it last belonged, the group is associated with the product. A profile comparison processing unit that extracts the optimal product for the changed group from the table and changes the value of the charge calculation target product information set in the customer data of the contractor based on the extraction result is provided.
[0010]
Further, it is a computer-readable recording medium that records a discount charge calculation storage program,
The discount charge calculation accumulation program obtains charge calculation target product information indicating a product subject to charge calculation among a plurality of products including unapplied products set in the contractor's customer data,
For the product whose value of the acquired charge calculation target product information indicates the target of charge calculation, the charge when using the product before receiving an inquiry about the charge when using the product from the contractor The procedure to do the calculation,
A procedure for storing calculation results for unapplied products in the charge calculation database as charge simulation results,
A procedure for creating customer profile information in which each contractor's usage data is statistically aggregated for each statistical aggregated item,
Compares the contractor's customer profile information for the current month with the previous month, and if there is a change in the customer profile information, it is best suited to the usage situation for the current month corresponding to the change from the table that associates the type of change with the product The steps to extract the right products,
A procedure for changing the value of the charge calculation target product information set in the contractor's customer data based on the extraction result is provided.
[0011]
Further, the discount charge calculation storage program compares the customer profile information of each contractor to obtain a similarity, and groups each customer profile information according to the similarity and a threshold;
Extracting standard profile information for each group based on customer profile information within the group and storing it in the standard profile information database;
The contractor's customer profile information is compared with the standard profile information in the standard profile information database, and when the group to which the contractor's customer profile information belongs has changed from the group to which it last belonged, the group is associated with the product. The procedure to extract the best product for the changed group from the table,
A procedure for changing the value of the charge calculation target product information set in the contractor's customer data based on the extraction result is provided.
[0012]
DETAILED DESCRIPTION OF THE INVENTION
First, the principle of the present invention will be described.
The embodiment of the present invention is roughly divided into the following four principles.
(1) Manage customer profile information for each contractor.
Customer profile information is information obtained by statistically collecting the usage status of each contractor.
The statistically aggregated information is, for example, the usage time and usage count for each call time zone, the usage time and usage count for each call day, and the usage time and usage count for each call destination.
The management of customer profile information is a process of extracting and accumulating predetermined items for statistical aggregation based on the usage status of each contractor.
(2) Charge calculation accumulation processing for each contractor is performed.
The charge calculation accumulation process is a process for calculating a charge for an applied product and an unapplied product determined in advance for each contractor.
As the products for which the charge calculation is performed, the products considered to be optimal are selected based on the customer profile information for each contractor.
A product that seems to be optimal is set for each contractor by being extracted from the customer profile information described in the first principle or deleted according to the charge calculation result. (3) Manage standard profile information viewed from customer profile information for each contractor.
The standard profile information is obtained by performing grouping based on the similarity of the usage situation based on the customer profile information described in the first principle and calculating the standard value of each group.
(4) Based on the customer profile information for each contractor, it is managed whether there is any change in the group to which it belongs.
The group to which the user belongs is based on the standard value of the group described in the third principle above, and assigns a group to each contractor based on which standard value the customer profile information of each contractor is similar to. is there.
A product that seems to be optimal is set in advance in the group, and a contractor who is determined to have a change in the group will be charged for the product corresponding to the group.
[0013]
Hereinafter, a discount charge calculation / accumulation device according to an embodiment that calculates and accumulates usage charges in advance when a contractor uses various products including unapplied products will be described.
FIG. 1 is a diagram showing a schematic configuration of a discount charge calculation storage apparatus of the present embodiment.
As shown in FIG. 1, the discount charge calculation storage device of this embodiment includes a customer profile extraction processing unit 201, a charge calculation control processing unit 202, a customer profile comparison processing unit 203, a charge calculation processing unit 204, and a comparison determination. A processing unit 205, a customer database management processing unit 206, a standard profile management processing unit 207, and a profile comparison processing unit 208 are included.
[0014]
The customer profile extraction processing unit 201 is a processing unit that obtains the contractor's usage status data from the usage status database 115 as needed or periodically and stores it in the customer profile database 117 as customer profile information.
The charge calculation control processing unit 202 instructs to check the change in usage status of each contractor, and sets charge calculation target product information indicating a product for which charge calculation is to be performed among a plurality of products including unapplied products. For a product acquired from the customer database 116 and indicating that the acquired charge calculation target product information is a target of charge calculation, the product is received before receiving a charge inquiry from the contractor when using the product. Instructs the calculation of charges when used, stores the calculation results for products that the contractor has actually applied for in the charge fee database 119 as billing charges, and calculates the calculation results for unapplied products as the charge simulation results It is a processing unit stored in the charge calculation database 120.
The customer profile comparison processing unit 203 compares the customer profile information of the contractor for the current month with the customer profile information of the previous month in accordance with an instruction from the charge calculation control processing unit 202, and calculates the price of unapplied products according to the comparison result. The processing unit changes the value of the charge calculation target product information to the setting for performing
The fee calculation processing unit 204 is a processing unit that performs fee calculation using the usage status data of the contractor in accordance with an instruction from the fee calculation control processing unit 202.
The comparison judgment processing unit 205 is set so that the charge calculation of the unapplied product is not performed after the next time according to the comparison result between the billing fee of the product applied by the contractor and the charge simulation result of the unapplied product. This is a processing unit that changes the value of the charge calculation target product information (this value will be described later).
The customer database management processing unit 206 is a processing unit that manages the customer database 116.
[0015]
The standard profile management processing unit 207 periodically acquires customer profile information of all contractors or arbitrary contractors from the customer profile database 117, performs grouping based on the similarity of the acquired customer profile information, This is a processing unit that extracts standard profile information of a group and stores it in the standard profile database 121.
The profile comparison processing unit 208 acquires standard profile information from the standard profile database 121 at regular or arbitrary timing, and compares the acquired standard profile information with the profile information of the contractor in the customer profile database 117. The processing unit changes the value of the charge calculation target product information of the contractor to the setting for calculating the charge of the unapplied product according to the comparison result.
The discount charge calculation storage device includes a customer profile extraction processing unit 201, a charge calculation control processing unit 202, a customer profile comparison processing unit 203, a charge calculation processing unit 204, a comparison determination processing unit 205, a customer database management processing unit 206, and a standard profile management process. It is assumed that a program for functioning as the unit 207 and the profile comparison processing unit 208 is recorded on a recording medium such as a CD-ROM, stored in a magnetic disk, etc., then loaded into a memory and executed.
The medium for recording the program may be a medium other than the CD-ROM.
[0016]
The system includes a main memory 111 for storing various processing programs and work areas,
A display unit 112 for displaying customer profile information for each contractor, charge calculation results for each contractor, information on products for which charges have been applied and products for which charges have not been applied, and the like.
Enter customer profile information for each contractor, charge calculation results for each contractor, input of search key to search for product information for application and unapplied products, and addition of product information for charge calculation of unapplied products And an input unit 113 for instructing deletion,
CPU 114, which is a central processing unit that performs arithmetic processing;
A usage database 115 that stores contractor usage data;
A customer database 116 that stores information on the product for which charge calculation is applied for the applied product and the unapplied product and the group to which the usage status belongs;
A customer profile database 117 storing profile information for each contractor;
A usage status-service relation table 118 that stores associations between types of usage status changes and discount service products for extracting discount service products optimal for usage status changes based on changes in usage status;
A billing fee database 119 for storing billing fee data which is actual fee billing information to the contractor;
A charge calculation database 120 for storing a charge simulation result for products for which the contractor has not applied,
A standard profile database 121 for storing grouped standard profile information;
A group-service relation table 122 is provided for storing associations between discount service products and groups for extracting discount service products most suitable for the changed group based on the change of the group to which the user belongs.
[0017]
The main memory 111 acquires the contractor's usage status data from the usage status database 115 and stores it in the customer profile database 117 as customer profile information.
The customer profile information is acquired from the customer profile database 117, the acquired customer profile information is compared, the calculation target product information for each contractor is obtained from the customer database 116 based on the execution result, and the contract from the usage status database 115 A charge calculation control processing unit 202 that extracts a usage state of each person, executes charge calculation corresponding to the extracted calculation target product information, and selects an output destination of charge calculation results;
A customer profile comparison processing unit 203 for comparing customer profile information for each contractor;
A charge calculation processing unit 204 for calculating charges based on the charge calculation specifications for each product;
A comparison / determination processing unit 205 that selects billing service products for the next and subsequent times of the contractor by comparing the billing charge data and the charge simulation result for each contractor;
A customer database management processing unit 206 for registering or changing the charge calculation target product information of unapplied products for each contractor selected by the customer profile comparison processing unit 203 and the comparison determination processing unit 205 in the customer database 116;
Standard profile management processing unit that acquires customer profile information from the customer profile database 117, performs grouping based on the similarity of the acquired customer profile information, extracts the standard profile information of each group, and stores it in the standard profile database 121 207,
A profile comparison processing unit 208 that compares the standard profile information with customer profile information for each contractor, and changes the value of the charge calculation target product information to a setting for calculating the charge of an unapplied product according to the comparison result;
It has a work area 209 for temporarily storing the results of various processes, input information, and the like.
[0018]
FIG. 2 is a diagram showing an example of the usage status database 115 of the present embodiment.
As shown in FIG. 2, the usage status database 115 stores information on the usage breakdown of the pay-as-you-go product contractor.
For example, in the present embodiment, in the usage status database 115, the customer telephone number 21, the contractor's outgoing telephone number 22, and the other party's incoming telephone number 23 that can uniquely identify the usage breakdown are started. The start date 24, the start time 25 when the use is started, the end date 26 when the use is ended, and the end time 27 when the use is ended are stored.
[0019]
FIG. 3 is a diagram illustrating an example of the customer database 116 according to the present embodiment.
As shown in FIG. 3, the customer database 116 stores information for determining a charge calculation target product for each contractor.
For example, in this embodiment, the customer database 116 includes a customer number column 31 that allows each contractor registered in the customer name column 32 to uniquely identify the contractor, and a customer power key that is a key for charge calculation. No. column 33, own price calculation target product column 34 in which the company's charge calculation target product information is stored, other company charge calculation target product column 35 in which the other company's charge calculation target product information is stored, and each contractor Is provided with a group ID column 36 in which a code for identifying which group of the standard profile information in the standard profile database 121 belongs is stored.
For example, the actual charge amount is calculated for each product (product A, product B, product C, product D, product a, product b) in the company charge calculation product column 34 and the other company charge calculation product column 35. “○” for applied products that need to be processed, “△” for unapplied products for which price simulation calculation is performed, and “-” for unapplied products that do not require fee simulation calculation Is stored.
Each of the above “◯”, “Δ”, and “−” is referred to as the value of the charge calculation target product information.
Judgment for which product price simulation calculation is performed can be easily added or deleted from an online screen or the like by an inquiry from a contractor or a business decision.
[0020]
FIG. 4 is a flowchart showing the procedure of the customer profile extraction process in the discount charge calculation storage apparatus of this embodiment.
The customer profile extraction process of this embodiment is demonstrated along the flowchart of FIG.
First, one record of the usage status database 115 is read (step 401), and based on the read usage status data, statistics are aggregated (the usage time and usage count for each call time zone, the usage time and usage count for each call day, The usage time and the number of times of use for each call destination are extracted (step 402).
Next, based on the extracted item, the customer profile information in the customer profile database 117 is updated using the customer telephone number as a key (step 403).
Then, it is determined whether or not usage status data that has not been statistically aggregated remains in the records in the usage status database 115 (step 404).
The processing from step 401 to step 403 is repeated until there is no usage status data that has not been statistically aggregated.
When there is no usage data for which statistics have not been aggregated, all processing is terminated.
The timing for collecting statistics may be performed in real time when the usage status data is generated, or may be performed at regular timing such as daily or monthly.
[0021]
FIG. 5 is a diagram showing an example of the customer profile database 117 of this embodiment.
As shown in FIG. 5, the customer profile database 117 stores information obtained by statistically collecting the usage status of each contractor.
For example, in the present embodiment, information obtained by statistically collecting the usage status is information (FIG. 5A) in which usage times and usage counts are aggregated for each call time zone, and usage times and usage counts are aggregated for each call day. Information (FIG. 5 (b)) and information (FIG. 5 (c)) in which usage time and number of usages are tabulated for each call partner.
The customer profile database 117 includes a customer number field 51 that allows each contractor registered in the customer name field 52 to uniquely identify the contractor, a customer telephone number field 53 that is a key for statistical aggregation, a call Use time / count field 54 for each call time zone that stores the use time and use frequency for each time zone, use time / count field 55 for each call day that stores the use time and use frequency for each call day, There is provided a use time / number of times field 56 for each call destination in which the use time and the number of use are stored for each destination.
[0022]
FIG. 6 is a flowchart showing a procedure of fee calculation accumulation processing in the discount fee calculation accumulation device of this embodiment.
The charge calculation accumulation process of this embodiment is demonstrated along the flowchart of FIG.
First, one customer profile information for the current month in the customer profile database 117 is acquired (step 601).
Similarly, the customer profile information of the same contractor as the acquired customer profile information for the previous month is acquired from the customer profile database 117 (step 602).
The acquired customer profile information of the current month and the previous month are compared (step 603), and it is determined whether there has been a change (step 604).
Whether there is a change in the customer profile information can be determined by calculating how similar the two usage states to be compared are (= similarity) and setting a threshold value.
The degree of similarity is obtained by expressing two usage situations to be compared as a distribution diagram and calculating the area difference between them.
The threshold value is used to determine how much similarity is handled as profile information of the same group, and the threshold value can be arbitrarily set.
[0023]
If it is determined that there has been a change, discount service product information corresponding to the change is extracted (step 605).
The extraction method is, for example, by preparing a usage state-service relation table 118 that associates discount service product information with a type of change (change regarding a call time zone, change regarding a call day, change regarding a call partner, etc.) It is possible to quickly extract discount service product information to be subjected to charge simulation according to the type of change.
The extracted discount service product information is compared with the charge calculation target product information in the customer database 116 of the contractor determined to have changed in the customer profile information (step 606), and the extracted discount service product information performs the charge calculation. Is checked (step 607).
When the value of the customer database 116 is not set so as to perform charge calculation, the customer database management processing unit 206 sets the value of the product information in the customer database 116 so that the advance fee simulation is performed with the discount service product information. Is changed from “−” to “Δ” (step 608).
For the customer profile information in the customer profile database 117, it is checked whether or not there is a target for checking whether the customer profile information has changed (step 609), and the processing from step 601 to step 608 is repeated until there is no target to be checked.
[0024]
Next, the number of records in the customer database 116 is acquired and stored in the counter N (step 610).
Then, it is determined whether or not the value of N is “0” (step 611).
This is because it is necessary to repeatedly perform the following processing (processing from step 612 to step 621) until there are no more records in the customer database 116.
If the value of N is not “0”, one record for each contractor is read from the customer database 116 in which the charge calculation target product information for each contractor is registered (step 612).
From the read record, charge calculation target product information that needs to be calculated for the contractor is acquired (step 613).
Items that require fee calculation include not only products that are actually applied for by the contractor, but also products that are set to perform charge simulation calculation based on inquiries from the contractor or business decisions. It is.
However, the product actually applied for by the contractor and the product for the charge simulation are classified according to the charge calculation target product information in the customer database 116 as described above, and the charge calculation control processing unit 202 Distinguish accordingly.
Further, the number of products subject to fee simulation is not limited to one, and a plurality of products are possible, and other companies 'products may be targeted for price comparison with other companies' products.
[0025]
Further, the usage status data for the contractor corresponding to the read record is read from the usage status database 115 (step 614), and the charge calculation processing is performed on the charge calculation target product information acquired in step 613 (step 615).
The charge calculation processing unit 204 is often created independently for each product. In this case, if the computer has parallel computing capability, a plurality of calculation processing, for example, the calculation processing for the product A and the product B It is possible to simultaneously perform the calculation process.
The charge calculation control processing unit 202 stores the calculation processing result for the product that the contractor has actually applied for in the billing fee database 119 (step 616), and the contractor has not applied for the charge simulation product that has not been applied for. The calculation processing result is stored in the fee calculation database 120 (step 617).
[0026]
FIG. 7 is a diagram showing an example of the usage status-service relation table 118 according to this embodiment.
As shown in FIG. 7, discount service product information corresponding to the type of change is stored in the usage status-service relation table 118 for each type of change in usage status.
For example, in the present embodiment, in the usage status-service relation table 118, a change code in which a change code that uniquely identifies the change type is registered for each change type registered in the change type column 72 is registered. A code column 71 and a corresponding discount service product column 73 for each change type in which the corresponding discount service product information is registered for each type of change are provided.
In the discount service product column 73 according to the change type, for example, “Discount service product for which it is better to perform a charge simulation calculation for each product (product A, product B, product C, product D, product a)” “O”, discount service products that do not require charge simulation calculation store information such as “space”.
Judgment for which product price simulation calculation is performed can be easily added or deleted from an online screen or the like based on business judgment or the like.
[0027]
FIG. 8 is a diagram showing an example of the billing fee database 119 of the present embodiment.
As shown in FIG. 8, the billing fee database 119 stores information on the breakdown of billing for each contractor.
For example, in the present embodiment, the billing fee database 119 includes a customer number column 81 in which a customer number for uniquely identifying each contractor registered in the customer name column 82 is registered. A customer telephone number column 83 in which a telephone number is registered, a billing date column 84 in which a billing date is registered, and a billing information column 85 in which billing information is stored are provided.
In the charge billing information column 85, for example, a product name, a breakdown of charges for the product (breakdown 1, breakdown 2, breakdown 3) and a total charge amount thereof are stored.
Such information can be used when an invoice is actually issued to the contractor.
[0028]
FIG. 9 is a diagram showing an example of the fee calculation database 120 of the present embodiment.
As shown in FIG. 9, the charge calculation database 120 stores information on the result of the charge simulation calculation for each contractor.
For example, in the present embodiment, the charge calculation database 120 includes a customer number column 91 in which a customer number for uniquely identifying each contractor registered in the customer name column 92 is registered. Customer telephone number column 93 in which a telephone number is registered, billing date column 94 in which a billing date is registered, an in-house product simulation result column 95 in which a result of charge simulation calculation performed on the in-house product is stored, and other companies The other company product result column 96 in which the result of the charge simulation calculation for the product is stored is provided.
[0029]
From the billing fee database 119 and the fee calculation database 120, the charge simulation calculation result including the billing fee data and the discount service products of other companies can be inquired instantaneously and simultaneously using the customer number as a key.
When the charge calculation process for one record is completed, the comparison determination processing unit 205 compares the charge calculation data of the product that the contractor has applied for with the charge calculation result for the unapplied charge simulation product (step 618). ).
The timing for comparison may be performed after the calculation processing for all records is completed.
Whether the price simulation calculation result for a product is clearly larger than the charge for the product for which the contractor is applying, that is, whether the discount service product can be determined to be ineffective for the contractor Check (step 619), for discount service products that can be determined to be ineffective, it is determined that it is useless to perform the fee calculation processing from the next time onward, and the customer database management processing unit 206 does not perform the fee calculation processing from the next time Similarly, the value of the product information in the customer database 116 is changed from “Δ” to “−” (step 620).
The basis for the determination can be freely set, for example, when the charge simulation calculation result is slightly higher than the actual billing charge, 10% higher, or 20% higher.
For products that are not to be changed, the charge simulation is performed after the next time, and the values in the customer database 116 are not changed.
When the process of changing one record is completed, the value of the counter N is decreased by “1” (step 621), and the process proceeds to a process of determining whether the value of N is “0” (step 611).
Thereafter, the processing from step 612 to step 621 is repeated. When there are no more records in the customer database 116, that is, when N becomes “0”, all processing is terminated.
[0030]
FIG. 10 is a flowchart showing the procedure of standard profile management processing in the discount charge calculation storage apparatus of this embodiment.
The standard profile management process of this embodiment will be described with reference to the flowchart of FIG.
First, customer profile information in the customer profile database 117 is acquired (step 1001).
The customer profile information to be acquired may be all contractors or arbitrary contractors. In the acquired customer profile information, a similarity between each piece of customer profile information is calculated (step 1002).
Based on the calculated similarity, a similarity threshold is set to group customer profile information (step 1003).
[0031]
Grouping means that contractors with similar customer profile information are grouped together.
In simple terms, how to divide a group is, for example, a group in which the call volume is concentrated in the daytime period or a group in which the call volume is concentrated in the nighttime period. It is done.
Further, when viewed by day of the call, there may be a group in which the call volume is concentrated on weekdays or a group in which the call volume is concentrated on weekends.
Actually, various groupings are possible depending on what kind of customer profile information is used to calculate the similarity and how the threshold is set.
[0032]
Next, standard profile information for each group is extracted from the customer profile information of each contractor grouped (step 1004).
The standard profile information can be obtained by calculating an average value of customer profile information for each group.
The extracted standard profile information is stored in the standard profile database 121 (step 1005), and all the processes are terminated.
[0033]
FIG. 11 is a diagram showing an example of the standard profile database 121 of this embodiment.
As shown in FIG. 11, in the standard profile database 121, the contractor's customer profile information is divided into groups, and standard profile information for each group is stored.
For example, in the present embodiment, the standard profile database 121 includes a group ID column 1101 for uniquely identifying each group registered in the group name column 1102 and a usage time for each call time zone. Standard usage hours by call time zone 1103 in which the standard usage time for each group that has been viewed is registered, and standard usage times by day of the week in which the standard usage time for each group is viewed from the usage time by day of the call A column 1104 and a combination standard use time column 1105 in which a standard use time for each group viewed from the combination of groups is registered.
Regarding the group, various groups such as a group viewed from the usage time for each call destination, a group viewed from the number of times of use, and a group viewed from a combination thereof can be set.
With regard to group settings, information can be easily added or changed from the online screen, etc., when new service products are added or based on business decisions.
[0034]
FIG. 12 is a flowchart showing the procedure of the comparison process between the standard profile information and the customer profile information in the discount charge calculation storage apparatus of this embodiment.
The profile comparison process of this embodiment will be described with reference to the flowchart of FIG.
First, standard profile information in the standard profile database 121 is acquired (step 1201), and similarly, one customer profile information in the customer profile database 117 is acquired (step 1202).
The acquired standard profile information and customer profile information are compared (step 1203), and the group of the standard profile information to which the customer profile information belongs is extracted (step 1204).
Which group the user belongs to can be obtained by calculating the similarity between the customer profile information and the standard profile information and setting a threshold value.
[0035]
Depending on the threshold value, one group may not be extracted or a plurality of groups may be extracted, but any number of groups may belong.
The group information up to the previous time of the contractor of the acquired customer profile information is acquired from the customer database 116, and the acquired previous group information is compared with the group information extracted this time (step 1205). It is determined whether they are different (step 1206).
If it is determined that they are different, the value of the affiliated group information of the contractor in the customer database 116 is changed to the value of the affiliated group information extracted this time (step 1207).
Next, discount service product information suitable for the extracted new group is extracted (step 1208).
As an extraction method, for example, by preparing a group-service association table 122 in which group information and discount service product information are associated, discount service product information to be subjected to charge simulation according to the group can be quickly extracted. .
[0036]
The discount service product information in the new affiliated group extracted is compared with the price calculation target product information of the contractor set in the customer database 116 (step 1209), and the charge simulation is performed with the discount service product information in the new affiliated group. It is determined whether or not it is set to be executed (step 1210).
If not set, the value of the charge calculation target product information of the contractor set in the customer database 116 is changed from “−” to “Δ” so that the advance charge simulation is performed (step 1211). .
The customer profile information in the customer profile database 117 is checked whether there is an object to be compared with the standard profile information (step 1212), and the processing from step 1202 to step 1211 is repeated until there is no object.
When there are no more targets for comparison, all processing is terminated.
[0037]
FIG. 13 is a diagram showing an example of the group-service relation table 122 of the present embodiment.
As shown in FIG. 13, in the group-service relation table 122, discount service product information corresponding to the group is stored for each group of standard profile information.
For example, in the present embodiment, the group-service association table 122 includes a group ID column 1301 in which a group ID for uniquely identifying each group registered in the group name column 1302 is registered. Separately, a group-specific applicable discount service product column 1303 in which the applicable discount service product information is registered is provided.
The discount service product column 1303 for each group includes, for example, “○ for discount service products for which it is better to perform charge simulation calculation for each product (product A, product B, product C, product D, product a). "Discount service products that do not require charge simulation calculations store information that is classified as" space ".
Judgment for which product price simulation calculation is performed can be easily added or deleted from an online screen or the like when a new service is added or a business decision is made.
[0038]
FIG. 14 is an example of a screen that displays the charge calculation result of the present embodiment.
The charge calculation result for the applied product and the unapplied product set in the customer database (116) of the contractor to be displayed is displayed, and it can be seen at a glance whether the applied product is optimal for the corresponding contractor. It is like that.
If not only the latest charge calculation results but also the past charge calculation results are displayed, it is possible to see in the long term whether the applied product is optimal.
[0039]
As described above, according to the present embodiment, in the charge calculation of various discount service products in the pay-as-you-go product, simultaneously with the charge calculation by the applied product for calculating the actual charge amount, several discount service products It is possible to conduct price simulations, and when responding to inquiries from the contractor or proposing discount service products, it is possible to respond quickly without investigating the use status of the contractor, thus improving customer service. As well as being improved, business efficiency can be improved.
Further, according to the present embodiment, it is possible to check in advance whether a discount service product is suitable without specifying a contractor. When the contractor uses the discount service, it is possible to immediately obtain how much the billing amount has been in the past usage situation, which can be used for selling discount service products.
Furthermore, according to the present embodiment, it is possible to find a contractor who is more advantageous for the other company's product by simultaneously performing a charge simulation when the contractor uses the other company's product. It can also be used to develop discount service products.
As described above, according to the discount charge calculation storage device of this embodiment, the charge when using unapplied products is calculated in advance, so when making inquiries from contractors or proposing discount service products It is possible to respond promptly without investigating the usage status of the contractor.
[0040]
【The invention's effect】
According to the present invention, since the charge when using unapplied products is calculated in advance, it is possible to respond promptly without investigating the usage status of the contractor when inquiring from the contractor or proposing discount service products Is possible.
[Brief description of the drawings]
FIG. 1 is a diagram illustrating a schematic configuration of a discount charge calculation storage apparatus according to an embodiment.
FIG. 2 is a diagram showing an example of a usage status database 115 of the present embodiment.
FIG. 3 is a diagram illustrating an example of a customer database 116 according to the present embodiment.
FIG. 4 is a diagram showing a flowchart of a customer profile extraction process in the discount charge calculation storage apparatus of the present embodiment.
FIG. 5 is a diagram showing an example of a customer profile database 117 according to the present embodiment.
FIG. 6 is a diagram showing a flowchart of charge calculation accumulation processing in the discount charge calculation accumulation apparatus of the present embodiment.
FIG. 7 is a diagram illustrating an example of a usage state-service relation table 118 according to the present embodiment.
FIG. 8 is a diagram showing an example of a charge fee database 119 according to the present embodiment.
FIG. 9 is a diagram showing an example of a charge calculation database 120 of the present embodiment.
FIG. 10 is a flowchart of standard profile management processing in the discount charge calculation storage apparatus of the present embodiment.
FIG. 11 is a diagram showing an example of a standard profile database 121 of the present embodiment.
FIG. 12 is a diagram showing a flowchart of profile comparison processing in the discount charge calculation storage apparatus of the present embodiment.
FIG. 13 is a diagram showing an example of a group-service association table 122 of the present embodiment.
FIG. 14 is a diagram showing an example of a screen that displays a charge calculation result of the present embodiment.
[Explanation of symbols]
111 Main memory
112 Display section
113 Input section
114 CPU
115 Usage database
116 customer database
117 customer profile database
118 Usage-Service Related Table
119 Billing fee database
120 charge calculation database
121 Standard profile database
122 Group Service Related Table
201 Customer profile extraction processing unit
202 Charge calculation control processing section
203 Customer profile comparison processing section
204 Charge calculation processing section
205 Comparison determination processing unit
206 Customer Database Management Processing Department
207 Standard profile management processor
208 Profile comparison processor
209 Work area

Claims (6)

Usage charges when each contractor uses various discount service products in a discount charge calculation storage device comprising a central processing unit (CPU), a main storage device, a display unit, an input unit, and a plurality of databases and tables. Is a discount charge calculation and accumulation method that calculates and accumulates
The central processing unit (CPU) reads contractor data from the customer database, and whether or not a plurality of discount service products including unapplied discount service products in the contractor data are subject to charge calculation. Acquire product information subject to charge calculation with a value indicating
The CPU extracts a discount service product indicating that a value indicating whether or not to be subject to charge calculation from among the unapplied discount service products in the acquired charge calculation target product information, is a charge calculation target, Read usage status data from the usage status database, calculate the charge when using the discount service product based on the usage status data and the information of the extracted discount service product, store the resulting fee in the charge calculation database,
The CPU reads each customer profile information of the current month and the previous month from a customer profile database storing customer profile information created by statistically collecting monthly usage statistics data of each contractor for each contractor.
The CPU compares the read customer profile information of the current month and the previous month, determines whether or not there is a change, and if there is a change, determines the type of change,
When there is a change, the CPU reads the usage state-service relation table in which the type of change is associated with the discount service product information, and uses the discount service product information corresponding to the type of change obtained by the determination. Extracted from the situation-service related table,
The CPU reads the contractor's data from the customer database, determines the value attached to the extracted discount service product information in the charge calculation target product information in the contractor's data, and confirms that the value is not subject to charge calculation. In the case of showing, a discount charge calculation storage method, wherein the value is changed to a value indicating that it is an object of charge calculation. In the discount charge calculation accumulation method according to claim 1,
The CPU reads the customer profile information of each contractor from the customer profile database, obtains the similarity between the read customer profile information, and groups each customer profile information according to the similarity and a preset threshold value The standard profile information is extracted for each group based on the customer profile information in the group, and the extracted standard profile information is stored in the standard profile information database.
The CPU reads the customer profile information of the contractor from the customer profile database, reads the standard profile information from the standard profile information database, compares the read customer profile information of the contractor with the read standard profile information, The group of standard profile information to which the customer profile information of the contractor belongs is extracted, the data of the contractor is further read from the customer database, the group in the data is compared with the extracted group, and the group changes. Whether or not
When the CPU determines that the group has changed, the CPU reads the group-service relation table, extracts the discount service product optimal for the changed group by referring to the table, and stores the discount service product in the customer database based on the extraction result. A discount charge calculation storage method, wherein the value of the charge calculation target product information set in the customer data of the contractor is changed. A discount charge calculation storage device comprising a central processing unit (CPU), a main storage device, a display unit, an input unit, a plurality of databases and tables,
The central processing unit (CPU)
A charge that reads contractor data from the customer database and adds a value indicating whether or not each discount service product including unapplied discount service products in the contractor data is subject to charge calculation. A discount service for obtaining calculation target product information and indicating that a value indicating whether or not to be subject to charge calculation among unsubscribed discount service products in the acquired charge calculation target product information is a target for charge calculation Extract the product, read the usage status data from the usage status database, calculate the fee when using the discount service product based on the usage status data and the extracted discount service product information, and calculate the resulting fee Charge calculation control processing means stored in the database;
Read usage data of the contractor from the usage database, read customer data of the contractor from the customer database, and calculate the charge for each charge calculation target product based on the usage status data and the charge calculation target product information in the customer data Charge calculation processing means for performing
Each month, the usage status data of the contractor is read from the usage status database, the contents of the items to be statistically aggregated are extracted from the usage status data, and the customer of the read contractor's month is extracted based on the contents of the extracted items. Customer profile extraction processing means for creating profile information and storing the created customer profile information of the contractor in a customer profile database;
Read the customer profile information of the contractor for the current month and the previous month from the customer profile database, compare the current month and the previous month of the customer profile information, determine whether there is a change, and if there is a change, the type of change If there is a change, the usage status-service relation table in which the type of change is associated with the discount service product information is read from the storage device, and the discount service corresponding to the type of change obtained by the determination is read. The product information is extracted from the usage status-service relation table, the contractor data is read from the customer database, and the value attached to the extracted discount service product information in the charge calculation target product information in the contractor data is determined. However, if the value indicates that it is not subject to charge calculation, the value is changed to a value indicating that it is subject to charge calculation. A customer profile comparison processing means for further, characterized by having a reduced rate computing storage device. In the discount charge calculation storage device according to claim 3,
The central processing unit (CPU)
The customer profile information of each contractor is read from the customer profile database, the similarity between the read customer profile information is obtained, and each customer profile information is grouped according to the similarity and a preset threshold value. Standard profile management processing means for extracting standard profile information for each group on the basis of customer profile information and storing the extracted standard profile information in a standard profile information database;
The customer profile information of the contractor is read from the customer profile database, the standard profile information is read from the standard profile information database, the read customer profile information of the contractor is compared with the read standard profile information, and the contractor A group of standard profile information to which the customer profile information belongs, further reads out the contractor's data from the customer database, compares the group in the data with the extracted group, and whether the group has changed If it is determined that the group has changed, the group-service related table is read out, the discount service product optimal for the group after the change is extracted with reference to the table, and the customer database is based on the extraction result Of the contractor in Discounted billing storage apparatus characterized by comprising: a profile comparison processing means for changing the value of the billing Shipping information set to the customer data. A discount fee that calculates and accumulates usage fees when each contractor uses various discount service products on a computer that has at least a processing device, a storage device, and an input / output device and is connected to multiple databases and tables. A computer program for storing information in the computer,
A charge that reads contractor data from the customer database and adds a value indicating whether or not each discount service product including unapplied discount service products in the contractor data is subject to charge calculation. The procedure to get the target product information,
A discount service product indicating that a value indicating whether or not to be subject to charge calculation from among unapplied discount service products in the obtained charge calculation target product information is subject to charge calculation, and is used in a usage status database Reading the usage status data from the usage status data and calculating the discount service product based on the extracted discount service product information, and storing the resulting fee in the fee calculation database;
A procedure for reading each customer profile information for the current month and the previous month from a customer profile database storing customer profile information created by statistically aggregating the usage status data of the contractor for each contractor for each statistical item every month,
Compare the customer profile information of the read current month and the previous month, determine whether there has been a change, and if there has been a change, determine the type of change,
When there is a change, the usage status-service association table in which the type of change is associated with the discount service product information is read, and the discount service product information corresponding to the type of change obtained by the determination is read as the usage status- The procedure to extract from the service related table,
When the contractor's data is read from the customer database, the value attached to the extracted discount service product information in the charge calculation target product information in the contractor's data is determined, and the value is not subject to charge calculation Includes a procedure for changing the value to a value indicating that it is a target of charge calculation, and a computer-readable recording medium recording a discount charge calculation storage program for executing the program. In a computer-readable recording medium in which the discount charge calculation storage program according to claim 5 is recorded,
The customer profile information of each contractor is read from the customer profile database, the similarity between the read customer profile information is obtained, and each customer profile information is grouped according to the similarity and a preset threshold value. Extracting standard profile information for each group based on customer profile information in the group, and storing the extracted standard profile information in a standard profile information database;
The customer profile information of the contractor is read from the customer profile database, the standard profile information is read from the standard profile information database, the read customer profile information of the contractor is compared with the read standard profile information, and the contractor To extract the group of standard profile information to which the customer profile information belongs,
Reading the contractor's data from the customer database, comparing the group in the data with the extracted group, and determining whether the group has changed,
When it is determined that the group has changed, the group-service association table is read out, and the discount service product optimal for the group after the change is extracted with reference to the table, and the above-mentioned in the customer database is extracted based on the extraction result. A computer-readable recording medium recording a discount charge calculation storage program for further executing a procedure for changing the value of the charge calculation target product information set in the customer data of the contractor.

Images