This application is based upon and claims the benefit of priority from the prior Japanese Patent Application No. 2006-83552, filed on Mar. 24, 2006, the entire contents of which are incorporated herein by reference.
1. Field of the Invention
The present invention relates generally to a tabulation system for questions from personal computer purchasers, etc., and more particularly, to a tabulation processing apparatus, tabulation processing method, computer readable recording medium having a tabulation processing program, and tabulation processing system that tabulate and display the questions depending on an elapsed period.
2. Description of the Related Art
With regard to questions about operations, problems, etc. from personal computer purchasers, etc., a system has been provided for accepting the questions at a call center established by a manufacturer and presenting coping methods corresponding to the questions from the call center.
With regard to such a question process, Japanese Patent Application Laid-Open Publication No. 2003-186977 discloses a call acceptance system that includes a server for registering question examples and answer examples prepared in advance to a database to display noteworthy information on a display apparatus of an operator terminal through this server. Japanese Patent Application Laid-Open Publication No. 2001-136858 is related to pet ownership and discloses a guidance system where a purchaser is provided with CD-ROM storing computer software for network connection and pet-raising guidance software to obtain answers for questions about know-how necessary for raising pets, growth states, problem occurrences, etc. through the medium of this CD-ROM over the Internet.
By the way, since questions from customers include wide variety of topics, responding individually to each question is not necessarily an optimum service. From such a viewpoint, the questions are categorized by content to tabulate and, for example, top 10 questions are published on a call center site in a ranking format. The customers can check the contents on the computer through the Internet and, for example, as shown in
When generating such a ranking format, for example, as shown in
In such tabulation and display forms, questions immediately after the purchase and questions after a time has elapsed from the purchase are mixed in the same ranking and, in
Japanese Patent Application Laid-Open Publication Nos. 2003-186977 and 2001-136858 do not disclose or indicate such problems and do not disclose or include means for solving the problems.
An object of the present invention is to acquire a tabulation result corresponding to changes in questions based on the knowledge that the question contents are changed as time advances from a point of generation of a cause of the question.
Another object of the present invention is to acquire a tabulation result corresponding to questions issued from customers with question contents changing as time advances from a point of purchase of equipments, etc.
The above objects are achieved in the present invention by forming a question group consisting of questions based on purchase of equipments, etc., by using the question group to tabulate the questions for each elapsed time period from a point of a cause of the question to a point of generation of the question, and by ranking the questions from the tabulation result to provide solution information for the questions from the customers.
In order to achieve the above objects, according to a first aspect of the present invention there is provided a tabulation processing apparatus that tabulates and ranks a plurality of questions, comprising a question storing unit that stores a question group constituted by a plurality of questions; and a processing unit that extracts questions from the question group in the question storing unit for each elapsed time period from a reference time point of the questions to a generation time point thereof to create a question list, the processing unit classifying and ranking the questions from the question list.
In the tabulation processing apparatus, the processing unit may extract the questions from the question group depending on customers to create the question list.
Preferably, the processing unit outputs ranking information with the use of a difference from the generation time point of the question based on the input of the reference time point.
Preferably, the tabulation processing apparatus comprises a reference information storing unit that stores reference information referred for the ranking, wherein the processing unit refers to the reference information of the reference information storing unit to perform the ranking.
To achieve the above objects, according to a second aspect of the present invention there is provided a tabulation processing method that tabulates and ranks a plurality of questions, comprising the steps of extracting questions from a question group constituted by a plurality of questions for each elapsed time period from a reference time point of the questions to a generation time point thereof to create a question list; and classifying and ranking the questions from the question list.
Preferably, the tabulation processing method comprises the step of creating the question group from a plurality of questions.
The tabulation processing method may comprise the step of extracting the questions from the question group depending on customers to create the question list.
The tabulation processing method may comprise the step of outputting ranking information with the use of a difference from the generation time point of the question based on the input of the reference time point.
To achieve the above objects, according to a third aspect of the present invention there is provided a computer readable recording medium having a tabulation processing program executable by a computer to tabulate and rank a plurality of questions embodied therein, the program comprising the steps of extracting questions from a question group constituted by a plurality of questions for each elapsed time period from a reference time point of the questions to a generation time point thereof to create a question list; and classifying and ranking the questions from the question list.
In the computer readable recording medium, the tabulation processing program may comprise the step of creating the question group from a plurality of questions.
In the computer readable recording medium, the tabulation processing program may comprise the step of extracting the questions from the question group depending on customers to create the question list.
Preferably, the tabulation processing program comprises the step of outputting information representing the ranking based on the input of the reference time point and the generation time point.
To achieve the above objects, according to a fourth aspect of the present invention there is provided a tabulation processing system that tabulates and ranks a plurality of questions, comprising a processing apparatus that extracts questions from the question group constituted by a plurality of questions for each elapsed time period from a reference time point of the questions to a generation time point thereof to create a question list, the processing apparatus performing processes for classifying and ranking the questions from the question list; and an information output terminal that is connected to the processing apparatus, the information output terminal outputting information representing the ranking.
Preferably, the processing apparatus inputs the reference time point from the information output terminal and outputs ranking information to the information output terminal with the use of a difference from a generation time point of the question.
Preferably, the processing apparatus comprises a storing unit that stores a question group constituted by a plurality of questions.
The tabulation processing system may comprise a reference information storing unit that stores reference information referred for the ranking, wherein the processing apparatus refers to the reference information of the reference information storing unit to perform the ranking.
The features and advantages of the present invention are listed as follows.
(1) A tabulation result can be provided correspondingly to the fact that question contents are changed as time advances from a time point of generation of a cause of the question (an event). Useful solution information can be provided for questions.
(2) Solution information can be rapidly and accurately browsed in a question tabulation result for questions from an information processing terminals.
The above and other objects, features, and advantages of the present invention will become more apparent from the following detailed description of the preferred embodiments when taken in conjunction with the accompanying drawings, in which:
A first embodiment of the present invention will be described with reference to
For example, this tabulation processing system 2 connects a tabulation processing apparatus 6 in a call center 4 and information processing terminals 10 of customers 8 through network 12, performs a tabulation process of questions from the customers 8 with the tabulation processing apparatus 6, and provides the processing terminals 10 of the customers 8 with the tabulation result. In this embodiment, the customers 8 are purchasers of products and the purchased products are equipments such as personal computers. Questions from the customers 8 relate to a handling method, troubles, etc. of the equipments purchased by the customers 8. Such questions are tabulated in the call center 4; the tabulation result is presented to the customers 8 relating to the questions; and the customers 8 acquire solution information for the questions accurately and rapidly.
The tabulation processing system 2 performs a slide tabulation process by elapsed times, a ranking display process, etc. In general terms, the slide tabulation process by elapsed times is a process for sorting and tabulating questions from customers after short elapsed time from a time point of the equipment purchase and questions from customers after some elapsed time with the use of a difference between a customer registration date and a question date. The ranking display process is a process for acquiring a customer registration date from a database (DB) 26 (owned model table 261) based on access to the tabulation processing apparatus 6 from the customers 8, calculating elapsed time that is a difference between the customer registration date and a current date, and displaying the ranking corresponding to the elapsed time.
The tabulation processing apparatus 6 disposed in the call center 4 is constituted by computers that tabulate the questions from the customer 8 and, in this embodiment, includes a database (hereinafter, “DB”) server 14, a web (World Wide Web) server 16, a management server 18, and information processing terminals 21, 22, 23, which are connected to a bus 24 and network 12. The network 12 is public network such as Internet. In the DB server 14, the DB 26 is constructed for storing various programs such as a tabulation processing program 40 (
The information processing terminal 10 disposed on the customer 8 side is constituted by a single or plurality of personal computers (PC) 281, 282, . . . 28N, portable terminal device 30, etc. The portable terminal device 30 is connected through radio signals such as electric waves to a base station 32 connected to the network 12. The tabulation result obtained by the tabulation processing apparatus 6 is output to the customer 8 side through the network 12 and is displayed on displaying units 31 of the PC 281 to 28N and the portable terminal device 30.
In such a tabulation processing system 2, the questions sent from the customers 8 to the call center 4 are formed into a database by the information processing terminals 21 to 23 and stored in the DB 26. By executing the tabulation processing program 40, each question is classified depending on elapsed time from a time point of equipment purchase to create a question list for each elapsed time, and this question list is analyzed to create a higher-order list by passed month, which is subjected to a ranking process. When accessing to the tabulation processing apparatus 6 through the network 12, the customer 8 can receive the process result correspondingly to the elapsed time from the time point of the equipment purchase of the customer 8 with the information processing terminal 10. In other words, for the question from the customer 8, the management server 18 transmits information corresponding to the elapsed time from the time point of the equipment purchase to the customer 8, and the customer 8 can receive information corresponding to the time and the learning level relevant to the purchased equipment.
As shown in
In such a configuration, by activating the tabulation processing program 40 stored in the DB server 14, various processing can be performed for creating the question list, tabulating questions correspondingly to the elapsed time from the time point of the equipment purchase or registration date, determining the ranking, etc.
In this case, the tabulation processing program 40 may be installed in the management server 18 rather than the DB server 14 and may be installed in the information processing terminal 21 to 23 if the information processing terminal 21 to 23 is disposed in the management system of the call center 4.
As shown in
The customer 8 logs into the tabulation processing apparatus 6 from the information processing terminal 10 and uses the procedure 401 to extract the registration date from the owned model table 261; a difference is calculated between the registration date and the question date; for example, display information representing top 10 is output from the ranking table 265 corresponding to the difference; and the top 10 are displayed on the information processing terminal 10.
For example, the ranking table 265 stores the ranking information of each passed month; each question is classified and correlated with classifying items, for example, “Q&A content 01”, “Q&A content 02”, “Q&A content 03”, etc.; and the ranking table 265 stores the ranking information corresponding to the amounts thereof, for example, “first place, Q&A content ID***01”, “second place, Q&A content ID***02”, “third place, Q&A content ID***03”, etc. In this case, the ranking information is ranking information for each passed month for one to six months.
Description will be made of the operation of the tabulation processing system.
(1) Data Generation in Owned Model Table 261
Description will be made of the data generation in the owned model table 261 with reference to
Input of customer information from the information processing terminal 21 to 23 triggers the owned model table 261 to generate the customer information and the customer ID (IDentification) that is customer identification information and to store the generation date (the time and/or day) thereof as a customer registration date. Model ID is identification information that represents a model of the purchased equipments.
In this generation process, as shown in
As shown in an example of
(2) Data Generation in Question Table 262
Description will be made of the data generation in the question table 262 with reference to
The data in the question table 262 are generated when the customer 8 sends question the call center 4. In this generation process, as shown in
As shown in an example of
(3) Data Generation in Marketing Period Table 263
Description will be made of the data generation in the marketing period table 263 with reference to
The marketing period table 263 receives input of model data generated for each marketing period and released in that marketing period. In this generation process, as shown in
In the marketing period table 263, as shown in an example of
(4) Tabulation Process
Description will be made of the tabulation process with reference to
In this tabulation process, a customer sampling process I, a question list generation process II, and a ranking determination process III are performed stepwise. In this tabulation process, the monitored customers 8 are sampled from the owned model table 261 (step S31); questions of the sampled customers are collected from the question log (step S32); the question of the sampled customer is classified by the passed days from the equipment purchase to create a question list of each passed month (step S33). With regard to a purchase date, the generation date extracted from the owned model table 261 may be assumed as the purchase date.
Higher orders of the question list are analyzed to create a higher-order list of each passed month (step S34); the higher-order list of the questions is correlated with corresponding classifying items, for example, Q&A contents (step S35); and the Q&A contents corresponding to the higher-order list are correlated with the ranking table 265 and stored (step S36).
The customer 8 logs into the tabulation processing apparatus 6 from a web site established on the network 12; the generation date is extracted from the owned model table 261 and is assumed as the purchase date; the number of the passed months from the purchase date to the current date are calculated (step S37); and the ranking table 265 corresponding to the number of the passed months is displayed as the top 10 of frequent questions of that month on a web site (e.g., a Q&A navi) (step S38). This display is deployed on the displaying unit 31 of the information processing terminal 10 and the customer 8 can acquire information such as an answer to the question.
With regard to this tabulation process, for example,
On the other hand, for questions from a customer group 81 related to one-month delayed purchase, a process result 101 is published by diverting the higher-order list 61 of the tabulation process 51. That is, the questions are tabulated by the elapsed time from each time point of purchase in common for the initial purchase customer group 80 and the one-month delayed purchase customer group 81; a process result after two months is published as a process result 102 after three months; and a process result after six months is published as a process result 106 after seven months.
In
Description will be made of a process that performs the tabulation process for a single month to create the ranking of the first month after the purchase in this embodiment with reference to
In this processing procedure, as shown in
In the question list generation process II, the question table 262 is referenced to collect questions for the customer ID, and questions for one month are extracted from the questions to create a question list for one month (step S42). In this case, questions are extracted for the customers 8 who have registered in a period from April 1st to April 30th in the example above (
In the ranking determination process III, the question group is input and the most frequent questions are drawn and output from the question group using the analysis of the higher orders (step S43). That is, the higher orders of the question list are analyzed to create the top 10 representing the ranking result of the frequent questions.
If the tabulation process for a single month is performed to acquire the ranking of, for example, the first month after the purchase of the models released in April, when inputting, for example, a list of the models released in April, a period of the customer registration dates (April 1st to April 30th), and a specified period, i.e., the first month after the purchase, the top 10 questions are output as the result of the ranking determination process of the most frequent questions of the first month by performing the customer sampling process I, the question list generation process II, and the ranking determination process III, as described above.
In such a tabulation process for each single month, the ranking determination process may be performed for the Nth month after the purchase.
In this processing procedure, as shown in
In the question list generation process II, the question table 262 is referenced to collect questions for the customer ID, and questions of the Nth month are extracted from the questions to create a question list for the Nth month (step S42). In this case, the question list is created by extracting questions sent in a period from (N−1)th month to Nth month after April in the example above (
In the ranking determination process III, the question group is input and the most frequent questions are drawn and output from the question group using the analysis of the higher orders (step S43). That is, the higher orders of the question list are analyzed to create the top 10 representing the ranking result of the frequent questions.
In such a process, for example, when inputting a list of the models released in April, a period of the customer registration dates, for example, a period from April 1st to April 30th, and a specified period, for example, the first Nth month after the purchase, the top 10 questions are output as the result of the ranking determination process of the most frequent questions of the Nth month after the purchase.
A second embodiment of the present invention will be described with reference to
This embodiment also uses the tabulation processing system 2 shown in
The tabulation process of this embodiment is a process when a tabulation process is performed for a plurality of months to create a ranking result of the first month. As shown in
In the question list generation process II, the question table 262 is referenced to collect questions for the customer ID, and questions for one month are extracted from the questions to create a question list for one month (step S62). In this case, questions registered in a period from April 1st to April 30th are extracted to create the question list.
In the ranking determination process III, the question group is input and the most frequent questions are drawn and output from the question group using the analysis of the higher orders (step S63). That is, the higher orders of the question list are analyzed to create the top 10 representing the ranking result of the frequent questions.
In such a process, for example, when inputting a list of the models released in April and a specified period, for example, the first month after the purchase, the top 10 are output as the ranking result of the most frequent questions of the first month.
With regard to this tabulation process, for example,
On the other hand, for questions from the customer group 81 related to one-month delayed purchase, the tabulation process is performed after one month (in June), and this tabulation process reflects the process result of the initial purchase customer group 80. For questions from the customer group 82 related to two-month delayed purchase, the tabulation process is performed after one month (in July), and the process result of the customer group 80 and a process result 101 of the customer group 81 are updated with the question tabulation result of the customer group 82 and are published as a process result 201. Similarly, a process result 202 is published after one month from the process result 201 (in August). That is, the data of the one-month delayed purchase customer group 81 are added to the data of the initial purchase customer group 80 to update the first month process result 201 referenced by the two-month delayed purchase customer group 82. The process result 201 of the questions from the two-month delayed purchase customer group 82 reflects the result of the tabulation process 51 of the initial-purchase customer group 80 and the process result 101 of the one-month delayed purchase customer group 81, and the two-month delayed purchase customer group 82 can reference the useful question information of the preceding customer groups 80, 81.
In such a tabulation process for a plurality of months, the ranking determination process may be performed for the Nth month after the purchase as shown in
In this processing procedure, as shown in
In the question list generation process II, the question table 262 is referenced to collect questions for the customer ID; differences are obtained between the question dates of the question table 262 and the customer registration date of the owned model table 261; and a question list is created by extracting questions with the differences from (N−1) months to N months (step S72). In this case, the question list is created by extracting questions sent in a period from (N−1)th month to Nth month after April in the example above (
In the ranking determination process III, a question list is drawn out and output using the analysis of the higher orders (step S73). That is, the higher orders of the question list are analyzed to create the top 10 representing the ranking result of the frequent questions.
In such a process, the top 10 are output as the ranking result related to the list of the models released in April and the most frequent questions of a specified period after the purchase, for example, the Nth month after the purchase in April.
A third embodiment of the present invention will be described with reference to
This embodiment also uses the tabulation processing system 2 shown in
The process of this embodiment is a tabulation process across marketing periods as well as a plurality of months and, by way of example, a process shown in
In this process, the monitored customers 8 are sampled from the owned model table 261 in a first customer sampling process Ia (step S81). At step S81, the customer registration date field of the owned model table 261 is referenced to extract the customer ID of the customers who purchased the model released in April 2005 and have registered after April 1st, for example.
In a first question list generation process IIa, the question table 262 is referenced to collect questions corresponding to the customer ID, and differences are obtained between the question dates of the question table 262 and the customer registration date of the owned model table 261 to pick up questions with the differences of (N−1) months to N months (step S82) only. A group of the picked-up questions is defined as a question group A.
In a second customer sampling process Ib, the monitored customers 8 are sampled from the owned model table 261 (step S83). At step S83, the customer registration date field of the customers 8 is referenced to extract the customer ID of the customers who purchased the model released in July 2004 and have registered after July 1st, for example.
In a second question list generation process IIb, the question table 262 is referenced to collect questions corresponding to the customer ID, and differences are obtained between the question dates of the question table 262 and the customer registration date of the owned model table 261 to pick up questions with the differences of (N−1) months to N months (step S84). A group of the picked-up questions is defined as a question group B.
In the ranking determination process III, after the question group B is weighted relative to the aforementioned question group A, higher orders of two question group list are analyzed to create the top 10 representing a result of the ranking from the most frequent question (step S85). That is, the question group of the current marketing period and the question group of the previous marketing period are input; two question groups are weighted and combined to form a single question group; and the most frequent questions are drawn and output from the question group by analyzing the higher orders.
This process is constituted by the first and second customer sampling processes Ia, Ib, the first and second question list generation process IIa, IIb, and the ranking determination process III and, in this process, for example, when inputting a list of the models released in April, a list of the models of the previous marketing period, a specified period after the purchase (in this case, N months), and the weight of the previous marketing period, the process output, i.e., the top 10 are output as the result of the ranking determination process of the most frequent questions of the Nth month after the purchase.
Referring to
Correspondingly, a tabulation process is performed for a customer group 180 related to winter initial purchase of the winter marketing period announcement. Since a tabulation process 1101 is a process of the first month after the purchase and a tabulation process 1102 is a process of the second month after the purchase, the tabulation process 1101 reflects the weighted ranking determination process result 201 of the first month of the passed marketing period corresponding to the elapsed time, and the tabulation process 1102 reflects the weighted ranking determination process result 202 of the second month of the passed marketing period corresponding to the elapsed time.
In such a tabulation process, the questions are tabulated correspondingly to the elapsed time to publish the top 10 as the ranking determination process result, and each customer can check the question contents having the common elapsed time from the equipment purchase to acquire useful solution information for problems. Especially, although less question information can be presented to the customers related to the initial purchase and the customers related to one-month delayed purchase, the accurate solution information can be presented by referring to the result of the previous marketing period and, particularly, after a default value of two months has elapsed, accuracy is increased in the information presented for the questions.
With regard to the embodiments described above, modifications, etc. will be listed and described.
(1) Customer Registration Date
Although the customer registration dates are different among the customers, when assuming a plurality of questions, differences in the number of days are within an error range from a viewpoint of the transition of the question contents. Therefore, the customer registration date may be a purchase date, and the usage start date, etc. may be input as the purchase timing to a customer information input screen.
(2) Tabulation Processing Apparatus 6
Although the DB server 14 and the information processing terminals 21 to 23 are configured separately and linked with the bus 24 in the above embodiments, a single computer may constitute the storing unit that constitutes the database and the processing unit that performs the tabulation process.
(3) Application of Tabulation Process
Although merchandise purchase is illustrated and described in the above embodiments, the present invention can be applied to various call center tabulation processes, etc. intended for the case that the learning level and the question contents change depending on elapsed time from a point of generation of an event, such as a process of questions from patients at hospitals and a process of questions to various schools from new students.
According to the present invention, a tabulation result can be acquired correspondingly to changes in questions based on the knowledge that the question contents are changed as time advances from a point of generation of a cause of the question, and since the questions are tabulated and ranked correspondingly to the elapsed time from an event such as the equipment purchase, the present invention beneficially contributes to presentation of useful solution information for the questions.
While the illustrative and presently preferred embodiments of the present invention have been described in detail herein, it is to be understood that the inventive concepts may be otherwise variously embodied and employed and that the appended claims are intended to be construed to include such variations except insofar as limited by the prior art.
Number | Date | Country | Kind |
---|---|---|---|
2006-083552 | Mar 2006 | JP | national |
Number | Name | Date | Kind |
---|---|---|---|
6526257 | Doi et al. | Feb 2003 | B2 |
7133834 | Abelow | Nov 2006 | B1 |
20010052009 | Desai et al. | Dec 2001 | A1 |
20010053514 | Doi et al. | Dec 2001 | A1 |
20030112959 | Mori | Jun 2003 | A1 |
20050089834 | Shapiro | Apr 2005 | A1 |
Number | Date | Country |
---|---|---|
2001-136858 | May 2001 | JP |
2002-007452 | Jan 2002 | JP |
2002-329056 | Nov 2002 | JP |
2003-186977 | Jul 2003 | JP |
2003-242337 | Aug 2003 | JP |
2004-126969 | Apr 2004 | JP |
2005-181442 | Jul 2005 | JP |
Number | Date | Country | |
---|---|---|---|
20070226215 A1 | Sep 2007 | US |