Systems and methods for analyzing businesses based on gratuities

A computer-implemented method for analyzing gratuity data of merchants and ranking merchants based on the analyzed gratuity data, the method being performed using a computing device including a processor in communication with a memory, and coupled to a payment processing device, the method comprising:

• receiving, by the processor, from an authorization database and a clearing database of the payment processing device, transaction data of a plurality of merchants, the transaction data comprising authorization transaction messages and clearing transaction messages, wherein each authorization transaction includes a base amount and each clearing transaction includes a sum of a gratuity amount and a base amount;
• matching, by the processor, each authorization transaction message with a clearing transaction message that corresponds to the same payment transaction based on one or more transaction identifiers included in both the authorization and clearance transaction messages;
• generating, and storing in the memory, by the processor, a table of matched transaction identifiers, wherein the table includes one or more transaction identifiers of an authorization transaction message matched to one or more transaction identifiers of a corresponding clearance transaction message;
• calculating, based on the table of matched transaction identifiers, gratuity amounts for each matched authorization transaction message and clearing transaction message by calculating a difference in payment amount between the clearing transaction message and the authorization transaction message;
• storing, in the memory, the calculated gratuity amounts in association with the matched transaction identifiers;
• receiving, by the processor, a user input from a user computing device, the user input including a geographic location;
• selecting, by the processor, based on the received user input, at least two merchants from among the plurality of merchants, the at least two merchants having geographic locations within a threshold distance from the geographic location included in the received user input;
• generating, by the processor, tip data for each merchant of the at least two merchants, the tip data for a respective merchant being generated based on calculated gratuity amounts stored in the memory for matched authorization and clearance transaction messages that correspond to the respective merchant, the tip data including at least an average tip amount, an average tip percentage of a base price, and a tip trend that indicates whether the gratuity amounts for the respective merchant are trending upwards or downwards over time;
• ranking, by the processor, the at least two merchants based on a comparison of the generated tip data of the at least two merchants with respect to each other by applying, for each merchant, weighted values to each of the average tip amount, the average tip percentage, and the tip trend;
• and
• outputting, by the processor, the rank and the tip data of the at least two merchants to a user by displaying the rank and the tip data of the at least two merchants on the user computing device, wherein the rank is an improved quantifiable indicator of services provided by the at least two merchants.

One or more computer-readable storage media having computer-executable instructions embodied thereon for analyzing gratuity data of merchants and ranking merchants based on the analyzed gratuity data, wherein a computing device includes a memory device and a processor in communication with the memory device, the computing device being communicatively coupled to a payment processor, and when executed by said processor, the computer-executable instructions cause said processor to:

• receive, from an authorization database and a clearing database of the payment processor, transaction data of a plurality of merchants, the transaction data comprising authorization transaction messages and clearing transaction messages, wherein each authorization transaction includes a base amount and each clearing transaction includes a sum of a gratuity amount and a base amount;
• match each authorization transaction with a clearing transaction that corresponds to the same payment transaction based on one or more transaction identifiers included in both the authorization and clearance transaction messages;
• generate, and store in the memory device, a table of matched transaction identifiers, wherein the table includes one or more transaction identifiers of an authorization transaction message matched to one or more transaction identifiers of a corresponding clearance transaction message;
• calculate, based on the table of matched transaction identifiers, gratuity amounts for each matched authorization transaction message and clearing transaction message by calculating a difference in payment amount between the clearing transaction message and the authorization transaction message;
• store, in the memory device, the calculated gratuity amounts in association with the matched transaction identifiers;
• receive a user input from a user computing device, the user input including a geographic location;
• select, based on the received user input, at least two merchants from among the plurality of merchants, the at least two merchants having geographic locations within a threshold distance from the geographic location included in the received user input;
• generate tip data for each merchant of the at least two merchants, the tip data for a respective merchant being generated based on calculated gratuity amounts stored in the memory device for matched authorization and clearance transaction messages that correspond to the respective merchant, the tip data including at least an average tip amount, an average tip percentage of a base price, and a tip trend that indicates whether the gratuity amounts for the respective merchant are trending upwards or downwards over time;
• rank the at least two merchants based on a comparison of the generated tip data of the at least two merchants with respect to each other by applying, for each merchant, weighted values to each of the average tip amount, the average tip percentage, and the tip trend;
• and
• output the rank and the tip data of the at least two merchants to a user by displaying the rank and the tip data of the at least two merchants on the user computing device, wherein the rank is an improved quantifiable indicator of services provided by the at least two merchants.