Rep Weekly Scorecard — 2026-11-09
Window: last 7 days (2026-11-02 to 2026-11-09), compared to the prior 7 days. Read-only — no CRM login, no messages sent, no memory writes.
Not an individual-performance or live unanswered-customer score: the source has no message author. Activity is grouped by the lead's current assigned rep, not who sent the message. Unmatched outbound can include managers, other staff or automation absent from the retained log. Inbound counts are messages, not unique customers; reactions, system notices, opt-outs and closed records have not been adjudicated. Review live history before coaching or contact. Totals below cover the named roster only, not necessarily the whole store.
Data freshness
- vs-appointments.json synced: 2026-11-09T15:42:10.438Z
- vs-sold.json synced: 2026-11-09T15:42:09.952Z
- leads.json synced: 2026-11-09T15:34:44.468Z
- message-log.json capped at 2000 entries (oldest pruned first). Matched/unmatched means only a same-customer timestamp match within 5 minutes, not verified authorship. Unmatched is NOT proof of a human send.
What this can't prove: appointment status has only SET/COMPLETED/CANCELLED/MISSED in the source data — there is no separate "confirmed" signal, so the Confirmed column is not measurable and is reported as "n/a" for every rep, not zero. "Showed" = COMPLETED, "No-show" = MISSED. Sold-from-appointment is gcid-matched against vs-sold.json with no date window (sales can lag the appointment by weeks), so it can overcount a rep who later sold that customer on an unrelated visit. Gross is not available in axcessa-cardeals.json or the delivery tracker sheet snapshot — neither carries a gross/profit field — so gross is omitted, not estimated as zero. Appointment counts are windowed by appointmentUtc (the appointment's own calendar date) — activityDateTimeUtc in the source data carries dates years earlier than the appointment itself (looks like a stale/unrelated creation timestamp, e.g. 2023 on a Sept 2026 appointment) and isn't used for windowing.
1. Appointments
| Assigned rep | Scheduled in window | Confirmed | Completed | Customer has sold record (any date) | Missed | Completed/scheduled | Δ scheduled (prior wk) |
|---|---|---|---|---|---|---|---|
| Ajay Malani | 2 | n/a | 2 | 2 | 0 | 100% | -2 |
| Henry Smith | 4 | n/a | 3 | 2 | 1 | 75% | +2 |
| La Marcus Burnette | 6 | n/a | 6 | 0 | 0 | 100% | -1 |
| Pedro Barrera | 3 | n/a | 1 | 1 | 1 | 33% | ±0 |
| Will Goodwin | 3 | n/a | 2 | 1 | 1 | 67% | -2 |
| Shane Inman | 1 | n/a | 0 | 0 | 0 | 0% | -4 |
| Edward Cavaness | 4 | n/a | 3 | 2 | 1 | 75% | +2 |
| Emely Tellez | 3 | n/a | 1 | 1 | 2 | 33% | -1 |
| Cesar Hernandez Jr | 1 | n/a | 1 | 1 | 0 | 100% | ±0 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 | n/a | ±0 |
| Tariq Halawani | 9 | n/a | 5 | 0 | 2 | 56% | +1 |
| Roster total | 36 | n/a | 24 | 10 | 8 | 67% | -5 |
2. Activity on assigned leads (machine-log matched vs unmatched; author unverified)
| Assigned rep | Unmatched texts | Unmatched emails | Phone activity | Matched texts | Matched emails |
|---|---|---|---|---|---|
| Ajay Malani | 4 | 1 | 18 | 10 | 4 |
| Henry Smith | 88 | 8 | 75 | 25 | 12 |
| La Marcus Burnette | 71 | 19 | 90 | 7 | 2 |
| Pedro Barrera | 101 | 23 | 138 | 16 | 8 |
| Will Goodwin | 64 | 22 | 133 | 16 | 9 |
| Shane Inman | 64 | 18 | 108 | 30 | 13 |
| Edward Cavaness | 52 | 3 | 118 | 13 | 14 |
| Emely Tellez | 70 | 14 | 106 | 12 | 5 |
| Cesar Hernandez Jr | 36 | 14 | 58 | 22 | 7 |
| Richard Martinez | 0 | 0 | 0 | 0 | 0 |
| Tariq Halawani | 128 | 21 | 172 | 15 | 6 |
| Roster total | 678 | 143 | 1016 | 166 | 80 |
3. Reply-history diagnostic (inbound -> next unmatched outbound; sender unverified)
Only inbound messages observed for at least 24 hours can be counted as 24-hour gaps. Younger unanswered messages are pending, not failures. Gaps are review candidates, not proven unanswered customer requests; phone activity is not proof of a connected conversation.
| Assigned rep | Inbound msgs | Median observed delay | Observed ≥24h | Gaps after 24h (unverified) | Pending <24h |
|---|---|---|---|---|---|
| Ajay Malani | 3 | 42m | 3 | 1 | 0 |
| Henry Smith | 73 | 7m | 72 | 3 | 1 |
| La Marcus Burnette | 56 | 3m | 56 | 2 | 0 |
| Pedro Barrera | 39 | 3m | 39 | 5 | 0 |
| Will Goodwin | 34 | 11m | 34 | 6 | 0 |
| Shane Inman | 29 | 6m | 29 | 6 | 0 |
| Edward Cavaness | 39 | 13m | 39 | 6 | 0 |
| Emely Tellez | 51 | 11m | 51 | 6 | 0 |
| Cesar Hernandez Jr | 13 | 32m | 13 | 3 | 0 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 |
| Tariq Halawani | 49 | 9m | 49 | 5 | 0 |
| Roster total | 386 | 7m | 385 | 43 | 1 |
4. Unmatched message samples on assigned leads (actual author unverified, most recent 3)
Ajay Malani
- 2026-11-08 14:06 — "Email auto response:"
- 2026-11-06 15:08 — "Outbound Text Message: Clay, still looking for a Maverick Lariat? Can you come by Friday or Saturday and I'll show you what we have and what's coming? Will, Leif Johnson Ford of Manor Reply STOP to ca"
- 2026-11-03 23:29 — "Outbound Text Message: We have 3 Jeeps avaiable here is the link for them https://www.leifjohnsonfordofmanor.com/inventory/used-vehicles/models-Jeep/ 2 small trucks ford rangers https://www.leifjohnso"
Henry Smith
- 2026-11-08 22:23 — "Outbound Text Message: How much money are y’all looking to put down?"
- 2026-11-08 22:23 — "Outbound Text Message: Good afternoon Ras, we could look at it multiple ways to see which option works better."
- 2026-11-08 12:24 — "Outbound Text Message: Good morning Ras, we look forward to assisting you Monday morning."
La Marcus Burnette
- 2026-11-07 22:09 — "Outbound Text Message: https://www.leifjohnsonfordofmanor.com/finance-application/?_gl=15h3boi_upMQ.._gaNTI1MzYwNjA4LjE3OTQwODUwODI._ga_D1YYBMNHP7*czE3OTQwODUwODEkbzEkZzAkdDE3OTQwODcyNzUkajYwJGw"
- 2026-11-07 21:37 — "Outbound Text Message: LaMarcus"
- 2026-11-07 21:28 — "Outbound Text Message: Yes. Come over please."
Pedro Barrera
- 2026-11-07 20:05 — "Outbound Text Message: Hi Manuel! We have just announced 2026 model year-end liquidation event. We have HUGE saving on ALL 2026 models. Would you like to set up an appointment to review the savings? G"
- 2026-11-07 19:47 — "Outbound Text Message: Let me know if the link works https://www.leifjohnsonfordofmanor.com/finance-application/"
- 2026-11-07 19:46 — "Outbound Text Message: Hey Malik! It's Pedro with Leif Johnson Ford of Manor. I wanted to touch base and see how things are coming along with getting everything squared away on your end. I know you we"
Will Goodwin
- 2026-11-08 03:34 — "Email auto response:"
- 2026-11-07 18:47 — "Outbound Text Message: Call me at my direct line 737-205-7493. Thanks, Eric"
- 2026-11-07 18:46 — "Outbound Text Message: Mary, this is Eric French at Leif Johnson Ford. I was the sales manager helping you. I called the lender we were working with and was able to lower your interest rate 1 point. S"
Shane Inman
- 2026-11-08 00:06 — "Email auto response:"
- 2026-11-07 21:26 — "Outbound Text Message: Hi Susan, Thanks for the call today. I will verify everything and get back to you."
- 2026-11-07 19:07 — "Outbound Text Message: I'll call you after 2:30pm."
Edward Cavaness
- 2026-11-07 20:40 — "Outbound Text Message: 😂😂 you got it"
- 2026-11-07 20:38 — "Outbound Text Message: One more question from Matt he said do you want to go on as guarantor or just the business itself?"
- 2026-11-07 20:28 — "Outbound Text Message: Thank you Matt is working on your application will let you know shortly."
Emely Tellez
- 2026-11-08 00:26 — "Outbound Text Message: me parece bien el lunes a que hora quieres pasar?"
- 2026-11-07 23:49 — "Outbound Text Message: sin ver la camioneta estamos entre 13mil a 15mil"
- 2026-11-07 23:39 — "Outbound Text Message: cuanto es lo que busca por tu camioneta?"
Cesar Hernandez Jr
- 2026-11-07 17:49 — "Outbound Text Message: No worries, let me know if i can help in a future, Thanks"
- 2026-11-07 17:33 — "Outbound Text Message: Hey Angelo, We just got this beauty. https://www.leifjohnsonfordofmanor.com/vehicle/1FA6P8CF0R5426720/Used-2024-Ford-Mustang-Manor-TX/?_gl=115n9yr6_upMQ.._ga*MTA5MjE0NDEwNC4"
- 2026-11-07 16:04 — "Outbound Text Message: Hi Cody! We have just announced 2026 model year-end liquidation event. We have HUGE saving on ALL 2026 models. Would you like to set up an appointment to review the savings? Giv"
Richard Martinez
- (no unmatched text/email outbound observed this week)
Tariq Halawani
- 2026-11-07 18:55 — "Outbound Text Message: HI Jefry, this is Eric French, sales manager, I was helping you when you were in here. We need pick something out that you want to buy. Choice is yours, so Explorer, Mustang, .."
- 2026-11-07 18:35 — "Outbound Text Message: Feel free to send us the deal for education maybe we’ll beat it "
- 2026-11-07 18:19 — "Outbound Text Message: Did you already make the purchase? I do have plenty of Lariats with the 5.0 engine"
5. Leads worked
"New leads received" uses Date Received (date-only values approximate midnight UTC). "No unmatched outbound in retained notes" covers all locally retained assigned records (5320 total), including historical/closed records and missing history. It does NOT prove zero human contact, current ownership at the time, or an actionable customer.
| Assigned rep | New leads received | No unmatched outbound in retained notes | Sold count | Gross |
|---|---|---|---|---|
| Ajay Malani | 3 | 95 | 2 | n/a |
| Henry Smith | 11 | 63 | 3 | n/a |
| La Marcus Burnette | 11 | 98 | 0 | n/a |
| Pedro Barrera | 6 | 60 | 1 | n/a |
| Will Goodwin | 7 | 85 | 1 | n/a |
| Shane Inman | 3 | 86 | 2 | n/a |
| Edward Cavaness | 7 | 37 | 2 | n/a |
| Emely Tellez | 10 | 56 | 1 | n/a |
| Cesar Hernandez Jr | 5 | 11 | 1 | n/a |
| Richard Martinez | 0 | 1 | 1 | n/a |
| Tariq Halawani | 10 | 9 | 0 | n/a |
| Roster total | 73 | 601 | 14 | n/a |
Gross: not available. Checked data/store/axcessa-cardeals.json (fields: deal, dateSold, dateDealDate, status, saleType, newUsed, stock, vin, year, make, model, vehicle, buyer, buyerRaw, coBuyer, customerNumber, salesmanId, salesman, salesmanRoster, units, commissionMultiple — no gross/profit field) and reports/delivery-tracker/ sheet snapshots (no gross column either). Would need a new source to add this.