Rep Weekly Scorecard — 2026-10-26
Window: last 7 days (2026-10-19 to 2026-10-26), 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-26T11:05:38.894Z
- vs-sold.json synced: 2026-10-26T11:05:38.615Z
- leads.json synced: 2026-10-26T11:39:42.820Z
- 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 | 7 | n/a | 7 | 6 | 0 | 100% | +3 |
| Henry Smith | 3 | n/a | 2 | 2 | 1 | 67% | -1 |
| La Marcus Burnette | 5 | n/a | 2 | 1 | 3 | 40% | +2 |
| Pedro Barrera | 2 | n/a | 1 | 0 | 0 | 50% | -3 |
| Will Goodwin | 2 | n/a | 1 | 1 | 1 | 50% | -2 |
| Shane Inman | 3 | n/a | 1 | 0 | 1 | 33% | -4 |
| Edward Cavaness | 3 | n/a | 1 | 0 | 2 | 33% | -3 |
| Emely Tellez | 1 | n/a | 0 | 0 | 0 | 0% | ±0 |
| Orlando Alston | 0 | n/a | 0 | 0 | 0 | n/a | -1 |
| Cesar Hernandez Jr | 3 | n/a | 3 | 3 | 0 | 100% | -1 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 | n/a | ±0 |
| Tariq Halawani | 7 | n/a | 4 | 1 | 2 | 57% | +3 |
| Roster total | 36 | n/a | 22 | 14 | 10 | 61% | -7 |
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 | 1 | 1 | 1 | 17 | 11 |
| Henry Smith | 61 | 9 | 73 | 43 | 18 |
| La Marcus Burnette | 77 | 21 | 98 | 24 | 14 |
| Pedro Barrera | 140 | 27 | 149 | 38 | 12 |
| Will Goodwin | 30 | 26 | 92 | 30 | 25 |
| Shane Inman | 108 | 38 | 175 | 69 | 25 |
| Edward Cavaness | 51 | 13 | 116 | 28 | 15 |
| Emely Tellez | 53 | 11 | 90 | 24 | 9 |
| Orlando Alston | 0 | 0 | 5 | 4 | 7 |
| Cesar Hernandez Jr | 33 | 3 | 24 | 16 | 14 |
| Richard Martinez | 0 | 0 | 1 | 1 | 0 |
| Tariq Halawani | 135 | 12 | 79 | 33 | 10 |
| Roster total | 689 | 161 | 903 | 327 | 160 |
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 | 5 | 16m | 5 | 2 | 0 |
| Henry Smith | 40 | 14m | 40 | 2 | 0 |
| La Marcus Burnette | 58 | 7m | 58 | 0 | 0 |
| Pedro Barrera | 67 | 8m | 66 | 6 | 1 |
| Will Goodwin | 19 | 7m | 19 | 4 | 0 |
| Shane Inman | 44 | 24m | 44 | 14 | 0 |
| Edward Cavaness | 35 | 14m | 35 | 3 | 0 |
| Emely Tellez | 24 | 6m | 24 | 6 | 0 |
| Orlando Alston | 0 | n/a | 0 | 0 | 0 |
| Cesar Hernandez Jr | 22 | 7m | 22 | 3 | 0 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 |
| Tariq Halawani | 63 | 4m | 63 | 4 | 0 |
| Roster total | 377 | 9m | 376 | 44 | 1 |
4. Unmatched message samples on assigned leads (actual author unverified, most recent 3)
Ajay Malani
- 2026-10-23 20:25 — "Outbound Text Message: When can u come by?"
- 2026-10-22 20:16 — "Email auto response:"
Henry Smith
- 2026-10-25 22:38 — "Email auto response:"
- 2026-10-24 18:44 — "Outbound Text Message: Rachel, this is Eric French with Leif Johnson Ford of Manor. I'm one of the managers here. If you are still interested in a Ranger or a truck simply reply "Yes" to this text."
- 2026-10-24 16:55 — "Email auto response:"
La Marcus Burnette
- 2026-10-24 23:39 — "Outbound Text Message: https://www.leifjohnsonfordofmanor.com/finance-application/?_gl=1fc3alw_upMQ.._gaODA5NjMwNjMuMTc5Mjg4MjU1Ng.._ga_D1YYBMNHP7*czE3OTI4ODI1NTYkbzEkZzAkdDE3OTI4ODUwMzkkajYwJGw"
- 2026-10-24 22:53 — "Email auto response:"
- 2026-10-24 17:47 — "Outbound Text Message: Hey Brody, checking in to see how I can help find you a truck"
Pedro Barrera
- 2026-10-24 23:30 — "Outbound Text Message: Yes ma'am so sorry, I thought I had sent them over yesterday. So right now, we do have 2 on the lot that are Hybrid Lariats with the 4k tow package. One is Ruby Red Metallic, an"
- 2026-10-24 23:27 — "Outbound Text Message: Hey Brian, it’s Pedro with Leif Johnson Ford of Manor! Just checking in on your Explorer ST search. Are you still looking for one, or have you gone a different direction? I’m ha"
- 2026-10-24 23:15 — "Outbound Text Message: Hey William, Pedro with Leif Johnson Ford of Manor. I'd love a chance to check out your current F-150 King Ranch and see what we can do for you!"
Will Goodwin
- 2026-10-24 18:50 — "Outbound Text Message: Robert, this is Eric French with Leif Johnson Ford of Manor. I'm one of the managers here. If you are still interested in a new vehicle, simply reply "Yes" to this text."
- 2026-10-24 18:09 — "Email auto response:"
- 2026-10-24 13:36 — "Outbound Text Message: Good morning Mark are you still coming in today to look at some F150s Ford just updated their rates. I have rates as low as 1.9 and 3.9"
Shane Inman
- 2026-10-25 01:02 — "Email auto response:"
- 2026-10-24 21:43 — "Outbound Text Message: Hey Alexis, it's Shane at Leif Johnson Ford Manor! 🤠 I wanted to reach out because we have access to different Mustang options, and I’d hate for you to miss out if you're still"
- 2026-10-24 21:35 — "Outbound Text Message: Hey Jazmine, it's Shane at Leif Johnson Ford Manor! I wanted to check in and see if anything has changed with your Bronco search. We get new vehicles in regularly, so if you're "
Edward Cavaness
- 2026-10-25 12:01 — "Email auto response:"
- 2026-10-24 22:31 — "Outbound Text Message: https://images.vinsolutions.com/texting/short/c576c44d-c2b7-4dec-9d4a-0df48c777194"
- 2026-10-24 22:17 — "Email reply to prospect: Good afternoon Ted this is Edward from Leif Johnson Ford of Manor. I wanted to let you know we don't have any 2024 Lightnings in stock at the moment but I do have a 2023 F"
Emely Tellez
- 2026-10-24 19:11 — "Email reply to prospect: Hi Rogelio, I wanted to check in regarding your 2022 Lexus IS 500 F SPORT Launch Edition. We’re very interested in your vehicle and would love the opportunity to provide you w"
- 2026-10-24 18:53 — "Outbound Text Message: Christina, this is Eric French with Leif Johnson Ford of Manor. I'm one of the managers here. If you are still interested in a new or pre-owned vehicle, simply reply "Yes" to th"
- 2026-10-24 17:32 — "Outbound Text Message: Hola, Javier. Solo le mando un mensaje para saber si todavía está interesado en cambiar su camioneta con nosotros. Reply STOP to cancel."
Orlando Alston
- (no unmatched text/email outbound observed this week)
Cesar Hernandez Jr
- 2026-10-24 20:45 — "Outbound Text Message: Bryson, this is Eric French with Leif Johnson Ford of Manor. I'm one of the managers here. If you are still interested in a new or pre-owned vehicle, simply reply "Yes" to this "
- 2026-10-24 19:20 — "Outbound Text Message: Angelo, this is Eric French with Leif Johnson Ford of Manor. I'm one of the managers here. If you are still interested in a new or pre-owned vehicle, simply reply "Yes" to this "
- 2026-10-23 23:04 — "Outbound Text Message: https://www.leifjohnsonfordofmanor.com/finance-application/?_gl=11ucduce_upMQ.._gaMTQ2MDAzMTg2Ni4xNzkyNzk2MzUw_ga_D1YYBMNHP7*czE3OTI3OTYzNDkkbzEkZzAkdDE3OTI3OTY2MzQkajYwJG"
Richard Martinez
- (no unmatched text/email outbound observed this week)
Tariq Halawani
- 2026-10-25 00:43 — "Email auto response:"
- 2026-10-25 00:03 — "Outbound Text Message: Hay Robert, are you still in the market for an F-150 Lariat? Let me know how I can assist."
- 2026-10-24 23:33 — "Outbound Text Message: https://www.leifjohnsonford.com/vehicle/1FT8W2BT1REE57470/Used-2024-Ford-Super_Duty_F--250-Austin-TX/?_gl=11um7ks5_upMQ.._gaMzE3OTE4MTEuMTc5Mjg4NDc2NQ.._ga_G8G4HBH01T*czE3" [FLAG: other-store name]
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 (4892 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 | 96 | 7 | n/a |
| Henry Smith | 8 | 64 | 4 | n/a |
| La Marcus Burnette | 12 | 97 | 1 | n/a |
| Pedro Barrera | 5 | 57 | 0 | n/a |
| Will Goodwin | 5 | 82 | 1 | n/a |
| Shane Inman | 11 | 86 | 0 | n/a |
| Edward Cavaness | 10 | 33 | 1 | n/a |
| Emely Tellez | 5 | 52 | 1 | n/a |
| Orlando Alston | 0 | 27 | 0 | n/a |
| Cesar Hernandez Jr | 3 | 11 | 4 | n/a |
| Richard Martinez | 0 | 1 | 0 | n/a |
| Tariq Halawani | 11 | 5 | 1 | n/a |
| Roster total | 76 | 611 | 20 | 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.