Rep Ping Scorecard — last 14 days
Generated 2026-09-21T00:53:47.245Z. Window: 2026-09-07T00:53:47.245Z -> 2026-09-21T00:53:47.245Z.
data/store/leads.json last synced: 2026-09-21T00:33:47.368Z.
What this can prove: a customer replied (memory/reply-ledger.jsonl, the same event that triggers the rep text), whether a genuinely human outbound (not in message-log.json) landed on that customer's file afterward, and how fast. What it cannot prove: that the rep read the TEXT itself, only that the CUSTOMER got a real human response afterward — a rep could act without ever opening the text (e.g. already working the deal by phone), or a text could bounce and go unnoticed while someone else in the store answers the customer.
UNVERIFIED means data/store/leads.json's sync for that customer is more than 6h stale as of report time — it is NOT counted as "no response," because the real answer may exist in VinSolutions and just hasn't synced down yet.
PINGS (proxy) vs LEDGER SENDS: "Pings" below = reply-ledger events in-window joined to a rep via leads.json. "Ledger sends" = actual confirmed text sends from memory/staff-text-sent.jsonl for that rep in the same window (class "reply"). They will not match exactly — reply-coalescing (repeat replies from the same customer inside 2h roll into one later text), quiet-hours deferral, and the governor's consolidation hold all mean one ping event doesn't always equal one text, and vice versa. Treat "Ledger sends" as the hard number of texts that went out, and "Pings" as the number of reply events the table below is scored against.
33 reply-ledger event(s) in-window had no matching leads.json record (skipped — can't attribute). 32 more had no valid roster rep assigned (Unassigned / Will Robbins / a corrupted "Assigned Salesperson" grid-scrape string — not a salesperson text, skipped from the per-rep table).
No phone on file: Abdelhak Zerrouk, Cesar Hernandez Jr, Christopher Tait, Daniel Arce, Gary Brophy, Kendra Parrish, Malachi Betancourth, Manuel Bran, Michael Naszkiewicz, Ramon Silos, Richard Martinez, Ryan Forbus, Sujey Bello, Tariq Halawani, Tre Templeton — have customers assigned to them but no phone number in config/team-roster.json, so messageStaff() can never text them. A reply from one of their customers falls back to a "callback" ping to Will instead. Structural gap, not a reading-their-texts problem — they show up below with 0 ledger sends even where they have pings.
Per rep
| Rep | Pings (proxy) | Ledger sends | <1h | <4h | Same day | Later | Never | Unverified |
|---|---|---|---|---|---|---|---|---|
| Ajay Malani | 91 | 4 | 3 | 2 | 0 | 0 | 0 | 86 |
| Cesar Hernandez Jr | 26 | 0 | 0 | 0 | 0 | 0 | 26 | 0 |
| Edward Cavaness | 142 | 57 | 16 | 17 | 7 | 15 | 0 | 87 |
| Emely Tellez | 44 | 46 | 9 | 2 | 0 | 2 | 1 | 30 |
| Henry Smith | 107 | 69 | 16 | 22 | 2 | 12 | 1 | 54 |
| La Marcus Burnette | 134 | 70 | 17 | 8 | 0 | 16 | 0 | 93 |
| Manuel Bran | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 |
| Matthew Cavaness | 0 | 23 | 0 | 0 | 0 | 0 | 0 | 0 |
| Orlando Alston | 116 | 28 | 5 | 8 | 2 | 14 | 0 | 87 |
| Oscar Pulido | 13 | 20 | 0 | 0 | 7 | 5 | 0 | 1 |
| Pedro Barrera | 96 | 31 | 6 | 2 | 1 | 7 | 0 | 80 |
| Robert Faust | 30 | 0 | 11 | 8 | 0 | 5 | 0 | 6 |
| Shane Inman | 94 | 66 | 23 | 26 | 4 | 17 | 6 | 18 |
| Will Goodwin | 161 | 53 | 9 | 10 | 4 | 69 | 0 | 69 |
| STORE TOTAL | 1056 | 467 | 115 | 105 | 27 | 162 | 34 | 613 |
10 oldest unanswered pings (bucket = Never, i.e. fresh sync + no human outbound found since)
| Rep | Customer | Ping at | Age | What the ping was about |
|---|---|---|---|---|
| Shane Inman | Brand Bee | 2026-09-11T13:10:32.633Z | 9d 11h | (reply detected via email — text unavailable) |
| Shane Inman | Brand Bee | 2026-09-11T17:36:07.519Z | 9d 7h | Email reply from prospect: Send me the link On Sep 11, 2026, at 06:10, Will Robbins wrobbins@leifjohnsonfordmanor.com wrote: Brand, glad you |
| Shane Inman | Brand Bee | 2026-09-11T18:08:14.534Z | 9d 6h | (reply detected via email — text unavailable) |
| Shane Inman | Brand Bee | 2026-09-11T18:44:05.087Z | 9d 6h | (reply detected via email — text unavailable) |
| Shane Inman | Brand Bee | 2026-09-11T19:30:13.245Z | 9d 5h | (reply detected via email — text unavailable) |
| Shane Inman | Brand Bee | 2026-09-11T20:04:07.399Z | 9d 4h | (reply detected via email — text unavailable) |
| Henry Smith | Braedan Hatch | 2026-09-16T21:12:02.604Z | 4d 3h | Inbound Text Message: Yeah I like that body style |
| Cesar Hernandez Jr | Carlos Guzman | 2026-09-17T20:45:59.576Z | 3d 4h | Inbound Text Message: Me puedes mandar fotos |
| Cesar Hernandez Jr | Carlos Guzman | 2026-09-17T21:18:00.432Z | 3d 3h | (reply detected via text — text unavailable) |
| Cesar Hernandez Jr | Carlos Guzman | 2026-09-17T21:50:01.085Z | 3d 3h | (reply detected via text — text unavailable) |