Rep Weekly Scorecard — 2026-11-16
Window: last 7 days (2026-11-09 to 2026-11-16), 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-16T12:05:09.628Z
- vs-sold.json synced: 2026-11-16T12:05:09.391Z
- leads.json synced: 2026-11-16T12:37:28.626Z
- 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 | 3 | 3 | 0 | 60% | +3 |
| Henry Smith | 5 | n/a | 4 | 2 | 1 | 80% | +1 |
| La Marcus Burnette | 8 | n/a | 2 | 1 | 6 | 25% | +3 |
| Pedro Barrera | 3 | n/a | 1 | 1 | 1 | 33% | +1 |
| Will Goodwin | 7 | n/a | 5 | 3 | 2 | 71% | +4 |
| Shane Inman | 2 | n/a | 1 | 0 | 1 | 50% | +1 |
| Edward Cavaness | 5 | n/a | 2 | 2 | 3 | 40% | +1 |
| Emely Tellez | 4 | n/a | 3 | 2 | 1 | 75% | +1 |
| Cesar Hernandez Jr | 1 | n/a | 0 | 0 | 1 | 0% | ±0 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 | n/a | ±0 |
| Tariq Halawani | 3 | n/a | 2 | 1 | 1 | 67% | -5 |
| Marco Lopez | 0 | n/a | 0 | 0 | 0 | n/a | -1 |
| Alejandro Flores | 1 | n/a | 0 | 0 | 1 | 0% | +1 |
| Roster total | 44 | n/a | 23 | 15 | 18 | 52% | +10 |
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 | 6 | 3 | 20 | 3 | 1 |
| Henry Smith | 106 | 4 | 66 | 24 | 9 |
| La Marcus Burnette | 50 | 9 | 68 | 16 | 1 |
| Pedro Barrera | 101 | 35 | 138 | 24 | 14 |
| Will Goodwin | 92 | 18 | 135 | 23 | 7 |
| Shane Inman | 62 | 32 | 66 | 18 | 4 |
| Edward Cavaness | 55 | 12 | 165 | 18 | 14 |
| Emely Tellez | 33 | 5 | 101 | 22 | 2 |
| Cesar Hernandez Jr | 54 | 21 | 51 | 13 | 1 |
| Richard Martinez | 0 | 0 | 0 | 0 | 0 |
| Tariq Halawani | 120 | 25 | 184 | 6 | 10 |
| Marco Lopez | 76 | 30 | 94 | 22 | 10 |
| Alejandro Flores | 5 | 2 | 25 | 7 | 1 |
| Roster total | 760 | 196 | 1113 | 196 | 74 |
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 | 9 | 26m | 9 | 0 | 0 |
| Henry Smith | 75 | 7m | 75 | 1 | 0 |
| La Marcus Burnette | 28 | 9m | 28 | 5 | 0 |
| Pedro Barrera | 43 | 3m | 43 | 2 | 0 |
| Will Goodwin | 52 | 9m | 51 | 4 | 1 |
| Shane Inman | 25 | 5m | 25 | 1 | 0 |
| Edward Cavaness | 54 | 14m | 54 | 1 | 0 |
| Emely Tellez | 37 | 11m | 37 | 7 | 0 |
| Cesar Hernandez Jr | 19 | 16m | 19 | 0 | 0 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 |
| Tariq Halawani | 58 | 13m | 58 | 4 | 0 |
| Marco Lopez | 34 | 4m | 34 | 0 | 0 |
| Alejandro Flores | 5 | 10m | 5 | 2 | 0 |
| Roster total | 439 | 8m | 438 | 27 | 1 |
4. Unmatched message samples on assigned leads (actual author unverified, most recent 3)
Ajay Malani
- 2026-11-14 00:54 — "Outbound Text Message: Hey Mike just checking in to see if you ended up purchasing that other F-150 after all?"
- 2026-11-12 23:26 — "Email reply to prospect: Hi Mike, Here's the link to our credit application: https://www.leifjohnsonfordofmanor.com/finance-application/ When you have a moment, could you also send a photo of the "
- 2026-11-12 18:01 — "Email reply to prospect: Mike here's the window sticker Gary Brophy General Manager 512.281.3673 www.Leifjohnsonfordofmanor.com You are receiving this email because you inquired about or purchased"
Henry Smith
- 2026-11-14 23:41 — "Email auto response:"
- 2026-11-14 22:29 — "Outbound Text Message: 7"
- 2026-11-14 22:03 — "Outbound Text Message: that works what are you available today or monday?"
La Marcus Burnette
- 2026-11-14 17:47 — "Outbound Text Message: Hi Dan! This is Eric French with Leif Johnson Ford of Manor. I see you inquired about a 26 Explorer ST, Nice unit! What questions do you have and how can we assist you with your"
- 2026-11-14 15:16 — "Outbound Text Message: Paula were you able to get a Bronco? If not as the GM I would love the opportunity to help. Gary"
- 2026-11-13 18:57 — "Outbound Text Message: Hey Mateo, I just got some really nice 5.0s in, let me know if you would like to check out one of these https://www.leifjohnsonfordofmanor.com/inventory/used-vehicles/models-For"
Pedro Barrera
- 2026-11-14 21:53 — "Outbound Text Message: Perfect! Whenever you get the chance if you could send over a picture of the VIN, current mileage, and a couple of the interior and exterior I'll get to work for you!"
- 2026-11-14 21:43 — "Outbound Text Message: Yes ma'am of course! I do have a couple of questions for you as well, are you looking to upgrade out of a current vehicle? I'd be happy to work numbers on it for you😄"
- 2026-11-14 21:26 — "Outbound Text Message: That's no problem! We can always reschedule, and if you'd like we can also do a lot of the process completely remotely, and I can even bring it straight to you. 😁Let me know wh"
Will Goodwin
- 2026-11-14 22:16 — "Email auto response:"
- 2026-11-14 20:15 — "Outbound Text Message: Hi Niki, this is Matt at Leif Johnson Ford of Manor. I wanted to check in and see if you were able to get that second opinion on your Explorer. I know this is a tough situation,"
- 2026-11-14 20:05 — "Email reply to prospect: Hi Ronny, I wanted to personally reach out regarding your interest in a 2026 Ford F-150. I know you've been in contact with a few members of our team, and I wanted to make"
Shane Inman
- 2026-11-14 22:47 — "Outbound Text Message: https://www.leifjohnsonfordofmanor.com/inventory/all-vehicles/used/models-Ford-Mustang/"
- 2026-11-14 22:46 — "Outbound Text Message: Hey Angel! Shane here at Leif Johnson Ford Manor. I wanted to see if you're still on the hunt for a Mustang! We've had some new ones come in, and I'd love to help you find the r"
- 2026-11-14 20:29 — "Email reply to prospect: Good morning Samantha! It's Shane at Leif Johnson Ford of Manor! I wanted to reach back out because we're still interested in your Toyota 4Runner! We're actively l"
Edward Cavaness
- 2026-11-14 20:07 — "Outbound Text Message: Hi Pamela, this is Matt, one of the Sales Managers at Leif Johnson Ford of Manor. I wanted to reach out one more time about the 2022 Ford Explorer you selected through your empl"
- 2026-11-14 19:04 — "Outbound Text Message: Hi Becky, this is Matt, one of the Sales Managers at Leif Johnson Ford of Manor. I wanted to personally reach out regarding the 2026 Bronco you built through TrueCar. We have it"
- 2026-11-14 19:02 — "Outbound Text Message: Which one caught your eye, or would you prefer the F-250 over the F-350? I want to make sure we get you into the right truck for your gooseneck setup. Let me know what you think"
Emely Tellez
- 2026-11-14 17:47 — "Outbound Text Message: Hi Jose, this is Matt, one of the Sales Managers at Leif Johnson Ford of Manor. I wanted to personally check in regarding the 2027 F-150 King Ranch you built in Marsh Gray with " [FLAG: hold]
- 2026-11-14 15:26 — "Outbound Text Message: ¡Hola, César! Soy Emely de Leif Johnson Ford de Manor. Solo quería saber si tú y tu esposa han reconsiderado la Explorer. ¡Todavía está disponible y tenemos otros colores! Déjan"
- 2026-11-13 20:10 — "Outbound Text Message: ¡Hola, Luciano! ¿Todavía va a poder venir hoy?"
Cesar Hernandez Jr
- 2026-11-15 01:51 — "Email auto response:"
- 2026-11-14 22:02 — "Email reply to prospect: Hey, this is Cesar Hernandez with Leif Johnson Ford here in Manor! I wanted to take a quick second to introduce myself. I’m excited to be part of the Leif Johnson Ford team, a"
- 2026-11-14 22:01 — "Outbound Text Message: Hey, this is Cesar Hernandez with Leif Johnson Ford here in Manor! I wanted to take a quick second to introduce myself. I’m excited to be part of the Leif Johnson Ford team, and"
Richard Martinez
- (no unmatched text/email outbound observed this week)
Tariq Halawani
- 2026-11-15 15:43 — "Email auto response:"
- 2026-11-15 00:04 — "Outbound Text Message: Flor, I completely understand, and I honestly appreciate you being upfront with me. The last thing I want is for you to stretch your budget or put yourself in a financial situat"
- 2026-11-14 23:47 — "Outbound Text Message: I just sent you the quote. you can change the numbers to your liking. then click on the dollar sign to see the break down."
Marco Lopez
- 2026-11-14 21:16 — "Outbound Text Message: That's with $0 down. If you were to put $2000 down. You would be at $696."
- 2026-11-14 21:08 — "Outbound Text Message: Based on the tentative figures we currently have, the estimated payment would be around $720 per month."
- 2026-11-14 21:02 — "Outbound Text Message: Can I have the VIN and current mileage? Also, did they provide you with a numbers sheet?"
Alejandro Flores
- 2026-11-14 18:40 — "Outbound Text Message: Brody are you still looking? Gary"
- 2026-11-14 16:03 — "Email reply to prospect: Good morning, this is Alex Flores here at Leif Johnson Ford. Just wanted to reach out and see if you're still in the market for a vehicle. If you are, we have some great d"
- 2026-11-12 18:21 — "Email reply to prospect: Good afternoon, Alfredo this is Edward from Leif Johnson Ford of Manor. Great news the 2021 GMC Yukon is available. Is there any questions I can assist with? We do offer remot"
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 (5447 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 | 97 | 5 | n/a |
| Henry Smith | 11 | 64 | 3 | n/a |
| La Marcus Burnette | 6 | 98 | 2 | n/a |
| Pedro Barrera | 6 | 59 | 1 | n/a |
| Will Goodwin | 6 | 85 | 3 | n/a |
| Shane Inman | 2 | 84 | 0 | n/a |
| Edward Cavaness | 9 | 35 | 3 | n/a |
| Emely Tellez | 3 | 55 | 2 | n/a |
| Cesar Hernandez Jr | 3 | 11 | 0 | n/a |
| Richard Martinez | 0 | 1 | 0 | n/a |
| Tariq Halawani | 11 | 11 | 4 | n/a |
| Marco Lopez | 11 | 0 | 1 | n/a |
| Alejandro Flores | 6 | 3 | 0 | n/a |
| Roster total | 79 | 603 | 24 | 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.