Rep Weekly Scorecard — 2026-10-12
Window: last 7 days (2026-10-05 to 2026-10-12), 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-10-12T11:05:41.047Z
- vs-sold.json synced: 2026-10-12T11:05:40.691Z
- leads.json synced: 2026-10-12T11:39:35.137Z
- 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 | 5 | n/a | 2 | 2 | 2 | 40% | +4 |
| Henry Smith | 3 | n/a | 2 | 1 | 1 | 67% | -1 |
| La Marcus Burnette | 2 | n/a | 0 | 0 | 1 | 0% | -1 |
| Pedro Barrera | 4 | n/a | 1 | 0 | 2 | 25% | +4 |
| Will Goodwin | 3 | n/a | 3 | 3 | 0 | 100% | ±0 |
| Shane Inman | 7 | n/a | 4 | 3 | 2 | 57% | +2 |
| Edward Cavaness | 2 | n/a | 1 | 1 | 1 | 50% | -1 |
| Emely Tellez | 2 | n/a | 2 | 2 | 0 | 100% | -1 |
| Orlando Alston | 0 | n/a | 0 | 0 | 0 | n/a | ±0 |
| Cesar Hernandez Jr | 5 | n/a | 2 | 0 | 3 | 40% | +4 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 | n/a | ±0 |
| Javier Choraifi | 0 | n/a | 0 | 0 | 0 | n/a | -1 |
| Tariq Halawani | 4 | n/a | 4 | 2 | 0 | 100% | +2 |
| Roster total | 37 | n/a | 21 | 14 | 12 | 57% | +11 |
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 | 2 | 4 | 4 | 9 | 10 |
| Henry Smith | 73 | 4 | 57 | 55 | 22 |
| La Marcus Burnette | 62 | 17 | 84 | 42 | 35 |
| Pedro Barrera | 158 | 48 | 149 | 76 | 19 |
| Will Goodwin | 59 | 27 | 75 | 39 | 16 |
| Shane Inman | 144 | 42 | 213 | 86 | 38 |
| Edward Cavaness | 57 | 6 | 112 | 31 | 15 |
| Emely Tellez | 59 | 4 | 69 | 24 | 10 |
| Orlando Alston | 1 | 0 | 3 | 3 | 2 |
| Cesar Hernandez Jr | 50 | 14 | 40 | 20 | 9 |
| Richard Martinez | 0 | 0 | 0 | 5 | 4 |
| Javier Choraifi | 3 | 0 | 10 | 2 | 2 |
| Tariq Halawani | 62 | 11 | 23 | 29 | 14 |
| Roster total | 730 | 177 | 839 | 421 | 196 |
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 | 6 | 0m | 6 | 5 | 0 |
| Henry Smith | 61 | 9m | 61 | 2 | 0 |
| La Marcus Burnette | 43 | 9m | 43 | 0 | 0 |
| Pedro Barrera | 99 | 3m | 99 | 2 | 0 |
| Will Goodwin | 51 | 18m | 50 | 11 | 1 |
| Shane Inman | 95 | 8m | 95 | 9 | 0 |
| Edward Cavaness | 36 | 28m | 36 | 2 | 0 |
| Emely Tellez | 49 | 19m | 49 | 5 | 0 |
| Orlando Alston | 1 | n/a | 1 | 1 | 0 |
| Cesar Hernandez Jr | 39 | 10m | 39 | 5 | 0 |
| Richard Martinez | 3 | n/a | 3 | 3 | 0 |
| Javier Choraifi | 7 | 4m | 7 | 2 | 0 |
| Tariq Halawani | 47 | 8m | 47 | 1 | 0 |
| Roster total | 537 | 9m | 536 | 48 | 1 |
4. Unmatched message samples on assigned leads (actual author unverified, most recent 3)
Ajay Malani
- 2026-10-11 14:07 — "Email auto response:"
- 2026-10-11 11:06 — "Email auto response:"
- 2026-10-09 23:15 — "Outbound Text Message: Text it here Reply STOP to cancel."
Henry Smith
- 2026-10-10 17:30 — "Email auto response:"
- 2026-10-10 16:52 — "Email auto response:"
- 2026-10-09 20:40 — "Outbound Text Message: I completely understand, we're here to help in any way we can!"
La Marcus Burnette
- 2026-10-10 17:47 — "Outbound Text Message: The 2015 sold, but I would love to put you into something else if it's still an option."
- 2026-10-10 14:57 — "Email reply to prospect: Thanks for confirming, Vince. The 2024 F-150 XL is still showing as available. I’d be happy to verify everything on the truck before you make the drive from Jacksboro. Is ther"
- 2026-10-10 14:04 — "Outbound Text Message: I totally understand, were you looking for a specific color and are you replacing a vehicle?"
Pedro Barrera
- 2026-10-10 20:38 — "Email reply to prospect: Hey Carlos, It's Pedro with Leif Johnson Ford of Manor. I just noticed the business application I had sent over previously was not the right file type. So sorry about the "
- 2026-10-10 20:35 — "Outbound Text Message: Alexander, this is Eric French with Leif Johnson Ford of Manor. I'm one of the managers here. Are you going to make it for your appointment this afternoon? I'll have the 24 Silv"
- 2026-10-10 20:24 — "Outbound Text Message: Yessir of course!"
Will Goodwin
- 2026-10-10 20:46 — "Outbound Text Message: We need to confirm your Social Security number"
- 2026-10-10 20:41 — "Outbound Text Message: Can you take a phone call real quick "
- 2026-10-10 20:11 — "Email auto response:"
Shane Inman
- 2026-10-10 23:49 — "Outbound Text Message: Thank you sir, after talking to my higher ups it appears we cannot accept vehicles with a title loan unfortunately.. that being said, we may still be able to get you approved on"
- 2026-10-10 23:04 — "Outbound Text Message: Awesome thank you! Any photos you can send us to help with the appraisal?"
- 2026-10-10 21:54 — "Email auto response:"
Edward Cavaness
- 2026-10-10 20:23 — "Outbound Text Message: Cynthia, this is Eric French at Leif Johnson Ford. I'm one of the sales managers here. What is the monthly payment range are you trying to budget for?"
- 2026-10-10 20:06 — "Outbound Text Message: I do have this one available let me know what you think? https://www.leifjohnsonfordofmanor.com/vehicle/3FTTW8JA4SRB69684/Used-2025-Ford-Maverick-Buda-TX/" [FLAG: other-store name]
- 2026-10-10 19:56 — "Outbound Text Message: Hey Cynthia, sorry for the late response. As soon as our porters arrived at our sister store, we were told the truck had already been sold. Is that the only truck you’re interes"
Emely Tellez
- 2026-10-10 20:25 — "Outbound Text Message: Hola Maide, ¡buenos días! 😊 Solo quería saber si has tenido oportunidad de pasar por la agencia. Aquí estoy para ayudarte cuando estés lista. ¡Gracias!"
- 2026-10-10 16:32 — "Outbound Text Message: Lawrence, this is Eric French at Leif Johnson Ford Manor. I'm one of the sales managers here. How can I help you with this vehicle?"
- 2026-10-10 16:08 — "Outbound Text Message: okay see you soon"
Orlando Alston
- 2026-10-05 15:05 — "Outbound Text Message: Audrey you do have a $2000 private offer from Ford Gary Leif Johnson Ford Manor Reply STOP to cancel."
Cesar Hernandez Jr
- 2026-10-11 21:41 — "Email auto response:"
- 2026-10-10 23:36 — "Outbound Text Message: perfect, Monday at 11:00 am ?"
- 2026-10-10 23:13 — "Outbound Text Message: https://www.leifjohnsonfordofmanor.com/vehicle/JTJBJRBZ5K2098890/Used-2019-Lexus-NX-Manor-TX/"
Richard Martinez
- (no unmatched text/email outbound observed this week)
Javier Choraifi
- 2026-10-05 19:51 — "Outbound Text Message: How does this one look?"
- 2026-10-05 19:38 — "Outbound Text Message: https://www.leifjohnsonfordofmanor.com/vehicle/3C6UR5PL4RG162783/Used-2024-RAM-2500-Austin-TX/" [FLAG: other-store name]
- 2026-10-05 19:35 — "Outbound Text Message: Hey Eric, this is LaMarcus with Leif Johnson Ford. I saw your notes on the Ram 2500. I understand you’re looking for the longer cab/bed configuration, a 3-inch lift, and trying "
Tariq Halawani
- 2026-10-10 21:58 — "Outbound Text Message: Hey Joshua! This is Matt, one of the sales managers at Leif Johnson Ford of Manor. I saw you picked out the 2026 F-150 STX in Avalanche, great choice! I’d love to have you come "
- 2026-10-10 19:37 — "Outbound Text Message: I just sent your build to my manager. I will sent you the quote as soon as he confirms it with Ford."
- 2026-10-10 19:00 — "Outbound Text Message: if you are ready to go with your build, let me know so I can confirm it with my manager and start the allocation proses for you."
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 (4508 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 | 6 | 95 | 3 | n/a |
| Henry Smith | 4 | 59 | 2 | n/a |
| La Marcus Burnette | 8 | 111 | 0 | n/a |
| Pedro Barrera | 7 | 68 | 0 | n/a |
| Will Goodwin | 9 | 81 | 4 | n/a |
| Shane Inman | 15 | 83 | 4 | n/a |
| Edward Cavaness | 4 | 34 | 1 | n/a |
| Emely Tellez | 4 | 56 | 4 | n/a |
| Orlando Alston | 2 | 37 | 0 | n/a |
| Cesar Hernandez Jr | 12 | 7 | 0 | n/a |
| Richard Martinez | 0 | 5 | 0 | n/a |
| Javier Choraifi | 3 | 2 | 0 | n/a |
| Tariq Halawani | 9 | 6 | 4 | n/a |
| Roster total | 83 | 644 | 22 | 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.