Rep Weekly Scorecard — 2026-10-17
Window: last 7 days (2026-10-10 to 2026-10-17), 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-17T19:52:08.767Z
- vs-sold.json synced: 2026-10-17T19:52:08.541Z
- leads.json synced: 2026-10-17T20:08:41.535Z
- 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 | 6 | n/a | 4 | 4 | 2 | 67% | +3 |
| Henry Smith | 2 | n/a | 2 | 0 | 0 | 100% | -3 |
| La Marcus Burnette | 5 | n/a | 2 | 0 | 2 | 40% | +4 |
| Pedro Barrera | 6 | n/a | 5 | 2 | 1 | 83% | +5 |
| Will Goodwin | 4 | n/a | 1 | 1 | 3 | 25% | +1 |
| Shane Inman | 6 | n/a | 5 | 3 | 1 | 83% | ±0 |
| Edward Cavaness | 4 | n/a | 1 | 1 | 2 | 25% | +2 |
| Emely Tellez | 1 | n/a | 1 | 1 | 0 | 100% | -2 |
| Orlando Alston | 1 | n/a | 0 | 0 | 0 | 0% | +1 |
| Cesar Hernandez Jr | 7 | n/a | 4 | 2 | 2 | 57% | +5 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 | n/a | ±0 |
| Tariq Halawani | 3 | n/a | 2 | 1 | 0 | 67% | -1 |
| Roster total | 45 | n/a | 27 | 15 | 13 | 60% | +15 |
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 | 3 | 2 | 6 | 13 | 12 |
| Henry Smith | 50 | 1 | 94 | 31 | 15 |
| La Marcus Burnette | 80 | 25 | 75 | 25 | 8 |
| Pedro Barrera | 110 | 26 | 118 | 57 | 16 |
| Will Goodwin | 29 | 24 | 94 | 38 | 27 |
| Shane Inman | 95 | 38 | 125 | 101 | 35 |
| Edward Cavaness | 30 | 12 | 94 | 27 | 19 |
| Emely Tellez | 34 | 5 | 50 | 33 | 21 |
| Orlando Alston | 6 | 0 | 29 | 11 | 6 |
| Cesar Hernandez Jr | 61 | 12 | 46 | 21 | 11 |
| Richard Martinez | 0 | 2 | 1 | 3 | 1 |
| Tariq Halawani | 77 | 5 | 75 | 37 | 24 |
| Roster total | 575 | 152 | 807 | 397 | 195 |
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 | 8 | 52m | 8 | 3 | 0 |
| Henry Smith | 27 | 14m | 27 | 3 | 0 |
| La Marcus Burnette | 42 | 9m | 33 | 5 | 1 |
| Pedro Barrera | 64 | 4m | 46 | 0 | 3 |
| Will Goodwin | 39 | 24m | 37 | 12 | 2 |
| Shane Inman | 71 | 18m | 69 | 3 | 1 |
| Edward Cavaness | 47 | 17m | 42 | 7 | 0 |
| Emely Tellez | 36 | 4.6h | 36 | 14 | 0 |
| Orlando Alston | 4 | 10m | 4 | 1 | 0 |
| Cesar Hernandez Jr | 36 | 23m | 35 | 4 | 0 |
| Richard Martinez | 2 | 14m | 2 | 0 | 0 |
| Tariq Halawani | 55 | 7m | 48 | 12 | 0 |
| Roster total | 431 | 13m | 387 | 64 | 7 |
4. Unmatched message samples on assigned leads (actual author unverified, most recent 3)
Ajay Malani
- 2026-10-14 20:40 — "Outbound Text Message: look forward to seeing you!!! Gary"
- 2026-10-14 20:28 — "Outbound Text Message: of course"
- 2026-10-14 13:43 — "Outbound Text Message: Hi Ireshia, this is Will, the sales manager at Leif Johnson Ford of Manor. Thank you for claiming your bonus offer toward a new vehicle. What are you thinking about getting into"
Henry Smith
- 2026-10-16 14:55 — "Outbound Text Message: Good morning Apollonius, we hope all is well with you today. Checking to see if we could be of any assistance?"
- 2026-10-16 14:50 — "Outbound Text Message: Good morning Mrs. Shackelford, we hope all is well with you today. Checking to see if you've made a decision on your next vehicle? Reply STOP to cancel."
- 2026-10-16 14:47 — "Outbound Text Message: You have successfully been removed from Riata Ford text messages."
La Marcus Burnette
- 2026-10-17 18:28 — "Outbound Text Message: Hey Mayra! It’s Marcus with Leif Johnson Ford of Manor. I wanted to check in since the Tacoma you originally liked has sold. Are you still looking for a truck? I’d be happy to k"
- 2026-10-17 18:27 — "Email reply to prospect: Hi Mayra, I wanted to personally check in with you. I know the 2020 Tacoma TRD Sport you originally liked has sold, and I don't want to keep bothering you with vehicles th"
- 2026-10-17 14:17 — "Outbound Text Message: Hey Omar, the expedition is still here, can you come by today to check it out? Reply STOP to cancel."
Pedro Barrera
- 2026-10-17 19:10 — "Outbound Text Message: Hey Roby, it’s Pedro with Leif Johnson Ford of Manor! I wanted to see if you’re still considering a Mustang. I have a few options I can help you compare and would be happy to na"
- 2026-10-17 19:09 — "Outbound Text Message: Hey Gerardo, it’s Pedro with Leif Johnson Ford of Manor! I wanted to see if you had any questions about the Mustang or wanted me to put together updated numbers for you. I’m hap"
- 2026-10-16 22:08 — "Outbound Text Message: When you get the chance to complete it save it and send it back! I'll see what we can do"
Will Goodwin
- 2026-10-16 18:11 — "Email auto response:"
- 2026-10-16 18:10 — "Outbound Text Message: Sounds good. We look forward to helping you."
- 2026-10-16 18:04 — "Outbound Text Message: Hey Samuel! This is Will over at Leif Johnson Ford of Manor. I’m reaching out about your interest in the 2022 Ford Super Duty F-250. Are you still in the market for a truck? I’d"
Shane Inman
- 2026-10-17 06:37 — "Email auto response:"
- 2026-10-16 23:31 — "Email reply to prospect: Hi Gabrielle, I wanted to follow up with you about your Nissan Altima. We're actively looking to purchase quality pre-owned vehicles, and I'd love the opportunity to p"
- 2026-10-16 20:20 — "Outbound Text Message: You have successfully been removed from Riata Ford text messages."
Edward Cavaness
- 2026-10-16 21:06 — "Email reply to prospect: Yes Ma'am, I'll keep my eyes out for options! Best, Pedro Barrera Sales Consultant Leif Johnson Ford of Manor 512-839-9191 -----Original Message----- From:"Sandra"
- 2026-10-16 21:02 — "Email reply to prospect: Of course! I've already been looking around at our inventory and right now for under $10,000 we are a bit limited, but we do have a couple options. 1999 Lexus RX 300 Used " [FLAG: other-store name]
- 2026-10-16 20:22 — "Outbound Text Message: Thank you we are getting everything ready.😀"
Emely Tellez
- 2026-10-17 00:46 — "Email auto response:"
- 2026-10-16 18:39 — "Outbound Text Message: Abigail, this is Eric French with Leif Johnson Ford of Manor. I'm one of the sales managers here. How can I help with the purchase of your 26 Bronco Sport? I'm here to help. Let"
- 2026-10-16 18:36 — "Outbound Text Message: Adelina, this is Eric French with Leif Johnson Ford of Manor. I'm one of the sales managers here. How can I help with your purchase? Did you get a chance to test drive the VW Be"
Orlando Alston
- 2026-10-16 19:03 — "Outbound Text Message: Ford has extended your private offer of $2500! Gary Leif Johnson Ford Manor Reply STOP to cancel."
- 2026-10-16 18:56 — "Outbound Text Message: Alan you have a $2500 Private offer from Ford!! Gary Leif Johnson ford Manor Reply STOP to cancel."
- 2026-10-16 14:30 — "Outbound Text Message: You have successfully been removed from Riata Ford text messages."
Cesar Hernandez Jr
- 2026-10-16 22:27 — "Outbound Text Message: Yes (Y) No (N)"
- 2026-10-16 21:16 — "Outbound Text Message: please let me know when you submit it"
- 2026-10-16 21:16 — "Outbound Text Message: here is the credit application https://www.leifjohnsonfordofmanor.com/finance-application/"
Richard Martinez
- 2026-10-16 21:57 — "Email auto response:"
- 2026-10-16 18:01 — "Email reply to prospect: Hello Jalyn, I wanted to follow up with a few more options. Please feel free to call or text me at (512) 296-5898 and let me know how I can best serve you. 2026 Ford Bronco Bi"
Tariq Halawani
- 2026-10-17 14:54 — "Outbound Text Message: Good morning, are you still in the market for a Ford Expedition?"
- 2026-10-17 14:51 — "Outbound Text Message: Good morning, Connie! This is Tariq with Leif Johnson Ford of Manor. I wanted to check in and see if your 2019 Land Rover Discovery Sport is still available. If you haven’t sold"
- 2026-10-17 14:36 — "Outbound Text Message: Hi Preetham, hope your trip is going well. Whenever you're back in town, I'd be happy to arrange the EcoBoost Premium test drive so you can hear the active exhaust before finali"
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 (4631 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 | 4 | n/a |
| Henry Smith | 13 | 66 | 1 | n/a |
| La Marcus Burnette | 8 | 100 | 0 | n/a |
| Pedro Barrera | 10 | 60 | 2 | n/a |
| Will Goodwin | 8 | 81 | 2 | n/a |
| Shane Inman | 11 | 84 | 3 | n/a |
| Edward Cavaness | 9 | 36 | 2 | n/a |
| Emely Tellez | 12 | 56 | 2 | n/a |
| Orlando Alston | 1 | 26 | 0 | n/a |
| Cesar Hernandez Jr | 7 | 9 | 2 | n/a |
| Richard Martinez | 0 | 3 | 0 | n/a |
| Tariq Halawani | 9 | 7 | 3 | n/a |
| Roster total | 93 | 622 | 21 | 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.