Rep Ping Scorecard — last 14 days
Generated 2026-10-17T20:09:27.086Z. Window: 2026-10-03T20:09:27.086Z -> 2026-10-17T20:09:27.086Z.
data/store/leads.json last synced: 2026-10-17T20:08:41.535Z.
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.
24 reply-ledger event(s) in-window had no matching leads.json record (skipped — can't attribute). 7 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 | 23 | 11 | 2 | 0 | 0 | 11 | 5 | 5 |
| Cesar Hernandez Jr | 40 | 34 | 17 | 6 | 3 | 11 | 0 | 3 |
| Edward Cavaness | 95 | 24 | 10 | 17 | 29 | 32 | 0 | 7 |
| Emely Tellez | 120 | 22 | 20 | 14 | 6 | 40 | 0 | 40 |
| Eric French | 0 | 39 | 0 | 0 | 0 | 0 | 0 | 0 |
| Gary Brophy | 11 | 0 | 3 | 2 | 0 | 6 | 0 | 0 |
| Henry Smith | 30 | 29 | 12 | 7 | 5 | 4 | 0 | 2 |
| La Marcus Burnette | 82 | 19 | 12 | 15 | 4 | 20 | 0 | 31 |
| Matthew Cavaness | 0 | 51 | 0 | 0 | 0 | 0 | 0 | 0 |
| Orlando Alston | 10 | 10 | 1 | 0 | 0 | 1 | 0 | 8 |
| Oscar Pulido | 3 | 62 | 2 | 1 | 0 | 0 | 0 | 0 |
| Pedro Barrera | 50 | 38 | 15 | 8 | 4 | 9 | 1 | 13 |
| Richard Martinez | 18 | 4 | 1 | 0 | 0 | 17 | 0 | 0 |
| Shane Inman | 136 | 71 | 22 | 25 | 5 | 18 | 2 | 64 |
| Tariq Halawani | 35 | 26 | 9 | 6 | 3 | 10 | 3 | 4 |
| Will Goodwin | 36 | 33 | 4 | 1 | 0 | 3 | 13 | 15 |
| STORE TOTAL | 689 | 473 | 130 | 102 | 59 | 182 | 24 | 192 |
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 |
|---|---|---|---|---|
| Will Goodwin | Joe Loza | 2026-10-10T22:07:28.119Z | 6d 22h | Email reply from prospect: i'm still in the market but i'm looking for a new one king ranch dually ruby red and the best price On Sa |
| Will Goodwin | Joe Loza | 2026-10-11T15:07:42.197Z | 6d 5h | Email reply from prospect: i dont have a timeline just once i find the right truck and right price i'll buy On Saturday, October 10, 202 |
| Will Goodwin | Joe Loza | 2026-10-11T15:40:09.173Z | 6d 4h | (reply detected via email — text unavailable) |
| Shane Inman | Jose Lopez | 2026-10-12T14:43:41.227Z | 5d 5h | Inbound Text Message: No but i have it |
| Shane Inman | Jose Lopez | 2026-10-12T15:16:10.011Z | 5d 4h | (reply detected via text — text unavailable) |
| Ajay Malani | Billie Spence | 2026-10-12T16:24:45.685Z | 5d 3h | Inbound Text Message: Yes if you could find me one in that same price range |
| Will Goodwin | Joe Loza | 2026-10-13T01:17:58.173Z | 4d 18h | Email reply from prospect: i'm not sure what option matters most On Monday, October 12, 2026 at 08:17:43 PM CDT, Will Robbins wrobbins@l |
| Will Goodwin | Joe Loza | 2026-10-13T02:02:29.129Z | 4d 18h | (reply detected via email — text unavailable) |
| Will Goodwin | Joe Loza | 2026-10-13T02:47:58.704Z | 4d 17h | (reply detected via email — text unavailable) |
| Will Goodwin | Joe Loza | 2026-10-14T01:04:04.345Z | 3d 19h | Email reply from prospect: i tow a fifth wheel and stock trailer so it would be nice to have the gooseneck/fifth wheel tow package and upfit |