How to Build a Dashboard for Your Home Service Business: 6 Paths Ranked by Cost and Pain

Jobber ships with over 20 built-in reports and zero custom report builder. That single gap is why more than half of contractors on Jobber end up exporting to Google Sheets within their first year, and why most of those spreadsheets are abandoned within 90 days.

You are reading this because the built-in reports do not tell you what you actually need to know. Revenue by service type, technician revenue per hour, close rate by lead source, gross margin per job. You want a dashboard. Here are the 6 real paths ranked by honest monthly cost and pain.

1. Google Sheets pulled manually from your CRM every Monday

The entry-level path. You open your CRM, export CSVs, paste them into a Google Sheets template, and build pivot tables.

• Export jobs, invoices, and payments as CSVs from Jobber, Housecall Pro, or ServiceTitan
• Paste into a master Google Sheet with tabs by data type
• Build pivot tables for revenue by service, tech, and month
• Write INDEX/MATCH or QUERY formulas to join jobs to invoices
• Add conditional formatting for KPI thresholds
• Repeat every Monday morning for 2 to 4 hours
• Archive old tabs monthly so the sheet stays under Google's 10 million cell limit

Ongoing cost: 8 to 16 hours per month of owner or office manager time, at $40/hour that is $320 to $640 per month in labor.

Right for contractors under $500K in revenue who are figuring out which KPIs they care about before investing in automation.

Text Sully: "Show me revenue by service type for the last 90 days with tech-level breakdowns."

2. Zapier-automated Google Sheets with live Jobber data

One step up. You stop exporting CSVs and let Zapier push new jobs, invoices, and payments into Google Sheets rows as they happen.

• Sign up for Zapier Professional at $49/month for 2,000 tasks
• Create Zaps for new Jobber job, new invoice, new payment, new quote, new client
• Map each Jobber field to a Google Sheets column
• Enable multi-step filtering so only completed jobs write to the revenue tab
• Build pivot tables on top of the live data
• Write formulas to join client records to jobs using client ID
• Set up weekly email summary using Google Sheets native scheduler

Ongoing cost: $49 to $299 per month for Zapier depending on volume, plus 4 to 6 hours per month to fix broken Zaps when APIs change. A 5-Zap setup running 10,000 events per month burns 50,000 tasks, which is the $299 Team plan.

Right for contractors with 200 to 500 jobs per month who have one person who can debug Zap failures.

Text Sully: "Which Zaps have fired in the last 24 hours and which customers triggered them?"

3. Power BI desktop pulling from your CRM API

Real BI tooling. You connect Power BI to your Jobber, Housecall Pro, or ServiceTitan API and build relational data models.

• Subscribe to Power BI Pro at $14/user/month as of April 2025
• Register a developer app in your CRM's developer portal
• Request API access (ServiceTitan requires The Works or Legacy plan)
• Write Power Query M scripts to pull jobs, customers, invoices, payments as separate tables
• Define relationships between tables using the data model view
• Build DAX measures for revenue recognized, AR aging, tech utilization
• Publish to Power BI Service so your team can view on mobile
• Schedule daily refresh which counts against your API rate limits

Ongoing cost: $14/user/month for Power BI Pro, plus $2,000 to $8,000 one-time build cost if you hire a consultant, plus 6 to 10 hours per month of DAX maintenance when you add metrics.

Right for contractors doing $2M+ who already have a CFO or ops manager comfortable with BI tooling.

Text Sully: "Show me AR aging over 60 days by customer, sorted by amount owed."

4. Looker Studio connected to a warehouse

The analyst path. You load your CRM data into BigQuery or Postgres, connect Looker Studio, and build shareable dashboards.

• Set up a Fivetran connector or write a custom ETL job to sync Jobber/HCP/ServiceTitan to BigQuery
• Pay Fivetran from $5/connection minimum per month to $1K to $5K monthly for mid-sized data volume as of January 2026
• Or self-host Airbyte on a $20/month VPS with the operational burden that implies
• Model tables in dbt or raw SQL views for revenue, jobs, customers, ar aging
• Connect Looker Studio (free tier works) or Looker Studio Pro at $9/user/month
• Build dashboards with filters, date ranges, drill-downs
• Schedule daily email snapshots to ownership

Ongoing cost: $50 to $1,500 per month for the warehouse and ELT, plus $9/user/month for Looker Studio Pro, plus 8 to 15 hours per month of pipeline babysitting when schemas drift.

Right for operators over $5M who want dashboards shared across 5+ roles and have someone in-house who can write SQL. We covered why this stack breaks for smaller contractors in the real cost of building an AI agent for a home service business.

Text Sully: "What was our revenue last quarter by service type and how does that compare to Q4?"

5. Hire an AAA freelancer to build a custom dashboard

The "just pay someone" path. You post on Upwork or the r/AI_Agents subreddit and hire a developer to build a custom dashboard connected to your CRM.

• Write a scope doc for the KPIs you want
• Get quotes from 3 freelancers ($2,500 to $8,000 typical range)
• Pick one, wire them into your CRM credentials
• They build on Retool, Metabase, or a custom React dashboard
• They deploy to a $20 to $50/month VPS or Vercel
• They hand off a 2-page README and disappear
• Your CRM changes something 3 months later and the dashboard breaks

Ongoing cost: $2,500 to $8,000 upfront, plus $50 to $200/month infrastructure, plus $150/hour emergency maintenance when something breaks. Average honeymoon length before first break is 3 months, documented in the patterns we see in why DIY ChatGPT bots fail in home services.

Right for contractors who have one specific, stable metric they need and do not mind rebuilding the dashboard every 12 to 18 months.

Text Sully: "Show me revenue per technician per hour for the last 30 days."

6. Skip the build. Text Sully.

Sully is an AI brain connected to your Jobber, Housecall Pro, ServiceTitan, Workiz, or GoHighLevel. You text it questions in plain English. It answers from your actual data.

• Connect your CRM in 5 minutes through the Sully onboarding flow
• Wait for the initial sync (under an hour for most accounts)
• Text Sully any question about your business
• Get the answer in under 10 seconds
• Share the answer with your team or save it to your morning brief
• Sully learns which metrics you care about and surfaces them proactively
• No dashboard to maintain, no API keys to rotate, no broken Zaps

Ongoing cost: flat subscription with no per-query, per-task, or per-user pricing surprises. You get unlimited questions across your whole data stack, same as asking a $60K/year analyst.

Right for any contractor under $10M who wants answers, not dashboards. The full architecture sits on the same pattern we describe in how to build an AI agent for home services, except you do not have to build it.

Text Sully: "What is my gross margin on HVAC installs this month and which techs are dragging the average down?"

Contractor stories from the build attempts

A thread on r/sweatystartup captured the path most owners actually walk. An HVAC owner doing about $1.8M started on Jobber's built-in reports, moved to weekly CSV exports into Google Sheets after 6 months, added Zapier automations at month 9 after hiring an office manager, then abandoned the whole stack at month 14 because the office manager quit and the next hire could not maintain the Zaps. Total spend including the $4,500 he paid a freelancer to rebuild in Retool: about $11,000 over 18 months, with no dashboard in production by the end.

On the Owned and Operated podcast, episode #140 with Danny Peavey of Home Service Engine, the recurring theme was that ServiceTitan operators routinely say "I don't trust the data, I want to understand how I'm performing," and Peavey's consultancy exists specifically to fix that mistrust. If a multi-location ServiceTitan shop on The Works plan cannot trust its own reports, a $1M to $10M contractor building a Power BI dashboard from the same API is guaranteed to feel that same pain compounded.

Honest path guidance

If you are under $1M and figuring out which KPIs matter, start with path 1. Export manually, iterate on the metrics, and stop when you know exactly what you want to automate. Most contractors overbuild the dashboard before they know the answer to that question.

If you are $1M to $3M and have an office manager who survives longer than 18 months, path 2 (Zapier to Sheets) is defensible as long as you budget the maintenance hours honestly. Do not let an AAA freelancer sell you path 5 until you have lived with path 2 and know exactly what breaks.

If you are $3M+ and have an ops lead who can write SQL, path 4 (warehouse plus Looker Studio) is the real answer, but only if you commit to the 8 to 15 hours per month it costs to keep it alive. Power BI (path 3) is the Microsoft-shop version of the same answer.

Path 5 (AAA freelancer) is the path most contractors regret. The build looks fast, the demo looks clean, and the maintenance cliff at month 3 to 6 consistently destroys the ROI. If you go this route, negotiate a retainer up front rather than a one-time build fee, because the real cost is post-launch.

Path 6 is honest about one thing the other 5 cannot be. Dashboards are a means, not an end. You do not want to look at a dashboard. You want to know if you are winning. Sully answers the second question directly without the 6-month build.

The honest answer for most $1M to $10M shops is to combine path 1 (for the KPIs you check once a month) with path 6 (for everything else). Skip the Zapier-to-Sheets middle layer unless you have a specific, stable use case that will pay for itself in 90 days. Skip the warehouse build unless you have a data engineer on staff.

What you save is not the monthly subscription. It is the 100+ hours per year you would have burned on Zap maintenance, DAX debugging, and API-change firefighting. That is the real dashboard ROI, and it is the reason most contractor dashboards never make it to the second anniversary.

The 6 paths at a glance

Frequently Asked Questions

Does Jobber have a custom report builder?

No. Jobber ships with over 20 built-in reports and zero custom report builder. That single gap is why more than half of contractors on Jobber end up exporting to Google Sheets within their first year, and why most of those spreadsheets are abandoned within 90 days.

How much does Power BI cost for contractors?

Power BI Pro is $14 per user per month as of 2026. On top of that, expect $2,000 to $8,000 one-time build cost if you hire a consultant, plus 6 to 10 hours per month of DAX maintenance when you add metrics. It makes sense for contractors doing $2M+ with a CFO or ops manager comfortable with BI tooling.

Is it worth building a custom dashboard for a small home service business?

Usually not. The AAA freelancer path averages a 3-month honeymoon before a CRM API change breaks the pipeline silently. One HVAC owner doing $1.8M spent $11,000 over 18 months on Jobber exports, Zapier, and a Retool rebuild, with no dashboard in production by the end.

What is the ServiceTitan API rate limit?

ServiceTitan APIs cap at 60 calls per second and 5 of the same report per minute per tenant. A naive export pipeline hits throttling by job 500. This is why most ServiceTitan dashboard builds require rate-limit-aware retry logic before they survive production load.

What's the fastest way to get dashboards for a home service business?

Text-based AI like Sully answers questions in under 10 seconds with no build time. Flat subscription pricing with unlimited questions beats the 6-month warehouse build for any contractor under $10M who wants answers, not dashboards.

How much does Fivetran cost for contractor data volume?

Fivetran starts at $5 per connection minimum per month and scales to $1K to $5K monthly for mid-sized data volume as of January 2026. Self-host Airbyte on a $20/month VPS if you want to trade cash cost for operational burden.

Sources:

• Jobber API Rate Limits
• ServiceTitan API Rate Limits
• Power BI Pricing 2026
• Looker Studio Pricing 2026
• Fivetran January 2026 pricing changes
• Jobber native report limitations
• Owned and Operated podcast #140 with Danny Peavey