Gateway Analysis

Objective

Compare Rebill Rate amongst all gateways by analyzing the number of attempts, successful attempts and ultimately the success rate. Leverage this report to determine if/when specific gateways need to be optimized at a deeper level based on rebill rate.

The Gateway dashboard provides detailed analysis for each gateway, including billing rate, chargeback and refund metrics. In addition to these metrics, the Gateway Analysis also provides reserve amounts for each gateway.

Potential Actions

  1. Adjust load balance or re-route volume to or away from a gateway to generate additional revenue by earning a higher rebill rate.

  • 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:45

 

 

Chart / Table

Description

Formula

Avg Initial Approval Rate

The average approval rate on Initial Orders. This is a metric that is helpful to judge the success of actually billing the initial attempts.

 (Cycle 0 Approvals ÷ Cycle 0 Gross Transactions)

Avg Rebill Rate

The average percent transaction success for Cycle 1/Rebill.

 (Cycle 1 Approvals ÷ Cycle 1 Gross Transactions)

Avg Cycle 2 Rate

The average percent transaction success for Cycle 2.

 (Cycle 2 Approvals ÷ Cycle 2 Gross Transactions)

Avg Cycle 3+ Rate

The average percent success for Cycle 3 transactions. 

 (Cycle 3+ Approvals ÷ Cycle 3+ Gross Transactions)

Approval Rate by Cycle

The chart displays the approval rate trend. The approval rate is the rate at which transactions actually turn into orders (or “successful transactions”).

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 by Cycle ÷ Transaction Attempts by Cycle

Gateway Analysis - Initial

The Gateway Analysis table provides the detail necessary to understand billing success rate by cycle. It specifically provides unique attempted transactions, approved transactions/orders and ultimately the rate of approval/success by subscription cycle. The data defaults as sorted by attempts (high to low) however by clicking on the column headers, you can sort any column.

Data Based On: Acquisition 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

Number of unique transaction attempts on the respective gateway, by billing cycle.

Attempted transactions by Cycle

Approved

Approved transactions by billing cycle

Approved transactions by Cycle

Rate

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

(Approved Orders ÷ Unique Transactions)

Gateway Analysis - Rebill

This table provides the detail necessary to understand billing success rate by Rebill (Cycle 1). It specifically provides unique attempted transactions, approved transactions/orders and ultimately the rate of approval/success. The data defaults as sorted by attempts (high to low) however by clicking on the column headers, you can sort any column.

Data Based On: Acquisition Date - See description above.

 

Attempts

See description above. See formula above.

Approved

See description above. See formula above.

Rate

See description above. See formula above.

Gateway Analysis - Cycle 2

This table provides the detail necessary to understand billing success rate by Cycle 2. It specifically provides unique attempted transactions, approved transactions/orders and ultimately the rate of approval/success. The data defaults as sorted by attempts (high to low) however by clicking on the column headers, you can sort any column.

Data Based On: Acquisition Date - See description above.

 

Gateway Analysis - Cycle 3+

This table provides the detail necessary to understand billing success rate by Cycle 3+. All data Cycle 3 and greater will fall into this summary table. It specifically provides unique attempted transactions, approved transactions/orders and ultimately the rate of approval/success. The data defaults as sorted by attempts (high to low) however by clicking on the column headers, you can sort any column.

Data Based On: Acquisition Date - See description above.

 

 

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.