BIN Quality

Objective

Compare and determine chargeback and refund trends for each BIN. Although a particular BIN may have a high billing rate, this report will help to determine if their are other quality issues with particular BINs, based on chargeback and refunds. Leverage this report to determine BINs that may need alternative business rules associated to them to help decrease chargebacks and refunds.

Potential Actions

  1. Adjust business rules for specific BINs help to decrease refunds and chargebacks. For example, one may decide to only allow certain consumer ordering on specific BINs to call in to place their order, be routed to a straight sale or deny the order altogether.

  • Data presented in this dashboard is based on "Transaction Date" unless otherwise noted. Transaction Date is the date that the order was placed without an association between the Re-bill and Recurring transactions (Cycles 1…X) and the Initial transaction (Cycle 0) that initiated the order.
  • All test orders marked within the platform are automatically removed from the Analytics data.

Chart / Table

Description

Formula

Top 5 BINs by MCB

Use this bar chart to identify problematic BINs based on chargeback count. After reviewing this chart, you could decide to handle specific BINs in a more conservative manner (i.e. route the orders being placed through specific BINs to receive additional scrutiny).

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.

Count(Chargeback by BIN)

Top 5 BINs by Refund Rate

This chart is similar to the previous chart, however, it is based on refund rate. The same type of conclusions can be drawn from each negative activity, whether it’s a chargeback or a refund.

(Refunded Revenue ÷ Total Approved Revenue)

BIN Quality Detail

The BIN Quality table provides Orders, Gross Revenue and Reserve metrics 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: Transaction Date - The date that the order was placed without an association between the Re-bill and Recurring transactions (Cycles 1…X) and the Initial transaction (Cycle 0) that initiated the order.

 

Orders

The amount of approved transactions by BIN.

Count(Approved orders by BIN)

Gross Revenue

Shows you the amount of revenue processed on the respective BIN

Sum(Order Total Revenue)

Reserves

Gateway estimated reserves based off value set in the CRM configuration. Reserves is a set amount of the advertiser’s money that is put aside by the acquiring bank as a security deposit. This safeguards the financial institution from unplanned liability.

 

(Gross Revenue × Reserve %)

Refer to Overview of Gateway Providers to determine how you set the Reserve %.

Chargebacks (MCBs) by BIN

The Chargebacks by BIN table provides MCB Count, MCB Percentage and MCB Revenue Percentage metrics 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: Transaction Date - See description above.

 

MCB #

This metric will show you the manufacture chargeback count on the respective BIN. This can be used to analyze and sort your BINs by the chargeback count in the selected date range.

Count(Chargeback by BIN)

 MCB %

This metric will show you the percentage of orders on the respective BIN that have been marked as chargeback

(Chargeback Count ÷ Approved Orders)

MCB Rev %

This metric will show you the percentage of revenue lost due to chargeback, by BIN. This will help show you how chargebacks are affecting your bottom line

(Chargeback Revenue ÷ Total Revenue)

Refunded by BIN

The Refunded by BIN table provides Refund Count, Refunded Amount, Refunded Revenue Percentage, Refunded without MCB, and MCB Lost Revenue metrics 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: Transaction Date - See description above.

 

Refund #

Refund count.

Count(Refunds by BIN)

Refunded

Gross Revenue lost as a result of refunds.

Sum(Total Revenue of Orders Refunded)

Refunded Rev %

Percentage of Gross Revenue lost due to refunds.

(Amount Refunded ÷ Gross Revenue)

Refunded w/o MCB

Gross Revenue lost with the refunds from chargebacks not included.

Sum(Refunds from sources other than MCBs)

MCB Lost Rev

MCB Lost Revenue is Gross Revenue lost within the designated time period as a result of chargebacks only.

Note: The benefits of representment is not reflected in the MCB Lost Revenue calculation.

Sum(Total Revenue of Orders Chargedback)

Have more questions? Submit a request

0 Comments

Article is closed for comments.