Ridgeline Comfort Heating & Air

Owner Cockpit · Easley, SC · 2 branches · 4 service trucks · 2 install crews
Sample data — illustrative only
One filter set drives every section below. Click any number, row, or bar to see its formula and the rows behind it — and to cross-filter the whole cockpit.

The Monday Morning Five

The five numbers that decide where the week goes. Click one for the math — and the work behind it.

01

Front Door

What demand did we pay for — and never answer?

Demand funnel — all channels

Universe: all demand. Every one of the 612 inbound contacts in the base book — calls, forms, and LSA leads from every source, counted once at the door. (Installs, below, counts only the paid-campaign slice of this demand.)

When demand arrives vs. when we answer

Share of daily demand by hour. Amber = after hours (6p–7a), when the phones roll to voicemail.

12a3a6a9a12p3p6p9p

Why booked jobs never happened

Reason-coded losses for demand that never became a booked job. Click a reason to see the definition and the recovery math.

7-day recovery list

Demand we can still win back this week, oldest first. Worked top-down, these are worth real gross profit.

HouseholdWhat happenedEst. GPWaitingNext step

Recovery targets are re-contacted by a human within one business day. No blast texts.

02

Trucks

Which technician actually makes the company money?

Technician scorecard — net contribution per paid hour

Revenue minus parts, loaded labor, and callback cost, divided by paid hours. The only ranking the owner should coach to. Click a technician for the full build-up.

TechnicianRevenueNet $/paid hrDrive timeCallback rateJobs

Where the paid hour goes

Every paid hour, split four ways. Drive and callbacks are the two leaks an owner can actually schedule away.

Billable Drive Callback Idle / admin

Callback drag — cause × technician

Darker = more callbacks. A column that lights up is a coaching conversation; a row that lights up is a process problem.

03

Installs

Which ad pays for a crew — and which estimates are dying unfollowed?

Ad spend → installed gross profit

Already banked · installed gross profit

Universe: paid campaigns only — the 418 leads that began as ads, a subset of the Front Door's 612 contacts, never a second count of them. (Example: Paid Search shows 96 contacts at the Front Door, but only the 63 replacement-intent Replace leads enter this chain.) Platform ROAS stops at the click; this stops at the bank.

Gross profit per lead, by campaign

Already banked · value of finished, paid work

What one lead is actually worth after the job is done and paid for. Click a campaign to cross-filter.

Open-estimate pipeline, by age

Still winnable · quoted value, not yet money

Quoted work waiting on a yes. An estimate nobody touches for two weeks is usually already sold — by somebody else.

Follow-up queue — oldest open estimates

Still winnable · quoted value, not yet money

Two touches minimum: a call, then a text with the quote attached. Click any row for the follow-up script math.

HouseholdSystem quotedQuoteAgeLast touch
04

Ahead

Where will demand come from before the phones ring?

Replacement opportunity by neighborhood

Installed base aged 13+ years, weighted by repair history and plan status. Click a zone to cross-filter the whole cockpit.

Pre-failure contact queue

Households most likely to need a replacement in the next 30 days — grouped by zone so one truck works one neighborhood.

HouseholdSignalSystem ageEst. value

Next 14 days — install capacity vs. shaped demand

Open install slots, and the order they should be filled: plan members first, then past-due replacements, then repair-heavy households — new ad demand last.

05

Plan Book

Is the maintenance book actually profitable — and who loses us money?

Net contribution per member, by cohort

Plan price minus the real cost to serve (visits, parts, drive, callback share). Click a cohort to cross-filter.

Cohorts are set by visits in the trailing 12 months: Light ≤2, Standard 3–4, Heavy 5+.

Renewal cliff — next 90 days

Agreements coming due, and how much of that revenue is on members who currently lose money.

Negative-member list — fix before the renewal letter

Every member whose cost to serve beats their plan price. Each one gets a named fix: reprice, convert, or re-route. Nobody gets quietly cancelled.

MemberZoneVisits/yrCost to servePlan priceNet/yrFix

06

Trust

Can every dollar on this page be traced to a source?

Revenue confidence ledger

Invoiced revenue, step by step: did it happen, and do we know where it came from?

A view that cannot reconcile to invoicing is labelled sample or dropped — never estimated into existence.

Needs human eyes

The short list where the data and the real world disagree. Cleared weekly, by a person, before the Monday numbers go out.

ItemAmountOwner

Your Monday brief

The five numbers below, ready to copy or save — open the saved file to put the brief on paper. It always uses the filters currently set on the cockpit.