Rep Weekly Scorecard — 2026-10-19
Window: last 7 days (2026-10-12 to 2026-10-19), 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-19T11:05:41.506Z
- vs-sold.json synced: 2026-10-19T11:05:41.289Z
- leads.json synced: 2026-10-19T11:36:41.797Z
- 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 | 4 | n/a | 4 | 4 | 0 | 100% | -1 |
| Henry Smith | 3 | n/a | 3 | 1 | 0 | 100% | ±0 |
| La Marcus Burnette | 5 | n/a | 2 | 0 | 2 | 40% | +4 |
| Pedro Barrera | 5 | n/a | 5 | 2 | 0 | 100% | +3 |
| Will Goodwin | 4 | n/a | 1 | 1 | 3 | 25% | +1 |
| Shane Inman | 7 | n/a | 5 | 3 | 1 | 71% | +2 |
| Edward Cavaness | 4 | n/a | 1 | 0 | 2 | 25% | +2 |
| Emely Tellez | 1 | n/a | 1 | 1 | 0 | 100% | -1 |
| Orlando Alston | 1 | n/a | 0 | 0 | 0 | 0% | +1 |
| Cesar Hernandez Jr | 4 | n/a | 3 | 2 | 0 | 75% | -1 |
| Richard Martinez | 0 | n/a | 0 | 0 | 0 | n/a | ±0 |
| Tariq Halawani | 4 | n/a | 3 | 2 | 0 | 75% | ±0 |
| Roster total | 42 | n/a | 28 | 16 | 8 | 67% | +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 | 3 | 0 | 6 | 14 | 14 |
| Henry Smith | 66 | 3 | 108 | 36 | 16 |
| La Marcus Burnette | 119 | 36 | 132 | 31 | 13 |
| Pedro Barrera | 116 | 29 | 145 | 64 | 15 |
| Will Goodwin | 28 | 22 | 96 | 41 | 23 |
| Shane Inman | 124 | 42 | 159 | 117 | 39 |
| Edward Cavaness | 37 | 13 | 118 | 32 | 21 |
| Emely Tellez | 34 | 5 | 48 | 31 | 19 |
| Orlando Alston | 6 | 0 | 35 | 12 | 7 |
| Cesar Hernandez Jr | 56 | 8 | 45 | 23 | 9 |
| Richard Martinez | 0 | 3 | 1 | 3 | 1 |
| Tariq Halawani | 89 | 7 | 85 | 44 | 23 |
| Roster total | 678 | 168 | 978 | 448 | 200 |
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 | 38 | 8m | 38 | 5 | 0 |
| La Marcus Burnette | 64 | 9m | 64 | 7 | 0 |
| Pedro Barrera | 70 | 5m | 70 | 5 | 0 |
| Will Goodwin | 36 | 24m | 36 | 12 | 0 |
| Shane Inman | 74 | 14m | 74 | 4 | 0 |
| Edward Cavaness | 54 | 13m | 54 | 4 | 0 |
| Emely Tellez | 35 | 5.0h | 35 | 14 | 0 |
| Orlando Alston | 4 | 10m | 4 | 1 | 0 |
| Cesar Hernandez Jr | 34 | 23m | 34 | 1 | 0 |
| Richard Martinez | 2 | 14m | 2 | 0 | 0 |
| Tariq Halawani | 64 | 7m | 62 | 11 | 2 |
| Roster total | 483 | 10m | 481 | 67 | 2 |
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-17 20:26 — "Outbound Text Message: Awesome. Drive safely, we'll see y'all soon! 😁"
- 2026-10-17 18:30 — "Outbound Text Message: Hey Larry, it’s Matt at Leif Johnson Ford of Manor. I wanted to follow up and see if you’ve given the Bronco Sport any more thought since we looked at the financing with $20K do"
- 2026-10-17 17:52 — "Outbound Text Message: Just sent the email over"
La Marcus Burnette
- 2026-10-19 01:45 — "Email auto response:"
- 2026-10-18 19:17 — "Email auto response:"
- 2026-10-17 20:58 — "Outbound Text Message: May you fill out this application so we can get the numbers together for you? Any money down? https://www.leifjohnsonfordofmanor.com/finance-application/"
Pedro Barrera
- 2026-10-18 15:50 — "Email auto response:"
- 2026-10-17 21:48 — "Outbound Text Message: Hey Luis! I’d be happy to work on getting you numbers on the single cab F-150. Are you looking to finance or pay cash, and do you have a vehicle you're looking to trade-in? I’ll"
- 2026-10-17 21:46 — "Outbound Text Message: Hey Brian, it’s Pedro with Leif Johnson Ford of Manor! Are you still interested in an Explorer ST? I’d be happy to work on getting you numbers on one! Are you still looking?"
Will Goodwin
- 2026-10-17 16:44 — "Email reply to prospect: Hi Sandeep! Just checking in one last time on your 2010 Audi Q5. If you’re still considering selling or trading it, we’d be happy to put together an updated appraisal and help"
- 2026-10-17 16:42 — "Outbound Text Message: Hey Juan! Just wanted to make it easy to reconnect on the 2026 Bronco Outer Banks. We’d be happy to review your options and look at the trade value for your BMW X1. Would you li"
- 2026-10-17 16:41 — "Outbound Text Message: Hi Steven! The Neptune Blue 2027 F-250 Platinum is expected to arrive between 10/26 and 11/1. Would you like to reserve it with a deposit to help secure it, or would you prefer " [FLAG: deposit]
Shane Inman
- 2026-10-18 04:01 — "Email auto response:"
- 2026-10-17 23:31 — "Email reply to prospect: Hi Samantha, it's Shane at Leif Johnson Ford Manor. I just wanted to touch base with you about your 4Runner! We’re actively looking to add quality pre-owned vehicles to ou"
- 2026-10-17 23:13 — "Outbound Text Message: This one is high roof 4x4 https://www.leifjohnsonfordofmanor.com/vehicle/1FTRU8UG1TKB26426/2026-Ford-Transit-Austin-TX/" [FLAG: other-store name]
Edward Cavaness
- 2026-10-17 23:17 — "Outbound Text Message: absolutely here to help have a great weekend"
- 2026-10-17 22:47 — "Outbound Text Message: we just got in a new Mustang Dark Horse SC that I thought might interest you. I know you're focused on selling your Shelby right now, but I wanted to mention it in case you'd be"
- 2026-10-17 22:38 — "Outbound Text Message: your welcome are you only looking to sell or Trade in?"
Emely Tellez
- 2026-10-17 20:25 — "Outbound Text Message: Hi Mike, this is Eric French with Leif Johnson Ford. I'm one of the sales managers here. How can I help you in regard to this 22 F-150? Right truck? I'm here to help. Let me kno"
- 2026-10-17 16:39 — "Email reply to prospect: Hi Timothy, Thank you for your interest in the 2013 Mazda3 you found on AutoTrader. Unfortunately, that vehicle has sold, but I’d still love the opportunity to help you find s"
- 2026-10-17 00:46 — "Email auto response:"
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-17 22:10 — "Email reply to prospect: Buenas tardes, todabia anda buscando una troka? Cesar Hernandez Leif Johnson Ford of Manor 512-845-4033 You are receiving this email because you inquired about or purchased a "
- 2026-10-17 22:09 — "Outbound Text Message: Buenas tardes"
- 2026-10-17 22:07 — "Email reply to prospect: Hey, this is Cesar with Leif Johnson Ford in Manor! I just wanted to introduce myself and let you know I’m here to help make your vehicle shopping experience easy and stress-f"
Richard Martinez
- 2026-10-17 22:03 — "Email auto response:"
- 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 22:34 — "Email auto response:"
- 2026-10-17 18:13 — "Outbound Text Message: 10507 US-290, Manor, TX 78653"
- 2026-10-17 16:46 — "Email reply to prospect: Good morning Beth, Just wondering if you had the chance to see the video I sent you on the 2024 VW Altas. and if you have some time this afternoon to drop by and take it for a"
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 (4642 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 | 12 | 64 | 2 | n/a |
| La Marcus Burnette | 8 | 99 | 0 | n/a |
| Pedro Barrera | 9 | 57 | 2 | n/a |
| Will Goodwin | 6 | 80 | 1 | n/a |
| Shane Inman | 10 | 84 | 3 | n/a |
| Edward Cavaness | 9 | 36 | 2 | n/a |
| Emely Tellez | 8 | 55 | 1 | n/a |
| Orlando Alston | 0 | 26 | 0 | n/a |
| Cesar Hernandez Jr | 6 | 9 | 3 | n/a |
| Richard Martinez | 0 | 3 | 1 | n/a |
| Tariq Halawani | 8 | 6 | 4 | n/a |
| Roster total | 81 | 613 | 23 | 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.