All Collections
Real world Alerting use cases
Logistics
Alerts on Order Accuracy to understand the health of your Logistics Operations
Alerts on Order Accuracy to understand the health of your Logistics Operations

Track and Monitor the performance of your Logistics system as a whole to identify overarching problems.

A
Written by Aditi
Updated over a week ago

Problem

Alert

Action

Impact

Order Accuracy is dropping

Trigger an alert when the ratio of #orders without any incidents/total orders drops below a threshold

Identify problematic areas, routes, drivers or trucks causing the bottlenecks and implement corrective actions

Fluctuations in Order accuracy in specific areas or specific times signal localised issues(or) bottlenecks which can be overlooked in traditional reports(monthly or quarterly), identifying and solving them can improve efficiency before they(issues) become endemic.

Step-by-step guide:

Step 1: Choose an Alert type

Choose the SQL Metric based alert to trigger an alert when the Order Accuracy drops below the critical threshold.

Step 2: Write an SQL query to fetch a value

Sample Query - to calculate the Order Accuracy rate for the last 7 Days. You can change the where conditions to calculate for different areas, time periods, drivers, hubs etc.

SELECT (1 - (failed_orders/total_orders)) AS order_accuracy
FROM
(SELECT 
SUM(DISTINCT CASE WHEN (order_status = “Closed”
AND (item_status = “Damaged” OR delivery_status=”Failed” OR rto_flag = TRUE OR ontime_delivery_status = “Delayed”))
THEN 1 ELSE 0 END) AS failed_orders
,
SUM(DISTINCT CASE WHEN (order_status = “Closed”)
THEN 1 ELSE 0 END) AS total_orders
FROM orders
WHERE order_timestamp BETWEEN DATEADD(Day,-7,GETDATE()) AND GETDATE())

Step 3: Configure Alert Condition

  • Alert Frequency: 24 Hrs

  • Column: order_accuracy

  • Operator: <

  • Value: {{critical_threshold}}

Step 4: Configure Team and Assignees

  • Team is responsible for this alert (optional) - Delivery Logistics Team

  • Person assigned to the incidents (optional) - Team Lead

Step 5: Configure Alert and Incident Details

  • Alert name: Order Accuracy Monitoring (7 Day moving average)

  • Configure Incident Tile: Order Accuracy for last 7 days is low at {{order_accuracy}}

  • Default Incident Priority: High

Step 6: Setup Notifications

  • Channel: email/slack

  • id: {{email_id or slack channel}}

  • Escalation:

    • Duration: 24 Hrs

    • Member: {{}}

    • Channel: {{}}

Blazing-fast operations minus all the constant firefighting👨‍🚒

Learn how to set up a control tower for your operations in under 15 minutes ️‍🔥

Setup Your First Alert Today!

...with Locale for modern ops teams

Did this answer your question?