Do I need a data warehouse to do custom reporting on ServiceTitan?
Not for every question. You need one when a question spans systems, requires history the source system overwrites, or has to be answered the same way ever…
Straight answers about connecting AI to the systems a business actually runs on — from the people who build these integrations. New answers publish every day.
Reporting, integration and revenue questions specific to ServiceTitan.
Not for every question. You need one when a question spans systems, requires history the source system overwrites, or has to be answered the same way ever…
Duplicate customers, jobs stuck in non-final statuses, completed work that sits uninvoiced, job types used as informal tags, business units that encode tw…
Later than most people assume, and the lag is mostly human rather than technical. Sync interval adds minutes. Technician paperwork and invoicing add hours…
A customer is the billing relationship. A location is a service address under that customer. Equipment records live at a location. One customer can hold m…
Spreadsheet exports are right for one-off questions and wrong for anything recurring, because they capture a moment and cannot be re-run identically. API …
Keep them as signed rows in the same dataset and let them net out, rather than filtering them away or storing them separately. Filtering negatives out inf…
You connect them through a shared identifier — usually the phone call or web lead — then follow that identifier into ServiceTitan's booking, job and invoi…
Because it is usually set once, by a person, under time pressure, and then inherited forever. A customer created under one campaign keeps that campaign on…
Because the campaign or source field usually reflects the most recent booking path, not the original one, and repeat customers book through channels that …
Define a callback as a return visit to the same location and equipment within a set window, related to prior work. Do not rely only on someone remembering…
Match on normalized phone number first, then narrow with a time window around the call, then confirm against the customer or location record. Expect a mea…
One tenant with business units gives you unified reporting, shared customer history and a single integration surface, at the cost of tighter coupling betw…
Both, because they answer different questions. A business unit says who owns the result — which crew, trade, division or location carries the profit and l…
Business unit for anything financial, because it is the dimension that maps to how the company is managed and it is enforced on every job. Job type for op…
ServiceTitan exposes a REST API, but access is not on by default. You request it, register an integration application, scope it to the endpoints you need,…
Bookings divided by bookable calls, not by all calls. Wrong numbers, vendors, employees, spam, and customers checking on an existing appointment are not o…
Built-in reporting is strong inside a single data category and weak across boundaries. It cannot pull in outside data such as ad spend, call transcripts o…
A booking is a request to be scheduled and may never become anything. A job is scheduled work with appointments, a business unit and a technician. An invo…
A booking is a request to be scheduled; a job is work that got created and dispatched. Bookings disappear when they are duplicates, when the customer cann…
Because both halves of the fraction are ambiguous. The numerator can be invoice total, subtotal before tax, or revenue excluding memberships and financing…
The Answer Hub you're reading is the same content intelligence system Bluefrog builds for clients. It discovers the questions customers actually ask, publishes structured answers, clusters them by topic, links them to the services they relate to, and adds new answers on a daily schedule instead of dumping a thousand pages at once.
That last detail matters more than it sounds. Search engines treat mass-published content as a quality signal in its own right. A hub that grows steadily, answers real questions and links coherently to the rest of the site behaves like a publication — which is the only version of this that holds up over time.
We run the same system on client sites in home services and the trades. See how the Answer Hub works, the automation behind it, or why it's built for AI search as much as for Google.
Bluefrog makes AI useful by integrating it with the way your business actually works — your software, your calls, your customers, your marketing and your revenue.
Technology development since 1997 · AI integration platforms since 2001
A real conversation with the people who build the technology — no obligation, no pressure.