Technician Close Rate by Job Type Report GuideLast updated on 03/22/2022
Purpose of the Technician Close Rate by Job Type Report:
This report provides an overview of technician sales performance / close rate. This report is designed for technicians who perform maintenance, service, or install jobs (not for sales technicians who are dispatched to provide estimates). Data is based on job completion dates.
Common uses for this report:
This report will show you how many jobs the technician was able to convert (this is the technician’s close rate). In ServiceTitan, a job is converted when the invoice subtotal is above the job sold threshold.
Use this report to see the average invoice subtotal for jobs the technician was able to convert.
Use this report to see how much revenue each technician is bringing in.
Required Setup for this Report:
In order to use this report, you must enter the job sold threshold for all of your job types (Settings > Job Types > Sold Threshold).
How to find this report:
Click Reports > Search Technician Close Rate by Job Type > Click the report name. Then you will be able to set filters and run the report.
Filter by date range. Use the From and To fields to set a custom date range.
View or download the report
Click Build to view the report.
The report can be downloaded in two different formats:
Export to Excel (*.xlsx) (click the dropdown arrow next to Download PDF)
Export to Comma separated (*.csv) (click the dropdown arrow next to Download PDF)
Explanation of report columns
At the top of the report, you will see that data is organized by job type. At the far right of the report, you will see totals for each technician.
This report breaks down each technician’s jobs by job type.
How to Configure - Job Types: Go to Settings > Job Types
To the far right of the report, you will see totals for each technician.
Calculation - Total:[Number of total sales] / [Number of total Opps]
The report includes the following columns:
Total number of completed jobs that were convertible. Convertible jobs are jobs where the technician is expected to make a sale. Convertible jobs do not include jobs that are marked as Recall, Warranty, or No Charge.
Calculation - # Opps: [Number of completed, convertible jobs] x [Technician splits]. Trigger: Job completed.
The technician’s close rate. The close rate is calculated by taking the total number of jobs with an invoice subtotal greater than the job sold threshold out of the total number of completed jobs that had the opportunity to be converted
Calculation - Close Rate: [# Sales] / [# Opps]. Trigger: Job completed, Job converted (invoice subtotal above the job sold threshold).
Total revenue for completed jobs, based on invoice subtotals.
Calculation - Revenue: [Sum of the invoice subtotals for completed jobs, based on job type] x [Technician splits]
Job average for completed, converted jobs, based on invoice subtotals.
Calculation - Average Ticket: ([Revenue] x [Technician splits]) / [# Opps]
Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.
Disclaimer: Information provided in this article is for informational purposes only and it should not be construed to be legal advice. Information provided in this article may also not constitute the most up-to-date legal or other information. You should not act or refrain from acting on the basis of any information in this article to meet any compliance requirements without seeking independent legal or other professional advice.