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

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
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: