Evaluating impact of in-store displays on shopping behavior

A computer program product comprising computer executable code embodied in a non-transitory computer readable medium that, when executing on one or more computing devices, performs the steps of:

• acquiring panel data, the panel data including a number of purchase records reported by a number of consumers in a panel for a number of shopping trips, each purchase record for one of the shopping trips identifying a store name for a store without providing a specific location of the store, a time of the one of the shopping trips, and a number of items purchased at the store during the one of the shopping trips, and each one of the number of consumers having a plurality of consumer demographic attributes;
• acquiring audit data from a number of retail locations, the audit data characterizing a number of retail displays within the retail locations according to one or more display attributes, each item of audit data further specifying an audit time at which the item of audit data was acquired;
• creating a data set by associating each store name in one of the purchase records of the panel data with one of the number of retail locations of the audit data having a corresponding store name that is geographically nearest to the consumer that provided the one of the purchase records;
• creating a consumer response model by relating one or more independent variables including the one or more display attributes to a dependent variable based on a trip outcome;
• acquiring trade area data including retail store data for the number of retail locations, point of sale data for the number of retail locations, and demographic data for a geographic area containing the number of retail locations, wherein the retail store data includes a square footage, a location, and an amount of sales for each of the number of retail locations, the point of sale data describes an amount of a product sold over a predetermined time period for each of the retail locations, and the demographic data characterizes a population within the trade area according to one or more trade area demographic attributes;
• refining the consumer response model and scaling the consumer response model to the trade area based on a relationship between the trade area data and the plurality of consumer demographic attributes for the number of consumers in the panel, thereby providing a trade area consumer response model including the one or more independent variables and the dependent variable;
• and
• applying the trade area consumer response model to estimate the trip outcome for the trade area based on the one or more display attributes.

A method comprising:

• acquiring panel data characterizing purchasing behavior of a predetermined group of consumers in a panel and audit data characterizing product displays at a number of retail location, wherein the purchasing behavior identifies retail venues by store name but not by geographic location;
• creating a consumer response model by relating one or more independent variables including the one or more display attributes to a dependent variable based on a trip outcome, wherein a set of trip outcomes is linked to geographic locations of the retail venues for each one of the set of trip outcomes based on a geographic relationship between a home location of a corresponding one of the predetermined group of consumers and a number of geographic locations of a corresponding number of stores for the retail venue;
• refining the consumer response model and scaling the consumer response model to a trade area based on a relationship between the trade area data and demographic attributes for the predetermined group of consumers in the panel, thereby providing a trade area consumer response model including the one or more independent variables and the dependent variable;
• and
• applying the trade area consumer response model to estimate the trip outcome for the trade area based on the one or more display attributes.

A system comprising:

• a memory storing panel data characterizing purchasing behavior of a predetermined group of consumers in a panel, audit data characterizing product displays at a number of retail location, wherein the purchasing behavior identifies retail venues by store name but not by geographic location, trade area data and demographic attributes for the predetermined group of consumers in the panel;
• a processor configured to create a consumer response model by relating one or more independent variables including the one or more display attributes to a dependent variable based on a trip outcome, wherein a set of trip outcomes is linked to geographic locations of the retail venues for each one of the set of trip outcomes based on a geographic relationship between a home location of a corresponding one of the predetermined group of consumers and a number of geographic locations of a corresponding number of stores for the retail venue, the processor further configured to refine and scale the consumer response model to a trade area based on a relationship between the trade area data and demographic attributes for the predetermined group of consumers in the panel, thereby providing a trade area consumer response model including the one or more independent variables and the dependent variable;
• and
• a physical display device coupled to the processor and configured by the processor to present a user interface for applying the trade area consumer response model to estimate the trip outcome for the trade area based on the one or more display attributes.