1. Field of the Disclosure
Aspects of the disclosure relate in general to financial services. Aspects include an apparatus, system, method and computer-readable storage medium to determine merchant business hours using financial transactions.
2. Description of the Related Art
For centuries, financial transactions have used currency, such as banknotes and coins. For example, traditionally, whenever travelers leave home, they carried to pay for expenses, such as shopping, transportation, lodging, and food.
In modern times, however, payment cards are rapidly replacing cash to facilitate payments. Payment cards provide the clients of a financial institution (“cardholders”) with the ability to pay for goods and services without the inconvenience of using cash. A payment card is a card that can be used by a cardholder and accepted by a merchant to make a payment for a purchase or in payment of some other obligation. Payment cards include credit cards, debit cards, charge cards, and Automated Teller Machine (ATM) cards.
Payment cards eliminate the need for carrying large amounts of currency. Moreover, in international travel situations, payment cards obviate the hassle of changing currency.
There are over ten million merchant locations in the United States. Throughout the entire world, there are an even greater number of merchant locations. While some merchants publish their business hours on a web-site, or make this information available via the telephone, many merchants do not make their business hour information available remotely. Moreover, due to the sheer number of merchants, it is a costly and difficult task to collect business hour information manually.
Embodiments include a system, device, method and computer-readable medium to determine merchant business hours using financial transactions.
In a method embodiment, the method determines business hours of a merchant. A processor extracts payment card transaction authorization information for the merchant. The payment card transaction authorization information includes a time and a date of multiple payment card authorizations. The processor groups each of the multiple payment card authorizations into days of a week. The processor determines an opening time and a closing time of at least one of the days of the week based at least in part on a first and a last payment card transaction authorization. A non-transitory computer-readable storage medium stores the opening and the closing time.
A business hours calculation server embodiment comprises a processor and a computer-readable storage medium. The processor is configured to extract payment card transaction authorization information for the merchant. The payment card transaction authorization information includes a time and a date of multiple payment card authorizations. The processor is further configured to group each of the multiple payment card authorizations into days of a week. The processor is configured to determine an opening time and a closing time of at least one of the days of the week based at least in part on a first and a last payment card transaction authorization. The non-transitory computer-readable storage medium stores the opening and the closing time.
A non-transitory computer-readable storage medium embodiment is encoded with data and instructions. When the instructions are executed by a computing device, the instructions cause the computing device to determine business hours of a merchant. A processor extracts payment card transaction authorization information for the merchant. The payment card transaction authorization information includes a time and a date of multiple payment card authorizations. The processor groups each of the multiple payment card authorizations into days of a week. The processor determines an opening time and a closing time of at least one of the days of the week based at least in part on a first and a last payment card transaction authorization. The non-transitory computer-readable storage medium stores the opening and the closing time.
One aspect of the disclosure includes the understanding that many merchants accept payment cards for transactions.
Another aspect of the disclosure is the realization that payment card financial transactions may be used to determine a merchant's business hours.
Embodiments of the present disclosure include a system, method, and computer-readable storage medium configured to determine a merchant's business hours using financial transaction data.
These and other aspects may be apparent in hindsight to one of ordinary skill in the art.
For the purposes of this disclosure, a payment card includes a stored-value card (such as a transit card or gift card), credit card, debit card, automatic teller machine (ATM) card, charge card, electronic wallet, Radio Frequency Identifier (RFID) device, cloud-based payment device, or any other electronic payment device known in the art.
Payment cards are affiliated with payment networks, which are operational networks that enable monetary exchange between parties. An example payment network includes MasterCard International Incorporated of Purchase, N.Y.
Business hours calculation server 2000 may run a multi-tasking operating system (OS) and include at least one processor or central processing unit (CPU) 2100, a non-transitory computer-readable storage medium 2200, and a network interface 2300.
Processor 2100 may be any central processing unit, microprocessor, micro-controller, computational device or circuit known in the art. It is understood that processor 2100 may communicate with and temporarily store information in Random Access Memory (RAM) (not shown).
As shown in
Merchant business hours collector 2110 is the structure that enables the business hours calculation server 2000 to analyze financial transactions and determine the business hours of a merchant 1100 based on the timing of the financial transactions. The functionality of merchant business hours collector 2110 is described in greater detail in
Payment-purchase engine 3130 may be any structure that facilitates payment from customer accounts at an issuer 2300 to a merchant 1100. The customer accounts may include payment card accounts, checking accounts, savings accounts and the like.
Data processor 2120 enables processor 2100 to interface with storage medium 2200, network interface 2300 or any other component not on the processor 2100. The data processor 2120 enables processor 2100 to locate data on, read data from, and write data to these components.
These structures may be implemented as hardware, firmware, or software encoded on a computer readable medium, such as storage medium 2200. Further details of these components are described with their relation to method embodiments below.
Network interface 2300 may be any data port as is known in the art for interfacing, communicating or transferring data across a computer network, examples of such networks include Transmission Control Protocol/Internet Protocol (TCP/IP), Ethernet, Fiber Distributed Data Interface (FDDI), token bus, or token ring networks. Network interface 2300 allows business hours calculation server 2000 to communicate with vendors, cardholders, and/or issuer financial institutions.
Computer-readable storage medium 2200 may be a conventional read/write memory such as a magnetic disk drive, floppy disk drive, optical drive, compact-disk read-only-memory (CD-ROM) drive, digital versatile disk (DVD) drive, high definition digital versatile disk (HD-DVD) drive, Blu-ray disc drive, magneto-optical drive, optical drive, flash memory, memory stick, transistor-based memory, magnetic tape or other computer-readable memory device as is known in the art for storing and retrieving data. Significantly, computer-readable storage medium 2200 may be remotely located from processor 2100, and be connected to processor 2100 via a network such as a local area network (LAN), a wide area network (WAN), or the Internet.
In addition, as shown in
Merchant business hours database 2210 is the data structure that stores merchant business hours, as determined by merchant business hours collector 2110.
Authorization database 2220 may be a linked-list, table, or any data structure known in the art that contains a record of payment card financial transactions. Table 1 below illustrates an example authorization table.
Merchant location database 2230 may be any data structure in the art that contains geographic information for a merchant 1100. The geographic information for merchant 1100 may include the time zone in which the merchant is located.
These structures may be implemented as hardware, firmware, or software encoded on a non-transitory computer readable medium, such as storage media. Further details of these components are described with their relation to method embodiments below.
It is understood by those familiar with the art that one or more of these databases 2210-2230 may be combined in a myriad of combinations. The function of these structures may best be understood with respect to the data flow diagram of
These structures may be implemented as hardware, firmware, or software encoded on a non-transitory computer readable medium, such as storage media. Further details of these components are described with their relation to method embodiments below.
Initially, for a particular merchant location, merchant business hours collector 2110 extracts all the transaction date and time information (for a given time period) from the authorization database 2220, block 3010. In some embodiments, the time period could be a year or less. Because of the 24-hour nature of most on-line and travel businesses (e.g., hotel and airlines), these merchants 1100 may be excluded.
The location information is extracted from the merchant location database 2230 for the selected merchant 1100, block 3020. The location information allows the merchant business hours collector 2110 to covert time information to the local time zone based on the merchant location, block 3030.
The transactions are grouped into the seven days of the week (Sunday through Saturday), block 3040.
Depending upon granularity of the time-interval desired, for each day of the week the day is divided into intervals, block 3050. For example, for half-hour intervals, the 24 hours is divided into 48 time intervals.
For each time interval, the number of transaction falling in that interval is determined, as shown in Table 1, block 3060.
Next, outlier transactions are filtered out, block 3070. Outlier transactions are “noise” and other transactions that occur outside the normal business hours. For example, some noise transactions include late night transactions from some merchants. Other outlier transactions occur because of shopping holidays, for example, “Black Friday.” Outlier transactions may be filtered for local holidays, for example. Additionally, some merchants use batch authorization which would occur outside the normal business hours; these authorizations can be detected as unusually high peaks in a time interval. The batch authorizations are filtered out. In some embodiments, to eliminate random noise transactions, a minimum cutoff ratio is set up, where the transaction counts have to exceed a minimum threshold to be considered valid.
Based on the pattern of the transaction count time series, such as gaps and cliffs, a pattern is detected, block 3080.
The intervals that contain the first transaction in a day may be correlated to the opening time and the last transaction correlated the closing time. Note that for some types of merchants, such restaurants that close after lunch and reopen at dinner, the merchants may have more than one opening or closing time. This process is able to detect such openings and closing times.
After detecting the opening and closing times, the information is stored on to storage media, block 3090.
To enable the embodiments described, it is understood that hardware, software, and firmware encoded on to non-transitory computer readable media are utilized.
The previous description of the embodiments is provided to enable any person skilled in the art to practice the disclosure. The various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without the use of inventive faculty. Thus, the present disclosure is not intended to be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and features disclosed herein.
This application claims priority to provisional U.S. Patent Application Ser. No. 61/838,137, entitled “Merchant Business Hours Database via Transaction Data Apparatus and Method,” filed on Jun. 21, 2013.
Number | Date | Country | |
---|---|---|---|
61838137 | Jun 2013 | US |