Lost & Bad Lead Review — last 7 days
Generated 2026-09-28T11:40:01.576Z. Window: 2026-09-21 → 2026-09-28 (prior window: 2026-09-14 → 2026-09-21).
1. Totals
| This period (7d) | Prior period (7d) | |
|---|---|---|
| Lost | 59 | 42 |
| Bad | 16 | 9 |
Lost by rep:
| Rep | Count |
|---|---|
| La Marcus Burnette | 12 |
| Henry Smith | 8 |
| Shane Inman | 8 |
| Pedro Barrera | 6 |
| Emely Tellez | 5 |
| Robert Faust | 5 |
| Ajay Malani | 3 |
| Edward Cavaness | 3 |
| Will Robbins | 2 |
| Will Goodwin | 2 |
| Cesar Hernandez Jr | 2 |
| Richard Martinez | 1 |
| Orlando Alston | 1 |
| Matthew Cavaness | 1 |
Bad by rep:
| Rep | Count |
|---|---|
| Edward Cavaness | 4 |
| La Marcus Burnette | 3 |
| Will Robbins | 2 |
| Emely Tellez | 2 |
| Henry Smith | 1 |
| Matthew Cavaness | 1 |
| Oscar Pulido | 1 |
| Ajay Malani | 1 |
| Pedro Barrera | 1 |
Lost by lead source:
| Source | Count |
|---|---|
| Phone Up | 7 |
| Drive By | 7 |
| Autotrader.Com - Lead | 5 |
| DC Used Quote | 4 |
| Repeat Customer | 3 |
| Sendmeafriend.Com | 3 |
| Truecar/Truecar | 3 |
| 2 | |
| Cargurus | 2 |
| Vincue-Value Your Trade | 2 |
| Referral | 2 |
| Inbound Internet | 1 |
| Cargurus - Appt - Digital Deal | 1 |
| Truecar/Benefithub | 1 |
| Accelerate Dr - Autotrader - Deal Events | 1 |
| Truecar/Extended Network | 1 |
| Autofi Deal Saved | 1 |
| Dc Credit | 1 |
| Carfax - Trade-In Leads | 1 |
| Auto Alert | 1 |
| Service Dept | 1 |
| Fd - Oem Quick Quote | 1 |
| Truecar/U.S. News | 1 |
| Truecar/Beneplace | 1 |
| Autofi Request More Info | 1 |
| Truecar/Sams Club | 1 |
| Dc New Quote | 1 |
| Autofi Trade In Offer Shown To Customer | 1 |
| Truecar/Perkspot | 1 |
| Chat-Impel | 1 |
Bad by lead source:
| Source | Count |
|---|---|
| Phone Up | 5 |
| 3 | |
| Drive By | 2 |
| Manor Area Outreach | 1 |
| Truecar/Consumer Reports | 1 |
| Truecar/Sams Club | 1 |
| Autotrader.Com - Lead | 1 |
| Vincue-Value Your Trade | 1 |
| Autofi Standalone App | 1 |
2. Every lost lead (59)
| Name | Rep | Source | Vehicle | Days Worked | Bucket | Reason (verbatim) |
|---|---|---|---|---|---|---|
| Rebecca Pounds | Pedro Barrera | Inbound Internet | (none) | 22d | no-reason-given | _no reason given_ |
| Dale Haney | Henry Smith | Phone Up | 2019 Ford Taurus SE (Used) / FWD 4dr Car (4 Door) | 22d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 125444525290 |
| Chauncy Christian Ragland | Will Robbins | Repeat Customer | (none) | 0d | other | Email auto response: ⚠️24h |
| Javier Alonso | Pedro Barrera | 2024 Ford F-150 XLT (Certified) / RWD Crew Cab Pickup (4 Door) | 12d | other | NIM | |
| Julio Hernandez | Ajay Malani | Cargurus | 2009 Cadillac SRX V6 (Used) / RWD SUV (4 Door) | 57d | no-reason-given | _no reason given_ |
| Roberto Ramos | Pedro Barrera | Cargurus - Appt - Digital Deal | (none) | 64d | no-reason-given | _no reason given_ |
| John Everett | La Marcus Burnette | Truecar/Benefithub | 2026 Ford Maverick XLT AWD (New) / Trans: AutomaticStyle: Pickup Tru | 64d | no-reason-given | _no reason given_ |
| Rosa Lopez | Edward Cavaness | DC Used Quote | 2014 Ford F-150 (New) | 32d | no-reason-given | _no reason given_ |
| Juan Morales | Shane Inman | Accelerate Dr - Autotrader - Deal Events | 2012 Ford Mustang (New) / RWD Coupe (2 Door) | 49d | no-reason-given | _no reason given_ |
| Sergio Gutierrez | Shane Inman | Truecar/Extended Network | 2019 Ford F-150 (New) / 4WD Truck (SuperCrew) | 73d | no-reason-given | _no reason given_ |
| Johnny Johnny | Shane Inman | Phone Up | 2007 Jeep Grand Cherokee / VIN: 1J8GS48K87C586115 | 58d | no-reason-given | _no reason given_ |
| Amy Pearson | Ajay Malani | Autofi Deal Saved | 2008 Dodge Avenger / VIN: 1B3LC46K68N189449 | 63d | no-reason-given | _no reason given_ |
| Jonathan Brou | Henry Smith | Dc Credit | (none) | 48d | no-reason-given | _no reason given_ |
| Manny Torres | Emely Tellez | Autotrader.Com - Lead | (none) | 63d | no-reason-given | _no reason given_ |
| Zachary Hood | La Marcus Burnette | Drive By | 2018 Ford F-150 XLT (Used) / 4WD Crew Cab Pickup (4 Door) | 31d | no-response | no response |
| Juan Torres | Emely Tellez | Carfax - Trade-In Leads | 2010 Ford F-350 (Used) / 4WD Truck (4 Door Crew Cab) | 77d | no-reason-given | _no reason given_ |
| Andres Montes | La Marcus Burnette | Vincue-Value Your Trade | 2022 Ford Super Duty F-250 SRW LARIAT (Used) / 4WD Crew Cab Pickup (4 | 1d | other | ACV $96k ⚠️24h |
| Christopher Walls | Will Goodwin | Repeat Customer | (none) | 1d | other | passed to will ⚠️24h |
| John Kim | Robert Faust | Drive By | 2025 Ford Bronco Sport Badlands (New) / 4WD Sport Utility (4 Door) | 34d | no-response | Left message |
| Jumis Ugarte | Robert Faust | Auto Alert | (none) | 19d | bought-elsewhere | Bought car elsewhere in different state |
| Darrell Davis | La Marcus Burnette | Autotrader.Com - Lead | 2013 Mazda Mazda3 i Sport (Used) / FWD 4dr Car (4 Door) | 15d | no-response | no response |
| Joshua Torres | Emely Tellez | Autotrader.Com - Lead | 2026 Ford F-150 STX (New) / RWD Crew Cab Pickup (4 Door) | 16d | trade | Email reply to prospect: Hi Joshua, It's been a couple weeks, so I wanted to pass along something useful instead of just checking in. Trade values have stayed s |
| Fabrice Normil | Shane Inman | Service Dept | 2026 Ford F-150 LARIAT (New) / 4WD Crew Cab Pickup (4 Door) | 0d | other | HAD SOME ISSUES WITH HIS SPEAKER , JUST LEFT SERVICE THEY SAID NOTHING IS WRONG WITH IT, he said if it keeps giving him issues he will consider trading it in to ⚠️24h |
| Kinneth Ochoa | Richard Martinez | Sendmeafriend.Com | (New) | 3d | bought-elsewhere | bought elsewhere |
| Gilbert Alba | Cesar Hernandez Jr | Repeat Customer | (none) | 1d | other | customer is looking for a car for the wife ⚠️24h |
| Ariel Morton | Shane Inman | Phone Up | 2026 Ford Bronco Sport (New) | 26d | bought-elsewhere | bought |
| Brendan Peters | Edward Cavaness | Fd - Oem Quick Quote | 2026 Ford Bronco (New) | 28d | bought-elsewhere | bought |
| Treyon Turner | Will Goodwin | Truecar/U.S. News | 2026 Ford Bronco Base 4 Door (New) / Trans: ManualStyle: SUVColor: | 36d | bought-elsewhere | bought |
| Charles Tucker | Shane Inman | Truecar/Beneplace | 2026 Ford Explorer ST-Line (New) / RWD Sport Utility (4 Door) | 7d | bought-elsewhere | bought |
| Brian Killough | Pedro Barrera | Phone Up | 2025 Ford Bronco Sport Badlands (New) / 4WD Sport Utility (4 Door) | 27d | bought-elsewhere | BOUGHT ELSEWHERE |
| Sandra Frank | Robert Faust | Sendmeafriend.Com | (New) | 1d | other | says she is not interested in upgrading at this time ⚠️24h |
| Ewit Gomez | La Marcus Burnette | DC Used Quote | 2018 Toyota Highlander Limited (Used) / FWD Sport Utility (4 Door) | 57d | other | NIM |
| Niesha Mackey | La Marcus Burnette | Autofi Request More Info | 2020 Buick Encore Preferred (Certified) / FWD Sport Utility (4 Door) | 62d | other | please read notes |
| Juan Bernal | Cesar Hernandez Jr | 2014 Buick LaCrosse Leather (Used) / FWD 4dr Car (4 Door) | 28d | other | out of the market | |
| Steven Etheridge | Henry Smith | Referral | 2022 Jeep Grand Cherokee L Limited (Certified) / 4WD Sport Utility (4 | 7d | other | He's not looking to purchase a vehicle at this time |
| Sebastian Luna | Emely Tellez | Drive By | (none) | 18d | other | Outbound Text Message: Hola Sebastián, solo quería saber si todavía estás interesado en comprar un vehículo nuevo. Si tienes alguna pregunta, aquí estoy para ay |
| Karry Keas | Pedro Barrera | Autotrader.Com - Lead | 2013 Mazda Mazda3 i Sport (Used) / FWD 4dr Car (4 Door) | 6d | bought-elsewhere | BOUGHT |
| Vernon Robertson | Orlando Alston | Truecar/Truecar | 2026 Ford Explorer ST RWD (New) / Trans: AutomaticStyle: SUVColor: | 2d | other | Email reply from prospect: Hi Orlando, I found the one I was looking for, right color, options etc. Thank you, Vernon From: Will Robbins wrobbins@leifjohnsonfor |
| Sophe Bethke | Henry Smith | Truecar/Sams Club | 2026 Ford Bronco Heritage Edition 4 Door Advanced (New) / Trans: Manu | 2d | out-of-market | Not in the market for a vehicle |
| Antony Sebastine | Henry Smith | Dc New Quote | 2025 Ford Bronco Badlands (New) / 4WD Convertible (4 Door) | 48d | out-of-market | No longer in the market for a vehicle |
| Leonel Carbajal | Henry Smith | Drive By | 2004 Ford Mustang Premium Mach 1 (Used) / RWD 2dr Car (2 Door) | 22d | other | Vehicle he is interested in is no longer available |
| Texx Telford | La Marcus Burnette | Cargurus | 2004 Ford Mustang Premium Mach 1 (Used) / RWD 2dr Car (2 Door) | 20d | other | Email reply to prospect: Texx, I've sent a few notes and haven't heard back. I get it. If the timing shifted or the Mach 1 just isn't the right move, no hard fe |
| Tiffany Hurtado | Henry Smith | Referral | (none) | 1d | other | Outbound Text Message: https://images.vinsolutions.com/connect-mobile-ios/short/30e2d350-0c01-4b28-ad4f-a9d9ebd366c4 ⚠️24h |
| Sinue Garcia | Emely Tellez | DC Used Quote | 2014 Chevrolet Silverado 1500 LT (Used) / RWD Crew Cab Pickup (4 Door) | 45d | other | Outbound Text Message: Hey Sinue, still want that video walkaround of the 2014 Chevrolet Silverado 1500 LT? Two minutes, I can send it whenever. |
| Andrew Geller | Ajay Malani | Phone Up | 2026 Ford Bronco Outer Banks (New) / 4WD Convertible (4 Door) | 4d | other | dup |
| Steven Ashley | Shane Inman | Autotrader.Com - Lead | 2025 Ford F-150 Tremor (Certified) / 4WD Crew Cab Pickup (4 Door) | 1d | bought-elsewhere | bought elsewhere ⚠️24h |
| Brian Hayes | Pedro Barrera | Autofi Trade In Offer Shown To Customer | 2025 Ford Bronco Sport Badlands (New) / 4WD Sport Utility (4 Door) | 53d | other | Outbound Text Message: Hey Brian. Want me to shoot a quick video walkaround of the 2025 Ford Bronco Sport Badlands? I can send it right to your phone so you can |
| Edi Sandoval | La Marcus Burnette | Sendmeafriend.Com | (New) | 14d | other | Outbound Text Message: Hey Edi, Oscar at Leif Johnson Ford of Manor. Just checking in on where things stand on your end. Anything I can help with this week? |
| Blake Burdette | Robert Faust | Drive By | 2022 Ford Super Duty F-250 SRW LARIAT (Used) / 4WD Crew Cab Pickup (4 | 11d | bought-elsewhere | Bought elsewhere |
| Jorge Sosa | Matthew Cavaness | Phone Up | 2026 Ford Explorer Platinum (New) / RWD Sport Utility (4 Door) | 17d | other | Outbound Text Message: Jorge, financing on a new Explorer can be tricky depending on where you're starting. If the numbers weren't there before, a different str |
| Scott Carlson | Will Robbins | Truecar/Truecar | 2026 Ford Super Duty F-250 LARIAT Crew Cab 6.75' Box 4WD (New) / Trans | 206d | other | Email auto response: |
| Ryan Dobbs | Edward Cavaness | Truecar/Perkspot | 2026 Ford F-150 LARIAT (New) / 4WD Crew Cab Pickup (4 Door) | 1d | no-response | Left message ⚠️24h |
| Emily Hovelson | Robert Faust | Chat-Impel | 2019 Toyota Camry XSE (Used) / FWD 4dr Car (4 Door) | 7d | bought-elsewhere | Bought elsewhere |
| Rachel Wade | Shane Inman | Vincue-Value Your Trade | 2019 Ford Expedition Platinum (Used) / RWD Sport Utility (4 Door) | 16d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 125386550633 |
| Jixian Li | La Marcus Burnette | Truecar/Truecar | 2026 Ford Ranger Raptor SuperCrew 5' Box 4WD (New) / Trans: Automatic | 20d | bought-elsewhere | bought elsewhere |
| Elise Collins | La Marcus Burnette | DC Used Quote | 2025 Ford Escape Active (Used) / FWD Sport Utility (4 Door) | 18d | no-response | no response |
| Keanu Nunoz | La Marcus Burnette | Drive By | (none) | 14d | no-response | no response |
| Kurosh Griffin | Henry Smith | Drive By | 2026 Ford Maverick (New) | 2d | bought-elsewhere | bought a maverick elsewhere |
| Chris Ruelas | La Marcus Burnette | Phone Up | 2021 Toyota RAV4 LE (Certified) / FWD Sport Utility (4 Door) | 3d | bought-elsewhere | bought elsewhere |
3. Every bad lead (16)
| Name | Rep | Source | Vehicle | Days Worked | Bucket | Reason (verbatim) | Really bad? |
|---|---|---|---|---|---|---|---|
| Angela B | Edward Cavaness | Phone Up | 2013 Mazda Mazda3 i Sport (Used) / FWD 4dr Car (4 Door) | 27d | out-of-market | not in the market | ⚠️ NO — customer replied/visited |
| Lynn Metcalf | Will Robbins | Manor Area Outreach | (none) | 1d | other | Outbound Text Message: You have successfully been removed from Riata Ford text messages. ⚠️24h | ⚠️ NO — customer replied/visited |
| Rosa Lopez | Henry Smith | Drive By | 2013 Mazda Mazda3 i Sport (Used) / FWD 4dr Car (4 Door) | 1d | other | Outbound Text Message: Good evening Ms. Rosa, checking to see if you received the numbers we sent over to you earlier? ⚠️24h | ⚠️ NO — customer replied/visited |
| Angel Lopez | Edward Cavaness | 2021 Ford Expedition Max XLT (Used) / 4WD Sport Utility (4 Door) | 4d | other | Inbound Text Message: Gracias | ⚠️ NO — customer replied/visited | |
| Mary Landreth | La Marcus Burnette | Truecar/Consumer Reports | 2026 Ford Maverick XLT AWD (New) / Trans: AutomaticStyle: Pickup Tru | 4d | out-of-market | client text back saying she is not in the market for a vehicle | ⚠️ NO — customer replied/visited |
| Kevin Majewski | Emely Tellez | Truecar/Sams Club | 2026 Ford Explorer ST RWD (New) / Trans: AutomaticStyle: SUVColor: | 0d | other | Outbound Text Message: You have successfully been removed from Riata Ford text messages. ⚠️24h | ⚠️ NO — customer replied/visited |
| Victoria Smith | Matthew Cavaness | Phone Up | (none) | 8d | other | Outbound Text Message: Hey Victoria, Matt at Leif Johnson Ford of Manor. Just checking in on where things stand on your end. Anything I can help with this week? | yes |
| Mark Labac | La Marcus Burnette | Autotrader.Com - Lead | 2026 Ford Super Duty F-450 DRW Platinum (New) / 4WD Crew Cab Pickup (4 | 14d | trade | Email reply to prospect: Hi Mark, Trade values have been holding stronger than most people expect right now. If you've got something to put toward the F-450, it | ⚠️ NO — customer replied/visited |
| Angel Waldon | Edward Cavaness | Vincue-Value Your Trade | 2022 Ford Explorer Base (Certified) / RWD Sport Utility (4 Door) | 4d | other | Was just looking not interested in buying right now. | ⚠️ NO — customer replied/visited |
| Mike Truscott | Oscar Pulido | Phone Up | (none) | 0d | other | Auto generated from adding customer. ⚠️24h | yes |
| Anthony Anderson | Ajay Malani | Phone Up | (none) | 3d | no-reason-given | _no reason given_ | yes |
| Guillermina Melchor | Emely Tellez | Autofi Standalone App | (none) | 1d | credit | Credit app ⚠️24h | ⚠️ NO — customer replied/visited |
| Juan Gomez | Pedro Barrera | 2023 Toyota Tundra 4WD TRD Pro Hybrid (Certified) / 4WD Crew Cab Picku | 1d | other | Outbound Text Message: Here we go it's back up. So here is the link to the system we use. You can adjust downpayment, and term length. This is all just an estim ⚠️24h | ⚠️ NO — customer replied/visited | |
| Souleymane Sow | Will Robbins | Phone Up | (none) | 1d | other | Auto generated from adding customer. ⚠️24h | yes |
| Alejandro Hernandez Presa | Edward Cavaness | 2023 Ford Super Duty F-250 SRW LARIAT (Used) / 4WD Crew Cab Pickup (4 | 21d | bought-elsewhere | Purchased else where | ⚠️ NO — customer replied/visited | |
| Joel Cervantes | La Marcus Burnette | Drive By | (none) | 5d | other | said he sold the vehicle elsewhere | yes |
4. Patterns
Top 3 lost-reason buckets: other (22), no-reason-given (14), bought-elsewhere (14)
Reps with lost leads that have no reason recorded:
| Rep | No reason | Total lost |
|---|---|---|
| Shane Inman | 4 | 8 |
| Pedro Barrera | 2 | 6 |
| Henry Smith | 2 | 8 |
| Ajay Malani | 2 | 3 |
| Emely Tellez | 2 | 5 |
| La Marcus Burnette | 1 | 12 |
| Edward Cavaness | 1 | 3 |
Sources with the worst lost rate (lost this period / all-time leads from source):
| Source | Lost this period | All-time leads | Rate |
|---|---|---|---|
| Dc Credit | 1 | 2 | 50.0% |
| Cargurus - Appt - Digital Deal | 1 | 3 | 33.3% |
| Inbound Internet | 1 | 7 | 14.3% |
| Accelerate Dr - Autotrader - Deal Events | 1 | 7 | 14.3% |
| Truecar/U.S. News | 1 | 9 | 11.1% |
Marked lost within 24h of creation (too fast): 9
- Chauncy Christian Ragland (Will Robbins, Repeat Customer)
- Andres Montes (La Marcus Burnette, Vincue-Value Your Trade)
- Christopher Walls (Will Goodwin, Repeat Customer)
- Fabrice Normil (Shane Inman, Service Dept)
- Gilbert Alba (Cesar Hernandez Jr, Repeat Customer)
- Sandra Frank (Robert Faust, Sendmeafriend.Com)
- Tiffany Hurtado (Henry Smith, Referral)
- Steven Ashley (Shane Inman, Autotrader.Com - Lead)
- Ryan Dobbs (Edward Cavaness, Truecar/Perkspot)
5. Coaching list (Monday)
- Biggest lost reason this period is "other" (22 leads) — build a talk track for it and drill it in the next sales meeting.
- Shane Inman logged 4 of 8 lost leads with no reason recorded — require a one-line lost reason before a lead can be marked lost.
- Dc Credit has the worst lost rate (1/2 all-time, 50%) — reconsider spend or handling on this source.
- 9 lead(s) were marked lost within 24 hours of coming in (e.g. Chauncy Christian Ragland) — too fast, review for premature marking.
- 11 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.