# US 2004/0064443 A1 · System and method for performing click stream analysis

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

- Number: US 2004/0064443 A1
- Document ID: US20040064443A1
- Status: Published application
- Kind: A1
- Application number: 10/261,558
- Filed: 2002-09-30
- Published: 2004-04-01
- Earliest claimed: 2002-09-30
- Assignees: Microsoft Corporation
- Inventors: David Taniguchi; Kong-Kat Wong; Eric A. Reel
- Web page: https://patentgrep.com/patent/US20040064443A1

## CPC

- G06F 16/958: Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
- Y10S 707/922: Communications
- Y10S 707/99933: Query processing, i.e. searching
- Y10S 707/99936: Pattern matching access
- Y10S 707/99942: Manipulating data structure, e.g. compression, compaction, compilation
- Y10S 707/99943: Generating database or data structure, e.g. via user interface
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS

## Abstract

A system and method for performing click stream analysis is described. In one implementation, a Web log is processed to reconstruct a visit made by a user to a Web site. The Web log contains records representing actions performed by the user during the visit including any actions that may be designated a commerce event. A sequential identification is assigned to each record and the sequential identification is stored with the associated record in a database. Any records representing actions performed by the user that are designated as a commerce event are identified. The database is queried for a certain quantity of records representing actions performed by the user prior to and/or subsequent to the commerce event, based on the sequential identification assigned to each record.

## Claims

### Claim 1

A method, comprising:
processing a Web log to reconstruct a visit to a Web site by a user, the Web log containing records representing actions performed by the user during the visit including any actions that are designated a commerce event;
assigning a sequential identification to each record and storing the sequential identification with the associated record in a database;
identifying any records representing actions performed by the user that are designated as a commerce event; and
querying the database for a certain quantity of records representing actions performed by the user prior to and/or subsequent to the commerce event, based on the sequential identification assigned to each record.

### Claim 2 (depends on 1)

The method as recited in claim 1, further comprising reporting the certain quantity records.

### Claim 3 (depends on 1)

The method as recited in claim 1, further comprising designating an action as a commerce event if the user performed anyone of the following actions during a visit to the Web site: (i) interacted with an advertisement, (ii) added an item to a basket, (iii) completed a transaction; and (iv) arrived at the Web site through an email advertisement.

### Claim 4 (depends on 1)

The method as recited in claim 1, further comprising permitting personnel managing the Web site to determine what actions are to be designated a commerce event.

### Claim 5 (depends on 1)

The method as recited in claim 1, further comprising assigning a visit identification to each record, the visit identification corresponding to the visit to the Web site by the user, and storing the visit identification with the associated record in the database.

### Claim 6 (depends on 1)

The method as recited in claim 1, further comprising assigning a user identification to each record, the user identification corresponding to the user, and storing the user identification with the associated record in the database.

### Claim 7 (depends on 1)

The method as recited in claim 1, further comprising deeming the visit to the Web site by the user complete if no records are located in the database representing actions performed by the user for a period of time.

### Claim 8 (depends on 1)

The method as recited claim 1, further comprising deeming the visit to the Web site by the user complete if no records are located in the database representing actions performed by the user for a period of time, wherein the period of time is definable by personnel managing the Web site.

### Claim 9 (depends on 1)

The method as recited in claim 1, further comprising assigning a date to each record, the date corresponding to the date the user visited the Web site and storing the date with the associated record in the database.

### Claim 10 (depends on 1)

The method as recited in claim 1, further comprising assigning a time to each record, the time corresponding to the time the user performed an action on the Web site and storing the time with the associated record in the database.

### Claim 11 (depends on 1)

The method as recited in claim 1, wherein the sequential identification is an ordinal number indicating an order for the actions performed by the user.

### Claim 12 (depends on 1)

One or more computer-readable media comprising computer-executable instructions that, when executed, perform the method as recited in claim 1.

### Claim 13

A system, comprising:
a Web server configured to process a Web log to reconstruct a visit to a Web site by a user, the Web log containing records representing actions performed by the user during the visit including any actions that are designated a commerce event; and
a database configured to store information associated with records;
wherein the Web server is configured to:
(i) assign a sequential identification to each record and store the sequential identification with the associated record in a database;
(ii) identify any records representing actions performed by the user that are designated as a commerce event; and
(iii) query the database for a certain quantity of records representing actions performed by the user prior to and/or subsequent to the commerce event, based on the sequential identification assigned to each record.

### Claim 14 (depends on 13)

The system as recited in claim 13, wherein the Web server is further configured to report the certain quantity records representing actions performed by the user prior to and/or after any of the records representing actions performed by the user that are designated as a commerce event.

### Claim 15 (depends on 13)

The system as recited in claim 13, wherein an action is designated as a commerce event if the user performed anyone of the following actions during a visit to the Web site: (i) interacted with an advertisement, (ii) added an item to a basket, (iii) completed a transaction; and (iv) arrived at the Web site through an e-mail advertisement.

### Claim 16 (depends on 13)

The system as recited in claim 13, wherein the Web server is further configured to permit personnel managing the Web site to determine what actions are to be designated a commerce event.

### Claim 17 (depends on 13)

The system as recited in claim 13, wherein the Web server is further configured to assign a visit identification to each record, the visit identification corresponding to the visit to the Web site by the user and store the visit identification with the associated record in the database.

### Claim 18 (depends on 13)

The system as recited in claim 13, wherein the Web server is further configured to assign a user identification to each record, the user identification corresponding to the user and store the user identification with the associated record in the database.

### Claim 19 (depends on 13)

The system as recited in claim 13, wherein the Web server is further configured to deem the visit to the Web site by the user complete if no records are located in the database representing actions performed by the user for a period of time.

### Claim 20 (depends on 13)

The system as recited in claim 13, wherein the Web server is further configured to deem the visit to the Web site by the user complete if no records are located in the database representing actions performed by the user for a period of time, wherein the period of time is definable by personnel managing the Web site.

### Claim 21 (depends on 13)

The system as recited in claim 13, wherein the Web server is further configured to assign a date to each record, the date corresponding to the date the user visited the Web site and storing the date with the associated record in the database.

### Claim 22 (depends on 13)

The system as recited in claim 13, wherein the Web server is further configured to assign a time to each record, the time corresponding to the time the user performed an action on the Web site and storing the time with the associated record in the database.

### Claim 23 (depends on 13)

The system as recited in claim 13, wherein the sequential identification is an ordinal number indicating an order for the actions performed by the user.

### Claim 24

A computer system comprising one or more processors and one or more software programs, the one or more software programs configured to reconstruct actions performed by a user while visiting a Web site by:
assigning a sequential identification and a user identification to each action performed by the user while visiting the Web site including any action that is designated a commerce event;
storing each action along with the sequential identification and the user identification in a database; and
querying the database for any action that is designated a commerce event and for each action located from the database that is designated a commerce event, using the sequential identification and the user identification as basis to search the database for a certain quantity of actions that occurred prior to and/or subsequent to the commerce event.

### Claim 25 (depends on 24)

The system as recited in claim 24, wherein the one or more software programs is further configured to reconstruct actions performed by a user while visiting a Web site by reporting the certain quantity of actions performed by the user prior to and/or after the commerce event.

### Claim 26 (depends on 24)

The system as recited claim 24, wherein the one or more software programs is further configured to reconstruct actions performed by a user while visiting a Web site by assigning a visit identification to each action performed by the user while visiting the Web site including any action that is designated a commerce event.

### Claim 27 (depends on 24)

The system as recited claim 24, wherein the one or more software programs is further configured to reconstruct actions performed by a user while visiting a Web site by assigning a user identification to each action performed by the user while visiting the Web site including any action that is designated a commerce event.

### Claim 28

One or more computer-readable media having stored thereon computer executable instructions that, when executed by one or more processors, causes the one or more processors of a computer system to:
process a Web log to reconstruct a visit to a Web site by a user, the Web log containing records representing actions performed by the user during the visit including any actions that are designated a commerce event;
assign a sequential identification to each record and storing the sequential identification with the associated record in a database;
identify any records representing actions performed by the user that are designated as a commerce event; and
query the database for a certain quantity of records representing actions performed by the user prior to and/or subsequent to the commerce event, based on the sequential identification assigned to each record.

### Claim 29 (depends on 28)

One or more computer-readable media as recited in claim 28, further comprising computer executable instructions that, when executed, direct the computer system to report the certain quantity records.

### Claim 30 (depends on 28)

One or more computer-readable media as recited in claim 28, further comprising computer executable instructions that, when executed, direct the computer system to designate an action as a commerce event if the user performed anyone of the following actions during a visit to the Web site: (i) interacted with an advertisement, (ii) added an item to a basket, (iii) completed a transaction; and (iv) arrived at the Web site through an e-mail advertisement.

### Claim 31 (depends on 28)

One or more computer-readable media as recited in claim 28, further comprising computer executable instructions that, when executed, direct the computer system to permit personnel managing the Web site to determine what actions are to be designated a commerce event.

### Claim 32 (depends on 28)

One or more computer-readable media as recited in claim 28, further comprising computer executable instructions that, when executed, direct the computer system to assign a visit identification to each record, the visit identification corresponding to the visit to the Web site by the user and store the visit identification with the associated record in the database.

### Claim 33 (depends on 28)

One or more computer-readable media as recited in claim 28, further comprising computer executable instructions that, when executed, direct the computer system to assign a user identification to each record, the user identification corresponding to the user and storing the user identification with the associated record in the database.

### Claim 34 (depends on 28)

One or more computer-readable media as recited in claim 28, further comprising computer executable instructions that, when executed, direct the computer system to deem the visit to the Web site by the user complete if no records are located in the database representing actions performed by the user for a period of time.

### Claim 35 (depends on 28)

One or more computer-readable media as recited in claim 28, further comprising computer executable instructions that, when executed, direct the computer system to deem the visit to the Web site by the user complete if no records are located in the database representing actions performed by the user for a period of time, wherein the period of time is definable by personnel managing the Web site.

### Claim 36 (depends on 28)

One or more computer-readable media as recited in claim 28, further comprising computer executable instructions that, when executed, direct the computer system to assign a date to each record, the date corresponding to the date the user visited the Web site, and store the date with the associated record in the database.

### Claim 37 (depends on 28)

One or more computer-readable media as recited in claim 28, further comprising computer executable instructions that, when executed, direct the computer system to assign a time to each record, the time corresponding to the time the user performed an action on the Web site, and store the time with the associated record in the database.

### Claim 38 (depends on 28)

One or more computer-readable media as recited in claim 28, wherein the sequential identification is an ordinal number indicating an order for the actions performed by the user.
