Abstract: At a marketing platform, an aggregated profile device graph is provided that associates different unique aggregated profile identifiers with different sets of related devices and their associated user identifiers. At least a portion of the aggregated profile device graph also associates user profile data and activity data with each device's user identifier and corresponding aggregated profile identifier. In response to the marketing platform obtaining a report request for a performance metric for a particular user segment, the performance metric is determined from activity data of specific ones of the aggregated user identifiers and their associated sets of related devices. Each of these specific aggregated user identifiers and their associated sets of related devices are associated with user profile data that includes the particular user segment. A report on the performance metric for the particular audience segment is then provided, for example, to the report requester.

Abstract: For each device represented in a device graph of different sets of related devices, user profile and advertisement activity data are periodically obtained and associated with such device. For each set of related devices, an aggregated user profile graph is formed either by copying each related device's user profile data to the user profile data of the other related devices based on the device graph or each related device's user profile data is referenced with the user profile data of each other related device based on the device graph while maintaining such each related device to be separately associated with its user profile data. Different unique aggregated profiled identifiers are associated with different sets of related devices, and the aggregated profile device graph is provided in a database that is accessible by a processor that is programmed to perform targeted advertising or marketing engagement over a computer network.

Abstract: A method for automatically defining a query interface for a datamart is described. The datamart includes fact and dimension tables. The method comprises accessing a schema description and a query interface description for the datamart. The schema description specifies a schema, which in turn, defines the relationships between the fact tables and dimension tables of the datamart. The query interface description specifies the fields, related to the schema description, that can be used in a query and the way in which results are to be presented to the user. The fields correspond to columns and rows in the fact tables. The schema description is used to create a first set of commands to create and populate the fact and dimension tables. Additionally, a second set of commands to create the query interface is created. Some commands of the first set of commands are executed causing the creation and population of the tables.