Back to results
US 2013/0173385 A1Published application
Generation and Provision of Directed Sales Incentives at Locations Remote from the Point of Sale
AssigneeSafeway Inc.
InventorKenneth H. TARBET
Life of this patent
Estimating the term…
Abstract
This invention is directed to a system and method for improving customer loyalty through direct sales incentive dissemination based on the customers past purchase history and items the store is offering at a reduced price. The additional services include providing the customer with a list of their preferred items, which are also on sale, without the customer needing to search for related coupons and the like.
Claims13
A method of picking records from at least one first table of a dimensional database, corresponding to at least one future event, the method comprising:
- receiving the dimensional database comprising a first plurality of tables comprising the at least one first table, each of a second plurality of the first plurality of tables comprising a plurality of rows having at least one attribute related to an effective identifier in said row, the second plurality comprising a third table comprising a plurality of rows, each of the plurality of rows of the third table comprising a reference to a row of at least one other table in the dimensional database;
- and
- following the receiving step:
- fashioning at least one second table responsive to an identifier attribute of at least one of the at least one first table of the dimensional database;
- and
- responsive to at least one attribute of at least one row of the at least one second table, picking at least one row from the at least first table of the dimensional database and a table produced responsive to at least a portion of a first table of the dimensional database.
3 more elements
A method of improving customer loyalty, said method comprising:
- receiving a dimensional database comprising a first plurality of tables comprising at least one first table, each of a second plurality of the first plurality of tables comprising a plurality of rows having at least one attribute related to an effective identifier in said row, the second plurality comprising a third table comprising a plurality of rows, each of the plurality of rows of the third table comprising a reference to a row of at least one other table in the dimensional database;
- and
- following the receiving step:
- fashioning at least one second table responsive to an item identifier attribute of at least one of the at least one first table of the at least one dimensional database;
- and
- responsive to at least one of the at least one second table, picking at least one row from one selected from a first table of the dimensional database and a table produced responsive to at least a portion of at least a portion of at least one first table of the dimensional database;
- and
- receiving an identifier of a first input table comprising at least a portion of one of the first tables, the first input table comprising a plurality of rows, at least one row consisting of at least one selected from an item effective identifier and a user effective identifier;
- and
- fashioning the third table comprising at least one row consisting of at least one selected from at least one identifier corresponding to at least one of the item identifiers from at least one row of the first input table and at least one identifier corresponding to at least one of the user identifiers from at least one row of the first input table.
7 more elements
A method of improving customer relations, said method comprising:
- receiving a dimensional database consisting essentially of at least one first table consisting of a plurality of rows having at least one attribute related to an inventory item and at least a second attribute related to a customer identifier;
- and
- following the receiving step;
- fashioning at least one second table responsive to at least one inventory item
- attribute and at least one customer identifier attribute of the at least one first table of the dimensional database, and
- receiving an identifier of a first input table consisting essentially of at least a portion of one of the first tables, the first input table comprising a plurality of rows, at least one row comprising the inventory item identifier;
- and
- fashioning a third table comprising at least one row consisting of at least one inventory item identifier corresponding to, at least one of the inventory item identifiers from at least one row of the first input table and at least one of the inventory item identifiers from at least one row of the second table, and at least one customer identifier attribute corresponding to at least one of the customer identifier attributes from at least one row of the second table;
- and
- informing the customer corresponding to the customer identifier attributes of the third table of the data in said table.
7 more elements
Dependencies are inferred from the claim text.