Attribution conflict: the master sheet says “Facebook Ad/Hook C”; the sales sheet says otherwise. The rule in place (master wins) is applied and the flag stays until Firstgen settles it.
Booked date May 19, 2026, 12:00 PM · from sales sheet conversion date
Left a voicemail.
Estimate signed; install on the books.
Estimate signed; install on the books.
No answer; trying again tomorrow.
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 “Facebook Ad/Hook C”.
Master sheet Lead Source: “Facebook Ad/Hook C”
Sales sheet Lead Type: Facebook Ad, Repeat Customer
Garage · 780 sq ft (from the notes) · 84040
$3,994 – $4,908middle half; median $4,346
Garage, 780 sq ft ±30%: jobs ran $4.72/sq ft to $7.02/sq ft (10th–90th percentile), totals $1,000 to $8,459, median job $4,500. 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 |
|---|---|---|---|---|
| May 19, 2026 | Layton 84040same zip | 845 | $4,000 | $4.73 |
| Mar 30, 2023 | Layton 84040same zip | 615 | $3,250 | $5.28 |
| Apr 21, 2023 | Layton 84040same zip | 605 | $2,420 | $4.00 |
| Apr 13, 2023 | Layton 84041same city | 875 | $3,741 | $4.28 |
| Aug 18, 2026 | Layton 84048same city | 910 | $4,554 | $5.00 |