Method for performing retail sales analysis
DCFirst Claim
1. A method for performing a transaction-related analysis, comprising the steps of:
- providing one or more computerized databases that include at least one of transaction and consumer data for one or more establishments, the at least one of transaction and consumer data including one or more transaction records associating at least a product identification code with a consumer identification code;
formulating an analysis project request via a user interface that is operatively coupled to a computer system having access to the database; and
generating, by the computer system, an analysis project on the at least one of transaction and consumer data in response to receiving the analysis project request;
wherein the step of formulating the analysis project request includes the steps of,selecting, via the user interface, the analysis project from a predefined list of available analysis projects;
obtaining, by the computer system a template of executable database analysis scripts based, at least in part, upon the selected analysis project;
selecting, via the user interface, one or more analysis parameters associated with the analysis project; and
loading, by the computer system, the selected one or more analysis parameters with the template of executable database analysis scripts to construct an executable analysis project script to be executed against on the at least one of transaction and consumer data in the generating step;
wherein the step of selecting, via the user interface, one or more analysis parameters associated with the analysis project includes the step of selecting one or more products from a list of available products;
wherein the step of selecting, via the user interface, one or more analysis parameters associated with the analysis project includes the step of selecting a time frame in which to limit the analysis of the at least one of transaction and consumer data; and
wherein the method further includes the step of executing, by the computer system, the executable analysis project script on the at least one of transaction and consumer data to produce result data.
2 Assignments
Litigations
2 Petitions
Accused Products
Abstract
The invention provides a user with substantial flexibility in requesting and generating analysis projects on transaction and/or consumer data that is stored in one or more databases. Exemplary embodiments of the invention provide a method for retailers and other authorized users, such as suppliers, to access and perform sophisticated, highly specialized analysis on transaction and/or consumer data, such as retail sales and consumer data, from a remote location using an internet connected computer. The transaction and/or consumer data that is accessed can be a compilation of retail transaction data (collected from EPOS systems, for example) and/or consumer data (which has been collected from frequent-shopper or loyalty cards used by consumers when they shop, for example). Projects are generated as spreadsheet based interactive reports, which are easy to manipulate for further analysis and presentations. Insights from these projects can lead to better decisions on new product launches, sampling, merchandizing, assortment, distribution, and other sales and marketing priorities. Exemplary projects may be interactive, allowing the user to manipulate and extract information which is specific to the user'"'"'s particular needs.
68 Citations
74 Claims
-
1. A method for performing a transaction-related analysis, comprising the steps of:
-
providing one or more computerized databases that include at least one of transaction and consumer data for one or more establishments, the at least one of transaction and consumer data including one or more transaction records associating at least a product identification code with a consumer identification code; formulating an analysis project request via a user interface that is operatively coupled to a computer system having access to the database; and generating, by the computer system, an analysis project on the at least one of transaction and consumer data in response to receiving the analysis project request; wherein the step of formulating the analysis project request includes the steps of, selecting, via the user interface, the analysis project from a predefined list of available analysis projects; obtaining, by the computer system a template of executable database analysis scripts based, at least in part, upon the selected analysis project; selecting, via the user interface, one or more analysis parameters associated with the analysis project; and loading, by the computer system, the selected one or more analysis parameters with the template of executable database analysis scripts to construct an executable analysis project script to be executed against on the at least one of transaction and consumer data in the generating step; wherein the step of selecting, via the user interface, one or more analysis parameters associated with the analysis project includes the step of selecting one or more products from a list of available products; wherein the step of selecting, via the user interface, one or more analysis parameters associated with the analysis project includes the step of selecting a time frame in which to limit the analysis of the at least one of transaction and consumer data; and wherein the method further includes the step of executing, by the computer system, the executable analysis project script on the at least one of transaction and consumer data to produce result data. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28)
-
-
29. A method for performing a transactional analysis, comprising the steps of:
-
providing one or more databases that include at least one of transaction and consumer data for one or more establishments; providing a computer system having access to the one or more databases; obtaining from a user, through a computer interface provided by the computer system, an analysis project selection; obtaining from the user, through the computer interface provided by the computer system, parameters for analysis of the at least one of transaction and consumer data, the parameters for analysis including an identification of retail products for analysis and an identification of a timeframe for analysis; feeding, by the computer system, the obtained parameters into a template of executable database analysis scripts, which corresponds to the analysis project selection, to produce an executable job file; executing, by the computer system, the executable job file on the at least one of transaction and consumer data to return results; and presenting to the user a project reflecting the returned results. - View Dependent Claims (30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61)
-
-
62. A computerized system for performing analysis comprising:
-
one or more databases having at least one of transaction and consumer data for one or more establishments, the at least one of transaction and consumer data including one or more transaction records associating at least a product identification code with a consumer identification code; a plurality of analysis project script executable code templates and a plurality of analysis project interactive output spreadsheet templates; and a computer system having access to the database and the plurality of analysis project script templates and analysis project interactive output spreadsheet templates, the computer system being configured to perform the steps of; obtaining parameters for analysis of the at least one of transaction and consumer data, the parameters for analysis including an identification of retail products for analysis and an identification of a timeframe for analysis; feeding the obtained parameters into a selected one of the plurality of analysis project script templates to produce an executable job file; executing the executable job file on the at least one of transaction and consumer data to return results; inserting the returned results into a selected one of the plurality of analysis project interactive output spreadsheet templates to produce an interactive output; and inserting the returned results into a selected one of the plurality of analysis project interactive output spreadsheet templates to produce an interactive output; and transmitting the interactive output to a user interface operatively coupled to the computer system. - View Dependent Claims (63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74)
-
Specification