1. Average Tickets Resolved

Description
The Average Tickets Resolved KPI measures the number of support tickets an employee resolves per day. This helps assess an employee’s efficiency in handling customer issues and maintaining workflow productivity.


Formula
Average Tickets Resolved = Total Tickets Resolved / Number of Working Days


Example Calculation
Assume an employee resolves tickets over a week:

DateTickets Resolved
2024-09-166
2024-09-175
2024-09-187
2024-09-198
2024-09-204
Total30


If the employee worked for 5 days:

Average Tickets Resolved = 30 / 5 = 6 tickets per day

This means the employee, on average, resolves 6 tickets per day.




2. First Call Resolution (Average)

Description
The Average First Call Resolution (FCR) KPI measures the percentage of tickets resolved by an employee during the first interaction with the client. This metric indicates efficiency and customer satisfaction, as resolving issues on the first attempt minimizes follow-ups.

Formula
First Call Resolution Rate = (Count of Tickets Resolved on First Call / Total Tickets Resolved) × 100

Example Calculation
Assume an employee resolves a number of tickets over a week, and some are resolved on the first call:

DateTickets ResolvedResolved on First Call
2024-09-1664
2024-09-1753
2024-09-1875
2024-09-1986
2024-09-2042
Total3020


FCR Rate = (20 / 30) × 100 = 66.7%

This means the employee resolves 66.7% of tickets on the first call, reducing follow-ups and improving customer satisfaction.




3. Late Time Entry

Description
The Late Time Entry KPI tracks the number of instances where an employee logs work hours later than the allowed time threshold. Ensuring timely time entries is crucial for accurate billing and reporting.

Formula
Late Time Entry = Count of Time Entries where (Date Entered - End Time) > Configured Limit

Example Calculation
Assume a company has a 15-minute threshold for logging time. An employee logs their work hours for different tickets as follows:

DateTickets WorkedTime Entry Late (>15 mins)
2024-09-1662
2024-09-1751
2024-09-1873
2024-09-1982
2024-09-2041
Total309


This means the employee has 9 late time entries for the week.




4. Productive Time

Description
The Productive Time KPI measures the percentage of an employee's working hours spent on billable tasks. This helps evaluate how effectively employees utilize their available work hours.

Formula
Productive Time (%) = (Billable Hours Worked / Daily Capacity) × 100

Example Calculation

EmployeeBillable Hours WorkedDaily Capacity (Hours)Productive Time (%)
John78(7/8) × 100 = 87.5%
Sarah68(6/8) × 100 = 75%
David88(8/8) × 100 = 100%


This means John spent 87.5% of his time on billable tasks, Sarah spent 75%, and David fully utilized his workday (100%).




5. Ticket Same Day Close Rate

Description
This KPI measures the percentage of tickets that are opened and closed on the same day, indicating efficiency in ticket resolution.

Formula
Ticket Same Day Close Rate = (Tickets Closed Same Day / Tickets Opened) × 100

Example Calculation

EmployeeTickets OpenedTickets Closed Same DaySame Day Close Rate (%)
John10080(80/100) × 100 = 80%
Sarah12090(90/120) × 100 = 75%
David110100(100/110) × 100 = 90.91%


This means John closed 80% of his tickets on the same day, Sarah 75%, and David had the highest efficiency with 90.91%.




6. Ticket Touches

Description
The Ticket Touches KPI measures the number of interactions (such as updates, notes, or additional responses) an employee makes on support tickets, helping to gauge involvement in ticket management.

Formula
Ticket Touches = Number of Time Entries or Notes on Tickets

Example Calculation

EmployeeTicket Touches
John15
Sarah12
David20


This means John touched 15 tickets, Sarah touched 12, and David had the highest interaction with 20 ticket touches.




7. Unscheduled Leave

Description
The Unscheduled Leave KPI tracks instances where an employee takes unplanned leave, which can impact team productivity and service delivery.

EmployeeUnscheduled Leave InstancesLeave Work Type
John2Sick Leave
Sarah1Personal Leave
David3Unpaid Leave


This means John took 2 unscheduled leaves, Sarah took 1, and David took the most at 3 instances.




8. Utilization Rate

Description
The Utilization Rate KPI measures the percentage of actual working hours that are effectively used for productive tasks, whether billable or non-billable.

Formula
Utilization Rate = (Total Utilized Hours) / (Total Actual Hours) × 100

Example Calculation

DateUtilized HoursActual Hours
2024-09-166.817.999
2024-09-175.568.06
Total26.7741.25


Utilization Rate = (26.77 / 41.25) × 100 = 64.8%

This means 64.8% of available working hours were used for productive tasks.




9. Billable Utilization Rate

Description
The Billable Utilization Rate KPI measures and tracks the percentage of actual working hours spent on billable tasks that generate revenue.

Formula
Billable Utilization Rate = (Billable Hours KPI) / (Actual Hours) × 100


Example Calculation

DateBillable Hours KPIActual Hours
2024-09-165.57.999
2024-09-174.88.06
Total22.541.25


Billable Utilization Rate = (22.5 / 41.25) × 100 = 54.5%

This means 54.5% of working hours were spent on revenue-generating tasks.