Weekly Manager Review — week of 2026-09-14
Summary
- Store show rate: 53%
- No-show leaders: Shane Inman (4), Orlando Alston (3), Will Goodwin (2)
- Median response time: 14m
- Reps with the most 24h-unanswered: Will Goodwin (10), Orlando Alston (8), Edward Cavaness (7)
- Lost: 43 this week (61 prior week)
- Bad: 8 this week (10 prior week)
Coaching list (Monday):
- Biggest lost reason this period is "other" (21 leads) — build a talk track for it and drill it in the next sales meeting.
- Pedro Barrera logged 1 of 5 lost leads with no reason recorded — require a one-line lost reason before a lead can be marked lost.
- Vincue-Value Your Trade-Google/Cpc/Sr_leif Johnson Ford Of Manor - Used has the worst lost rate (1/2 all-time, 50%) — reconsider spend or handling on this source.
- 4 lead(s) were marked lost within 24 hours of coming in (e.g. Terrence Kennedy) — too fast, review for premature marking.
- 7 lead(s) marked "Bad" actually had a real reply or showroom visit — that's a lost opportunity, not a bad lead. Coach on when to use the Bad status.
Facebook:
- Live FB listings: 167 (26 ghost/needs mark-sold)
- Posts last 30d: 201; buyer threads: 53 (reply ratio 4%)
- Success ratio (listing -> buyer message): 10%; apply ratio (thread -> VS lead): 2%
Lost & Bad Lead Review
Lost & Bad Lead Review — last 7 days
Generated 2026-09-21T00:53:46.623Z. Window: 2026-09-14 → 2026-09-21 (prior window: 2026-09-07 → 2026-09-14).
1. Totals
| This period (7d) | Prior period (7d) | |
|---|---|---|
| Lost | 43 | 61 |
| Bad | 8 | 10 |
Lost by rep:
| Rep | Count |
|---|---|
| La Marcus Burnette | 8 |
| Shane Inman | 7 |
| Emely Tellez | 6 |
| Pedro Barrera | 5 |
| Henry Smith | 5 |
| Edward Cavaness | 4 |
| Robert Faust | 3 |
| Will Goodwin | 2 |
| Ajay Malani | 2 |
| Cesar Hernandez Jr | 1 |
Bad by rep:
| Rep | Count |
|---|---|
| Edward Cavaness | 3 |
| Pedro Barrera | 2 |
| La Marcus Burnette | 1 |
| Tre Templeton | 1 |
| Emely Tellez | 1 |
Lost by lead source:
| Source | Count |
|---|---|
| Drive By | 7 |
| Phone Up | 7 |
| Repeat Customer | 3 |
| Vincue-Value Your Trade | 3 |
| Carfax - Trade-In Leads | 2 |
| Dc New Quote | 2 |
| Truecar/Truecar | 2 |
| DC Used Quote | 2 |
| Truecar/Extended Network | 2 |
| Inbound Internet | 1 |
| Autotrader.Com - Wallet Lead | 1 |
| Cargurus | 1 |
| Vincue-Value Your Trade-Google/Cpc/Sr_leif Johnson Ford Of Manor - Used | 1 |
| Truecar/Truecar For Drivers On Uber | 1 |
| Autofi Request More Info | 1 |
| Cargurus - Digital Deal | 1 |
| Fd - Trade-In | 1 |
| Vincue-Buying Center | 1 |
| Sendmeafriend.Com | 1 |
| 1 | |
| Autotrader.Com - Lead | 1 |
| Truecar/Beneplace | 1 |
Bad by lead source:
| Source | Count |
|---|---|
| Carfax - Trade-In Leads | 2 |
| 1 | |
| Referral | 1 |
| Service Dept | 1 |
| Chat-Impel | 1 |
| Drive By | 1 |
| DC Used Quote | 1 |
2. Every lost lead (43)
| Name | Rep | Source | Vehicle | Days Worked | Bucket | Reason (verbatim) |
|---|---|---|---|---|---|---|
| Rebecca Pounds | Pedro Barrera | Inbound Internet | (none) | 15d | no-reason-given | _no reason given_ |
| Eric Keefer | Edward Cavaness | Autotrader.Com - Wallet Lead | 2022 Kia Forte GT-Line (Used) / FWD 4dr Car (4 Door) | 52d | other | Inbound Text Message: Please stop, we are not looking for a vehicle any longer |
| Matt Modesette | Henry Smith | Cargurus | 2004 Ford Mustang Premium Mach 1 (Used) / RWD 2dr Car (2 Door) | 2d | bought-elsewhere | BOUGHT ELSE WHERE |
| Talha Ghaznavi | Emely Tellez | Carfax - Trade-In Leads | (none) | 62d | other | she is not interested |
| Juan Torres Bernal | La Marcus Burnette | Repeat Customer | 2026 Ford F-150 Raptor (New) / 4WD Crew Cab Pickup (4 Door) | 14d | no-response | Left message |
| John Kim | Robert Faust | Drive By | 2025 Ford Bronco Sport Badlands (New) / 4WD Sport Utility (4 Door) | 29d | no-response | Left message |
| Fabio Mendonca | Robert Faust | Vincue-Value Your Trade-Google/Cpc/Sr_leif Johnson Ford Of Manor - Used | 2021 Ford Bronco Sport Big Bend (Used) / 4WD Sport Utility (4 Door) | 2d | bought-elsewhere | Bought Elsewhere |
| Pedro Hernandez | Will Goodwin | Drive By | 2023 Ford Transit Cargo Van 350 (Used) / RWD Full-size Cargo Van (3 Do | 2d | other | Customer said he will stop by today |
| Sebastian Luna | Emely Tellez | Drive By | (none) | 13d | other | Inbound Text Message: Ok gracias |
| Housman Hydar | Shane Inman | Truecar/Truecar For Drivers On Uber | 2026 Ford Mustang Mach-E Select AWD (New) / Trans: AutomaticStyle: S | 62d | other | Outbound Text Message: Hey Housman, no ask here. Hope things are starting to ease up. We'll be here when the time is right. |
| Charlene Dixon | Cesar Hernandez Jr | Phone Up | 2026 Ford Explorer (New) | 3d | bought-elsewhere | Customer bought elsewhere |
| Quint Sherrod | Henry Smith | Autofi Request More Info | 2026 Ford F-150 Tremor (New) / 4WD Crew Cab Pickup (4 Door) | 2d | bought-elsewhere | He found another Tremor at a different dealership for $10,000 less |
| Johnnie Moore | Henry Smith | Phone Up | 2026 Ford Maverick (New) | 13d | other | https://audio.callrevu.com/ob/511709876 |
| Karen Flores | Henry Smith | Dc New Quote | 2026 Ford Bronco Outer Banks (New) / 4WD Convertible (4 Door) | 7d | out-of-market | Not in the market for a vehicle at this time |
| Jeremiah Bellfield | La Marcus Burnette | Cargurus - Digital Deal | 2014 Buick LaCrosse Leather (Used) / FWD 4dr Car (4 Door) | 26d | other | Outbound Text Message: Jeremiah, you said you were ready. Let me pull a few options together based on your Ram and payoff. Free this weekend to take a look? |
| Linda Vernon | Ajay Malani | Fd - Trade-In | 2026 Ford Escape (New) | 1d | other | Email reply to prospect: Got it, Linda. We actually have a 2014 Explorer in stock right now that might be worth a look. And we'll keep an eye out on Escapes too |
| Terrence Kennedy | Shane Inman | Vincue-Value Your Trade | 2024 Ford Maverick XLT (Used) / FWD Crew Cab Pickup (4 Door) | 0d | other | 5125997761 is his number the other one is his wifes ⚠️24h |
| Henry Nieto | Edward Cavaness | Vincue-Value Your Trade | 2026 Ford F-150 XL (New) / RWD Regular Cab Pickup (2 Door) | 59d | other | 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 aro |
| Angel Grandes | Shane Inman | Vincue-Buying Center | (Used) | 3d | other | sold it |
| Jose Lopez | La Marcus Burnette | Drive By | 2023 Ford F-150 King Ranch (Used) / 4WD Crew Cab Pickup (4 Door) | 10d | other | No repsonse |
| Emilio Aguirre | La Marcus Burnette | Drive By | 2024 Ford F-150 XL (Certified) / RWD Regular Cab Pickup (2 Door) | 9d | no-response | No response |
| Connor K | Emely Tellez | Phone Up | (none) | 6d | other | Outbound Text Message: Connor, that's awful and you deserved better. We're not that store. If you still want to find the right vehicle, I'm here and I'll be str |
| Tyler Meachum | La Marcus Burnette | Drive By | 2022 Ford Super Duty F-250 SRW LARIAT (Used) / 4WD Crew Cab Pickup (4 | 1d | bought-elsewhere | bought elsewhere ⚠️24h |
| Eamon Higgins | Shane Inman | Truecar/Truecar | 2026 Ford Super Duty F-250 SRW LARIAT (New) / 4WD Crew Cab Pickup (4 D | 12d | other | opted out |
| Kimberly Antolini | Shane Inman | DC Used Quote | 2022 Ford Ranger XL (Certified) / RWD Extended Cab Pickup (4 Door) | 14d | out-of-market | said she was out of market for now |
| Patrica Chavez | Will Goodwin | Phone Up | (none) | 19d | other | not looking anymore |
| Marcus Hayth | Emely Tellez | Phone Up | 2026 Ford F-150 Raptor (New) / 4WD Crew Cab Pickup (4 Door) | 9d | other | he only wants a blue raptor and the one we had sold and we dont have anything coming in |
| Eric Smith | Pedro Barrera | Phone Up | 2023 Ford F-150 LARIAT (Certified) / 4WD Crew Cab Pickup (4 Door) | 7d | bought-elsewhere | BOUGHT |
| Janet Dunn | Henry Smith | Carfax - Trade-In Leads | (none) | 3d | out-of-market | She is not looking to sell her vehicle at this time and she's not in the market. Marking the lead lost. |
| Holmes Onwukaife | Emely Tellez | Repeat Customer | 2025 Ford F-150 Tremor (Certified) / 4WD Crew Cab Pickup (4 Door) | 1d | other | Personal friend. he said traffic was too bad coming from cedar park. He said he will come tomorrow instead. |
| Julianna Singer | Shane Inman | Sendmeafriend.Com | (New) | 1d | other | wants to come in saturday ⚠️24h |
| Israel Orozco | La Marcus Burnette | Dc New Quote | 2026 Ford F-150 XL (New) / 4WD Regular Cab Pickup (2 Door) | 18d | other | Email reply to prospect: Hi Israel, The STX I mentioned yesterday (stock #TKE15182A, 10 miles) is still at Manor. If you're around this weekend, I can have it r |
| Axel Mejias | Ajay Malani | Truecar/Extended Network | 2026 Ford Super Duty F-250 SRW LARIAT (New) / 4WD Crew Cab Pickup (4 D | 12d | other | Email reply to prospect: Axel, I know we couldn't get the numbers where you needed them on the Lariat. I'm not going to pretend otherwise. What I can do is keep |
| Val Han | Robert Faust | (none) | 9d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 125322941448 | |
| Hervin Padilla | La Marcus Burnette | Repeat Customer | (none) | 1d | trade | negative on trade ⚠️24h |
| Ismael Perez | Pedro Barrera | Drive By | 2023 Ford F-150 XL (Certified) / RWD Crew Cab Pickup (4 Door) | 9d | other | Age |
| Dan Jones | Edward Cavaness | Truecar/Extended Network | 2026 Ford Maverick XLT (New) / AWD Crew Cab Pickup (4 Door) | 27d | bought-elsewhere | Purchased else where |
| Vicki Fuentes | La Marcus Burnette | DC Used Quote | 2014 Chevrolet Silverado 1500 LT (Used) / RWD Crew Cab Pickup (4 Door) | 20d | bought-elsewhere | bought elsewhere |
| Prudhvi Nooney | Pedro Barrera | Vincue-Value Your Trade | 2025 Ford Bronco Outer Banks (New) / 4WD Convertible (4 Door) | 14d | bought-elsewhere | BOUGHT |
| Dorian Torres | Edward Cavaness | Autotrader.Com - Lead | 2022 Jeep Grand Cherokee L Limited (Certified) / 4WD Sport Utility (4 | 7d | out-of-market | not in the market |
| Louis Ramirez | Shane Inman | Truecar/Truecar | 2025 Toyota Tacoma 4WD SR5 (Used) / 4WD Crew Cab Pickup (4 Door) | 3d | bought-elsewhere | bought elsewhere |
| Anas Khazaali | Pedro Barrera | Phone Up | 2026 Chevrolet Silverado 1500 RST (Used) / 4WD Extended Cab Pickup (4 | 6d | out-of-market | NO LONGER INTERESTED |
| Brian Fitzpatrick | Emely Tellez | Truecar/Beneplace | 2022 Ford Explorer Base (Certified) / RWD Sport Utility (4 Door) | 4d | bought-elsewhere | bought elsewhere |
3. Every bad lead (8)
| Name | Rep | Source | Vehicle | Days Worked | Bucket | Reason (verbatim) | Really bad? |
|---|---|---|---|---|---|---|---|
| Abbi Hunter | Pedro Barrera | 2024 Ford Expedition Max Limited (Certified) / RWD Sport Utility (4 Do | 11d | other | Outbound Text Message: Shame I have family in Tallahassee. Just trying to make a whole excuse to go down there. If something changes, please let us know. :) | ⚠️ NO — customer replied/visited | |
| Autumn Syfret | La Marcus Burnette | Referral | (none) | 2d | no-reason-given | _no reason given_ | yes |
| Sonny Willis | Tre Templeton | Service Dept | (none) | 3d | bought-elsewhere | 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 a | ⚠️ NO — customer replied/visited |
| Ricardo Bustos | Emely Tellez | Carfax - Trade-In Leads | (none) | 52d | other | Inbound Text Message: Fuck off | ⚠️ NO — customer replied/visited |
| Jeff S | Edward Cavaness | Chat-Impel | 2026 Ford Bronco Outer Banks (New) / 4WD Convertible (4 Door) | 2d | out-of-market | Inbound Text Message: We're no longer in the market for a vehicle | ⚠️ NO — customer replied/visited |
| Cesar Cardenas | Edward Cavaness | Carfax - Trade-In Leads | (none) | 3d | other | Email reply to prospect: Hey Cesar, No pressure at all. If you ever want a more accurate number on the Sierra than what Carfax estimated, I can get you a real a | ⚠️ NO — customer replied/visited |
| Ana Lopez Villegas | Edward Cavaness | Drive By | 2019 Nissan Altima 2.5 SV (Certified) / FWD 4dr Car (4 Door) | 18d | bought-elsewhere | purchased elsewhere | ⚠️ NO — customer replied/visited |
| Joe Calovic | Pedro Barrera | DC Used Quote | 2009 Cadillac DTS w/1SC (Used) / FWD 4dr Car (4 Door) | 6d | price | Email reply from prospect: Looking for an older Cadillac with low miles. Or possibly another model. Budget is open. Prefer a black vehicle. If I see something a | ⚠️ NO — customer replied/visited |
4. Patterns
Top 3 lost-reason buckets: other (21), bought-elsewhere (11), out-of-market (5)
Reps with lost leads that have no reason recorded:
| Rep | No reason | Total lost |
|---|---|---|
| Pedro Barrera | 1 | 5 |
| Robert Faust | 1 | 3 |
Sources with the worst lost rate (lost this period / all-time leads from source):
| Source | Lost this period | All-time leads | Rate |
|---|---|---|---|
| Vincue-Value Your Trade-Google/Cpc/Sr_leif Johnson Ford Of Manor - Used | 1 | 2 | 50.0% |
| Truecar/Truecar For Drivers On Uber | 1 | 3 | 33.3% |
| Inbound Internet | 1 | 6 | 16.7% |
| Truecar/Extended Network | 2 | 27 | 7.4% |
| Fd - Trade-In | 1 | 15 | 6.7% |
Marked lost within 24h of creation (too fast): 4
- Terrence Kennedy (Shane Inman, Vincue-Value Your Trade)
- Tyler Meachum (La Marcus Burnette, Drive By)
- Julianna Singer (Shane Inman, Sendmeafriend.Com)
- Hervin Padilla (La Marcus Burnette, Repeat Customer)
5. Coaching list (Monday)
- Biggest lost reason this period is "other" (21 leads) — build a talk track for it and drill it in the next sales meeting.
- Pedro Barrera logged 1 of 5 lost leads with no reason recorded — require a one-line lost reason before a lead can be marked lost.
- Vincue-Value Your Trade-Google/Cpc/Sr_leif Johnson Ford Of Manor - Used has the worst lost rate (1/2 all-time, 50%) — reconsider spend or handling on this source.
- 4 lead(s) were marked lost within 24 hours of coming in (e.g. Terrence Kennedy) — too fast, review for premature marking.
- 7 lead(s) marked "Bad" actually had a real reply or showroom visit — that's a lost opportunity, not a bad lead. Coach on when to use the Bad status.
Rep Weekly Scorecard
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-20T11:05:38.576Z
- vs-sold.json synced: 2026-09-20T11:05:38.314Z
- leads.json synced: 2026-09-21T00:33:47.368Z
- 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 | 28 | 11 | 82 | 19 | 29 |
| Pedro Barrera | 71 | 25 | 69 | 32 | 26 |
| Will Goodwin | 81 | 27 | 84 | 35 | 39 |
| Shane Inman | 91 | 30 | 118 | 44 | 31 |
| Edward Cavaness | 28 | 6 | 55 | 37 | 41 |
| Emely Tellez | 82 | 13 | 45 | 20 | 17 |
| Orlando Alston | 7 | 0 | 20 | 11 | 13 |
| Robert Faust | 22 | 5 | 45 | 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 | 501 | 129 | 625 | 286 | 273 |
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 | 23 | 33m | 4 |
| Pedro Barrera | 29 | 5m | 2 |
| Will Goodwin | 44 | 46m | 10 |
| Shane Inman | 45 | 10m | 3 |
| Edward Cavaness | 39 | 14m | 7 |
| 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 | 14m | 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 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?"
- 2026-09-19 14:16 — "Email reply to prospect: Good morning, the following are rates through FORD. 2.9% for 36 months 3.9% for 48 months 4.9% for 60 months 5.9% for 72 months LaMarcus Burnette Business Manager Leif Johnson" [FLAG: rate/APR]
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.
Rep Ping Scorecard
Rep Ping Scorecard — last 14 days
Generated 2026-09-21T00:53:47.245Z. Window: 2026-09-07T00:53:47.245Z -> 2026-09-21T00:53:47.245Z.
data/store/leads.json last synced: 2026-09-21T00:33:47.368Z.
What this can prove: a customer replied (memory/reply-ledger.jsonl, the same event that triggers the rep text), whether a genuinely human outbound (not in message-log.json) landed on that customer's file afterward, and how fast. What it cannot prove: that the rep read the TEXT itself, only that the CUSTOMER got a real human response afterward — a rep could act without ever opening the text (e.g. already working the deal by phone), or a text could bounce and go unnoticed while someone else in the store answers the customer.
UNVERIFIED means data/store/leads.json's sync for that customer is more than 6h stale as of report time — it is NOT counted as "no response," because the real answer may exist in VinSolutions and just hasn't synced down yet.
PINGS (proxy) vs LEDGER SENDS: "Pings" below = reply-ledger events in-window joined to a rep via leads.json. "Ledger sends" = actual confirmed text sends from memory/staff-text-sent.jsonl for that rep in the same window (class "reply"). They will not match exactly — reply-coalescing (repeat replies from the same customer inside 2h roll into one later text), quiet-hours deferral, and the governor's consolidation hold all mean one ping event doesn't always equal one text, and vice versa. Treat "Ledger sends" as the hard number of texts that went out, and "Pings" as the number of reply events the table below is scored against.
33 reply-ledger event(s) in-window had no matching leads.json record (skipped — can't attribute). 32 more had no valid roster rep assigned (Unassigned / Will Robbins / a corrupted "Assigned Salesperson" grid-scrape string — not a salesperson text, skipped from the per-rep table).
No phone on file: Abdelhak Zerrouk, Cesar Hernandez Jr, Christopher Tait, Daniel Arce, Gary Brophy, Kendra Parrish, Malachi Betancourth, Manuel Bran, Michael Naszkiewicz, Ramon Silos, Richard Martinez, Ryan Forbus, Sujey Bello, Tariq Halawani, Tre Templeton — have customers assigned to them but no phone number in config/team-roster.json, so messageStaff() can never text them. A reply from one of their customers falls back to a "callback" ping to Will instead. Structural gap, not a reading-their-texts problem — they show up below with 0 ledger sends even where they have pings.
Per rep
| Rep | Pings (proxy) | Ledger sends | <1h | <4h | Same day | Later | Never | Unverified |
|---|---|---|---|---|---|---|---|---|
| Ajay Malani | 91 | 4 | 3 | 2 | 0 | 0 | 0 | 86 |
| Cesar Hernandez Jr | 26 | 0 | 0 | 0 | 0 | 0 | 26 | 0 |
| Edward Cavaness | 142 | 57 | 16 | 17 | 7 | 15 | 0 | 87 |
| Emely Tellez | 44 | 46 | 9 | 2 | 0 | 2 | 1 | 30 |
| Henry Smith | 107 | 69 | 16 | 22 | 2 | 12 | 1 | 54 |
| La Marcus Burnette | 134 | 70 | 17 | 8 | 0 | 16 | 0 | 93 |
| Manuel Bran | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 |
| Matthew Cavaness | 0 | 23 | 0 | 0 | 0 | 0 | 0 | 0 |
| Orlando Alston | 116 | 28 | 5 | 8 | 2 | 14 | 0 | 87 |
| Oscar Pulido | 13 | 20 | 0 | 0 | 7 | 5 | 0 | 1 |
| Pedro Barrera | 96 | 31 | 6 | 2 | 1 | 7 | 0 | 80 |
| Robert Faust | 30 | 0 | 11 | 8 | 0 | 5 | 0 | 6 |
| Shane Inman | 94 | 66 | 23 | 26 | 4 | 17 | 6 | 18 |
| Will Goodwin | 161 | 53 | 9 | 10 | 4 | 69 | 0 | 69 |
| STORE TOTAL | 1056 | 467 | 115 | 105 | 27 | 162 | 34 | 613 |
10 oldest unanswered pings (bucket = Never, i.e. fresh sync + no human outbound found since)
| Rep | Customer | Ping at | Age | What the ping was about |
|---|---|---|---|---|
| Shane Inman | Brand Bee | 2026-09-11T13:10:32.633Z | 9d 11h | (reply detected via email — text unavailable) |
| Shane Inman | Brand Bee | 2026-09-11T17:36:07.519Z | 9d 7h | Email reply from prospect: Send me the link On Sep 11, 2026, at 06:10, Will Robbins wrobbins@leifjohnsonfordmanor.com wrote: Brand, glad you |
| Shane Inman | Brand Bee | 2026-09-11T18:08:14.534Z | 9d 6h | (reply detected via email — text unavailable) |
| Shane Inman | Brand Bee | 2026-09-11T18:44:05.087Z | 9d 6h | (reply detected via email — text unavailable) |
| Shane Inman | Brand Bee | 2026-09-11T19:30:13.245Z | 9d 5h | (reply detected via email — text unavailable) |
| Shane Inman | Brand Bee | 2026-09-11T20:04:07.399Z | 9d 4h | (reply detected via email — text unavailable) |
| Henry Smith | Braedan Hatch | 2026-09-16T21:12:02.604Z | 4d 3h | Inbound Text Message: Yeah I like that body style |
| Cesar Hernandez Jr | Carlos Guzman | 2026-09-17T20:45:59.576Z | 3d 4h | Inbound Text Message: Me puedes mandar fotos |
| Cesar Hernandez Jr | Carlos Guzman | 2026-09-17T21:18:00.432Z | 3d 3h | (reply detected via text — text unavailable) |
| Cesar Hernandez Jr | Carlos Guzman | 2026-09-17T21:50:01.085Z | 3d 3h | (reply detected via text — text unavailable) |
FB Performance Audit
FB Marketplace Performance Audit — 2026-09-21
Read-only. Built from files already on disk — no browser, no Facebook touched. Window: last 30 days.
1. Listings
Last audit: 2026-09-20T15:19:40.752Z
- Live on Facebook right now: 167
- In current inventory (correct): 131
- Ghosts — live on FB but NOT in inventory, needs mark-sold: 26
- Tracked as posted but gone from FB (stale tracking): 6
- Duplicate listing groups: 0
- Untracked/adoptable (live on FB, dup-post risk if reposted): 1
- Untracked title-ghosts (live on FB, not in our tracked-posted list): 9
Trend vs 2026-09-01: live listings 152 → 167, ghosts 11 → 26, tracked-but-gone 24 → 6.
Read: a lot of ghost listings — FB thinks units are for sale that we've already sold. Worth a mark-sold pass.
2. Posting
Posts in last 30 days: 201 across 21 active posting days (avg 9.6/active day). Last run: 2026-09-17T21:37:08.144Z. Tracked-posted ledger total (all time): 685.
Scan/post-run failures (scan shrank >15%, aborted) in last 30 days: 14. 14-day-dedup skip events logged: 501 VIN-skips (posted recently, not re-posted).
Currently paused FB jobs:
fb-approve: Paused 2026-08-28 by Claude at Will's request: pause ALL Facebook jobs for the moment. rm this marker to resume.fb-closer: Paused 2026-09-08 4:40pm CT: Will — Facebook replies are handled by his person; he wants posting/inventory/viewing only, not the draft assistant. Drafts already queued stay for his review; fb-approve/fb-nudge/fb-publish-drafts remain paused. rm this marker to resume drafts-only (FB_CLOSER_AUTO=0 keeps every draft human-approved).fb-marketplace-drip-poster.ts: Paused 2026-08-11 ~10pm: Will reports duplicate postings on Marketplace. Stay paused until the live selling-dashboard scan + dedupe verdict land.fb-nudge: Paused 2026-08-28 by Claude at Will's request: pause ALL Facebook jobs for the moment. rm this marker to resume.fb-publish-drafts: Paused 2026-08-28 by Claude at Will's request: pause ALL Facebook jobs for the moment. rm this marker to resume.
Throttle/scan-shrink incident days in last 30 days: 6 (2026-09-12, 2026-09-14, 2026-09-15, 2026-09-16, 2026-09-17, 2026-09-18).
Last known-good scan: 162 cards at 2026-09-17T21:06:32.900Z.
3. Buyer messages
Buyer threads (last 30d, by first-seen): 53. Threads with zero replies from us: 51. Reply ratio: 4%.
Median time-to-first-reply where we did reply: 9.8h.
Last thread activity recorded: 2026-09-08T20:27:44.489Z. fb-closer has been paused since 9/8 — Will's person answers by hand, so this state may be stale.
4. Leads
FB Marketplace leads in VinSolutions, last 30 days: 12 (all-time in file: 41).
Outcome breakdown: Active Lead: 2, Lost: 2, Active: 5, Bad: 1, Sold: 2.
Sold matches (gcid → vs-sold.json, or name → axcessa-cardeals.json): 1.
- Jose Hernandez — 2021 GMC Yukon (matched via VS sold)
5. Ratios Will asked for
Success ratio (posted listings with ≥1 buyer message / posted, 30d): 10% (21 of 201).
Apply ratio (buyer threads that turned into a VS lead, best-effort VIN/name match, 30d): 2% (1 of 53).
Listings-per-sale: 201 listings posted in 30d vs 1 FB-sourced sale(s) matched — best-effort, name/gcid matching only.
6. What blocked posting
- 2026-08-11: duplicate postings reported by Will — fb-marketplace-drip-poster paused, superseded by fb-safe-post (10/day cap, dedupe) since 8/28.
- 2026-08-28: Will requested ALL Facebook jobs paused (fb-approve, fb-closer, fb-nudge, fb-publish-drafts) while a calm-profile plan was put in place.
- 2026-09-05/08: Facebook replies ruled human-owned (Will's person) — fb-closer stays draft-queue-only; posting + audit keep running.
- 2026-09-16 to 2026-09-18: repeated scan-shrink throttle — Marketplace 'you/selling' page rendered as few as 5-46 cards vs 142-162 expected, aborting posts to avoid re-listing sold units (see section 2 failure count).
- 2026-09-20: JOB SILENT alert on fb-audit-live-listings (last ran 5.2d ago per scheduler) — audit cadence gap, not a posting block.