Systems and methods for constructing and utilizing a merchant database derived from customer purchase transactions data

• US 8,175,908 B1
• Filed: 09/03/2004
• Issued: 05/08/2012
• Est. Priority Date: 09/04/2003
• Status: Active Grant

• Current Assignee: Chase Manhattan Mortgage Corporation (JP Morgan Chase & Co)
• Original Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Inventors: Anderson, Russell Wayne
• Primary Examiner(s): Jeanty, Romain
• Application Number:
  US10/933,462
• Time in Patent Office: 2,804 Days
• Field of Search: 705/10, 705/7, 705/7.29
• US Class Current: 705/7.29
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data

Abstract

The invention relates to a method and system, including a computer system for storing and manipulating transaction data including transaction purchase information, customer demographics information, and merchant information, the computer system comprising a storage device for storing the transaction data and a processor for processing the transaction data. The method may include obtaining transaction purchase information generated from a plurality of sources; generating customer profile information based on the transaction purchase information; and obtaining merchant information relating to at least one merchant. The method may further include generating merchant profile information based on the merchant information and purchase transaction information; and processing the customer profile information and the merchant profile information in combination to generate business information; wherein the business information includes at least one selected from the group consisting of merchant profit information, merchant bankruptcy information, merchant revenue, merchant profit projections, and merchant market share.

Claims

1. A method, in a computer system for storing and manipulating transaction data including transaction purchase information, customer demographics information, and merchant information, the computer system comprising a storage device for storing the transaction data and a processor for processing the transaction data, the method comprising:

obtaining, by the computer system, transaction purchase information generated from a plurality of sources;

generating, by the computer system, customer profile information based on the transaction purchase information;

obtaining, by the computer system, merchant information relating to at least one merchant;

generating, by the computer system, merchant profile information based on the merchant information and transaction purchase information;

processing, by the computer system, the customer profile information and the merchant profile information in combination to generate business information; and

wherein the business information includes at least one selected from the group consisting of merchant profit information, merchant bankruptcy information, merchant revenue, merchant profit projections, and merchant market share;

wherein the processing the customer profile information and the merchant profile information in combination to generate business information includes;

analyzing the merchant profile information from a past time period, the merchant profile information being based on a selected merchant;

analyzing the customer profile information from the same past time period; and

generating interrelationship information between the analyzed merchant profile information and customer profile information from the past period time, the interrelationship information defining an interrelationship between the analyzed merchant profile information and the analyzed customer profile information; and

wherein the processing profile information and the merchant profile information in combination to generate business information further includes;

identifying a subsequent time period, which occurs after the past time period;

analyzing customer profile information from the subsequent time period; and

applying the interrelationship information in order to infer pseudo merchant profile information for the subsequent time period.

2. The method of claim 1, wherein the transaction purchase information is generated based on at least one selected from the group consisting of credit card activity, debit card activity, checking activity, and ACH transaction activity of consumers.

3. The method of claim 1, wherein the computer system is maintained and the method is effected by a banking institution or transaction processor.

4. The method of claim 1, wherein the transaction purchase information is generated based on at least one selected from the group consisting of stored value card activity and internet payment activity.

5. The method of claim 1, the computer system including a transaction model and a merchant model, and wherein the processing the customer profile information and the merchant profile information in combination to generate business information includes:

inputting the customer profile information into the transaction model, the computer system using the transaction model to generate transaction model output data;

inputting the merchant profile information into the merchant model, the computer system using the merchant model to generate merchant model output data; and

performing a scoring process, using the transaction model output data and the merchant model output data, to generate the business information.

6. The method of claim 1, wherein the processing the customer profile information and the merchant profile information in combination to generate business information includes:

inputting the customer profile information into an integrated model;

inputting the merchant profile information into the integrated model; and

wherein the integrated model outputs the business information.

7. The method of claim 1, wherein:

the merchant profile information from a past time period relates to profits of the selected merchant in the past period of time; and

the pseudo merchant profile information for the subsequent time period relates to anticipated profits of the selected merchant in the subsequent period of time.

8. The method of claim 1, wherein:

the merchant profile information from a past time period relates to sales volume of the selected merchant in the past period of time; and

the pseudo merchant profile information for the subsequent time period relates to sales volume of the selected merchant in the subsequent period of time.

9. The method of claim 8, wherein the sales volume relates to a particular type of merchandise.

10. The method of claim 8, wherein the sales volume relates to a particular product.

11. The method of claim 1, wherein:

the merchant profile information from a past time period relates to bankruptcy related attributes of the selected merchant in the past period of time, the selected merchant having declared bankruptcy proximate to the past period of time; and

the pseudo merchant profile information for the subsequent time period relates to sales bankruptcy related attributes of a further merchant in the subsequent period of time.

12. The method of claim 11, wherein:

the customer profile information from a past time period relates to bankruptcy related attributes of customer profile information, which are associated with the selected merchant in the past period of time; and

the customer profile information for the subsequent time period relates to sales bankruptcy related attributes of customer profile information, which are associated with the further merchant in the subsequent period of time.

13. The method of claim 1, wherein:

the merchant profile information from a past time period relates to payment default risk data of the selected merchant in the past period of time; and

the pseudo merchant profile information for the subsequent time period relates to payment default risk data of the selected merchant in the subsequent period of time.

14. The method of claim 1, wherein the customer profile information is information from at least one selected from the group consisting of credit card activity, debit card activity, stored value card activity, internet payment activity, checking activity, wireless payment activity and ACH transaction activity of consumers.

15. The method of claim 1, wherein the interrelationship information is based on corresponding predetermined attributes of the customer profile information and the merchant profile information.

16. The method of claim 1, wherein generating an interrelationship between the analyzed merchant profile information and customer profile information from the period of time is performed using a model.

17. The method of claim 1, wherein:

the transaction purchase information is stored in an account database, the account database being updated with further transaction information in real time based on occurring transactions; and

the merchant information is stored in a merchant database, the merchant database being updated with updates relating to the merchant, the merchant database being updated using batch updating.

18. The method of claim 17, wherein the batch updating is performed monthly.

19. The method of claim 1, wherein the business information relates to at least one of average purchase amount per visit, average annual amount spent, frequency of customer visits, and revenue by zip code.

20. The method of claim 19, wherein the computer system is maintained and the process is effected by a banking institution.

21. The method of claim 1, wherein the processing the customer profile information and the merchant profile information in combination to generate business information further includes:

identifying particular merchant profile information associated with a requesting merchant;

determining at least one competitor merchant associated with a competitor merchant profile, based on comparing merchant profile information associated with various merchants against the merchant profile information of the requesting merchant;

applying the merchant profile information of the competitor merchant against the customer profile information to identify transaction purchase information related to the competitor merchant; and

generating the business information based on the identified transaction purchase information.

22. The method of claim 21, wherein the business information relates to at least one of geographical distribution of market share, inventory expansion, customer demand and new store locations.

23. The method of claim 1, wherein the business information further includes further customer profile information.

24. The method of claim 1, further comprising a first entity, which maintains the computer system, sharing the transaction purchase information and the merchant information with a second entity, the second entity being a competitor of the first entity;

and

where the transaction purchase information and the merchant information is shared only as aggregated data such that specifics of such information is not shared.

25. The method of claim 1, wherein the merchant profile information includes:

store level profile information, which is information relating to individual stores; and

enterprise level profile information, which is information relating to a collection of stores in an enterprise, the method including;

the step of aggregating the store level profile information to generate the enterprise level profile information.

26. The method of claim 25, wherein the step of aggregating the store level profile information to generate the enterprise level profile information includes using at least one selected from the group consisting of a Standard Industry Category (SIC) code and a Merchant Category Code (MCC).

27. The method of claim 1, wherein the transaction purchase information is generated based on activity associated with a private label card, the transaction purchase information including identification of a particular item that has been purchased, the identification of a particular item including.

28. The method of claim 1, wherein the processing the customer profile information and the merchant profile information in combination to generate business information further includes conducting a same day purchase analysis, the same day purchase analysis including:

segregating transaction purchase information so as to collect transaction purchase information from a single day; and

performing the processing based on the transaction purchase information collected from the single day.

29. The method of claim 1, wherein the processing the customer profile information and the merchant profile information in combination to generate business information further includes:

selecting accounts with purchases at a client store to generate a set of selected accounts; and

performing a further selection process on the set of selected accounts to retain only transactions on these accounts occurring on the same day, so as to build a same-day purchase database.

30. A computer system constituted by a processing machine for storing and manipulating transaction data including transaction purchase information and merchant information, the computer system comprising:

an account database for storing transaction purchase information, the account database inputting transaction purchase information generated from a plurality of sources;

a merchant database for storing merchant information, the merchant database inputting merchant information relating to at least one merchant;

a customer profile portion, disposed in the processing machine, that generates customer profile information based on the transaction purchase information;

a merchant profile portion, disposed in the processing machine, that generates merchant profile information based on the merchant information; and

a processing portion, disposed in the processing machine, that processes the customer profile information and the merchant profile information in combination to generate business information;

wherein the business information includes at least one selected from the group consisting of merchant profit information, merchant bankruptcy information, merchant revenue, merchant profit projections, and merchant market share;

wherein the processing portion processes the customer profile information and the merchant profile information in combination to generate business information including;

analyzing the merchant profile information from a past time period, the merchant profile information being based on a selected merchant;

analyzing the customer profile information from the same past time period; and

generating interrelationship information between the analyzed merchant profile information and customer profile information from the past period time, the interrelationship information defining an interrelationship between the analyzed merchant profile information and the analyzed customer profile information,

wherein the processing the customer profile information and the merchant profile information in combination to generate business information, as performed by the processing portion, further includes;

identifying a subsequent time period, which occurs after the past time period;

analyzing customer profile information from the subsequent time period; and

applying the interrelationship information in order to infer pseudo merchant profile information for the subsequent time period.

31. The system of claim 30, wherein the plurality of sources includes a plurality of databases.

32. The method of claim 30, wherein the processing portion processes the customer profile information and the merchant profile information in combination to generate business information further including:

identifying particular merchant profile information associated with a requesting merchant;

determining at least one competitor merchant associated with a competitor merchant profile, based on comparing merchant profile information associated with various merchants against the merchant profile information of the requesting merchant;

applying the merchant profile information of the competitor merchant against the customer profile information to identify transaction purchase information related to the competitor merchant; and

generating the business information based on the identified transaction purchase information.

33. The system of claim 30, wherein:

the merchant profile information from a past time period relates to profits of the selected merchant in the past period of time; and

the pseudo merchant profile information for the subsequent time period relates to anticipated profits of the selected merchant in the subsequent period of time.