Abstract: A system and method are disclosed for estimating a number of unique users (e.g., the number of unique users accessing a website, etc.). In one aspect, one or more transactions occurring during a time frame and a plurality of unauthenticated unique identification records associated with the transactions are identified. The time frame is segmented into disjoint time intervals, and a respective bit pattern is determined for each of the unauthenticated unique identification records. A set of churn patterns is determined based on the bit patterns, and a number of expected unauthenticated unique identification records is determined based on the bit patterns and the churn patterns. A number of unique users is estimated based on the size of the set of churn patterns and the number of expected unauthenticated unique identification records.

Abstract: Systems and methods for enabling querying of nested or repeated structures with simple, non-nested group by queries derived from a template. In particular, non-flat tables (e.g., tables with repeated or nested structures) can be queried from a frontend interface as though the tables flat, exposing data associated with the nested structures by way of the non-nest queries.

Abstract: This disclosure generally relates to systems and methods that facilitate employing a statistical model over a specified time frame divided into a plurality of time intervals for estimating a quantity of unique users from a set of unauthenticated unique identifiers, such as cookies, associated with accesses to one or more servers.

Abstract: Systems and methods for enabling querying of nested or repeated structures with simple, non-nested group by queries derived from a template. In particular, non-flat tables (e.g., tables with repeated or nested structures) can be queried from a frontend interface as though the tables flat, exposing data associated with the nested structures by way of the non-nest queries.