Compiling values that relate to aggregate data

A computer program product tangibly embodied in a computer-readable medium, the computer program product including instructions that, when executed, cause a processor to perform operations comprising:

• provide, from a data warehouse system and to a computer device, an output that causes a visual display of aggregate data portions to be generated on the computer device, the aggregate data portions being (i) selected from the group consisting of:
• a table entry, a segment of a displayed graph, and combinations thereof, and (ii) created by being aggregated from selected data records in a data source system;
• receive, at the data warehouse system and from the computer device after the visual display is generated, a user first input indicating that a user has selected at least one of the aggregate data portions in the visual display and requests a list of values relating to the selected at least one aggregate data portion, the requested values being stored in a field of each of the selected data records from which the selected at least one aggregate data portion was aggregated;
• generate, in the data warehouse system and in response to the user input, the list of the values stored in the field of each of the selected data records from which the selected at least one aggregate data portion was aggregated, the values being identifiers for entities that are to be made members of a target group in a marketing campaign;
• receive, at the data warehouse system and from the computer device after the visual display is generated, a second user input indicating that the user has selected at least one of the several data source systems having respective campaign management application programs;
• and
• forward the generated list of the values to the respective campaign management application program of the selects data source system, wherein those of the identifiers that relate to entities that are not recognized in the selected data source system are omitted.

A method of compiling identifiers that relate to aggregate data, the method comprising:

• providing, from a data warehouse system and to a computer device, an output that causes a visual display of an aggregate data portion to be generated on the computer device, the aggregate data portion being (i) selected from the group consisting of:
• a table entry, a segment of a displayed graph, and combinations thereof, and (ii) created by being aggregated from selected data records in at least one of several data source systems, the several data source systems having respective campaign management application programs;
• receiving, at the data warehouse system and from the computer device after the visual display is generated, a first user input indicating a request to compile identifiers for entities that are to be made members of a target group in a marketing campaign, the identifiers being stored in a field of each of the selected data records, the visual display configured for a user to make the first user input;
• compiling, in the data warehouse system and in response to the first user input, the identifiers stored in the field of each of the selected data records;
• receiving, at the data warehouse system and from the computer device after the visual display is generated, a second user input indicating that the user has selected at least one of the several data source systems;
• and
• forwarding the compiled identifiers to the respective campaign management application program of the selected data source system, wherein those of the identifiers that relate to entities that are not recognized in the selected data source system are omitted.

A method of compiling values that relate to aggregate data, the method comprising:

• providing, from a data warehouse system and to a computer device, an output that causes a visual display of an aggregate data portion to be generated on the computer device, the aggregate data portion (i) created by being aggregated from selected data records in a data source system, and (ii) being a segment of a displayed graph, and wherein the displayed graph is supplemented by a table that is provided to the computer device and not displayed with the graph;
• receiving, at the data warehouse system and from the computer device after the visual display is generated, a first user input indicating a request to compile values stored in a field of each of the selected data records, the visual display configured for a user to make the first user input;
• compiling, in the data warehouse system and in response to the first user input, the values stored in the field of each of the selected data records, the values being identifiers for entities that are to be made members of a target group in a marketing campaign;
• receiving, at the data warehouse system and from the computer device after the visual display is generated, a second user input indicating that the user has selected at least one of several data source systems having respective campaign management application programs;
• and
• forwarding the compiled values to the respective campaign management application program of the selected data source system, wherein those of the identifiers that relate to entities that are not recognized in the selected data source system are omitted, and wherein the data warehouse system obtains the aggregate data portion by a query before providing the output, and wherein compiling the values comprises performing the query with an additional criterion that configures the query to retrieve the values stored in the field of each of the selected data records.