Alerts on Bank wise Transaction Failures

Get alerted when an issuing bank or payment channel is underperforming

Value Delivery

Problem	Alert	Action	Impact
Delayed or Failed Transaction attempts	Send a notification when an issuing bank or channel is underperforming.	The Manager can follow up with problematic banks and/or display downtime messages to communicate it to users and display only the unaffected payment methods.	User messages improve user experience and also decrease failed and abandoned transactions. Real-time alerts give you enough time to follow up and resolve issues.

‍

Step-by-step guide:

Step 1: Choose an Alert type

Choose the SQL List based alert to trigger an alert and share Bank (or) payment channel details to required personnel.

‍

Step 2: Write an SQL query to fetch a value

Sample Query - to fetch a list of issuing banks facing high failure rates.

Code Display Example


SELECT bank_name, (t2.failed_trxns*100/t1.total_trxns) AS failure_rate
WHERE failure_rate > #{{threshold}}
FROM
(SELECT bank_name, COUNT(trxn_ids) AS total_trxns
WHERE timestamp BETWEEN DATEADD(minute,-10,GETDATE()) AND GETDATE()
GROUP BY bank_name) AS t1
LEFT JOIN
(SELECT bank_name, COUNT(trxn_ids) AS failed_trxns
WHERE trxn_status = “Failed” AND
timestamp BETWEEN DATEADD(minute,-10,GETDATE()) AND GETDATE()
GROUP BY bank_name) AS t2
ON t1.bank_name = t2.bank_name

‍

Step 3: Configure Alert Condition

Alert Frequency: 10 mins
Unique value column: bank_name

‍

Step 4: Configure Team and Assignees

Team is responsible for this alert (optional) - Banking Ops Team
Person assigned to the incidents (optional) - Ops Lead

‍

Step 5: Configure Alert and Incident Details

Alert name: High Transaction Failures - Banking
Configure Incident Tile: #{{bank_name}} bank is facing high failure rates.
Default Incident Priority: High

‍

Step 6: Setup Notifications

Channel: email
id: #{{}}
Escalation:
- Duration: 2 Hr
- Member: Operations Head - Banking
- Channel: email - #{{banking_ops_head _ email}}