Quarterly Employee Performance Reports

Automated employee performance reviews based on staff data

Written By Emma Williams

Last updated 2 months ago

Overview

Reports that compile the employee data that Drawbridge collects into helpful, digestible info for owners and managers. These reports will be sent automatically on the first day of each quarter to anyone subscribed to monthly reports for your venue (through Metabase). This report is based on employee data from the previous 4 weeks and is intended to assist in performance reviews.

It will review things like:

  • escape rate (including true escape rate vs overall escape rate)

  • hint response time

  • punctuality for shifts

  • number of rebookings and reviews

  • if training modules and timed resets are up to date

  • what percent of resets had an error or took longer than the threshold time

  • daily task completion

  • productivity scores (these are calculated by us based on completion of many of the things above per hour clocked in)

Certain locations may end up with less specific feedback depending on what we have data for in your venue, but we've worked to develop reports that are applicable even without all of the above data.

In order for them to be as accurate as possible, encourage staff to be signed in when completing tasks, game mastering, or hosting. If you don't have it set up yet, it's also easy to add Google integration to track review mentions and make sure your rebooking codes are formatted correctly to round out your other data.

If you'd like to review your venue to see if there are empty fields, this data is coming from the Staff Productivity Scorecard - Last 4 Weeks in Metabase monthly reports. More details on the application of the data below.


Values Used

An overview of the data being used and its application in these reports

Escape Rate

True escape rate: percentage of groups that escaped without the game master adding, removing, or pausing game time while the group played.

Overall escape rate: percentage of groups that escaped (game ended successfully), no matter how much time was added/removed or how long the game was paused.

We compare these two values to identify if most of this employees games needed time added to escape. These employees should work on pacing. This isn’t always a bad thing, just something to be aware of.

Punctuality

How frequently (%) an employee clocked in after their scheduled shift time.

*can only be calculated if timekeeping is fully integrated since it needs timeclock information

Number of Rebookings/Reviews

We’re using these raw numbers and also taking the number of games hosted and comparing it to the number of reviews or rebookings generated. This helps create a reference point for how many opportunities the employee had to get a review or rebooking and if they could’ve been doing more to get them.

Ensure your system is set up to collect reviews from Google and has rebooking codes formatted correctly.

Training Modules

Checking if training modules are assigned that have not been marked as complete in the training tracker. This should be a priority.

How to set up training modules

Up to Date Resets

This checks if an employee has reset a game in the last 4 weeks within the timing threshold set in Point of Sale Settings for that game. It then creates a percentage of ‘expired resets’ that employees have not completed.

If your venue doesn’t time resets, this will not be relevant.

How to time resets and why it matters

Percentage of Bad Resets

Calculated using the following formula:

% bad resets = (resets that took too long + resets with errors) / total resets completed

If this number is high, the employee frequently has slow or incorrect resets.

How to log a reset error

Daily Task Completion

Counts how many tasks have been completed by this employee and compares it to other staff members.

How to set up Daily Tasks

Productivity Score

This is a calculation that assigns points to everything an employee does while they’re signed in. Everything has a weighted point value, whether it’s hosting a game, mastering a game, completing a daily task, resetting a room, etc. These all add together into a number that is then divided by the number of hours they were clocked in to get a score.

This number is generally lower for managers, since they’re usually not checking off as many tasks as a typical employee.

*this score can only be calculated if timekeeping is fully integrated since it needs timeclock information

Average Hints Given

Averages out the number of hints given by this employee per game. Generally if this number is high and their escape rate is still low, they’re not giving effective hints.

Average Escape Time

Recommended escape times are 53-58 minutes. If players escape too quickly, they don’t feel challenged or like they got what they paid for. If employees have an average escape time under 50 minutes, they may be helping players too much.

Average Props Forced

Generally, this should be under 1.5. If employees are forcing props open, either the props are broken or players are doing puzzles incorrectly but advancing anyway. While this can help increase escape rate, it shouldn’t be done for every group on every puzzle as it can lead to players misunderstanding puzzles. It also needs to be carefully timed or players know things are being forced open for them.

Average Hint Reply

This is the average number of seconds between when players hit the hint button and when they receive a response. We generally recommend this should not be more than about 7-8 seconds and certainly not more than 10. The longer a group waits, the more they feel abandoned and the higher their stress levels get.