Method and system for tracking client software use

• US 7,739,282 B1
• Filed: 05/13/2005
• Issued: 06/15/2010
• Est. Priority Date: 10/18/2001
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Smith, Ross Faulkner, Penoyer, Gregory Allen, Snitkovskiy, Alex G., Hicks, David Lloyd, Turner, Cameron Royce
• Primary Examiner(s): Mahmoudi; Tony
• Assistant Examiner(s): Uddin; Md. I
• Application Number:
  US11/128,979
• Time in Patent Office: 1,859 Days
• Field of Search: 707/200, 707/2, 707/3, 707/4, 707/661, 707/665, 707/667, 707/670, 707/708, 707/713, 707/718, 707/736
• US Class Current: 707/736
• CPC Class Codes: H04L 67/535 Tracking the activity of the user network monitoring arrangements H04L43/00; recording of computer activity G06F11/34

Abstract

A method and system for tracking client software use is disclosed. User data, specifically user interaction with a client-installed software application, is collected in data files and the data files are dynamically uploaded over a global computer system, such as the Internet, to a remote analysis system. The data files are parsed for on-going analysis of feature usage. Typically, for any action that a user performs in the software application, several items are recorded in a data file, such as a user ID, an absolute time-stamp, the method invoked including application source (if the software application includes more than one application), and details such as the dialog invoked, button pressed, menu used, menu item selected, application launch, application termination, as well as environment variables, such as operating system, screen resolution, etc.

Claims

1. A method for analyzing a logging file from a computer, wherein the logging file comprises a plurality of records corresponding to user interactions with a software application program module of the computer, the method comprising the steps of:

downloading the logging file from the computer;

converting the logging file to Extensible Markup Language (XML) data associated with a unique user identifier, wherein the step of converting the logging file to XML data comprises the steps of;

calling an application with a plurality of mapping files, wherein the mapping files are operative to expand the records in the logging file to indicate a specific user interface element, the mapping files comprising information that maps a user interface of the software application program module, the mapping files further comprising a list of elements, wherein each listed element includes a full textual name, a numeric identifier, and a reference to a user interface object containing the listed element, wherein only the numeric identifiers for the listed elements are stored on the computer, wherein the mapping files are used to resolve the numeric identifiers during post-processing operations to reduce a size of a set-up program on the computer, to reduce a disk space amount consumed on the computer, and to reduce an amount of code loaded into a memory of the computer, thereby improving computer performance;

expanding the records in the logging file; and

converting the records in the logging file to XML data;

parsing the XML data and uploading the parsed XML data to a SQL data warehouse, wherein parsing the XML data comprises converting an identification field, a user interface element field, and a time stamp field into unique fields in an SQL table of the SQL data warehouse; and

analyzing the XML data, wherein analyzing the XML data comprises;

submitting a plurality of queries to the data warehouse for specific usage questions, wherein the plurality of queries comprise;

a query for determining a number of users using specific features within the software application program module and a frequency of use with respect to the specific features;

a query for identifying undiscovered areas of the software application program module which are frequently used by users after the areas are discovered;

a query for identifying unused areas of the software application program module; and

a query for identifying a most-performed sequence of features used within the software application program module; and

receiving a plurality of the XML data from the data warehouse in response to the plurality of queries.

2. The method of claim 1 wherein the step of downloading the logging file from the computer comprises receiving an ADO database record set from the computer.

3. The method of claim 1 wherein the step of downloading the logging file from the computer comprises receiving transmissions via a global computer network connection.

4. The method of claim 1 wherein the querying and receiving steps are performed via an Active Server Pages (ASP) connection.

5. The method of claim 1 wherein the step of analyzing the XML data comprises converting the XML data to a plurality of user actions that correspond to the user interactions with the software application program module.

11. The method of claim 1, wherein the processor, in analyzing the markup language data, is operative to convert the markup language data to a plurality of user actions that correspond to the user interactions with the software application program module.

6. A computer system for analyzing a logging file, wherein the logging file comprises a plurality of records corresponding to user interactions with a software application program module of a client computer, the system comprising:

a server computer comprising a memory for storing executable program code and a processor, functionally coupled to the memory, the processor being responsive to computer-executable instructions contained in the program code and operative to;

download the logging file;

convert the logging file to markup language data associated with a unique user identifier, wherein in converting the logging file to markup language data, the processor is further operative to;

call an application with a plurality of mapping files, wherein the mapping files are operative to expand the records in the logging file to indicate a specific user interface element, the mapping files comprising information that maps a user interface of the software application program module, the mapping files further comprising a list of elements, wherein each listed element includes a full textual name, a numeric identifier, and a reference to a user interface object containing the listed element, wherein only the numeric identifiers for the listed elements are stored on the client computer, wherein the mapping files are used to resolve the numeric identifiers during post-processing operations to reduce a size of a set-up program on the client computer, to reduce a disk space amount consumed on the client computer, and to reduce an amount of code loaded into a memory of the client computer, thereby improving client computer performance;

expanding the records in the logging file; and

converting the records in the logging file to the markup language data;

parse the markup language data and uploading the parsed markup language data to a SQL data warehouse, wherein parsing the markup language data comprises converting at least one of an identification field, a user interface element field, and a time stamp field into unique fields in an SQL table of the SQL data warehouse; and

analyze the markup language data.

7. The system of claim 6 wherein the processor, in downloading the logging file from the computer, is operative to receive an ADO database record set.

8. The system of claim 6 wherein the processor, in downloading the logging file, is operative to receive transmissions via a global computer network connection.

9. The system of claim 6 wherein the processor, in analyzing the markup language, is operative to:

submit a plurality of queries to the data warehouse for specific usage questions, wherein the plurality of queries comprise at least one of;

a query for determining a number of users using specific features within the software application program module and a frequency of use with respect to the specific features;

a query for identifying undiscovered areas of the software application program module which are frequently used by users after the areas are discovered;

a query for identifying unused areas of the software application program module; and

a query for identifying a most-performed sequence of features used within the software application program module; and

receive a plurality of the markup language data from the data warehouse in response to the plurality of queries.

10. The system of claim 9, wherein the plurality of queries is submitted and the plurality of markup language data is received via an Active Server Pages (ASP) connection.

12. A computer-readable non-transitory storage medium comprising computer executable instructions which, when executed on a computer, will cause the computer to perform a method for analyzing a logging file from a computer, wherein the logging file comprises a plurality of records corresponding to user interactions with a software application program module of the computer, the method comprising the steps of:

downloading the logging file from the computer;

converting the logging file to markup language data associated with a unique user identifier, wherein the step of converting the logging file to markup language data comprises the steps of;

calling an application with a plurality of mapping files, wherein the mapping files are operative to expand the records in the logging file to indicate a specific user interface element, the mapping files comprising information that maps a user interface of the software application program module, the mapping files further comprising a list of elements, wherein each listed element includes a full textual name, a numeric identifier, and a reference to a user interface object containing the listed element, wherein only the numeric identifiers for the listed elements are stored on the computer, wherein the mapping files are used to resolve the numeric identifiers during post-processing operations to reduce a size of a set-up program on the computer, to reduce a disk space amount consumed on the computer, and to reduce an amount of code loaded into a memory of the computer, thereby improving computer performance;

expanding the records in the logging file; and

converting the records in the logging file to the markup language data;

parsing the markup language data and uploading the parsed markup language data to a SQL data warehouse, wherein parsing the markup language data comprises converting at least one of an identification field, a user interface element field, and a time stamp field into unique fields in an SQL table of the SQL data warehouse; and

analyzing the markup language data.

13. The computer-readable storage medium of claim 12, wherein downloading the logging file from the computer comprises receiving an ADO database record set from the computer.

14. The computer-readable storage medium of claim 12, wherein downloading the logging file from the computer comprises receiving transmissions via a global computer network connection.

15. The computer-readable storage medium of claim 12, wherein analyzing the markup language data comprises:

submitting a plurality of queries to the data warehouse for specific usage questions, wherein the plurality of queries comprise at least one of;

a query for determining a number of users using specific features within the software application program module and a frequency of use with respect to the specific features;

a query for identifying undiscovered areas of the software application program module which are frequently used by users after the areas are discovered;

a query for identifying unused areas of the software application program module; and

a query for identifying a most-performed sequence of features used within the software application program module; and

receiving a plurality of the markup language data from the data warehouse in response to the plurality of queries.

16. The computer-readable storage medium of claim 15, wherein submitting the plurality of queries and receiving the plurality of markup language data is performed via an Active Server Pages (ASP) connection.

17. The computer-readable storage medium of claim 12 wherein analyzing the markup language data comprises converting the markup language data to a plurality of user actions that correspond to the user interactions with the software application program module.