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. 1

    Pick a period

    One global date filter, plus rep and campaign filters, drive every widget.

  2. 2

    Fetch from JobNimbus

    Jobs, contacts, tasks, activities, estimates, invoices and work orders load in parallel for that period.

  3. 3

    Apply the rules

    JavaScript queries find Sold dates in activity history and take revenue from approved estimates.

  4. 4

    Show it

    KPI cards, charts and tables update with changes against the previous period.

Screens

Inside the build

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

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