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.
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}}
Blazing-fast operations minus all the constant firefighting👨🚒Learn how to set up a control tower for your operations in under 15 minutes ️🔥
...with Locale for modern ops teams |