BIN Analysis

Objective

Compare and determine trends for each BINs ability to successfully process transactions. Leverage this report to determine BINs that may need alternative business rules associated to them to help increase billing rate.

Potential Actions

  1. Adjust business rules for specific BINs to increase billing ratio. For example, one may decide to only allow certain consumer ordering on specific BINs to call in to order, be routed to a straight sale or deny the order altogether.

  • Data presented in this dashboard is based on "Acquisition Date" unless otherwise noted. Acquisition Date is the date that the original order was placed and allows Analytics to present data in an appropriately connected way.  Specifically, Acquisition Date associates Re-bill and Recurring transactions (Cycles 1…X) to the Initial transaction that initiated the order.  When calculating many metrics, disassociating the recurring transaction types from the date of origination (the Initial transaction) causes arithmetic inconsistencies and brings incorrect and misleading results - and ultimately incorrect business decisions.

    As example: metrics that incorporate time-phasing and transaction type correlation into the calculation: think Re-Bill rate or Chargeback Rate; they both associate a transactional event to other components of the overall order within a timeframe.

    That being said, there are instances where you may want to simply see the count, or value, or count by transaction type, of transactions within a period.  When this type of analysis is performed it will be noted as such.

  • All test orders marked within the platform are automatically removed from the Analytics data.
  • Please reference the Lime Light Order Cycle Nomenclature visual below to understand the way that Lime Light references the phases of a each order type. 

 


 Video Length: 6:56

 

Chart / Table

Description

Formula

BIN Analysis Detail - Totals

Breaks down the total attempts, approved and rate (approved rate) by BIN with the added BIN detail such as bank (i.e. Chase, Wells Fargo, etc), brand (i.e. Visa, Mastercard, etc), type (i.e. debit, prepaid, etc), level (i.e. platinum, standard, etc) and country (i.e. US, UK, etc).

Data Based OnAcquisition Date - Data is organized by the date that the original order was placed. This allows Analytics to present data in an appropriately connected way. Specifically, Acquisition Date associates Re-bill and Recurring transactions (Cycles 1…X) to the Initial transaction that initiated the order.

 

Attempts Total transaction attempts by BIN. Sum(Transaction Attempts by BIN)
Approved Total approved transactions by BIN. Sum(Approved Transactions by BIN)

Rate

Percentage of total approved transactions on the respective BIN. The approval rate can be used to analyze and compare to other BIN approval rates. Transaction Attempts by BIN ÷ Approved  Transactions by BIN

BIN Analysis Detail - <cycle>

Breaks down easy Cycle attempts, approved and rate (approved rate) by BIN with the added BIN detail such as bank (i.e. Chase, Wells Fargo, etc), brand (i.e. Visa, Mastercard, etc), type (i.e. debit, prepaid, etc), level (i.e. platinum, standard, etc) and country (i.e. US, UK, etc).

Data Based On: Acquisition Date - See description above.

 

Attempts

Transaction attempts by BIN, by Cycle. Sum(Transaction Attempts by BIN - by Cycle)

Approved

Approved transactions by Cycle. Sum(Approved Transactions by BIN, by Cycle)

Rate

Percentage of approved transactions by billing cycle on the respective BIN. The approval rate can be used to analyze and compare to other BIN approval rates. Transaction Attempts by BIN, by Cycle ÷ Approved  Transactions by BIN, by Cycle
BIN Analysis Detail - Totals (By Bank)

Breaks down the total attempts, approved and rate (approved rate) by Bank. 

Data Based On: Acquisition Date - See description above.

 
Attempts Total transaction attempts by Bank. Sum(Transaction Attempts by Bank)
Approved Total approved transactions by Bank. Sum(Approved Transactions by Bank)

Rate

Percentage of total approved transactions on the respective BIN. The approval rate can be used to analyze and compare to other BIN approval rates.

Transaction Attempts by Bank ÷ Approved  Transactions by Bank

BIN Analysis Detail - <cycle> (By Bank)

Breaks down the total attempts, approved and rate (approved rate) by bank (i.e. Wells Fargo, JPMorgan Chase, etc).

Data Based On: Acquisition Date - See description above.

 

Attempts Transaction attempts by Bank, by Cycle. Sum(Approved Transactions by Bank, by Cycle)
Approved Approved transactions by Bank, by Cycle. Transaction Attempts by Bank, by Cycle ÷ Approved Transactions by Bank, by Cycle

Rate

Percentage of approved transactions by billing cycle on the respective BIN. The approval rate can be used to analyze and compare to other BIN approval rates.

Transaction Attempts by Bank, by Cycle ÷ Approved Transactions by Bank, by Cycle

BIN Analysis Detail - Totals (By Brand)

Breaks down the total attempts, approved and rate (approved rate) by credit card Brand (i.e. Visa, MasterCard, etc).

Data Based On: Acquisition Date - See description above.

 

Attempts Total transaction attempts by Brand. Sum(Transaction Attempts by Brand)
Approved Total approved transactions by Brand. Sum(Approved Transactions by Brand)

Rate

Percentage of total approved transactions on the respective Bank. The approval rate can be used to analyze and compare to other Brand approval rates.

Transaction Attempts by Brand ÷ Approved Transactions by Brand

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.