Alerts on Driver performance in Hyperlocal or Logistics Deliveries

Problem	Alert	Action	Impact
Driver Performance Monitoring	Alert the fleet management team when a driver’s performance drops below standards.	The fleet managers can follow up with the driver and rectify any issues or incentivize drivers to improve their performance accordingly.	Manage the fleet effectively and improve driver performance and weed out bad actors.

‍

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.

Code Display Example


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