Rep Weekly Scorecard — 2026-11-02
Window: last 7 days (2026-10-26 to 2026-11-02), 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-02T12:05:37.835Z
- vs-sold.json synced: 2026-11-02T12:05:37.550Z
- leads.json synced: 2026-11-02T12:36:37.427Z
- 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 | 4 | n/a | 4 | 2 | 0 | 100% | -3 |
| Henry Smith | 2 | n/a | 0 | 0 | 1 | 0% | -1 |
| La Marcus Burnette | 8 | n/a | 7 | 1 | 1 | 88% | +3 |
| Pedro Barrera | 3 | n/a | 2 | 1 | 0 | 67% | +1 |
| Will Goodwin | 5 | n/a | 2 | 0 | 3 | 40% | +3 |
| Shane Inman | 5 | n/a | 2 | 0 | 2 | 40% | +2 |
| Edward Cavaness | 3 | n/a | 3 | 2 | 0 | 100% | ±0 |
| Emely Tellez | 4 | n/a | 2 | 1 | 0 | 50% | +3 |
| Cesar Hernandez Jr | 1 | n/a | 1 | 0 | 0 | 100% | -2 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 | n/a | ±0 |
| Tariq Halawani | 9 | n/a | 4 | 1 | 3 | 44% | +2 |
| Roster total | 44 | n/a | 27 | 8 | 10 | 61% | +8 |
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 | 7 | 0 | 6 | 12 | 11 |
| Henry Smith | 77 | 10 | 76 | 41 | 22 |
| La Marcus Burnette | 57 | 16 | 79 | 20 | 12 |
| Pedro Barrera | 120 | 26 | 117 | 38 | 19 |
| Will Goodwin | 48 | 14 | 88 | 25 | 8 |
| Shane Inman | 101 | 45 | 130 | 47 | 20 |
| Edward Cavaness | 34 | 7 | 98 | 16 | 13 |
| Emely Tellez | 76 | 3 | 93 | 22 | 9 |
| Cesar Hernandez Jr | 23 | 5 | 23 | 26 | 11 |
| Richard Martinez | 0 | 0 | 0 | 0 | 0 |
| Tariq Halawani | 141 | 12 | 100 | 38 | 22 |
| Roster total | 684 | 138 | 810 | 285 | 147 |
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 | 16 | 10m | 14 | 4 | 2 |
| Henry Smith | 48 | 2m | 48 | 7 | 0 |
| La Marcus Burnette | 52 | 10m | 52 | 8 | 0 |
| Pedro Barrera | 81 | 13m | 81 | 6 | 0 |
| Will Goodwin | 36 | 6m | 36 | 6 | 0 |
| Shane Inman | 54 | 21m | 54 | 1 | 0 |
| Edward Cavaness | 37 | 9m | 37 | 11 | 0 |
| Emely Tellez | 47 | 14m | 47 | 6 | 0 |
| Cesar Hernandez Jr | 19 | 34m | 19 | 6 | 0 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 |
| Tariq Halawani | 77 | 5m | 77 | 6 | 0 |
| Roster total | 467 | 9m | 465 | 61 | 2 |
4. Unmatched message samples on assigned leads (actual author unverified, most recent 3)
Ajay Malani
- 2026-10-31 20:58 — "Outbound Text Message: You have successfully been removed from Riata Ford text messages."
- 2026-10-30 22:44 — "Outbound Text Message: Thanks for the update, Valerie."
- 2026-10-27 18:18 — "Outbound Text Message: checking can you also unlock Transunion Ford is tiering you at a higher rate right now let me check with 4k down see if we can get you the lower rate"
Henry Smith
- 2026-11-01 02:44 — "Email auto response:"
- 2026-10-31 16:01 — "Outbound Text Message: Hey Joe! 🎃 Matt here, one of the Sales Managers at Leif Johnson Ford of Manor. I wanted to check back in on that F-150 Platinum! I know we're still trying to close the gap on p"
- 2026-10-31 01:55 — "Email auto response:"
La Marcus Burnette
- 2026-10-31 17:03 — "Outbound Text Message: Hey Daniel, is that what you are looking for?"
- 2026-10-31 15:50 — "Outbound Text Message: https://www.leifjohnsonfordofmanor.com/vehicle/1FA6P8R06T5502516/2026-Ford-Mustang-Austin-TX/?_gl=11bd0v2d_upMQ.._gaMTA3ODYzMjY3Mi4xNzkzNDYxNzky_ga_D1YYBMNHP7*czE3OTM0NjE3" [FLAG: other-store name]
- 2026-10-31 15:50 — "Outbound Text Message: https://www.windowsticker.forddirect.com/windowsticker.pdf?token=Ox0zEhln0Oo5kCT0DF34NYigi8atmlky2wDk588JDFvSAoDn60N%2FhMaL1w%2FnjTDS1cv0%2FcmHEZKHt3%2F75zasZwwLZoUcR0sbTHB5cVQm"
Pedro Barrera
- 2026-11-01 17:41 — "Email auto response:"
- 2026-10-31 21:00 — "Outbound Text Message: Hey Osagie, It's Pedro with Leif Johnson Ford of Manor. Are you still interested in getting an offer on your Suburban?"
- 2026-10-31 19:53 — "Outbound Text Message: Thank you."
Will Goodwin
- 2026-11-01 23:48 — "Email auto response:"
- 2026-11-01 13:07 — "Email auto response:"
- 2026-10-31 23:26 — "Email auto response:"
Shane Inman
- 2026-11-01 13:12 — "Email auto response:"
- 2026-10-31 22:23 — "Outbound Text Message: my cell is 5127021802"
- 2026-10-31 22:23 — "Outbound Text Message: https://www.leifjohnsonfordofmanor.com/finance-application/"
Edward Cavaness
- 2026-11-01 13:06 — "Email auto response:"
- 2026-10-31 19:07 — "Outbound Text Message: You bet! Enjoy your weekend!"
- 2026-10-31 18:51 — "Outbound Text Message: Dice mi manager de finance como es pre approval necesitamos llamarle al banco de chase para darle la nueva informacion de la ranger raptor. dice que si puedes llenar la applicas"
Emely Tellez
- 2026-10-31 18:23 — "Outbound Text Message: Sounds good sir if anything changes on your end let us know were here to help."
- 2026-10-31 14:39 — "Outbound Text Message: Good morning, Nestor! Just wanted to give you a quick update. The rain has slowed down the process, but they’re working on it right now. That’s why it’s taking a little longer t"
- 2026-10-31 03:00 — "Outbound Text Message: Hey sir I am very sorry for the late response I didn't want you to drive all way the here in the morning but I am being told the truck is no longer available."
Cesar Hernandez Jr
- 2026-10-30 20:17 — "Outbound Text Message: Here is a video of the King Ranch"
- 2026-10-30 20:17 — "Outbound Text Message: https://vidmails.com/v/O9cjYikQaT"
- 2026-10-30 15:54 — "Email reply to prospect: Benjamin, Hi, Benjamin. I was just following up on your visit from a few weeks back regarding the Mazda Mazda3. Did you have any additional questions that you may have come up"
Richard Martinez
- (no unmatched text/email outbound observed this week)
Tariq Halawani
- 2026-10-31 23:12 — "Outbound Text Message: Loan to value is defiantly hearting you. Do you possibly have cosigner with good credit or more money down 3-4K?"
- 2026-10-31 23:02 — "Outbound Text Message: actual miles"
- 2026-10-31 22:59 — "Outbound Text Message: who is it financed by?"
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 (5023 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 | 5 | 94 | 2 | n/a |
| Henry Smith | 8 | 64 | 1 | n/a |
| La Marcus Burnette | 8 | 99 | 1 | n/a |
| Pedro Barrera | 8 | 58 | 2 | n/a |
| Will Goodwin | 8 | 82 | 1 | n/a |
| Shane Inman | 9 | 85 | 2 | n/a |
| Edward Cavaness | 5 | 33 | 2 | n/a |
| Emely Tellez | 8 | 54 | 1 | n/a |
| Cesar Hernandez Jr | 4 | 13 | 0 | n/a |
| Richard Martinez | 0 | 1 | 1 | n/a |
| Tariq Halawani | 13 | 8 | 1 | n/a |
| Roster total | 76 | 591 | 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.