Patent ID: 7133882

Claim:
A computer-implemented method for updating a master product attribute catalog database for consumer response modeling, comprising: receiving data in a customer specific data format from at least one source of product data, wherein the received data includes product data, store data, cost data promotion data and point of sale data; converting the received data, using a customer specific data map, from the customer specific data format to a common data format useful for updating a master product attribute catalog; storing the converted received data in a staging database; performing a data integrity check on the converted received data; determining if the converted received data exists in the master product attribute catalog, and if the converted received data exists in the master product attribute catalog: then performing a reconciliation between the converted received data and the master product attribute catalog to determine whether there is a conflict between the converted received data and the master product attribute catalog, and if there is a conflict then performing a vote of the converted received data, and whenever the vote exceeds a threshold then updating the product data in the master product attribute catalog; else if the converted received data does not exists in the master product attribute catalog, then creating a new record of the converted received data in the master product attribute catalog, and updating the master product attribute catalog by adding the product data to the new record; adding the converted received data to a modeling database; adding the product data from the master product attribute catalog to the modeling database; creating a consumer response model from the converted received data and the product data in the modeling database, wherein the consumer response model includes a sales model; adding the converted received data to an optimization database; adding the product data from the master product attribute catalog to the optimization database; and adding parameters including model coefficients of the consumer response model to the optimization database, and wherein the model coefficients are estimated using Bayesian statistics.