Patent ID: 8549019

Claim:
A computer-implemented method for creating aggregate tables for web analytics, the method comprising: at a server having one or more processors and memory, performing the following: receiving a web site selection; receiving a plurality of aggregate table definitions; generating respective aggregate tables for the web site according to the received aggregate table definitions; populating and updating data entries in the generated aggregate tables for the web site based on their corresponding aggregate table definitions and server hit data derived from log files for the web site and stored in a hits table; providing a user interface for selection of a view of web analytics data; receiving a view selection from a user utilizing the user interface; determining whether the selected view includes data in one or more aggregate tables; when the selected view includes data in at least one aggregate table: retrieving data from the at least one aggregate table; and returning the data to the user in a respective view; and when the selected view includes data that is not stored in any aggregate table: executing a corresponding query in the hits table; retrieving the data from the hits table in response to the query; and returning the data to the user in a respective view.