Alerts on Driver performance in Hyperlocal or Logistics Deliveries

‍

Step-by-step guide:

Step 1: Choose an Alert type

Choose the Alert on a row getting added to a list to trigger an alert whenever a

driver falls short of your performance metrics.

‍

Step 2: Write an SQL query to fetch a value

Sample Query - to fetch a list of drivers whose delivery trips are delayed or whose delivery items are damaged.

SELECT * FROM
(
SELECT
driver _id, COUNT (*) AS total_trips,
SUM(CASE WHEN ontime_status = “Delayed” THEN 1 ELSE 0 END) AS delayed_trips,
SUM(CASE WHEN damaged_flag = TRUE THEN 1 ELSE 0 END) AS damaged_trips,
SUM(CASE WHEN delivery_status = “Failed” THEN 1 ELSE 0 END) AS failed_trips
FROM driver_trip_details
WHERE updated_at BETWEEN DATEADD(Day,-1, GETDATE()) AND GETDATE()
GROUP BY driver_id
)
WHERE (delayed_trips+damaged_trips+failed_trips)/total_trips > 0.10
        

‍

Step 3: Configure Alert Condition

• Alert Frequency: 24 Hrs
• Unique value column: driver_id

‍

Step 4: Configure Team and Assignees

• Team that is responsible for this alert (optional) - Fleet Management Team
• Person assigned to the incidents (optional) - Driver Ops Lead

‍

Step 5: Configure Alert and Incident Details

• Alert name: Driver Performance Alert
• Configure Incident Tile: Driver # #{{driver_id}} performance has dropped in the Last 24 Hrs.
• Default Incident Priority: Medium

‍

Step 6: Setup Notifications

• Channel: Email
• id: #{{}}
• Escalation:
  • Duration: 24 Hrs
  • Member: Fleet Manager
  • Channel: email - fleet_manager@hq.com