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.
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 - [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 |