System and Method for Generating and Delivering Automated Reports Concerning the Performance of a Call Center
AssigneeNorth American Communications Resources, Inc.
InventorScott J. Wendt
Life of this patent
Estimating the term…
Abstract
Transformation of binary data files created by a data logger of a telephone system used by a call center into a searchable form for generation of meaningful management reports concerning the operation and performance of a call center, its agents and equipment is accomplished by providing a report server which u, under software control, processes the data in the log file to complete fields of tables in a database. The database is then used to create and deliver management reports both automatically and in response to queries entered by supervisors.
Claims17
For use with a data logger which logs data related to calls handled by agents of a call center by creating log files containing data related to a plurality of calls, a call center management report generation apparatus comprising:
- a processor, at least one storage device, a database comprising a first set of tables and a second set of tables stored in said at least one storage device, a communications port, operating system software, and an application program which cooperates with the operating system software to control the call center management report generation apparatus such that the report generation apparatus processes at least one log file containing data related to a plurality of calls created by the data logger by (i) communicating with the data logger through the communications port to retrieve the at least one log file and store the at least one log file in a temporary storage location of the at least one storage device, (ii) transforming data contained in the at least one log file stored in the temporary storage location into a searchable form by creating in the first set of tables for each of the plurality of calls a separate set of entries, the entries in each table of the first set of tables related to each particular call segment including the UCID number, sequence number and sequence key of the particular call segment to uniquely identify the particular call segment and correlate the data related to the particular call segment contained in the plurality of tables of the first set of tables, the entries in the first set of tables also including for each call segment data related to actions taken by a caller, equipment used by the call center to handle the call, an identity of particular agents who handled the call segment, actions taken by the agents to assist the caller and timing of events related to the call, (iii) creating in the database at least one table containing data related to processing of the at least one log file and any errors occurring during processing of the at least one log file;
- and (iv) using the database to generate management reports in near real time, including information related to at least one topic selected from the group of topics consisting of operation of the call center equipment, performance of the call center, and performances of agents handling calls using the call center.
A call center management report generation apparatus comprising:
- a. a data logger comprising a first processor, a first storage device, at least one first communications port and a first application program which controls the data logger such that the data logger (i) ingests through the at least one communications port data related to a plurality of calls handled by a call center, (ii) creates a log file containing said data and (iii) stores the log file in said first storage device;
- b. a report server comprising a second processor, a second storage device, at least one second communications port, operating system software, a database comprising a first set of tables and a second set of tables stored in said second storage device, and a second application program which cooperates with the operating system software to control the report server such that the report server processes the log file by (i) communicating with the data logger through the at least one first communications port and the at least one second communications port to retrieve the log file, store the log file in a temporary storage location in the second storage device, and then delete the log file from the first storage device, (ii) transforming data contained in the log file stored in the temporary storage location in the second storage device into a searchable form by creating in the first set of tables of the database, for each segment of the plurality of calls, a separate set of entries, the entries in each table of the first set of tables related to each particular call segment including a UCID number, sequence number and sequence key of the particular call segment to uniquely identify the call segment and correlate data related to the call segment contained in a plurality of tables of the first set of tables, the entries in the first set of tables also including, for each call segment, data related to actions taken by the caller, equipment used by the call center to handle the call, the identity of particular agents who handled the call segment, actions taken by the agents to assist the caller and a timing of events related to the call, (iii) creating in the second set of tables of the database entries containing data related to processing of the log file and any errors occurring during processing of the log file;
- and (iv) using the database to generate management reports in near real time including information related to at least one topic selected from a group of topics consisting of operation of the call center equipment, performance of the call center, and performances of agents handling calls using the call center.
A method for providing call center management reports comprising the steps of:
- a. Providing a data logger comprising a first processor, a first storage device, at least one first communications port and a first application program which controls the data logger;
- b. Providing a report server comprising a second processor, a second storage device, a database comprising a first set of tables and a second set of tables stored in said second storage device, at least one second communications port, operating system software, and second application program which cooperates with the operating system software to control the report server;
- c. Using the data logger to ingest data related to a plurality of calls handled by a call center, create a log file containing at least some of the data related to a plurality of calls, and store the log file in the first storage;
- and
- d. Using the report server to process the log file by (i) communicating with the data logger through the at least one first communications port and the at least one second communications port to retrieve the log file, store the log file in a temporary storage location in the second storage device, and then delete the log file from the first storage, (ii) transforming data contained in the log file stored in the temporary storage location into a searchable form by creating in the first set of tables of the database, for each segment of the plurality of calls, a separate set of entries, the entries in each table of the first set of tables related to each particular call segment including a UCID number, sequence number and sequence key of the particular call segment to uniquely identify the call segment and correlate the data related to the call segment contained in the plurality of tables of the first set of tables, the entries in the first set of tables also including, for each call segment, data related to actions taken by the caller, equipment used by the call center to handle the call, the identity of particular agents who handled the call segment, actions taken by the agents to assist the caller and the timing of events related to the call, (iii) creating in the second set of tables of the database entries containing data related to processing of the log file and any errors occurring during processing of the log file;
- and (iv) using the database to generate management reports, in near real time, including information related to at least one topic selected from a group of topics consisting of operation of the call center equipment, performance of the call center, and performance of agents handling calls using the call center.
Dependencies are inferred from the claim text.