Booked, date unknown: no status change, sales-sheet row or previous record supplies a date. Excluded from commission until set.
Asked for a weekend install.
Scheduled the walkthrough.
No commission line: the booked date is unknown.
No job on the sales sheet yet.
Suggested for this lead:
Score = 50 + the points above, held between 0 and 100. Points = (that group's historical close rate − the overall rate) × 100, capped at ±20, only where the group has 10+ decided leads.
Extracted from the notes, follow-ups and form text only; nothing is inferred. A correction you save wins over any future re-read.
No form submission. The master sheet lists the source as “Internet Search”.
Master sheet Lead Source: “Internet Search”
Garage · 400 sq ft (from the notes) · 84121
$2,198 – $2,852middle half; median $2,403
Garage, 400 sq ft ±30%: jobs ran $5.14/sq ft to $8.17/sq ft (10th–90th percentile), totals $1,391 to $4,980, median job $2,733. The range above multiplies your square feet by the middle half of those rates.
Jobs whose notes mention cracking, leveling, patching, spalling, pitting, moisture or damage closed at $5.50/sq ft (n=3, median job $4,235) against $5.68/sq ft for the rest (n=332). Too few of either to compare yet. Tick “needs repair or leveling” to limit the comps to those jobs.
| Date | Where | Sq ft | Total | Rate |
|---|---|---|---|---|
| Aug 11, 2026 | 84121same zip | 483 | $2,294 | $4.75 |
| Mar 20, 2026 | Cottonwood Heights 84121same zip | 490 | $2,965 | $6.05 |
| Sep 6, 2022 | Cottonwood Heights 84121same zip | 515 | $4,000 | $7.77 |
| Mar 7, 2022 | Salt Lake City 84116same city | 410 | $2,250 | $5.49 |
| May 25, 2022 | Salt Lake City 84109same city | 375 | $3,750 | $10.00 |