Rep Weekly Scorecard — 2026-10-05
Window: last 7 days (2026-09-28 to 2026-10-05), 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-05T11:05:46.782Z
- vs-sold.json synced: 2026-10-05T11:05:45.842Z
- leads.json synced: 2026-10-05T11:37:23.725Z
- 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 | 1 | n/a | 1 | 1 | 0 | 100% | -1 |
| Henry Smith | 4 | n/a | 2 | 1 | 1 | 50% | +2 |
| La Marcus Burnette | 3 | n/a | 1 | 1 | 1 | 33% | ±0 |
| Pedro Barrera | 1 | n/a | 0 | 0 | 0 | 0% | -3 |
| Will Goodwin | 3 | n/a | 3 | 2 | 0 | 100% | -3 |
| Shane Inman | 6 | n/a | 2 | 0 | 2 | 33% | +2 |
| Edward Cavaness | 3 | n/a | 3 | 3 | 0 | 100% | +2 |
| Emely Tellez | 3 | n/a | 2 | 2 | 0 | 67% | +1 |
| Orlando Alston | 0 | n/a | 0 | 0 | 0 | n/a | -3 |
| Cesar Hernandez Jr | 1 | n/a | 0 | 0 | 0 | 0% | -1 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 | n/a | ±0 |
| Javier Choraifi | 1 | n/a | 0 | 0 | 0 | 0% | +1 |
| Tariq Halawani | 2 | n/a | 1 | 1 | 0 | 50% | +2 |
| Roster total | 28 | n/a | 15 | 11 | 4 | 54% | -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 | 2 | 0 | 8 | 3 | 5 |
| Henry Smith | 107 | 3 | 101 | 35 | 17 |
| La Marcus Burnette | 55 | 27 | 94 | 24 | 22 |
| Pedro Barrera | 133 | 46 | 166 | 38 | 28 |
| Will Goodwin | 71 | 30 | 116 | 40 | 21 |
| Shane Inman | 124 | 33 | 206 | 65 | 49 |
| Edward Cavaness | 59 | 3 | 88 | 31 | 31 |
| Emely Tellez | 75 | 9 | 63 | 30 | 16 |
| Orlando Alston | 3 | 1 | 25 | 4 | 3 |
| Cesar Hernandez Jr | 21 | 5 | 18 | 15 | 10 |
| Richard Martinez | 4 | 0 | 0 | 8 | 5 |
| Javier Choraifi | 7 | 8 | 28 | 13 | 11 |
| Tariq Halawani | 34 | 8 | 42 | 5 | 11 |
| Roster total | 695 | 173 | 955 | 311 | 229 |
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 | 4 | 17m | 4 | 1 | 0 |
| Henry Smith | 64 | 5m | 64 | 0 | 0 |
| La Marcus Burnette | 27 | 8m | 27 | 1 | 0 |
| Pedro Barrera | 50 | 4m | 50 | 5 | 0 |
| Will Goodwin | 39 | 35m | 39 | 10 | 0 |
| Shane Inman | 56 | 8m | 56 | 9 | 0 |
| Edward Cavaness | 56 | 6m | 52 | 8 | 4 |
| Emely Tellez | 56 | 17m | 56 | 11 | 0 |
| Orlando Alston | 0 | n/a | 0 | 0 | 0 |
| Cesar Hernandez Jr | 23 | 11m | 23 | 3 | 0 |
| Richard Martinez | 14 | 4m | 14 | 7 | 0 |
| Javier Choraifi | 6 | 2.9h | 6 | 2 | 0 |
| Tariq Halawani | 23 | 29m | 23 | 1 | 0 |
| Roster total | 418 | 10m | 414 | 58 | 4 |
4. Unmatched message samples on assigned leads (actual author unverified, most recent 3)
Ajay Malani
- 2026-10-02 22:11 — "Outbound Text Message: Hey Billie, we don’t do in-house financing, but we do work with multiple lenders that can help with a wide range of credit situations. If you have $1,800 to put down, I can have"
- 2026-09-30 18:39 — "Outbound Text Message: Alan are you still looking for an F150? Gary Leif Johnson Ford Manor"
Henry Smith
- 2026-10-03 22:52 — "Email auto response:"
- 2026-10-03 22:45 — "Outbound Text Message: Finance manager will give you a call shortly"
- 2026-10-03 22:45 — "Outbound Text Message: Thank you"
La Marcus Burnette
- 2026-10-04 01:45 — "Email auto response:"
- 2026-10-03 20:57 — "Email reply to prospect: Hey Cody, I wanted to reach out one last time regarding the 2026 F-150 Lariat you matched with on TrueCar. I know you’ve gotten a few messages from us, so I don’t want to keep"
- 2026-10-03 20:35 — "Email reply to prospect: Hey Edward, Just wanted to check in with you on the Explorer. Last time we spoke, you were planning to move forward with the offer you had at Covert. Did you end up getting on"
Pedro Barrera
- 2026-10-04 00:03 — "Outbound Text Message: Yessirrr and if you need anything in the meantime you can reach me here or at my cell 512-839-9191"
- 2026-10-03 23:57 — "Outbound Text Message: Sounds good, I'll also need a idea of your pay off to make sure I get you accurate numbers! If you can get me that information over the weekend, I can work on numbers for you ou"
- 2026-10-03 23:55 — "Outbound Text Message: and do you owe on your current vehicle?"
Will Goodwin
- 2026-10-04 02:22 — "Email auto response:"
- 2026-10-03 21:48 — "Email auto response:"
- 2026-10-03 19:54 — "Outbound Text Message: https://images.vinsolutions.com/texting/short/ffde0cc2-8271-4087-bd1b-731af660c7fa"
Shane Inman
- 2026-10-05 00:47 — "Email auto response:"
- 2026-10-03 23:33 — "Outbound Text Message: Sounds good sir, please let me know how I can better assist you. Have a great night!"
- 2026-10-03 23:31 — "Outbound Text Message: I know you really wanted to trade in, it's just the only way they would approve it is with no trade in. Let me know what you think sir we would love to earn your business!"
Edward Cavaness
- 2026-10-03 23:51 — "Outbound Text Message: my finance manager said that their is one more email that needs to be signed its called route one"
- 2026-10-03 22:17 — "Outbound Text Message: I’m here"
- 2026-10-03 21:23 — "Outbound Text Message: thank you"
Emely Tellez
- 2026-10-03 15:18 — "Outbound Text Message: Hey Jessica! Just checking in, have you been able to save a little more for your down payment? Reply STOP to cancel."
- 2026-10-03 15:00 — "Outbound Text Message: Hola Adrian, solo quería darle seguimiento. ¿Pudiste ver el video y el CARFAX de la Expedition?"
- 2026-10-03 14:10 — "Outbound Text Message: Hi Veronica, just checking in on the Bronco. Have you had any more thoughts on the numbers?"
Orlando Alston
- 2026-09-30 17:26 — "Email reply to prospect: Kristi, Happy Birthday! Just wanted you to know we are thinking of you here at Leif Johnson Ford of Manor. Hope your birthday is wonderful. We wish you another year of happy a"
- 2026-09-29 16:56 — "Outbound Text Message: Hi, Happy Birthday!!!! We have your vehicle registration ready for pick up or we can mail it to you."
- 2026-09-28 21:28 — "Outbound Text Message: Hey Zachariah, Will with Leif Johnson Ford of Manor. The one we looked at has sold, but I’d be happy to help find another option while you’re shopping. I know you’re trying to s"
Cesar Hernandez Jr
- 2026-10-03 23:06 — "Outbound Text Message: Are you still on the market for a Super Duty?"
- 2026-10-03 23:05 — "Outbound Text Message: Are you still in the market for a truck?"
- 2026-10-03 23:03 — "Email reply to prospect: Leodora, I sent you some info on the Ranger you inquired on at Leif Johnson Ford of Manor, and I wanted to make sure you received it? Did I sent the right vehicle? Please let "
Richard Martinez
- 2026-09-28 22:53 — "Outbound Text Message: banks usually ask for 10 to 15% down on a new bronco its about 3k down" [FLAG: rate/APR]
- 2026-09-28 22:32 — "Outbound Text Message: thank you how many miles on it?"
- 2026-09-28 22:18 — "Outbound Text Message: payment under 500 i can work on that can you send me the vin # to you nissan titan"
Javier Choraifi
- 2026-10-03 18:56 — "Outbound Text Message: Hi Jonathan, this is Eric French at Leif Johnson Ford of Manor. I'm one of the sales managers here. I want to thank for checking put the 27 Expedition with us. Do you have any q"
- 2026-10-02 22:56 — "Email auto response:"
- 2026-10-02 15:53 — "Outbound Text Message: Hi Jonathan, this is Robert with Leif Johnson Ford of Manor. I wanted to ask you one simple question: Was the Expedition close to what you’re looking for, or was something missi"
Tariq Halawani
- 2026-10-03 22:47 — "Outbound Text Message: Which color are you more interested in? 😊 I’d be happy to send you a quick walkaround video of the vehicle so you can get a better look."
- 2026-10-03 22:44 — "Outbound Text Message: yes sir, I have several 4x4 STX's available in my lot right now. https://www.leifjohnsonfordofmanor.com/inventory/new-vehicles/models-Ford-F--150-STX/dealership-Leif_Johnson_For"
- 2026-10-03 20:10 — "Outbound Text Message: Good afternoon, Eddy! I just wanted to follow up and see if you had a chance to watch the video I sent you of the 2015 Ford Super Duty F-450 DRW Lariat. Let me know if you have "
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 (4354 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 | 8 | 101 | 5 | n/a |
| Henry Smith | 11 | 62 | 1 | n/a |
| La Marcus Burnette | 7 | 126 | 1 | n/a |
| Pedro Barrera | 10 | 78 | 0 | n/a |
| Will Goodwin | 7 | 94 | 1 | n/a |
| Shane Inman | 13 | 87 | 1 | n/a |
| Edward Cavaness | 8 | 37 | 3 | n/a |
| Emely Tellez | 7 | 60 | 2 | n/a |
| Orlando Alston | 0 | 39 | 0 | n/a |
| Cesar Hernandez Jr | 5 | 6 | 0 | n/a |
| Richard Martinez | 1 | 5 | 0 | n/a |
| Javier Choraifi | 6 | 1 | 0 | n/a |
| Tariq Halawani | 7 | 0 | 1 | n/a |
| Roster total | 90 | 696 | 15 | 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.