# US 2014/0211931 A1 · System and Method for Generating and Delivering Automated Reports Concerning the Performance of a Call Center

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2014/0211931 A1
- Document ID: US20140211931A1
- Status: Published application
- Kind: A1
- Application number: 13/755,800
- Filed: 2013-01-31
- Published: 2014-07-31
- Earliest claimed: 2013-01-31
- Assignees: North American Communications Resources, Inc.
- Applicants: North American Communications Resources, Inc.
- Inventors: Scott J. Wendt
- Web page: https://patentgrep.com/patent/US20140211931A1

## CPC

- H04M 3/5175: {Call or contact centers supervision arrangements}
- H04M 2203/401: Performance feedback
- H04M: TELEPHONIC COMMUNICATION (circuits for controlling other apparatus via a telephone cable and not involving telephone switching apparatus G08)

## 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.

## Claims

### Claim 1

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.

### Claim 2 (depends on 1)

The call center management report generation apparatus of claim 1 wherein the application program causes the report generation apparatus to periodically check for and process any new log files created by the data logger.

### Claim 3 (depends on 1)

The call center management report generation apparatus of claim 1 wherein the application program causes the call center management report generation apparatus to create and store for a predetermined period of time an archival copy of the at least one log file.

### Claim 4 (depends on 1)

The call center management report generation apparatus of claim 1 wherein the types of data stored related to errors occurring during processing of the at least one log file are selectable.

### Claim 5 (depends on 1)

The call center management report generation apparatus of claim 1 wherein the application program and operating system software cooperate to permit the database to be queried and custom reports to thereby be generated.

### Claim 6

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.

### Claim 7 (depends on 6)

The call center management report generation apparatus of claim 6 further comprising a management workstation comprising a third processor and at least one further communications port, and wherein the second application program causes the report server to deliver at least one of the management reports in near real time to the management workstation.

### Claim 8 (depends on 6)

The call center management report generation apparatus of claim 6 wherein the second application program causes the report server to periodically check for and process any new log files stored in the first storage.

### Claim 9 (depends on 6)

The call center management report generation apparatus of claim 6 wherein the second application program creates an archival copy of the log file and stores the archival copy for a predetermined period of time.

### Claim 10 (depends on 6)

The call center management report generation apparatus of claim 6 wherein the types of data stored related to errors occurring during processing of the log file are selectable.

### Claim 11 (depends on 6)

The call center management report generation apparatus of claim 6 wherein the second application program and operating system software cooperate to permit the database to be queried and custom reports to thereby be generated.

### Claim 12

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.

### Claim 13 (depends on 12)

The method of claim 12 further comprising the step of delivering at least one of the management reports in near real time to a management workstation.

### Claim 14 (depends on 12)

The method of claim 12 further comprising the step of causing the report server to periodically check for and process any new log files stored in the first storage.

### Claim 15 (depends on 12)

The method of claim 12 further comprising repeating steps (c) and (d).

### Claim 16 (depends on 12)

The method of claim 12 further comprising the steps of creating an archival copy of the log file and storing the archival copy for a predetermined period of time.

### Claim 17 (depends on 12)

The method of claim 12 further comprising the steps of creating a query, processing the query to retrieve data from the database, and generating a custom report using the retrieved data.
