Lost & Bad Lead Review — last 7 days
Generated 2026-11-02T12:40:01.449Z. Window: 2026-10-26 → 2026-11-02 (prior window: 2026-10-19 → 2026-10-26).
1. Totals
| This period (7d) | Prior period (7d) | |
|---|---|---|
| Lost | 54 | 91 |
| Bad | 7 | 13 |
Lost by rep:
| Rep | Count |
|---|---|
| La Marcus Burnette | 14 |
| Edward Cavaness | 10 |
| Tariq Halawani | 8 |
| Shane Inman | 6 |
| Will Goodwin | 5 |
| Cesar Hernandez Jr | 5 |
| Emely Tellez | 3 |
| Pedro Barrera | 1 |
| Ajay Malani | 1 |
| Henry Smith | 1 |
Bad by rep:
| Rep | Count |
|---|---|
| Tariq Halawani | 2 |
| La Marcus Burnette | 2 |
| Pedro Barrera | 2 |
| Emely Tellez | 1 |
Lost by lead source:
| Source | Count |
|---|---|
| Repeat Customer | 9 |
| Phone Up | 5 |
| Cargurus | 4 |
| DC Used Quote | 4 |
| Autofi Trade In Offer Shown To Customer | 3 |
| Autotrader.Com - Lead | 2 |
| Vincue-Value Your Trade | 2 |
| Carfax - Trade-In Leads | 2 |
| Autofi Deal Saved | 2 |
| Truecar/Navy Federal | 2 |
| Autofi Request More Info | 1 |
| Dc New Quote | 1 |
| Vinsolutions - Ici Private Offer | 1 |
| Tv Contact Us Sales | 1 |
| Upstart Auto Retail | 1 |
| Kbb Ico Dealer Website | 1 |
| Referral | 1 |
| Truecar/Working Advantage | 1 |
| Truecar/Lifecare | 1 |
| Drive By | 1 |
| Truecar/U.S. News | 1 |
| Fd - Oem Quick Quote - Es Fdaf | 1 |
| Truecar/Beneplace | 1 |
| Sendmeafriend.Com | 1 |
| Autotrader.Com - Dealer Price Quote Lead | 1 |
| Truecar/Benefithub | 1 |
| Fd - Oem Quick Quote | 1 |
| AUTOFI BEGAN APPLICATION | 1 |
| Truecar/Truecar | 1 |
Bad by lead source:
| Source | Count |
|---|---|
| Drive By | 2 |
| Autotrader.Com - Car And Driver Call Start Phone Lead | 1 |
| Repeat Customer | 1 |
| Autotrader.Com - Lead | 1 |
| Cargurus - Digital Deal | 1 |
| Fd - Oem Build & Price | 1 |
2. Every lost lead (54)
| Name | Rep | Source | Vehicle | Days Worked | Bucket | Reason (verbatim) |
|---|---|---|---|---|---|---|
| Mark Moke | Emely Tellez | Autotrader.Com - Lead | 2022 Ford Ranger XL (Certified) / RWD Extended Cab Pickup (4 Door) | 91d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 125767851967 |
| Angela Wolf | Will Goodwin | Autofi Request More Info | 2025 Ford Escape ST-Line (Certified) / FWD Sport Utility (4 Door) | 90d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 125763504727 |
| Rod Miller | Tariq Halawani | Phone Up | 2024 Ford Super Duty F-250 SRW King Ranch (Certified) / 4WD Crew Cab P | 9d | other | Inbound Text Message: Liked “Congrats! Rod! Keep us in mind for the future and feel free to use our award-winning service department.” |
| Vijay Gundarapu | Tariq Halawani | Dc New Quote | 2026 Ford Mustang Mach-E Select (New) / RWD Sport Utility (4 Door) | 2d | no-reason-given | _no reason given_ |
| Angel Gonzalez Linares 28 308 | La Marcus Burnette | Repeat Customer | (none) | 74d | no-response | no response, old lead |
| Kashan Hameed | La Marcus Burnette | Repeat Customer | (none) | 74d | no-response | no response, old lead |
| Eugenio Arias Hernandez | La Marcus Burnette | Repeat Customer | (none) | 74d | no-response | no response |
| Lorena De La Pena Oranday | Cesar Hernandez Jr | Vinsolutions - Ici Private Offer | 2024 Ford Super Duty F-250 SRW LARIAT (New) / 4WD Crew Cab Pickup (4 D | 113d | other | Email reply to prospect: Lorena, thank you for telling me. I am sorry about how your son was treated. That is not how we want anyone treated here, and I take it |
| Shelby Shelby | Edward Cavaness | Phone Up | 2024 Ram 2500 Limited (Used) / 4WD Crew Cab Pickup (4 Door) | 2d | other | Inbound Text Message: Appreciate it |
| Jazmin Torres | Shane Inman | Repeat Customer | 2019 Ford Mustang EcoBoost Premium (Used) / RWD 2dr Car (2 Door) | 0d | other | Email reply to prospect: Hi Irazema, It's Will at Leif Johnson Ford of Manor. Would you like to come by this weekend and see what we have? Just reply here and I ⚠️24h |
| Brad Guinn | Cesar Hernandez Jr | Tv Contact Us Sales | 2022 Ford F-150 XL (Used) | 0d | other | Email reply to prospect: Hi Maureen, It's Will at Leif Johnson Ford of Manor. Are you thinking about a different vehicle anytime soon? Just reply here and I'll ⚠️24h |
| Elizabeth Gibson | Will Goodwin | Vincue-Value Your Trade | 2026 Ford Explorer Active w/200A Pkg (New) / RWD Sport Utility (4 Door | 17d | bought-elsewhere | BOUGHT ELSEWHERE |
| Nicole Davis | Pedro Barrera | Upstart Auto Retail | 2015 Kia Forte EX (Used) / FWD 4dr Car (4 Door) | 0d | other | Email reply to prospect: Hi Nicole, It's Will at Leif Johnson Ford of Manor. Are you still looking for an Explorer or an F-150? Just reply here and I'll set up ⚠️24h |
| Alexander Gamez | Cesar Hernandez Jr | Kbb Ico Dealer Website | (none) | 231d | other | Email reply to prospect: Hi Terrence, It's Will at Leif Johnson Ford of Manor. Are you still thinking about trading in your F-150? Just reply here and I'll set |
| Oscar Posada | La Marcus Burnette | Cargurus | 2026 Ford Ranger LARIAT (New) / 4WD Crew Cab Pickup (4 Door) | 0d | price | Email reply to prospect: Hey Oscar, good news. The 2026 Ford Ranger Lariat you found on CarGurus is here at Leif Johnson Ford of Manor. Avalanche Gray, 2.7L Eco ⚠️24h |
| Omar Ahmed | Edward Cavaness | DC Used Quote | 2020 Ford Expedition Max XLT (Used) / 4WD Sport Utility (4 Door) | 22d | other | Outbound Text Message: Omar are you still looking for a Expedition? Gary |
| Tre Dunham | Shane Inman | Autofi Trade In Offer Shown To Customer | 2026 Ford F-150 King Ranch (New) / 4WD Crew Cab Pickup (4 Door) | 25d | bought-elsewhere | bought |
| Santiago Hernandez | Edward Cavaness | Phone Up | (none) | 87d | other | has not responded when he does answer we set appt and he never comes in set 4 appt with him and nothing. |
| Leyka Nieves Vargas | Edward Cavaness | Cargurus | 2025 Acura MDX w/Technology Package (Used) / AWD Sport Utility (4 Door | 39d | other | not interested |
| Merricka Seabrooks | La Marcus Burnette | Referral | (none) | 1d | other | Referral will be here around 3:30pm ⚠️24h |
| Gualdimer Alexander Portillo | Cesar Hernandez Jr | Carfax - Trade-In Leads | (none) | 72d | no-response | Lead marked lost by the system due to inactivity. Lost process was started. |
| Chantel Mead | La Marcus Burnette | DC Used Quote | 2024 Kia Forte GT (Certified) / FWD 4dr Car (4 Door) | 2d | other | Nice lady still comparing recent total loss |
| Phillip Boatright | Ajay Malani | Truecar/Working Advantage | 2027 Ford Super Duty F-450 LARIAT Crew Cab 8' Box DRW 2WD (New) / Tran | 1d | other | WORKING ON GETTING TRUCK BROUGHT OVER FROM TRUCK CITY. CUSTOMER IS ALSO LOOKING AT COVERT HUTTO ⚠️24h |
| Mario Vega | Cesar Hernandez Jr | Phone Up | 2026 Ford Explorer (New) | 6d | other | sold to brother |
| Christopher Simon | Edward Cavaness | Truecar/Lifecare | 2026 Ford Maverick LARIAT (New) / AWD Crew Cab Pickup (4 Door) | 6d | other | Email auto response: |
| Lazaro A | Emely Tellez | Drive By | 2026 Ford Expedition Platinum (4dr 4x4) (New) | 13d | bought-elsewhere | purchased somewhere else |
| Juanita Tinsley | Edward Cavaness | Autofi Deal Saved | 2015 Ford Escape SE (Used) / 4WD Sport Utility (4 Door) | 7d | other | Email reply to prospect: Hi Juanita, Did you know you can buy the 2015 Ford Escape SE without ever visiting the dealership? Here's how our home delivery works: |
| Hayden Sledge | Will Goodwin | DC Used Quote | 2022 Ford Super Duty F-250 SRW King Ranch (Used) / 4WD Crew Cab Pickup | 90d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 125729033709 |
| Reshakea Owens | La Marcus Burnette | Autofi Trade In Offer Shown To Customer | 2023 Ford Bronco Sport (Used) | 1d | credit | Credit app lead clock |
| Eduardo Cerqueira | Edward Cavaness | Autofi Trade In Offer Shown To Customer | 2014 Ford Explorer Base (Used) / FWD Sport Utility (4 Door) | 36d | other | not interested |
| Vrutant Patel | Shane Inman | Autofi Deal Saved | 2026 Ford F-150 Raptor (New) / 4WD Crew Cab Pickup (4 Door) | 18d | other | too far apart only wants to pay 5k over MSRP on a Raptor R |
| William Szeneri | Tariq Halawani | Truecar/U.S. News | 2026 Ford Escape Active FWD (New) / Trans: AutomaticStyle: SUVColor: | 9d | no-response | Left message |
| Alipio Frias | Edward Cavaness | Fd - Oem Quick Quote - Es Fdaf | 2027 Ford Expedition (New) | 16d | no-response | Left message |
| Sandra Clarke | Edward Cavaness | Autotrader.Com - Lead | 2013 Mazda Mazda3 i Sport (Used) / FWD 4dr Car (4 Door) | 14d | no-response | no response |
| Chad Watson | Tariq Halawani | Phone Up | 2026 Ford F-150 XLT (New) / 4WD Crew Cab Pickup (4 Door) | 1d | other | Outbound Text Message: You have successfully been removed from Riata Ford text messages. ⚠️24h |
| Toni Lufi | Edward Cavaness | Truecar/Beneplace | 2024 Ford F-150 XL (Certified) / RWD Regular Cab Pickup (2 Door) | 3d | no-response | Left message |
| A M | Shane Inman | Cargurus | 2020 Ford Explorer Platinum (Used) / 4WD Sport Utility (4 Door) | 15d | other | NOT LOOKING FOR A CAR |
| Jabier Garcia | Will Goodwin | Sendmeafriend.Com | (New) | 1d | other | Referred by Henry Smith. Interested in . Assigned to: Cesar Hernandez ⚠️24h |
| Blair Logan | Henry Smith | Carfax - Trade-In Leads | (none) | 8d | other | she no longer lives in texas |
| Mia Acosta | La Marcus Burnette | Vincue-Value Your Trade | 2024 Toyota Camry SE (Certified) / FWD 4dr Car (4 Door) | 1d | other | 219k miles ⚠️24h |
| Joe Castillo | Tariq Halawani | Truecar/Navy Federal | 2026 Ford Mustang GT Premium Convertible (New) / Trans: ManualStyle: | 35d | bought-elsewhere | already bought |
| Brand Bee | Shane Inman | DC Used Quote | 2026 Ford Bronco Badlands (New) / 4WD Convertible (4 Door) | 123d | other | 6/26 |
| Bennyjoe Tenorio Jr | La Marcus Burnette | Repeat Customer | (none) | 70d | no-response | No response |
| Jerico Araiza | La Marcus Burnette | Repeat Customer | (none) | 70d | no-response | No response |
| Carolyn G White | La Marcus Burnette | Repeat Customer | (none) | 70d | no-response | No response |
| Samuel Allen | Will Goodwin | Autotrader.Com - Dealer Price Quote Lead | 2026 Ford F250 Super Duty Crew Cab (New) / 2022 Ford Super Duty F-250 | 28d | bought-elsewhere | bought else where |
| Richard Tex Hall | Tariq Halawani | Truecar/Navy Federal | 2026 Ford Super Duty F-350 LARIAT Crew Cab 8' Box SRW 4WD (New) / Tran | 45d | bought-elsewhere | bought |
| Shawn Martinez | Tariq Halawani | Repeat Customer | (none) | 70d | trade | Email reply to prospect: Hi Shawn, Congrats on the new truck. Glad you found something. Whenever you're ready to move on from it, trade values on trucks are str |
| Michael Fuentes | Emely Tellez | Truecar/Benefithub | 2026 Ford F-150 STX SuperCrew 5.5' Box 4WD (New) / Trans: AutomaticSt | 27d | other | NO LONGER IN MARKET |
| Mike Mckinnon | Tariq Halawani | Cargurus | 2026 Honda Civic Sedan Hybrid Sport (Certified) / FWD 4dr Car (4 Door) | 5d | bought-elsewhere | Purchased elcewhere |
| Michelle Burton | La Marcus Burnette | Repeat Customer | (none) | 70d | no-response | No response |
| Christian Sorto | Shane Inman | Fd - Oem Quick Quote | 2026 Ford F-150 (New) | 25d | other | Outbound Text Message: Christian, noted. When you're ready to start looking next year, I'll be here. The F-150 STX will likely still be a strong option. Anythin |
| Adelina Silguero | La Marcus Burnette | AUTOFI BEGAN APPLICATION | 2018 Volkswagen Beetle Convertible S (Used) / FWD Convertible (2 Door) | 12d | no-response | No response |
| Samuelle Henley | La Marcus Burnette | Truecar/Truecar | 2026 Ford Super Duty F-250 SRW LARIAT (New) / 4WD Crew Cab Pickup (4 D | 15d | no-response | No response |
3. Every bad lead (7)
| Name | Rep | Source | Vehicle | Days Worked | Bucket | Reason (verbatim) | Really bad? |
|---|---|---|---|---|---|---|---|
| Hanwei Zhang | Tariq Halawani | Drive By | (none) | 3d | other | Let him know that I have his check ready | ⚠️ NO — customer replied/visited |
| Skyla L Greene | La Marcus Burnette | Autotrader.Com - Car And Driver Call Start Phone Lead | (none) | 4d | no-response | no response from client, i did not take the original call | ⚠️ NO — customer replied/visited |
| Mustafa Al Jbory | Tariq Halawani | Repeat Customer | (none) | 73d | trade | Email reply to prospect: Mustafa, got it. A 1983 Ford wagon with 350k miles. Are you looking to sell it, trade it in, or asking about something else? Will Robbi | ⚠️ NO — customer replied/visited |
| Donnie Vanness | Pedro Barrera | Autotrader.Com - Lead | 2024 Ford Super Duty F-350 DRW King Ranch (Certified) / 4WD Crew Cab P | 43d | other | Email reply to prospect: Hi Donnie, It’s Pedro with Leif Johnson Ford of Manor! I wanted to follow up on your search for the right Super Duty. I know the 2024 F | ⚠️ NO — customer replied/visited |
| Luis Perez | Pedro Barrera | Drive By | 2022 Ford Super Duty F-250 SRW LARIAT (Certified) / 4WD Crew Cab Picku | 10d | other | Outbound Text Message: Hey Luis, it’s Pedro with Leif Johnson Ford of Manor! I wanted to check in and see if you’re still looking to upgrade from your Ram or if | ⚠️ NO — customer replied/visited |
| Mike Galvez | Emely Tellez | Cargurus - Digital Deal | 2022 Ford F-150 LARIAT (Certified) / 4WD Crew Cab Pickup (4 Door) | 14d | other | Outbound Text Message: You have successfully been removed from Riata Ford text messages. | ⚠️ NO — customer replied/visited |
| Juan Serrano | La Marcus Burnette | Fd - Oem Build & Price | 2027 Ford Super Duty F-250? King Ranch? (New) / Trans: TorqShift?-G t | 5d | other | Outbound Text Message: Juan, quick one. Do you have a vehicle you'd be trading in when you pull the trigger on the F-250? | ⚠️ NO — customer replied/visited |
4. Patterns
Top 3 lost-reason buckets: other (26), no-response (14), bought-elsewhere (7)
Reps with lost leads that have no reason recorded:
| Rep | No reason | Total lost |
|---|---|---|
| Will Goodwin | 2 | 5 |
| Emely Tellez | 1 | 3 |
| Tariq Halawani | 1 | 8 |
Sources with the worst lost rate (lost this period / all-time leads from source):
| Source | Lost this period | All-time leads | Rate |
|---|---|---|---|
| Fd - Oem Quick Quote - Es Fdaf | 1 | 2 | 50.0% |
| Autofi Deal Saved | 2 | 13 | 15.4% |
| Truecar/Lifecare | 1 | 7 | 14.3% |
| Truecar/Working Advantage | 1 | 8 | 12.5% |
| Autotrader.Com - Dealer Price Quote Lead | 1 | 8 | 12.5% |
Marked lost within 24h of creation (too fast): 9
- Jazmin Torres (Shane Inman, Repeat Customer)
- Brad Guinn (Cesar Hernandez Jr, Tv Contact Us Sales)
- Nicole Davis (Pedro Barrera, Upstart Auto Retail)
- Oscar Posada (La Marcus Burnette, Cargurus)
- Merricka Seabrooks (La Marcus Burnette, Referral)
- Phillip Boatright (Ajay Malani, Truecar/Working Advantage)
- Chad Watson (Tariq Halawani, Phone Up)
- Jabier Garcia (Will Goodwin, Sendmeafriend.Com)
- Mia Acosta (La Marcus Burnette, Vincue-Value Your Trade)
5. Coaching list (Monday)
- Biggest lost reason this period is "other" (26 leads) — build a talk track for it and drill it in the next sales meeting.
- Will Goodwin logged 2 of 5 lost leads with no reason recorded — require a one-line lost reason before a lead can be marked lost.
- Fd - Oem Quick Quote - Es Fdaf 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. Jazmin Torres) — 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.