Rep Weekly Scorecard — 2026-09-21
Window: last 7 days (2026-09-14 to 2026-09-21), compared to the prior 7 days. Read-only — no CRM login, no messages sent, no memory writes.
Data freshness
- vs-appointments.json synced: 2026-09-21T11:05:41.971Z
- vs-sold.json synced: 2026-09-21T11:05:41.718Z
- leads.json synced: 2026-09-21T11:35:01.164Z
- message-log.json capped at 2000 entries (oldest pruned first) — human/machine split for activity older than the log's own retention window is undercounted toward "human" by default.
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
| Rep | Set | Confirmed | Showed | Sold-from-appt | No-show | Show rate | Δ Set (prior wk) |
|---|---|---|---|---|---|---|---|
| Ajay Malani | 2 | n/a | 1 | 0 | 1 | 50% | -3 |
| Henry Smith | 3 | n/a | 3 | 2 | 0 | 100% | -2 |
| La Marcus Burnette | 5 | n/a | 4 | 4 | 0 | 80% | +2 |
| Pedro Barrera | 1 | n/a | 1 | 1 | 0 | 100% | -1 |
| Will Goodwin | 2 | n/a | 0 | 0 | 2 | 0% | -2 |
| Shane Inman | 4 | n/a | 0 | 0 | 4 | 0% | -1 |
| Edward Cavaness | 2 | n/a | 1 | 1 | 1 | 50% | -2 |
| Emely Tellez | 5 | n/a | 3 | 2 | 2 | 60% | +5 |
| Orlando Alston | 3 | n/a | 0 | 0 | 3 | 0% | +2 |
| Robert Faust | 2 | n/a | 1 | 0 | 0 | 50% | +1 |
| Tre Templeton | 1 | n/a | 1 | 0 | 0 | 100% | ±0 |
| Cesar Hernandez Jr | 2 | n/a | 2 | 0 | 0 | 100% | -1 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 | n/a | ±0 |
| Store total | 32 | n/a | 17 | 10 | 13 | 53% | -2 |
2. Activity (outbound touches, human vs machine)
| Rep | Human texts | Human emails | Human calls | Machine texts | Machine emails |
|---|---|---|---|---|---|
| Ajay Malani | 4 | 1 | 6 | 8 | 11 |
| Henry Smith | 77 | 4 | 76 | 47 | 39 |
| La Marcus Burnette | 30 | 11 | 82 | 20 | 28 |
| Pedro Barrera | 71 | 25 | 69 | 32 | 27 |
| Will Goodwin | 81 | 26 | 84 | 35 | 38 |
| Shane Inman | 92 | 30 | 118 | 44 | 31 |
| Edward Cavaness | 27 | 5 | 54 | 39 | 41 |
| Emely Tellez | 82 | 13 | 45 | 20 | 17 |
| Orlando Alston | 7 | 0 | 20 | 11 | 13 |
| Robert Faust | 22 | 5 | 47 | 12 | 10 |
| Tre Templeton | 8 | 2 | 16 | 7 | 10 |
| Cesar Hernandez Jr | 2 | 4 | 9 | 13 | 6 |
| Richard Martinez | 0 | 1 | 0 | 1 | 1 |
| Store total | 503 | 127 | 626 | 289 | 272 |
3. Responsiveness (inbound -> next human outbound by assigned rep)
| Rep | Inbound msgs | Median response | No human reply within 24h |
|---|---|---|---|
| Ajay Malani | 7 | 4.0h | 1 |
| Henry Smith | 62 | 5m | 5 |
| La Marcus Burnette | 24 | 55m | 3 |
| Pedro Barrera | 29 | 5m | 2 |
| Will Goodwin | 43 | 41m | 10 |
| Shane Inman | 44 | 10m | 3 |
| Edward Cavaness | 40 | 14m | 8 |
| Emely Tellez | 34 | 8m | 3 |
| Orlando Alston | 18 | 1.9h | 8 |
| Robert Faust | 24 | 22m | 0 |
| Tre Templeton | 4 | 5m | 1 |
| Cesar Hernandez Jr | 7 | 6.0h | 6 |
| Richard Martinez | 1 | 47.9h | 1 |
| Store total | 337 | 15m | 51 |
4. Message samples (their own human texts this week, most recent 3)
Ajay Malani
- 2026-09-19 00:45 — "Outbound Text Message: Hey Aaron thanks for the reply. I hate saying it but it sounds like the CPO warranty and there price is a great deal. I definitely want to get this car off my lot but unfortunat"
- 2026-09-18 15:00 — "Outbound Text Message: Hey Nick, this is Pedro with Leif Johnson Ford of Manor. I heard you were interested in our 2004 Ford Mustang Premium Mach 1! I'll send over a quick walkaround video of it here "
- 2026-09-17 20:46 — "Email reply to prospect: Linda you are a valued customer. You will get the best deal on anything we have in stock. I know you've had some communication with Robert. Let us know when you're rea"
Henry Smith
- 2026-09-20 01:53 — "Email auto response:"
- 2026-09-19 15:51 — "Outbound Text Message: Good morning Julius, checking to see if you're still thinking about upgrading your vehicle?"
- 2026-09-19 14:02 — "Outbound Text Message: You have successfully been removed from Riata Ford text messages."
La Marcus Burnette
- 2026-09-19 22:16 — "Outbound Text Message: expedition"
- 2026-09-19 18:02 — "Outbound Text Message: https://www.leifjohnsonfordofmanor.com/finance-application/"
- 2026-09-19 15:37 — "Outbound Text Message: Hey Elise, it's Marcus from Ford in Manor, have you bought an Escape yet?"
Pedro Barrera
- 2026-09-19 21:53 — "Outbound Text Message: Hey Mr. White, it's Pedro with Leif Johnson Ford of Manor! Thanks for stopping by today, if you guys have any questions for me, I'd be happy to help in any way I can! You can re"
- 2026-09-19 21:38 — "Email reply to prospect: Hi Evaristo, I hope you're doing well! It's Pedro with Leif Johnson Ford of Manor. I wanted to check in and see if you’re still considering selling or trading your Alt"
- 2026-09-19 19:22 — "Email reply to prospect: Hi Sidney, It's Pedro with Leif Johnson Ford of Manor. I wanted to check in and see if you’re still in the market for a Mustang. If you are, I’d be happy to keep an eye ou"
Will Goodwin
- 2026-09-19 17:05 — "Outbound Text Message: I have this vehicle but it is a diesel 1500"
- 2026-09-19 17:05 — "Outbound Text Message: https://www.leifjohnsonfordofmanor.com/vehicle/3GCUYDET9LG317540/Used-2020-Chevrolet-Silverado_1500-Manor-TX/"
- 2026-09-19 16:18 — "Outbound Text Message: Hi Helena! Just checking back in on the 2022 Chevy Silverado 1500 you were interested in. I can send you our current truck inventory or numbers on similar options. Which would b"
Shane Inman
- 2026-09-20 02:52 — "Email auto response:"
- 2026-09-19 21:12 — "Email auto response:"
- 2026-09-19 20:30 — "Outbound Text Message: Dang! That is really good sir. I might be able to get to $60k... but $70k is definitely out of our range."
Edward Cavaness
- 2026-09-18 17:13 — "Outbound Text Message: let me know"
- 2026-09-18 14:30 — "Outbound Text Message: did you get a chance to take a photo of the vin number"
- 2026-09-17 22:34 — "Outbound Text Message: Henry that F150 regular cab has sold. We do have several coming. Do you have any specifics you're looking for in the package. We have around 20 coming but 12 of them are already"
Emely Tellez
- 2026-09-19 17:14 — "Email reply to prospect: Hi Priscilla, I wanted to follow up since you’ve had a chance to look at some of the Bronco options and videos I sent over. I’d love to know what you thought. Was there a part"
- 2026-09-19 17:12 — "Email reply to prospect: Hi Blanca, I wanted to follow up regarding your 2019 Cadillac Escalade Platinum. If you’re still considering trading it, I’d be happy to help you get a current value and answe"
- 2026-09-19 15:47 — "Outbound Text Message: Hey Gary, Emely here! I wanted to check in and see if you’re still looking for an F-250 with the Lariat Ultimate Package. If you’re still in the market, I’d be happy to help nar"
Orlando Alston
- 2026-09-17 15:53 — "Outbound Text Message: Ok Understood. Thanks"
- 2026-09-17 14:38 — "Outbound Text Message: Good morning Rafael! I hope all is well! My name is Oscar I am the sales manager here I am following up to confirm your appt here at Leif Johnson Ford of Manor at 2pm. Does that"
- 2026-09-16 18:03 — "Outbound Text Message: Noah it's a nice looking Lexus!! https://www.leifjohnsonfordofmanor.com/inventory/all-vehicles/text-REE08817A/"
Robert Faust
- 2026-09-19 14:13 — "Email reply to prospect: Good morning, Zachary, This is Robert with Leif Johnson Ford of Manor. I wanted to follow up about your 2008 Honda Element. The CARFAX history-based value of approximately $2,"
- 2026-09-18 21:49 — "Outbound Text Message: This is that $25,000 one that I'd be willing to do $1,000 less."
- 2026-09-18 21:49 — "Outbound Text Message: https://leifjohnson.com/inventory/Used-2024-Ford-Bronco_Sport-Big_Bend-3FMCR9B64RRF51596"
Tre Templeton
- 2026-09-18 15:08 — "Email reply to prospect: Hi, Ms Willis are you still going to b able to make your appointment for apprasial? You are receiving this email because you inquired about or purchased a vehicle from Leif Jo"
- 2026-09-16 15:29 — "Outbound Text Message: Alexandra this is Tre Templeton from Leif Johnson Ford of Manor. I wanted to follow up with you and ask how your shopping went yesterday after leaving the dealership yesterday!"
- 2026-09-15 16:04 — "Outbound Text Message: I fought for some extra cash. the new max I could do is 8k. I know that it isn't 11k but its more than half what you expected. Take your looks but I am just trying to do what I "
Cesar Hernandez Jr
- 2026-09-18 21:15 — "Email reply to prospect: Hi Dixon, it was great meeting you and assisting you while you were here. I will follow up with you like we discussed, but if you should need to reach me before feel free to c"
- 2026-09-18 20:27 — "Outbound Text Message: buenas tardes Misael habla Cesar de Leif Johnson Ford, me dice el banco que su vehiculo fue perdida total, espero todo este bien y al mismo tiempo me pongo a sus ordenes para po"
- 2026-09-18 14:23 — "Email reply to prospect: Israel, I sent you some info on the Corvette 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-20 21:56 — "Email auto response:"
5. Leads worked
"New leads assigned" is scoped to this window (Date Received). "Zero human-touch leads" is scoped to the rep's full current book in leads.json (4016 total leads) — a lead with only machine sends, or none at all, counts regardless of when it was assigned.
| Rep | New leads assigned | Zero human-touch leads | Sold count | Gross |
|---|---|---|---|---|
| Ajay Malani | 5 | 112 | 3 | n/a |
| Henry Smith | 11 | 87 | 5 | n/a |
| La Marcus Burnette | 12 | 162 | 5 | n/a |
| Pedro Barrera | 7 | 96 | 2 | n/a |
| Will Goodwin | 7 | 106 | 3 | n/a |
| Shane Inman | 10 | 121 | 3 | n/a |
| Edward Cavaness | 4 | 45 | 2 | n/a |
| Emely Tellez | 4 | 72 | 2 | n/a |
| Orlando Alston | 3 | 52 | 1 | n/a |
| Robert Faust | 6 | 0 | 0 | n/a |
| Tre Templeton | 2 | 3 | 0 | n/a |
| Cesar Hernandez Jr | 2 | 4 | 2 | n/a |
| Richard Martinez | 1 | 5 | 1 | n/a |
| Store total | 74 | 865 | 29 | 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.