System and method of preparing and processing data for trade promotion
First Claim
Patent Images
1. A computer-based method of processing data from disparate data sources into a combined data file for use in a system for conducting data processing for trade promotion event effectiveness analysis, the method comprising the acts of:
- inputting into a computer consumption data, shipment data and event cost data, wherein the consumption data is extracted from a database provided by one or more syndicated consumer data reporting agency, the shipment data is provided by a user'"'"'s internal systems, and the event cost data is provided by the user'"'"'s organization;
transforming by said computer consumption data by checking and verifying the consumption data for uniqueness and consistency from one time period to another, computing and adding to the inputted consumption data, baseline consumption data for each event time period and identifying time periods and related consumption data associated with a trade promotion event, aggregating by said computer the consumption data, shipment data and event cost data into a single data file; and
using the single data file to analyze effectiveness of trade promotional events.
3 Assignments
0 Petitions
Accused Products
Abstract
A system and method for the preparation of data into an organized and effective methodology provides users with a data modeling tool. Data is confirmed and baseline calculations, event extraction, key performance indicator calculations and the production of event outputs are performed. Analytical tools can then be used to visualize patterns, trends and relationships in the data.
-
Citations
37 Claims
-
1. A computer-based method of processing data from disparate data sources into a combined data file for use in a system for conducting data processing for trade promotion event effectiveness analysis, the method comprising the acts of:
-
inputting into a computer consumption data, shipment data and event cost data, wherein the consumption data is extracted from a database provided by one or more syndicated consumer data reporting agency, the shipment data is provided by a user'"'"'s internal systems, and the event cost data is provided by the user'"'"'s organization;
transforming by said computer consumption data by checking and verifying the consumption data for uniqueness and consistency from one time period to another, computing and adding to the inputted consumption data, baseline consumption data for each event time period and identifying time periods and related consumption data associated with a trade promotion event, aggregating by said computer the consumption data, shipment data and event cost data into a single data file; and
using the single data file to analyze effectiveness of trade promotional events. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. A computer-based method of aggregating data to create a computer data file for trade promotion event effectiveness analysis, the method comprising the acts of:
-
inputting into a computer consumption data, shipment data and event cost data into files in the computer, wherein the consumption data is provided by one or more syndicated consumer data reporting agency, the shipment data is provided by a user'"'"'s internal systems, and the event cost data is provided by the user'"'"'s organization;
matching using said computer consumer account identification data in the consumption file with shipment account identification data in the shipment file and matching standard product identification data in the shipment file to product identification data in the consumption file;
outputting a consolidated historical trade promotion event data file based on matched data records in each of the consumption, shipment and event cost data files; and
using the consolidated historical trade promotion event data file to analyze effectiveness of trade promotional events;
whereby the consolidated historical trade promotion event data file is more efficient and more correct than raw data files for performing event in said computer analysis. - View Dependent Claims (16, 17, 18, 19, 20, 21, 22, 23, 24)
-
-
25. A system for processing data from disparate data sources into a combined data file for use in a system for trade promotion event effectiveness analysis, comprising:
-
a database collecting consumption data, shipment data and event cost data wherein the consumption data is provided by one or more syndicated consumer data reporting agency, the shipment data is provided by a user'"'"'s internal systems, and the event cost data is provided by the user'"'"'s organization; and
a processor transforming the consumption data by checking and verifying the consumption data for uniqueness and consistency from one time period to another, computing and adding to the inputted consumption data baseline consumption data for each event time period and identifying time periods and related consumption data associated with a trade promotion event, and aggregating the transformed consumption data, shipment data and event cost data into a single data file, and using the single data file to analyze effectiveness of trade promotional events. - View Dependent Claims (26, 27, 28)
-
-
29. A system for aggregating data from disparate data sources to create a data file for efficient analysis of trade promotion event effectiveness, comprising:
-
a database storing consumption data, shipment data and event cost data wherein the consumption data is provided by one or more syndicated consumer data reporting agency, the shipment data is provided by a user'"'"'s internal systems, and the event cost data is provided by the user'"'"'s sales organization; and
a processor matching consumer account identification data in the consumption data with shipment account identification data in the shipment data and matching standard product identification data in the shipment data to product identification data in the consumption data and matching trade promotion data in the event cost data to related time periods in the consumption data, and outputting a consolidated historical trade promotion event data file based on matched data records in each of the consumption, shipment and event cost data, and using the consolidated historical trade promotion event data file to analyze effectiveness of trade promotional events;
whereby the consolidated historical trade promotion event data file is more efficient and more correct than raw data files for performing event based analysis. - View Dependent Claims (30, 31, 32, 33, 34, 35, 36, 37)
-
Specification