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.