Billing Attempt Summary
This report lists billing attempt status for Subscriptions during the selected time period, aggregated by Product, Affiliate, and Currency. It lists total billing attempts, and summarizes successful and failed attempts with the total amount billed. It specifies first, second, and subsequent billing attempts.
This report can be used to determine whether retry attempts for soft failures, and using card updater, result in increased payment capture, and are therefore cost effective when compared with the fees associated with retries.
To determine success rate without retries (Subscribe payment capture):
Divide (First Attempt Billing: Successful Attempts) by (First Attempt: Sub Total First Billing).
To determine Subscribe uplift:
Divide (Total successful billings - Total successful first attempts) by (Total first attempts).
To generate a one time report:
- Enter the relevant date range.
- Optional. Enter an Email address where you'd like to receive notifications when the report is available. A single email address can be entered.
- Click Submit. View the report in the My Reports page.
To generate a recurring report:
- Toggle Recurring toggle to Yes.
- Select a date for the first reporting period. Note: Reports display data occurring starting from the defined date. For example, a monthly report starting on March 1st displays data for the month of March up to March 31st.
- Select the report's Frequency. Choose between Weekly, Monthly or Quarterly.
- Optional. Enter an Email address where you'd like to receive notifications when the report is available. A single email address can be entered.
- Optional. If you want to receive the report uploaded to an SFTP Server, enable this option and provide the required details.
- Click Submit. View the report in the My Reports page.
Display Columns
Field | Description |
---|---|
Product ID | Product ID from the customer's Subscription. |
Product Name | Product Description from the customer's Subscription. |
Affiliate ID | The Affiliate listed on the customer's Subscription. |
Currency | Currency of Transaction. |
Total Billings | Every billing attempt made. |
Total Successful Billings | Attempts that resulted in successful payments. |
Total Failed Billings | Attempts that resulted in Hard Fail or Soft Fail reason codes. |
Total Billings Attempts | All attempts made during period specified (initial and retries; success and failures). |
First Attempt Billings | Initial attempts (success and failures). |
Second Attempt Billings | Second attempt (retries for failures from initial attempt). |
Subsequent Attempt Billings | All other attempts (retries for failures from second attempt and any additional - if merchant has specified additional retries). |
Number | Count of attempts. |
Amount | Total billed for attempts. |
Subtotal | The Total for the listed Product’s results. |
Total | The Total for all listed Product’s results. |