Booked, date unknown: no status change, sales-sheet row or previous record supplies a date. Excluded from commission until set.
Moved the appointment a week out at the customer's request.
Moved the appointment a week out at the customer's request.
No commission line: the booked date is unknown.
No job on the sales sheet yet.
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”.
Master sheet Lead Source: “Internet”
Garage · 950 sq ft (from the notes) · 84098
$4,772 – $5,875middle half; median $5,263
Garage, 950 sq ft ±30%: jobs ran $4.58/sq ft to $6.80/sq ft (10th–90th percentile), totals $1,000 to $11,800, median job $5,000. 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 5, 2022 | Park City 84098same zip | 976 | $8,445 | $8.65 |
| Oct 19, 2022 | Park City 84098same zip | 1,010 | $6,297 | $6.23 |
| Oct 30, 2023 | Park City 84098same zip | 810 | $6,704 | $8.28 |
| Jun 7, 2022 | Park City 84098same zip | 755 | $8,264 | $10.95 |
| Mar 23, 2023 | Park City 84098same zip | 1,165 | $6,199 | $5.32 |