Overview
Use the Customers template to create detailed reports on customer information. It includes default columns such as customer name, address, phone number, and email, with options to customize by adding details like tags, job counts, revenue, financials, and membership information.
Who uses this feature
Administrators, managers, and office employees
Applies to all business types
Feature configuration
The ability to create custom reports is dependent on your ServiceTitan Package. For custom reports access, please contact your Customer Success Manager.
Things to know
Report results include all customers, even if there is no account activity within the date filters.
Each line in the report represents a single customer.
Click an underlined cell and then click Expand
to drill down for additional details. Click a job, invoice, or estimate number to open the corresponding record in a new tab.
Report examples
Create a customer contact list that includes customer names, full addresses, phone numbers, and email addresses.
Compare the total revenue between customers with memberships and customers without.
Run reports for customers with no recent job activity to build audiences for marketing campaigns.
Create a report detailing customer records, including any associated tags.
Review customer financials with a report showing customer payment and financing details.
Create a Customers report
Follow the steps to create a custom report based on the Customers template and select the columns to include in your report.
The Customers template has these columns selected by default:
Customer Name: Name of the customer
Full Address: Address of the customer
Phone Number: Phone number of the customer
Email: Email address of the customer
You can customize the report by selecting additional columns from these sections:
Customer Details: Details about the customer record including tags
Addresses and Contacts: Customer contact details
Jobs Counts and Rates: Customer job details
Sales and Revenue KPIs: Customer-related revenue details
Financials: Payment and financing details
Memberships: Customer-related membership details
Run a report
Before you run your report, set filters to focus your results. Filters are applied differently for each column. For a brief description of how filters are applied, hover over a column header.
To run a report:
Click the From - To field to set date filters. You can:
Use the calendar to select a specific date range and then click Apply.
Use the left menu to select a preset date range:
Today: From 12:00 AM to the current time.
Yesterday: Previous day, from 12:00 AM to 11:59 PM.
This Week: From Monday through Sunday of the current week.
Week to Date: From Monday through the current date of the current week.
Last 7 Days: Previous seven days, including today.
Last 14 Days: Previous 14 days, including today.
Last 30 Days: Previous 30 days, including today.
Month to Date: From the first of the current month to the current day.
Last Month: Entire month before the current month. For example, if the date is February 5, the entire month of January.
Last 90 Days: Previous 90 days, including today.
This Quarter: Current quarter, including future dates. For example, if the date is April 25, from April 1 - June 30.
Last Quarter: Entire quarter before the current quarter. For example, if the date is April 25, from January 1 - March 31.
Quarter to Date: From the first day of the current quarter to the current day.
Year to Date: From January 1 of the current year to the current day.
Last 365 Days: Previous 365 days, including today.
Last Year: From January 1 of the previous year to December 31.
From the Business Unit dropdown, select the business units (BUs) you want to report on. By default, the report runs for all BUs. You can filter your report by business units or business unit categories:
Click the dropdown to select individual BUs.
To report on BU categories such as trade or division, click Filter
, select the BU categories you want to include, and click Filter.
Note: How BU filters are applied depends on the key performance indicator (KPI). Hover over a column header for details.
Select Show Inactive Customers to include customers whose status is Inactive.
When you’re done setting your filters, click Run Report.
Tip: Click Edit Columns to add and remove columns. You can arrange report columns and apply filters for further customization.
Want to learn more?