Booked, date unknown: no status change, sales-sheet row or previous record supplies a date. Excluded from commission until set.
Texted to confirm the appointment.
Spoke with the homeowner; sending the estimate today.
Measured the space; prep is light.
Sent the color options.
No commission line: the booked date is unknown.
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 “Elevated Website”.
Master sheet Lead Source: “Elevated Website”
Sales sheet Lead Type: Elevated Website, Elevated Website
Driveway / walkway · 800 sq ft (from the notes) · 84032
Not enough comparable jobs to guide from (2 matched Driveway / walkway, 800 sq ft ±30%; 5 needed). Widen the match by clearing the square feet or the project type.
Jobs whose notes mention cracking, leveling, patching, spalling, pitting, moisture or damage closed at — (n=0, median job —) against $2.52/sq ft for the rest (n=6). 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 |
|---|---|---|---|---|
| Jun 25, 2023 | Tooele 84074 | 770 | $866 | $1.13 |
| Jun 20, 2023 | Lehi 84043 | 758 | $1,327 | $1.75 |