Benchmarking - Primary Trade Dashboard
- Caroline Antoun
- Chellie Esters
The Benchmarking - Primary Trade Dashboard compares you to your peers at the primary trade level. There are 16 common repair and maintenance trades to choose from and you can compare four at a time. If you do not choose any specific trades in your filter choices, the top four trades based on annual spend will be displayed. If there are less than 5 peers in your filtered data set, you will see the message too few peers.
The visualizations in this report are:
- Spend: based on invoice date
- Workorder Volume: based on work order call date
- Efficiency: based on work order call date
This data is updated on the 2nd Sunday of each month. You can download the data for each visualization and email reports to recipients.
Data Visualization
Spend
Metrics used in this section are based off the invoice date from the last rolling 12 months.
Note
Should you have less than 12 months of data, this visualization will not be an "apples-to-apples" comparison when viewed against peers.
Average Annual Spend per Trade
Shows how your average annual spend per location in top 4 primary trades compares to your peer group. Easily see where your spend is higher than the upper quartile and determine if adjustments need to be made for spend in certain trades.
Note
The average annual spend determines the order in which the trades will be displayed in the subsequent looks regardless if the data is higher or lower in rank.
Average Invoice Amount
Shows how your average invoice amount in the top 4 primary trades compares to your peer group. Determine if you are regularly being charged too much in a certain trade.
Maintenance Spend Percentage
Shows how your maintenance spend percentage in the top 4 primary trades compares to your peer group. Are you spending more than others on preventative maintenance? And does it match with predicted spend for these trades?
Repair Spend Percentage
Shows how your repair spend percentage in the top 4 primary trades compares to your peer group.
Note
Maintenance and Repair spend do not include CAPEX amounts.
Workorder Volume
Metrics used in this section are based off the call date from the last rolling 12 months.
Annual Work Orders per Location
Shows how your annual work orders per location in the top 4 primary trades compares to your peer group and is based on the invoice posted date from the last rolling 12 months. Easily check the ratio between the amount of work orders vs the spend amount in a specific trade. Do you have a lot of spend, but not a lot of work orders in that trade? Here is a chance to tackle that with real data!
Percent of Work Orders with Accepted Proposals
Shows how your percent of work orders with accepted proposals in the top 4 primary trades compares to your peer group. If you have a high percentage, it might mean you don't have your NTE set at the right amount. If it's too low, you could be regularly overcharged due to too high of an NTE amount.
Note
The accepted proposal percentage is calculated by dividing the number of repair work orders with proposals by the total number of repair work orders.
Efficiency
Time metrics used in this section are based off the call date from the last rolling 12 months.
Median Work Order Resolution Time
Shows how your median resolution time in days in the top 4 primary trades compares to your peer group. Ascertain how quickly your providers are completing work orders at the trade level in comparison to other people's providers. This is one more way you can measure the efficiency of your providers!
Note
Work order resolution time is calculated as the median minutes difference between the call date and completion date.
Median Time Waiting for Parts
Shows how your median time waiting for parts in the top 4 primary trades compares to your peer group. Work orders that actually move into the waiting for parts status are shown here. This is a way you can determine if the supplier your provider is using is as efficient as they can be now that you can compare them across the industry. If they aren't, here is a solid talking point for you and your provider.
Note
Median waiting for parts time is calculated by the SUM of minutes difference from any PARTS related status to the next status.
Median Time for Proposal Submission
Shows how your median proposal submission time (in days) in the top 4 primary trades compares to your peer group. See how responsive your providers are in getting proposals in and ultimately completing work orders faster.
Note
Median proposal submission time is calculated by the difference between WAITING FOR QUOTE and WAITING FOR APPROVAL status.
Median Time to Approve Proposals
Shows how your median proposal approval time (in days) in the top 4 primary trades compares to your peer group. Here you can measure how fast your facility management team is approving proposals. If it isn't as fast as your peers, you have an opportunity here to address this speed bump in the Work Order Lifecycle with your team.
Note
Median proposal approval time is calculated by the difference between WAITING FOR APPROVAL and PROPOSAL APPROVED status.
Below is a quick reference guide regarding tracking numbers in Analytics, filtering, sorting, downloading data, and sending reports. Throughout Analytics you can drill down into visualizations to see the underlying data. In most cases, the tracking numbers related to that data are listed. You can click the tracking number to navigate straight to the work order details in Service Automation. On top of the report are all-inclusive filters to help you hone in on key data. All reports on the page are affected by the criteria set in these all-inclusive filters. The filter criteria for each dashboard may differ. Filters reset to the default when the page is refreshed. Click filter field to show the criteria. Select the desired criteria to include or exclude: To Include criteria: select is equal to, contains, starts with, or ends with, and then begin typing the criteria in the picklist. Select the desired criteria (or multiple criteria) from the picklist. To exclude criteria: select is not equal to, does not contain, does not start with, or does not end with. Is null depicts the absence of data in a data set. Conversely, is not null depicts the presence of data To include or exclude data without a certain data criteria — for example, to select data without a Region or District assigned in Service Automation — choose is blank / is not blank. To add more options, click the plus sign (+) next to a field to add another option to the filter. The new option will appear as either an OR condition or an AND condition, depending on the type of filter option. Once all criteria are selected, click Refresh icon in the top-right corner. The Dashboard report updates with the selected criteria. More details are available on Filtering an Analytics Dashboard Analytics tables are dynamic, as you can: In the upper-right corner of any page, click the Vertical Ellipses to download reports, schedule delivery of reports at regular intervals, add to a board, or get a link. You can download data from a table and visualization or download a dashboard tabto PDF or CSV. Select the desired File Format and choose a File Name: A default name is listed but you can change it. On the desired dashboard (or dashboard tab), click the Gear icon in the upper-right of the page, and then click Download as PDF. The Download modal appears. A default Filename appears, but you can change it. Under Advanced options: Single-column format lays out all tables and visualizations on a page into one column in the PDF, as opposed to how it is laid out in the dashboard. Expand tables shows all rows in a table, instead of just the rows that appear on the dashboard. Paper size adjusts the PDF to your desired size. Click Open in Browser to view the PDF in your chosen browser, or click Download to save a version of the report onto your device. On the desired dashboard (or dashboard tab), click the Gear icon in the upper-right of the page, and then click Download as CSVs... A new browser tab opens. After the files render, you are prompted to save the CSV Zip file onto your device. More details are available on Downloading and Sending Dashboards and Reports You can also Send a one-time report via email or Schedule a recurring email send. On the desired dashboard (or dashboard tab), click the Gear icon in the upper-right of the page, and then click Send. The Send (Dashboard Name) modal opens. A Title is given by default, but you can change it. Under Who should it be emailed to?, enter the desired recipient(s), separated by a comma, and then click Add. (Optional) Click Include a custom message to add a personal note. Under Format data as, choose PDF, Visualization, or CSV Zip file. (Optional): Click Filters to limit the criteria that appear in the email. Note that the same filters on the dashboard itself will also appear here. Click Send. The email is sent to your recipients. On the desired dashboard (or dashboard tab), click the Gear icon in the upper-right of the page, and then click Schedule. The Schedule (Dashboard Name) modal opens. A Title is given by default, but you can change it. Under Who should it be emailed to?, enter the desired recipient(s), separated by a comma, and then click Add. (Optional) Click Include a custom message to add a personal note. Under Format data as, choose PDF, Visualization, or CSV Zip file. Under Deliver this schedule, choose Daily, Weekly, Monthly, Hourly, or By minute (in 5-minute increments, up to 30 minutes) (Optional): Use Filters to limit the criteria that appear in the email. Note that the same filters on the dashboard itself will also appear here. Click Send. The email is sent to your recipients. More details are available on Downloading and Sending Dashboards and ReportsCommonly Used Features
Tracking Numbers in Analytics
Filtering Dashboards
Dynamic Table Sorting
Downloading and Sending Reports
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page:
-
Page: