What data sources are needed for a contractor KPI dashboard?

Most contractor KPI dashboards pull from a field-service CRM (ServiceTitan, Housecall Pro, or Workiz) for jobs and calls, QuickBooks for financial data, a call-tracking platform for inbound call attribution, one or more ad platforms for spend and ROAS, and review platforms for reputation metrics. Some also connect capacity or scheduling tools. The exact list depends on which KPIs the business actually needs to track.

Can I build a KPI dashboard using only my CRM data?

You can, but it will only show operational activity, not profitability. A CRM holds jobs, calls, bookings, and invoices but not your true margin or cost of goods. Without QuickBooks connected, the dashboard cannot show gross profit, labor percentage, or expense pacing. For an owner or GM who needs to run the business rather than just track sales activity, a CRM-only view is a partial picture.

How does call tracking connect to a KPI dashboard?

Call tracking platforms like CallRail assign unique phone numbers to each marketing channel. When a customer calls, the platform logs which channel drove the call alongside the call outcome. That attribution data connects marketing spend to inbound volume and, when paired with CRM job data, all the way to revenue. Without call tracking, a dashboard can count total calls but cannot tell you which campaign generated bookable calls versus price shoppers.

What is the best order to connect data sources for a new KPI dashboard?

Start with your CRM to get operational KPIs live first, then add QuickBooks for the financial layer. Call tracking comes next, because it bridges marketing to CRM outcomes. Ad platforms follow so you can calculate ROAS in the same view as revenue. Review data comes last and rounds out the picture with reputation metrics. This sequencing gets you to a useful dashboard faster than trying to connect everything simultaneously.

What happens if my QuickBooks data is messy before I connect it?

Messy QuickBooks data surfaces as unreliable margin and cost figures in the dashboard, which erodes trust in the whole board. The most common issues are an unclear chart of accounts (costs bucketed too broadly to distinguish labor from materials), timing differences between invoiced and recognized revenue, and inconsistent categorization across locations. A brief controller audit before the build is faster than debugging mid-build. A good dashboard partner will flag these gaps during the discovery phase rather than connecting and hoping.

Do I need a separate data source for each department?

Not always. Most of the data your CSR, service, sales, and install departments need lives in the same CRM, just structured differently. A well-connected CRM feeds department-level boards with booking rate for the call center, tech revenue for service, average ticket for sales, and job completion data for install. The accounting source handles financial breakdowns. You would add a department-specific source only if that department uses a tool not already in your stack, such as a separate estimating or project-management platform.

How many data sources does a multi-location contractor typically need?

A single-location contractor usually needs four to five sources: CRM, QuickBooks, call tracking, one or two ad platforms, and reviews. A multi-location operator often has more because each location may have its own ad accounts, separate QuickBooks files, or inconsistent CRM instances. The number of sources is less important than whether the data definitions are consistent across locations. A dashboard that pulls from eight sources but uses different booking rate definitions per branch will produce misleading rollups.

What is ROAS and why do contractors need it in a dashboard?

ROAS (return on ad spend) measures the revenue generated for every dollar spent on advertising. For a home-service company it tells you whether your Google Ads, LSA, or other paid campaigns are producing profitable calls, not just call volume. Without ROAS in your dashboard, a marketing leader might cut a campaign that looks expensive on a cost-per-click basis but is actually generating your highest-value service calls. Calculating ROAS in a dashboard requires connecting your ad platform spend data to CRM job revenue, with call tracking as the bridge.

Dashboards & reporting

What data sources do you need for a contractor KPI dashboard?

Before a single number shows up on your dashboard, something has to feed it. Most contractors discover mid-build that three or four tools hold the data they assumed lived in one place. This article maps the sources, what each one contributes, and how to sequence the connections so your KPI dashboard shows a complete picture from day one.

By Datacube content engineAutogenerated

The short answer: a contractor KPI dashboard typically pulls from four to six distinct systems. The core set is a field-service CRM (ServiceTitan, Housecall Pro, Workiz), an accounting package (usually QuickBooks), a call-tracking platform, at least one ad platform, and a review aggregator. Add a fifth source if you run a membership program or track capacity separately.

The harder question is not which tools you use but what data lives in each one and whether those records are clean enough to power a real-time board. Most operators assume their CRM holds everything. It holds jobs and calls, but not margin. QuickBooks holds margin, but not booking rate. Call tracking holds call volume, but not which calls turned into jobs. None of those three talks to the others by default.

That gap is why most contractors are flying blind on their most important numbers. The sections below walk through each source category, what it contributes, and which KPIs it unlocks.

Quick summary: what this article covers

The six source categories a contractor dashboard typically needs and what each one feeds.
A source-to-KPI mapping table showing which numbers require which connection.
The most common data gaps that leave dashboards incomplete and how to spot them before the build.
A practical sequencing order for connecting sources so you see value quickly.
A checklist for auditing your current data landscape before setup starts.

Source-to-KPI map for a contractor dashboard

Source category	Common tools in the trades	What data lives here	KPIs it unlocks
Field-service CRM	ServiceTitan, Housecall Pro, Workiz	Jobs, calls, bookings, dispatch, tech assignments, invoices, memberships	Booking rate, average ticket, jobs run, tech revenue, call conversion, membership count
Accounting	QuickBooks	Revenue, COGS, payroll, expenses, accounts receivable, gross profit, net operating income	Gross margin, labor percentage, COGS trend, expense pacing, NOI vs. target
Call tracking	CallRail and similar platforms	Inbound call volume, missed calls, call recordings, lead source attribution per call	Missed call rate, calls by lead source, CSR answer rate, call-to-booking conversion
Ad and marketing platforms	Google Ads, Meta Ads, LSA, other paid channels	Campaign spend, impressions, clicks, cost per lead by channel	Cost per lead, ROAS by channel, ad spend as a percentage of revenue
Review platforms	Google Business Profile, other review aggregators	Star rating, review count, response rate, recent reviews	Average star rating, review velocity, reputation trend by tech or location
Operational / capacity data	CRM dispatch board, scheduling tools	Open slots, booked capacity, dispatch efficiency, job completion time	Capacity utilization, dispatch lag, same-day booking fill rate

Warning

Data visibility gap: what your CRM alone cannot tell you

ServiceTitan, Housecall Pro, and Workiz hold your jobs and calls, but none of them carries your true margin. Job revenue in a CRM is invoiced revenue, which is not the same as collected revenue and not the same as gross profit after labor and parts. If you build a KPI dashboard that only pulls from your CRM, you will have an accurate view of sales activity and a blind spot on profitability. The fix is adding QuickBooks as the second source so cost data and revenue data live side by side.

Your CRM: the operational backbone

Your field-service CRM is where the operational pulse of the business lives. For most home-service companies this is ServiceTitan, Housecall Pro, or Workiz. Every job dispatched, every inbound call logged, every technician assignment, and every invoice created passes through here.

From the CRM a dashboard can show booking rate (calls that became jobs vs. all inbound calls), average ticket, tech-by-tech revenue, jobs run by department, and membership sold versus lost. These are the numbers your CSR manager and dispatch lead need to see in real time, not in a weekly export.

The limitation: CRM data tells you what your team did, not whether it was profitable. An HVAC company could run 80 service calls in a week, all logged in the CRM, and not know until QuickBooks closes whether the margin on those calls was 45 percent or 22 percent.

Accounting (QuickBooks): where the money really lives

QuickBooks is the second source most contractors connect and the one that unlocks financial KPIs: gross profit, labor percentage, COGS trend, and net operating income. Without it, a KPI dashboard can only show revenue on the top line, with no view of what it cost to earn it.

When QuickBooks is connected alongside the CRM, an owner can watch revenue, COGS, and gross margin move in parallel across the month. A plumbing company owner who sees gross margin drop from 52 to 44 percent mid-month can investigate the cause while there is still time to act, not after the books close on the 31st.

Call tracking: the missing link between marketing and bookings

A call-tracking platform like CallRail adds a layer the CRM cannot provide on its own: which marketing channel drove which call, and what happened to that call. Your CRM records whether a CSR booked the job. Call tracking records which Google Ads campaign or local services ad generated the call in the first place.

Without call tracking, a dashboard might show 200 inbound calls this month but have no way to attribute them to channels. With it, you can see that 80 came from Google Ads, 60 from organic search, 40 from LSA, and 20 from repeat customers. That breakdown changes every decision your marketing leader makes.

Ad platforms: spend visibility and ROAS

Connecting Google Ads and other ad platforms surfaces campaign spend and cost-per-lead in the same view as CRM revenue. That is the only way to calculate return on ad spend (ROAS) without manual exports. An HVAC company running $30,000 per month across Google Ads and LSA needs to know which campaigns generated jobs and at what cost, not just click counts.

Review platforms: reputation as a leading indicator

Review data from Google Business Profile and similar platforms is often left out of contractor dashboards. That is a mistake. Star rating and review velocity are leading indicators of lead quality and close rate. A garage-door company whose average star rating drops from 4.8 to 4.4 over six weeks will feel that in lead cost before they see it in revenue.

Connecting reviews also enables per-technician reputation scoring. If one tech is generating negative reviews consistently, you will see that pattern in the data before a customer escalation makes it impossible to ignore.

Info

Dashboard idea: the five-source view for an HVAC owner

Picture a single screen showing: booking rate from the CRM (ServiceTitan), gross margin from QuickBooks, missed call count from call tracking, cost per lead from Google Ads, and average star rating from Google Business Profile. Each number comes from a different tool. None of them can answer your question alone. Together they tell you whether the business is healthy this week. That is what a datacube custom dashboard is designed to consolidate, across 50-plus source types, into one view your team checks before asking for a report.

How to sequence your data source connections

01
1. Start with your CRM
Your field-service CRM is the operational core. Get it connected first so booking rate, average ticket, and tech performance are visible from day one. This is also where your employees and job types are defined, which drives how every other board is structured.
02
2. Connect QuickBooks second
Once the CRM is feeding jobs and revenue, add QuickBooks to layer in cost data. This is when the dashboard stops being an activity tracker and starts being a profitability tool. Reconcile revenue between the two sources early; gaps here are common and usually stem from timing differences or how refunds are recorded.
03
3. Add call tracking
Call tracking is the bridge between your marketing spend and your CRM outcomes. Add it third so you can tie call volume to lead source and start calculating call-to-booking conversion by channel. This is where you find out which campaign is delivering bookable calls and which is generating price-shoppers.
04
4. Layer in ad platform data
Connect Google Ads and any other active paid channels. Now that call tracking is live, you have a chain: spend to call, call to booking, booking to revenue. ROAS by channel becomes a real number instead of an estimate.
05
5. Pull in reviews and reputation
Add review platform data to close the loop on customer experience. A reputation board that shows star rating trend, review count, and per-tech scores rounds out the picture and surfaces coaching opportunities before they become a pattern.

Pre-build audit: questions to answer before you connect anything

Data quality determines dashboard reliability. A build that surfaces bad data faster is not an upgrade. Before connecting sources, audit each one with these questions:

Is the data entered consistently? If techs record job types differently across locations, your per-department breakdown will be unreliable. Are leads tagged by source in the CRM? Without source tagging in the CRM, call tracking attribution does not carry through to revenue. Does QuickBooks have a clean chart of accounts? A jumbled chart of accounts means cost categories will not map cleanly to labor, materials, and overhead. Are call recordings available and attributed? If call tracking does not log missed calls separately, you cannot measure missed-call rate. How far back does usable history go? Some source connections only expose 12 months of history; others go further. Knowing this up front shapes what you can show for year-over-year comparisons.

Multi-location operators: where data sources multiply

A single-location plumbing shop might connect four sources and have a clear picture. A roofing company with three locations often has three CRM instances, two QuickBooks files, separate Google Ads accounts by market, and inconsistent call-tracking setups inherited from different acquisitions. The data-source challenge for multi-location operators is not just connection but standardization: every location has to measure booking rate, average ticket, and gross margin the same way or the rollup is misleading.

The discovery and KPI-alignment stage of a dashboard build is specifically where these definitions get locked before anything is connected. That is the step most operators rush and then regret.

Data source readiness scorecard

Rate each source before you start. Poor scores here slow the build and lower trust in the dashboard.

CRM data entry consistencydefine job types and lead sources before connecting
Watch
Current
Varies by rep
Target
Standardized across team
QuickBooks chart of accountsa controller audit now saves rework later
Poor
Current
Mixed categories
Target
Clean labor/materials/overhead split
Call tracking coveragesource attribution carries through to CRM
Good
Current
All inbound lines tracked
Target
All lines, all channels
Ad account access and namingnaming matters for channel-level ROAS
Good
Current
One owner per account
Target
Read access granted, campaigns named by intent
Review profile claimed and activeresponse rate visible in dashboard
Good
Current
Google profile claimed
Target
Claimed, monitored, and responding

Metric	Current	Target	Status
CRM data entry consistencydefine job types and lead sources before connecting	Varies by rep	Standardized across team	Watch
QuickBooks chart of accountsa controller audit now saves rework later	Mixed categories	Clean labor/materials/overhead split	Poor
Call tracking coveragesource attribution carries through to CRM	All inbound lines tracked	All lines, all channels	Good
Ad account access and namingnaming matters for channel-level ROAS	One owner per account	Read access granted, campaigns named by intent	Good
Review profile claimed and activeresponse rate visible in dashboard	Google profile claimed	Claimed, monitored, and responding	Good

What this means for your dashboard build

A contractor KPI dashboard is only as complete as its sources. Connecting your CRM gives you operational visibility. Adding QuickBooks gives you financial reality. Layering in call tracking, ad platforms, and reviews gives you the full loop from marketing spend to booked job to margin. Miss any one of those connections and you have a partial view that can mislead as easily as it informs. If you want to see what a full multi-source build looks like for a home-service company, the contractor KPI dashboard page shows what datacube consolidates and how it is structured for operators.

Data sources for contractor KPI dashboards: common questions

See what your data sources could power

Datacube is designed to consolidate 50-plus source types, from ServiceTitan and QuickBooks to call tracking, ad platforms, and reviews, into a single custom dashboard built for your operation. Book a live demo and we will walk through which sources apply to your business and what KPIs they would unlock.

Schedule a live demo Self-guided demo