Lost & Bad Lead Review — last 7 days
Generated 2026-10-15T17:37:16.107Z. Window: 2026-10-08 → 2026-10-15 (prior window: 2026-10-01 → 2026-10-08).
1. Totals
| This period (7d) | Prior period (7d) | |
|---|---|---|
| Lost | 48 | 62 |
| Bad | 14 | 6 |
Lost by rep:
| Rep | Count |
|---|---|
| Pedro Barrera | 8 |
| Shane Inman | 7 |
| La Marcus Burnette | 7 |
| Will Goodwin | 6 |
| Emely Tellez | 5 |
| Cesar Hernandez Jr | 5 |
| Henry Smith | 5 |
| Matthew Cavaness | 1 |
| Ajay Malani | 1 |
| Will Robbins | 1 |
| Edward Cavaness | 1 |
| Gary Brophy | 1 |
Bad by rep:
| Rep | Count |
|---|---|
| Tariq Halawani | 2 |
| Pedro Barrera | 2 |
| Shane Inman | 2 |
| Will Robbins | 2 |
| Edward Cavaness | 1 |
| Marri Stokes | 1 |
| Orlando Alston | 1 |
| La Marcus Burnette | 1 |
| Ajay Malani | 1 |
| Javier Choraifi | 1 |
Lost by lead source:
| Source | Count |
|---|---|
| Phone Up | 13 |
| Carfax - Trade-In Leads | 4 |
| Autotrader.Com - Lead | 3 |
| Drive By | 3 |
| Cargurus | 2 |
| Truecar/Navy Federal | 2 |
| Repeat Customer | 2 |
| Fd - Oem Quick Quote | 2 |
| DC Used Quote | 2 |
| Truecar/Truecar | 2 |
| Dc New Quote | 2 |
| Drive By | 1 |
| Vincue-Value Your Trade-Google/Cpc/Sr_leif Johnson Ford Of Manor - Used | 1 |
| Fd - Oem Search Inventory | 1 |
| Service Dept | 1 |
| Autofi Request More Info | 1 |
| Truecar/Lifecare | 1 |
| Sendmeafriend.Com | 1 |
| Referral | 1 |
| Autotrader.Com - Wallet Lead | 1 |
| Truecar/Extended Network | 1 |
| Vincue-Value Your Trade-Google/Cpc/Sr_leif Johnson Ford Of Manor - New | 1 |
Bad by lead source:
| Source | Count |
|---|---|
| Vincue-Value Your Trade | 2 |
| Cargurus | 2 |
| Chat-Impel | 1 |
| Drive By | 1 |
| Autofi Trade In Offer Shown To Customer | 1 |
| Fd - Trade-In | 1 |
| A-Z Advisor | 1 |
| Autotrader.Com - Call Start Phone Lead | 1 |
| 1 | |
| Repeat Customer | 1 |
| Autotrader.Com - Phone Lead | 1 |
| Autofi Standalone App | 1 |
2. Every lost lead (48)
| Name | Rep | Source | Vehicle | Days Worked | Bucket | Reason (verbatim) |
|---|---|---|---|---|---|---|
| Yusdel Varela | Emely Tellez | Drive By | 2025 Ford Expedition (Certified) | 80d | no-reason-given | _no reason given_ |
| Woody Robertson | Will Goodwin | Cargurus | 2025 Acura MDX w/Technology Package (Used) / AWD Sport Utility (4 Door | 75d | no-reason-given | _no reason given_ |
| Tanner Cannady | Shane Inman | Vincue-Value Your Trade-Google/Cpc/Sr_leif Johnson Ford Of Manor - Used | 2023 Chevrolet Colorado 4WD Trail Boss (Used) / 4WD Crew Cab Pickup (4 | 21d | bought-elsewhere | Bought a Colorado |
| Brian Washington | Will Goodwin | Autotrader.Com - Lead | 2022 Ford F-350 King Ranch (New) / | 88d | no-reason-given | _no reason given_ |
| Bobby Davis | Shane Inman | Phone Up | 2019 MINI Countryman Cooper (Used) / FWD SUV | 105d | no-reason-given | _no reason given_ |
| Ramiro Lopez | Emely Tellez | Autotrader.Com - Lead | 2014 Ford F-250 (Used) / 4WD Truck (4 Door Crew Cab) | 86d | no-reason-given | _no reason given_ |
| Shannon Clewett | Matthew Cavaness | Phone Up | 2026 Ford F-150 STX (New) / RWD Crew Cab Pickup (4 Door) | 96d | no-reason-given | _no reason given_ |
| Michael Mccorvey | La Marcus Burnette | Fd - Oem Search Inventory | 2026 Ford Mustang Mach-E Premium (New) / RWD Sport Utility (4 Door) | 101d | no-reason-given | _no reason given_ |
| Braeden Worthman | Will Goodwin | Truecar/Navy Federal | 2026 Ford Ranger XLT SuperCrew 5' Box 4WD (New) / Trans: AutomaticSty | 104d | no-reason-given | _no reason given_ |
| Gilbert Alba | Cesar Hernandez Jr | Repeat Customer | (none) | 21d | other | out |
| Lindsey Houchen | Cesar Hernandez Jr | Phone Up | 2023 Ford Bronco Outer Banks (Certified) / 4WD Convertible (4 Door) | 15d | other | out |
| Adam Rogers | Cesar Hernandez Jr | Fd - Oem Quick Quote | 2026 Ford Super Duty (New) | 8d | other | out |
| Armando Garza | Henry Smith | Service Dept | 2026 Ford F-150 Raptor (New) / 4WD Crew Cab Pickup (4 Door) | 15d | other | Checking to see if he's found a vehicle that will work for him |
| Lenorris Wilson | Henry Smith | DC Used Quote | 2020 Chevrolet Silverado 1500 LT (Used) / 4WD Crew Cab Pickup (4 Door) | 18d | bought-elsewhere | Bought elsewhere |
| Dakota Kays | Pedro Barrera | Carfax - Trade-In Leads | (none) | 59d | no-response | NO RESPONSE EMAIL ONLY LEAD |
| Maria Solano Vazquez<br>Landco Landscapes Services Llc | Ajay Malani | Repeat Customer | (none) | 4d | other | not ready to buy |
| Evaristo Jaramillo | Pedro Barrera | Carfax - Trade-In Leads | (none) | 36d | other | NO REPSONSE |
| Randall Williams | Pedro Barrera | DC Used Quote | 2017 Chevrolet Silverado 1500 LT (Used) / RWD Crew Cab Pickup (4 Door) | 48d | no-response | STOPPED RESPONDING.. |
| Mazareth Paumier | La Marcus Burnette | Drive By | 2025 Ford Bronco Big Bend (Certified) / 4WD Convertible (4 Door) | 19d | no-response | no response since they were on the showroom |
| Jessica Alexander | La Marcus Burnette | Drive By | (none) | 15d | no-response | No response |
| Duaine Tealer | Will Goodwin | Autofi Request More Info | 2018 Honda Pilot Touring (Used) / FWD Sport Utility (4 Door) | 7d | other | bad |
| Ricardo Flores | Will Robbins | Truecar/Truecar | 2025 Ford F-150 Raptor SuperCrew 5.5' Box 4WD (New) / Trans: Automat | 185d | other | Email auto response: |
| Terri Ivarsson | La Marcus Burnette | Truecar/Lifecare | 2026 Ford Bronco Sport Big Bend (New) / 4WD Sport Utility (4 Door) | 5d | bought-elsewhere | bought elsewhere |
| Joe Heiney | La Marcus Burnette | Autotrader.Com - Lead | 2026 Ford Super Duty F-450 DRW Platinum (New) / 4WD Crew Cab Pickup (4 | 3d | bought-elsewhere | bought elsewhere |
| Jessie Soto | Pedro Barrera | Phone Up | 2026 Ford F-150 (New) | 3d | bought-elsewhere | BOUGHT |
| Diego Lujan | Shane Inman | Cargurus | 2025 Ford F-150 King Ranch (Certified) / 4WD Crew Cab Pickup (4 Door) | 91d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 125570033689 |
| Sandra Frank | Will Goodwin | Sendmeafriend.Com | (New) | 19d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 126248868743 |
| Jessie E | Emely Tellez | Phone Up | (none) | 6d | bought-elsewhere | purchased somewhere else |
| Sarah Biel | Shane Inman | Referral | (none) | 2d | bought-elsewhere | Bought at LJ Ford in Austin. |
| Alex Tullos | Pedro Barrera | Phone Up | (none) | 5d | out-of-market | SAID STOP TO COVIDEO. NO LONGER INTERESTED... |
| Josue Vazquez | Emely Tellez | Drive By | 2020 Ram 1500 Lone Star (Used) / RWD Crew Cab Pickup (4 Door) | 8d | other | customer has mexican passport does not has a valid us id and no one to sign with him |
| Nick Rigopoulos | Cesar Hernandez Jr | Phone Up | 2027 Ford Explorer Platinum (New) / 4WD Sport Utility (4 Door) | 16d | bought-elsewhere | bought elsewhere |
| Alexis Catanzano | Pedro Barrera | Fd - Oem Quick Quote | 2026 Ford Bronco Sport (New) | 8d | other | CUSTOMER ONLY WANTS TO WORK WITH A DEALERSHIP USING TEKION. |
| Mary Mcmillam | Pedro Barrera | Carfax - Trade-In Leads | (none) | 53d | no-response | NO RESPONSE |
| Jose Pichardo | Pedro Barrera | Carfax - Trade-In Leads | (none) | 42d | no-response | NO RESPONSE |
| Micky Aguian | Will Goodwin | Phone Up | 2019 Ford Super Duty F-250 SRW XLT (Certified) / 4WD Crew Cab Pickup ( | 91d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 125553826576 |
| Brian Peeples | Henry Smith | Dc New Quote | 2026 Ford Mustang Dark Horse (New) / RWD 2dr Car (2 Door) | 4d | other | Inbound Text Message: I know Mrs Johnson ill talk to her |
| Jessi Dixon | Cesar Hernandez Jr | Autotrader.Com - Wallet Lead | 2021 Ford Mustang Shelby GT500 (Used) / RWD 2dr Car (2 Door) | 91d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 125553666701 |
| Aadish Charaniya | La Marcus Burnette | Truecar/Truecar | 2026 Ford Mustang EcoBoost Premium (New) / RWD 2dr Car (2 Door) | 7d | other | Outbound Text Message: Also send me the front and back of your driver's license please |
| Penaloza Rios | Shane Inman | Phone Up | (New) | 24d | bought-elsewhere | bought |
| Angel Smith | Shane Inman | Truecar/Navy Federal | 2025 Ford Bronco Outer Banks (New) / 4WD Convertible (4 Door) | 43d | bought-elsewhere | bought |
| Omar Jasso | Henry Smith | Phone Up | 2026 Ford Super Duty F-250 SRW LARIAT (New) / 4WD Crew Cab Pickup (4 D | 8d | bought-elsewhere | BOUGHT ELSEWHERE |
| Paula Vinklarek | La Marcus Burnette | Dc New Quote | 2026 Ford Expedition Active (New) / RWD Sport Utility (4 Door) | 9d | other | Email auto response: |
| Dennis Tucker | Emely Tellez | Truecar/Extended Network | 2026 Ford F-150 XLT (New) / 4WD Crew Cab Pickup (4 Door) | 8d | bought-elsewhere | Purchased elsewhere. |
| Gary Mabry | Shane Inman | Phone Up | 2022 Ford Ranger XL (Certified) / RWD Extended Cab Pickup (4 Door) | 36d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 126074295984 |
| Steven Hanson | Henry Smith | Phone Up | 2015 Ford Super Duty F-450 DRW Lariat (Used) / 4WD Crew Cab Pickup (4 | 36d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 126069271864 |
| Michael Sullivan | Edward Cavaness | Vincue-Value Your Trade-Google/Cpc/Sr_leif Johnson Ford Of Manor - New | 2026 Ford F-150 STX (New) / RWD Crew Cab Pickup (4 Door) | 43d | other | not interested |
| A Turrubiarte | Gary Brophy | Phone Up | 2023 Ford Explorer Timberline (Used) / 4WD Sport Utility (4 Door) | 36d | no-reason-given | Lead marked lost by a custom user configured event globalActiveProcessEventID 126067316381 |
3. Every bad lead (14)
| Name | Rep | Source | Vehicle | Days Worked | Bucket | Reason (verbatim) | Really bad? |
|---|---|---|---|---|---|---|---|
| Sharlene Havel | Edward Cavaness | Chat-Impel | (New) | 103d | no-reason-given | _no reason given_ | yes |
| Laura Stough | Tariq Halawani | Drive By | 2026 Ford Bronco Sport Heritage (New) / 4WD Sport Utility (4 Door) | 5d | other | Inbound Text Message: Please remove me from your phone list. | ⚠️ NO — customer replied/visited |
| Dee Rob | Pedro Barrera | Autofi Trade In Offer Shown To Customer | 2026 Ford Super Duty F-250 SRW LARIAT (New) / 4WD Crew Cab Pickup (4 D | 9d | other | NUMBER IS NOT IN SERVICE | ⚠️ NO — customer replied/visited |
| Matthew Duoblys | Tariq Halawani | Fd - Trade-In | 2026 Ford Mustang (New) | 0d | other | not interested ⚠️24h | ⚠️ NO — customer replied/visited |
| Wilson Ly | Pedro Barrera | Vincue-Value Your Trade | 2026 Ford F-150 STX (New) / RWD Crew Cab Pickup (4 Door) | 1d | other | unable to connect, call was cutting out ⚠️24h | ⚠️ NO — customer replied/visited |
| Amazon Finance Test | Marri Stokes | A-Z Advisor | 2018 Mercedes-Benz GLC GLC 300 (Used) / AWD Sport Utility (4 Door) | 1d | price | Email reply to prospect: Hey Amazon, The 2018 Mercedes-Benz GLC 300 you were checking out is still on our lot here at Leif Johnson Ford of Manor. No dealer add- ⚠️24h | yes |
| Touring Ltd | Orlando Alston | Autotrader.Com - Call Start Phone Lead | (none) | 4d | other | Outbound Text Message: Hey Touring, Orlando at Leif Johnson Ford of Manor. We can handle everything remotely. Financing, paperwork, all of it. No trip required. | ⚠️ NO — customer replied/visited |
| Michael Reid | La Marcus Burnette | Cargurus | 2015 Ford Super Duty F-450 DRW Lariat (Used) / 4WD Crew Cab Pickup (4 | 7d | other | Outbound Text Message: The 2015 sold, but I would love to put you into something else if it's still an option. | ⚠️ NO — customer replied/visited |
| Dylan Aguirre | Shane Inman | 2015 Ford Super Duty F-450 DRW Lariat (Used) / 4WD Crew Cab Pickup (4 | 6d | other | Outbound Text Message: Hey Dylan, it's Shane with Leif Johnson Ford in Manor. You inquired about a 2015 F-450 on Facebook a few days back. Still available if yo | ⚠️ NO — customer replied/visited | |
| Cj Simmons | Shane Inman | Cargurus | 2004 Ford Mustang Premium Mach 1 (Used) / RWD 2dr Car (2 Door) | 22d | other | KID ANSWERED AND SAID " YOU STINK LIKE FARTS" haha im going to mark it bad lead | ⚠️ NO — customer replied/visited |
| Howard Flournoy | Will Robbins | Repeat Customer | (none) | 53d | wrong-number/spam | Inbound Text Message: Wrong number | ⚠️ NO — customer replied/visited |
| K Touring Ltd | Ajay Malani | Autotrader.Com - Phone Lead | (none) | 1d | other | Outbound Text Message: Hey, this looks like it came through to our sales line. For service on Miranda's Bronco, call us directly at (512) 000-0000 and ask for S ⚠️24h | ⚠️ NO — customer replied/visited |
| Avery Hammond | Javier Choraifi | Vincue-Value Your Trade | 2026 Ford F-150 XLT (New) / 4WD Crew Cab Pickup (4 Door) | 1d | other | Not interested said he is looking at the value of his vehicle only | ⚠️ NO — customer replied/visited |
| Michael Ray Ochoa | Will Robbins | Autofi Standalone App | (none) | 186d | other | Email auto response: | ⚠️ NO — customer replied/visited |
4. Patterns
Top 3 lost-reason buckets: no-reason-given (15), other (14), bought-elsewhere (12)
Reps with lost leads that have no reason recorded:
| Rep | No reason | Total lost |
|---|---|---|
| Will Goodwin | 5 | 6 |
| Shane Inman | 3 | 7 |
| Emely Tellez | 2 | 5 |
| Matthew Cavaness | 1 | 1 |
| La Marcus Burnette | 1 | 7 |
| Cesar Hernandez Jr | 1 | 5 |
| Henry Smith | 1 | 5 |
| Gary Brophy | 1 | 1 |
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 | 4 | 25.0% |
| Vincue-Value Your Trade-Google/Cpc/Sr_leif Johnson Ford Of Manor - New | 1 | 5 | 20.0% |
| Truecar/Lifecare | 1 | 6 | 16.7% |
| Fd - Oem Search Inventory | 1 | 9 | 11.1% |
| Truecar/Navy Federal | 2 | 32 | 6.3% |
Marked lost within 24h of creation (too fast): 0
5. Coaching list (Monday)
- Biggest lost reason this period is "no-reason-given" (15 leads) — build a talk track for it and drill it in the next sales meeting.
- Will Goodwin logged 5 of 6 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/4 all-time, 25%) — reconsider spend or handling on this source.
- 12 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.