Rep Weekly Scorecard — 2026-09-28
Window: last 7 days (2026-09-21 to 2026-09-28), 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-09-28T11:05:40.664Z
- vs-sold.json synced: 2026-09-28T11:05:40.405Z
- leads.json synced: 2026-09-28T11:37:16.452Z
- 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 | 2 | n/a | 1 | 1 | 1 | 50% | +1 |
| Henry Smith | 2 | n/a | 1 | 1 | 1 | 50% | -1 |
| La Marcus Burnette | 3 | n/a | 1 | 1 | 1 | 33% | -4 |
| Pedro Barrera | 3 | n/a | 1 | 1 | 1 | 33% | +2 |
| Will Goodwin | 5 | n/a | 4 | 2 | 0 | 80% | +3 |
| Shane Inman | 4 | n/a | 2 | 1 | 1 | 50% | +1 |
| Edward Cavaness | 1 | n/a | 1 | 1 | 0 | 100% | ±0 |
| Emely Tellez | 3 | n/a | 3 | 2 | 0 | 100% | -2 |
| Orlando Alston | 3 | n/a | 0 | 0 | 3 | 0% | -1 |
| Robert Faust | 2 | n/a | 2 | 0 | 0 | 100% | ±0 |
| Tre Templeton | 0 | n/a | 0 | 0 | 0 | n/a | -1 |
| Cesar Hernandez Jr | 3 | n/a | 2 | 1 | 1 | 67% | +1 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 | n/a | ±0 |
| Roster total | 31 | n/a | 18 | 11 | 9 | 58% | -1 |
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 | 0 | 1 | 4 | 2 | 7 |
| Henry Smith | 77 | 10 | 60 | 25 | 20 |
| La Marcus Burnette | 44 | 11 | 90 | 24 | 26 |
| Pedro Barrera | 83 | 32 | 77 | 48 | 21 |
| Will Goodwin | 48 | 24 | 61 | 51 | 29 |
| Shane Inman | 84 | 13 | 107 | 34 | 30 |
| Edward Cavaness | 45 | 12 | 75 | 24 | 36 |
| Emely Tellez | 65 | 13 | 42 | 21 | 17 |
| Orlando Alston | 4 | 4 | 13 | 9 | 12 |
| Robert Faust | 40 | 8 | 47 | 14 | 17 |
| Tre Templeton | 5 | 0 | 11 | 1 | 5 |
| Cesar Hernandez Jr | 38 | 9 | 24 | 9 | 8 |
| Richard Martinez | 4 | 2 | 6 | 6 | 4 |
| Roster total | 537 | 139 | 617 | 268 | 232 |
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 | 0 | n/a | 0 | 0 | 0 |
| Henry Smith | 64 | 5m | 64 | 6 | 0 |
| La Marcus Burnette | 24 | 11m | 24 | 5 | 0 |
| Pedro Barrera | 55 | 5m | 55 | 2 | 0 |
| Will Goodwin | 31 | 59m | 31 | 8 | 0 |
| Shane Inman | 85 | 15m | 85 | 3 | 0 |
| Edward Cavaness | 61 | 14m | 61 | 12 | 0 |
| Emely Tellez | 49 | 13m | 48 | 5 | 1 |
| Orlando Alston | 10 | 1.1h | 10 | 4 | 0 |
| Robert Faust | 35 | 13m | 32 | 2 | 3 |
| Tre Templeton | 0 | n/a | 0 | 0 | 0 |
| Cesar Hernandez Jr | 25 | 13m | 25 | 1 | 0 |
| Richard Martinez | 7 | 10.4h | 7 | 3 | 0 |
| Roster total | 446 | 10m | 442 | 51 | 4 |
4. Unmatched message samples on assigned leads (actual author unverified, most recent 3)
Ajay Malani
- 2026-09-22 20:15 — "Email auto response:"
Henry Smith
- 2026-09-27 14:06 — "Email auto response:"
- 2026-09-27 01:08 — "Outbound Text Message: You have successfully been removed from Riata Ford text messages."
- 2026-09-26 23:42 — "Email auto response:"
La Marcus Burnette
- 2026-09-26 20:59 — "Outbound Text Message: Ok we can reschedule, drive careful."
- 2026-09-25 20:36 — "Outbound Text Message: Ok ill set an appointment for 5pm, looking forward to assisting you and meeting you."
- 2026-09-25 20:27 — "Outbound Text Message: what time you think you can come in tomorrow?"
Pedro Barrera
- 2026-09-26 20:53 — "Email reply to prospect: Hi Jose, It's Pedro with Leif Johnson Ford of Manor. I wanted to check in on the Lexus. Are you still looking to sell it, or have your plans changed? Either way, just let "
- 2026-09-26 20:12 — "Outbound Text Message: Hey Roby, Pedro here with Leif Johnson Ford of Manor. Still looking for a Mustang? I’m happy to help if you are!"
- 2026-09-26 14:05 — "Outbound Text Message: Perfect ask for Pedro when you arrive!"
Will Goodwin
- 2026-09-27 02:35 — "Email auto response:"
- 2026-09-26 00:09 — "Outbound Text Message: You will have to get it towed in"
- 2026-09-26 00:08 — "Outbound Text Message: I’m looking at 1000 maybe 2000"
Shane Inman
- 2026-09-27 00:07 — "Outbound Text Message: No problem, most banks are closed we won’t have an answer until Monday. I’ll reach out first thing Monday morning. Hope you have a great weekend!"
- 2026-09-27 00:07 — "Email auto response:"
- 2026-09-27 00:04 — "Outbound Text Message: What’s his name?"
Edward Cavaness
- 2026-09-27 00:11 — "Email auto response:"
- 2026-09-26 20:24 — "Outbound Text Message: Hi Kenna, this is Matt, one of the managers at Leif Johnson Ford. I just tried giving you a quick call regarding your 2014 Mitsubishi Mirage trade. It looks like the online appr"
- 2026-09-26 15:09 — "Email reply to prospect: I did want to make sure you had our address also if its easier we also do deliveries as well. 10507 Highway 290 E. Manor, TX 78653 -----Original Message----- From:"Baylor"
Emely Tellez
- 2026-09-26 21:27 — "Outbound Text Message: Perfecto Juan, se lo apartamos. ¿Puede venir hoy? Tengo disponibilidad a las 5:15, 6:00 o 6:45. ¿Cuál le funciona mejor?"
- 2026-09-26 20:37 — "Outbound Text Message: Yes i got as much done as I could do before you get here. I'll need license insurance business application... etc I will have you working with one of my senior sales guys. Hes e"
- 2026-09-26 19:27 — "Outbound Text Message: Ha yes sir! Good thing we don't either. Yours is getting washed right now."
Orlando Alston
- 2026-09-26 17:49 — "Outbound Text Message: 2018 Honda CR-V"
- 2026-09-25 21:14 — "Outbound Text Message: Hi, we have your vehicle registration ready for pick up or we can mail it to you. Reply STOP to cancel."
- 2026-09-25 14:33 — "Email auto response:"
Robert Faust
- 2026-09-26 21:36 — "Outbound Text Message: https://portal.autofi.com/customer/BAEeX8BrxI7n31hT7GX5C2LWrQBv6YKj/vehicles/consumer?source=LINK&eventId=6ab83ad9e24b5476224e4ab0"
- 2026-09-26 21:36 — "Outbound Text Message: Chris, here are the numbers on the black EcoBoost Premium. We sharpened it up as much as we could to try to make this work $34,190.65 out the door after your trade, including ta"
- 2026-09-26 19:44 — "Outbound Text Message: Hi Jonathan, this is Matt with Leif Johnson Ford of Manor. I’m reaching out on your interest in a 2027 Ford Expedition. I also see you have a 2017 Tahoe LT with about 143,500 mi"
Tre Templeton
- 2026-09-25 22:19 — "Outbound Text Message: pictures of both trade ins and also filling out the credit app will allow us to give you official numbers on the deal for the used bronco you expressed interest in!"
- 2026-09-23 17:09 — "Outbound Text Message: Ok so I sent you a video to show you that the desert sand bronco sport is here. the vehicle is in service as we just received her not too long ago and it has to go through inspe"
- 2026-09-22 22:18 — "Outbound Text Message: Expeditons. please forgive the auto correct error!"
Cesar Hernandez Jr
- 2026-09-26 17:57 — "Outbound Text Message: https://images.vinsolutions.com/texting/short/455b01e1-3b11-4cab-80a5-90acd0e0d6ad"
- 2026-09-26 13:54 — "Outbound Text Message: let me check"
- 2026-09-25 23:42 — "Outbound Text Message: will have be equipped whit leather"
Richard Martinez
- 2026-09-23 19:59 — "Outbound Text Message: Hey Yossary, Richard at Leif Johnson Ford of Manor. Saw your credit app come through on the 2021 Ram 1500. We're on it. What questions do you have while we review it? Reply STOP"
- 2026-09-22 19:06 — "Outbound Text Message: Hi Jalyn, this is Matt, one of the sales managers at Leif Johnson Ford of Manor. I wanted to personally follow up with you on the 2026 Bronco Outer Banks. I know you were lookin"
- 2026-09-22 17:23 — "Email reply to prospect: Anessa have we provided you all the information you need on the Maverick? Gary Gary Brophy General Manager 512.281.3673 www.Leifjohnsonfordofmanor.com You are receiving this e"
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 (4209 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 | 4 | 116 | 4 | n/a |
| Henry Smith | 11 | 88 | 3 | n/a |
| La Marcus Burnette | 7 | 160 | 1 | n/a |
| Pedro Barrera | 6 | 93 | 1 | n/a |
| Will Goodwin | 7 | 109 | 2 | n/a |
| Shane Inman | 7 | 122 | 2 | n/a |
| Edward Cavaness | 11 | 45 | 1 | n/a |
| Emely Tellez | 3 | 74 | 2 | n/a |
| Orlando Alston | 7 | 52 | 1 | n/a |
| Robert Faust | 5 | 1 | 0 | n/a |
| Tre Templeton | 2 | 2 | 0 | n/a |
| Cesar Hernandez Jr | 6 | 8 | 0 | n/a |
| Richard Martinez | 2 | 5 | 2 | n/a |
| Roster total | 78 | 875 | 19 | 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.