Rep Ping Scorecard — last 14 days
Generated 2026-10-26T11:40:02.638Z. Window: 2026-10-12T11:40:02.638Z -> 2026-10-26T11:40:02.638Z.
data/store/leads.json last synced: 2026-10-26T11:39:42.820Z.
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.
12 reply-ledger event(s) in-window had no matching leads.json record (skipped — can't attribute). 30 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, Christopher Tait, Daniel Arce, Gary Brophy, Kendra Parrish, Malachi Betancourth, Manuel Bran, Michael Naszkiewicz, Ramon Silos, Ryan Forbus, Sujey Bello — 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 | 12 | 14 | 4 | 0 | 0 | 0 | 0 | 8 |
| Cesar Hernandez Jr | 20 | 23 | 10 | 3 | 0 | 5 | 0 | 2 |
| Edward Cavaness | 84 | 17 | 11 | 21 | 28 | 23 | 1 | 0 |
| Emely Tellez | 49 | 19 | 9 | 4 | 2 | 20 | 6 | 8 |
| Eric French | 0 | 41 | 0 | 0 | 0 | 0 | 0 | 0 |
| Gary Brophy | 11 | 0 | 3 | 2 | 0 | 6 | 0 | 0 |
| Henry Smith | 32 | 15 | 10 | 4 | 3 | 1 | 0 | 14 |
| La Marcus Burnette | 89 | 15 | 11 | 10 | 9 | 28 | 0 | 31 |
| Matthew Cavaness | 2 | 92 | 0 | 0 | 0 | 0 | 0 | 2 |
| Orlando Alston | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 0 |
| Oscar Pulido | 0 | 58 | 0 | 0 | 0 | 0 | 0 | 0 |
| Pedro Barrera | 39 | 24 | 6 | 3 | 4 | 16 | 0 | 10 |
| Richard Martinez | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 |
| Shane Inman | 110 | 59 | 23 | 25 | 5 | 7 | 0 | 50 |
| Tariq Halawani | 61 | 26 | 13 | 8 | 11 | 24 | 0 | 5 |
| Will Goodwin | 27 | 27 | 1 | 0 | 0 | 22 | 0 | 4 |
| STORE TOTAL | 537 | 445 | 102 | 80 | 62 | 152 | 7 | 134 |
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 |
|---|---|---|---|---|
| Edward Cavaness | Sandra Clarke | 2026-10-13T16:28:33.806Z | 12d 19h | Email reply from prospect: I would like to know the history and accidents if possible on this vehicle pleaseOn Tue, Oct 13, 2026 at 8:44AM W |
| Emely Tellez | Daniel Trowell | 2026-10-23T19:21:52.789Z | 2d 16h | Inbound Text Message: This number is not set up for texting. |
| Emely Tellez | Daniel Trowell | 2026-10-23T20:01:58.292Z | 2d 15h | (reply detected via unknown channel — text unavailable) |
| Emely Tellez | Daniel Trowell | 2026-10-23T20:38:10.550Z | 2d 15h | (reply detected via unknown channel — text unavailable) |
| Emely Tellez | Daniel Trowell | 2026-10-23T21:17:28.072Z | 2d 14h | (reply detected via unknown channel — text unavailable) |
| Emely Tellez | Daniel Trowell | 2026-10-23T21:55:26.412Z | 2d 13h | (reply detected via unknown channel — text unavailable) |
| Emely Tellez | Daniel Trowell | 2026-10-23T22:31:53.771Z | 2d 13h | (reply detected via unknown channel — text unavailable) |