Case study · Roofing & home improvement
A live sales dashboard for a roofing team, built on JobNimbus
This roofing and home-improvement company sells through door-knocking, canvassers and its own campaigns, and keeps everything in JobNimbus. Leadership wanted one live view of sales, revenue, closing ratio and field activity, by company and by rep. We built it in Retool on the JobNimbus API, then rebuilt it so every number follows a written rule.
The challenge
What wasn’t working
Sales numbers lived in JobNimbus, and getting a company or per-rep view meant exporting reports.
Simple questions had more than one answer. Does a sale count on the day the job became Sold, or by its status today? Which estimate is the revenue?
JobNimbus returns at most 10,000 records per request, and the team wanted full histories.
The solution
What we built
Headline KPIs
Sales, new leads, revenue, closing ratio, pipeline value, appointments and doors knocked, each compared with the previous period.
Company and rep views
The same metrics for the whole company or one rep, with a top-four leaderboard and month-to-date and year-to-date bookings.
Lead source performance
Conversions and revenue by campaign, split between company leads and self-generated ones.
Field activity
Appointments set, confirmed and converted, plus doors knocked, canvasser activity and a live feed of recent sales.
Written metric rules
A sale counts on the date the job moved into Sold, revenue comes from the latest approved estimate, and closing ratio is Sold / (Sold + Lost). Each rule is documented in its query.
Faster loading
Version two sends the date range to the API as a filter and loads every source in parallel, so it fetches only what the view needs.
How it works
How the numbers are built
- 1
Pick a period
One global date filter, plus rep and campaign filters, drive every widget.
- 2
Fetch from JobNimbus
Jobs, contacts, tasks, activities, estimates, invoices and work orders load in parallel for that period.
- 3
Apply the rules
JavaScript queries find Sold dates in activity history and take revenue from approved estimates.
- 4
Show it
KPI cards, charts and tables update with changes against the previous period.
Screens
Inside the build
Real screenshots from the project. Client names, logos and personal details are blurred.

The result
What changed
- One live view of sales, leads and field activity, with no CRM exports
- Metric definitions are written down and used the same way everywhere
- Campaign and rep views show where revenue really comes from
- Loading only the selected period keeps the dashboard quick
More work
More case studies
Site hours, task progress and payroll in one app for a construction company
Read the case study →Family lawA custody schedule planner with a custom calendar component in Retool
Read the case study →Air freight & logisticsAn admin app for an air freight pricing and routing engine
Read the case study →Have a project like this?
Tell us what you need to build. In 30 minutes we’ll map what to build first and follow up with a fixed-scope estimate.
Official Retool Agency Partner5.0 on Clutch, 9 reviewsBuilding software since 2015Reply within one business day