Discovery
During layout verification for P07 phase 0, Sam noticed a CallRail Call Log record showed Party = "WINCHESTER KY WINCHESTER KY". Full live-state sweep confirmed this is a systematic pattern from the CallRail integration.
Scope
- 1,163 ghost Account records with
<CITY> <ST> <CITY> <ST> naming across 15 state codes (KY=933, CA=42, IN=36, OH=29, FL=23, NY=22, TX=20, TN=19, GA=11, IL=8, NC=7, MO=6, VA=5, SC=1, WV=1).
- 1,590+ CallRail_Call_Log__c records linked to a ghost.
- 998 ghost Contacts (KY/OH/IN sample; full count refreshed in Phase 1).
- 80 Tasks linked.
- Zero Matters, Intakes, Opportunities, Cases, Events reference any ghost — pure integration junk with no real client-data dependencies.
All ghost Accounts were created by Nathaniel Hatfield (the CallRail integration user). Date range: Sept 2025 onward.
Root cause
CallRail integration's Account-creation mapping populates FirstName and LastName both with the caller's <City> <State> value. Account.Name auto-computes to the duplicated string. Fix belongs in P16 Phase 1 (integration admin panel remap) — P18 waits until P16 Phase 1 is done so cleanup isn't a treadmill.
What was scaffolded
Folder: Salesforce-Cleanup-Projects/P18-callrail-ghost-party-cleanup/
- README.md — full live state, state-code distribution, safety case, dependencies (hard prereq on P16 Phase 1).
- INSTRUCTIONS.md — 4 phases: inventory refresh → decision halt → destination build + scripts → batched execution → post-sweep. Batch sizes: 200 CallRail logs, 100 Contacts, 50 Tasks, 50-100 Accounts.
- DECISION.md — 4 open decisions Sam must sign before Phase 2: destination for historical logs, ghost Contact resolution, Task resolution, deletion method (hard delete vs soft-retire vs merge).
- rollback/ROLLBACK.md — per-batch reversal in opposite order (Accounts → Tasks → Contacts → CallRail). Includes Id-mapping caveat for hard-delete rollback.
- context/ghost-party-inventory-2026-04-17.csv — all 1,163 ghost Accounts with Id, Name, Phone, CreatedDate.
- context/callrail-logs-linked-to-ghosts-2026-04-17.csv — all 1,590+ linked logs.
Dependencies