Update coverage report: mark data-quality findings #1 (pipe-merges) + #2 (personal-domain tagging) RESOLVED; correct gmail count 100->157

de9f5d38814886d58881cd2f33dda628222bf4de · 2026-08-17 06:25:58 -0700 · Steve Abrams

Files touched

M REPORT-coverage.md

Diff

commit de9f5d38814886d58881cd2f33dda628222bf4de
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Mon Aug 17 06:25:58 2026 -0700

    Update coverage report: mark data-quality findings #1 (pipe-merges) + #2 (personal-domain tagging) RESOLVED; correct gmail count 100->157
---
 REPORT-coverage.md | 21 +++++++++++++++------
 1 file changed, 15 insertions(+), 6 deletions(-)

diff --git a/REPORT-coverage.md b/REPORT-coverage.md
index 5a3b88b..5bde427 100644
--- a/REPORT-coverage.md
+++ b/REPORT-coverage.md
@@ -28,10 +28,19 @@ cbre.com 120 · gmail.com 100 · kidder.com 55 · jll.com 54 · nmrk.com 48 ·
 matthews.com 44 · marcusmillichap.com 42 · orionprop.com 42.
 
 ## ⚠ Data-quality findings (non-send, fixable)
-1. **Bad company merge: "CBRE | Colliers" (59 contacts).** CBRE and Colliers are
-   separate competing firms — this pipe-joined value is a normalization error.
-   CBRE also appears separately as "CBRE" (56). These should be split/reconciled.
-2. **100 verified emails on gmail.com** — legitimate (individual agents), but worth
-   tagging as personal-domain so firm-level rollups aren't skewed.
+1. ✅ **RESOLVED — pipe-merged company names.** The "CBRE | Colliers" bad merge (59
+   contacts) plus the entire pipe-merge bug class were fixed across all 4 worklist
+   CSVs in five passes (commits e70a1e4, 2628508, c9a6490, a4557d6, dbbef8f):
+   Class 1 cross-firm merges (120 rows), Class 2 `| EMAIL` parse artifacts (370 rows),
+   Class 3a same-firm case/typo twins (253 rows), Class 3b evidence-clear variants
+   (144 rows), Class 3c domain-clear reserved merges (78 rows). Only intentional
+   pipes remain (SVN franchise office names, the C&W|PICOR affiliate, one gmail
+   contact whose employer is unknowable).
+2. ✅ **RESOLVED — personal-domain emails tagged.** 157 verified emails on personal
+   domains (108 gmail, 12 yahoo, 12 cox, plus aol/hotmail/outlook/etc.) are legitimate
+   individual agents. Added a non-destructive `Domain Type` column to
+   `rentv_CRE_worklist.csv` (personal / firm / blank) so firm-level and domain-level
+   rollups can exclude them (commit b6c0043). Tally: 157 personal, 3,713 firm, 335 no-email.
 3. **335 CRE contacts (8%) have no email** and **37% have no phone** — the residual
-   unreachable tail; expected given the held/obscure firms.
+   unreachable tail; expected given the held/obscure firms. Not fixable (no source
+   data); documented as-is.

← b6c0043 Add 'Domain Type' column to CRE worklist (personal/firm/blan · back to Rentv Sheet Enrich · Add deduped CRE worklist export (4,036 rows): collapse 169 s 31159ba →