Alert your Operations team when orders are getting delayed and help them follow up on these orders.
Value Delivery:
Problem | Alert | Action | Impact |
Tracking SLA breaches and Delays across hubs (or) cities. | Send an alert to Operations Team when orders in the pipeline are getting delayed. | Central Ops team will follow up with regional teams across Hubs to take measures and expedite delayed orders through the system. | Proactive tracking of orders at all stages will help you rectify delays before they breach Customer SLAs. |
Step-by-step guide:
Step 1: Choose an Alert Type
Choose the SQL List based alert to trigger an alert when orders are getting delayed across hubs (or) stages of supply chain.
Step 2: Write an SQL query to fetch a value
Sample Query - to fetch all the delayed orders in your system.
SELECT current_hub, COUNT(DISTINCT order_id) AS delayed_orders
FROM orders
WHERE ontime_status = “Delayed”
GROUP BY current_hub
Step 3: Configure Alert Condition
Alert Frequency: 1 Hr
Unique value column: current_hub
This query will run every Hour and fetches any new delayed orders across the hubs.
Step 4: Configure Team and Assignees
Team is responsible for this alert (optional) - Central Operations Team
Person assigned to the incidents (optional) - Operations Lead
Step 5: Configure Alert and Incident Details
Alert name: SLA Breaches & Delayed Orders
Configure Incident Tile: {{delayed_orders}} orders are delayed at {{current_hub}} hub.
Default Incident Priority: Medium
Step 6: Setup Notifications
Channel: email
Escalation: This issue will be escalated to the Operations Head if it is not resolved within 4 hrs of Incident creation.
Duration: 4 Hr
Member: Operations Head
Email: [email protected]
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 |