Lost & Bad Lead Review — last 7 days
Generated 2026-10-12T11:40:01.032Z. Window: 2026-10-05 → 2026-10-12 (prior window: 2026-09-28 → 2026-10-05).
1. Totals
| This period (7d) | Prior period (7d) | |
|---|---|---|
| Lost | 62 | 88 |
| Bad | 9 | 15 |
Lost by rep:
| Rep | Count |
|---|---|
| Pedro Barrera | 17 |
| La Marcus Burnette | 10 |
| Henry Smith | 9 |
| Edward Cavaness | 9 |
| Will Goodwin | 4 |
| Shane Inman | 4 |
| Emely Tellez | 3 |
| Cesar Hernandez Jr | 3 |
| Gary Brophy | 1 |
| Tariq Halawani | 1 |
| Ajay Malani | 1 |
Bad by rep:
| Rep | Count |
|---|---|
| La Marcus Burnette | 2 |
| Shane Inman | 2 |
| Will Robbins | 2 |
| Javier Choraifi | 1 |
| Emely Tellez | 1 |
| Cesar Hernandez Jr | 1 |
Lost by lead source:
| Source | Count |
|---|---|
| Phone Up | 17 |
| Drive By | 3 |
| Carfax - Trade-In Leads | 3 |
| 3 | |
| Referral | 2 |
| Fd - Oem Quick Quote | 2 |
| Dc New Quote | 2 |
| Truecar/Truecar | 2 |
| Truecar/Extended Network | 2 |
| Autotrader.Com - Lead | 2 |
| DC Used Quote | 2 |
| Truecar/Benefithub | 2 |
| Repeat Customer | 2 |
| Sendmeafriend.Com | 1 |
| Autotrader.Com - Wallet Lead | 1 |
| Truecar/Navy Federal | 1 |
| Vincue-Value Your Trade-Google/Cpc/Sr_leif Johnson Ford Of Manor - New | 1 |
| Truecar/Sams Club | 1 |
| Autofi Request More Info | 1 |
| Cargurus Area Boost | 1 |
| Truecar/Perkspot | 1 |
| Truecar/Progressive | 1 |
| Autotrader.Com - Dealer Price Quote Lead | 1 |
| AUTOFI NO PAYMENT LEAD | 1 |
| Cargurus | 1 |
| Truecar/Beneplace | 1 |
| Chase Auto Preferred | 1 |
| Cargurus - Digital Deal | 1 |
| Service Dept | 1 |
| Truecar/Corestream | 1 |
| Vincue-Value Your Trade | 1 |
Bad by lead source:
| Source | Count |
|---|---|
| Cargurus | 2 |
| 1 | |
| Repeat Customer | 1 |
| Vincue-Value Your Trade | 1 |
| Autofi Standalone App | 1 |
| Autotrader.Com - Lead | 1 |
| Chat-Impel | 1 |
| FORD ICI PRIVATE OFFER | 1 |
2. Every lost lead (62)
| Name | Rep | Source | Vehicle | Days Worked | Bucket | Reason (verbatim) |
|---|---|---|---|---|---|---|
| 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 |
| Rajesh Reddy Thiyyagura | Tariq Halawani | Truecar/Extended Network | 2026 Ford Mustang GT (New) / RWD 2dr Car (2 Door) | 0d | bought-elsewhere | BOUGHT ELSEWHERE ⚠️24h |
| Augie Martinez | La Marcus Burnette | Autotrader.Com - Lead | 2019 Ford F-150 XL (Used) / RWD Crew Cab Pickup (4 Door) | 11d | no-response | no response |
| Kathir M | La Marcus Burnette | Phone Up | 2025 Lucid Air Touring (Used) / AWD 4dr Car (4 Door) | 92d | no-reason-given | _no reason given_ |
| Kimberly Smith | Henry Smith | Truecar/Sams Club | 2026 Ford Maverick LARIAT AWD (New) / Trans: AutomaticStyle: Pickup | 8d | other | Outbound Text Message: You're welcome! 😁 |
| Oliver Jiminez | La Marcus Burnette | Phone Up | 2026 Ford F-150 XL (New) / RWD Regular Cab Pickup (2 Door) | 19d | other | Outbound Text Message: Hey Oliver, it's Marcus from Ford, checking to see if you are still looking for a regular cab? |
| Ashley Retzloff | Will Goodwin | Autofi Request More Info | 2026 Ford Expedition King Ranch (New) / 4WD Sport Utility (4 Door) | 8d | no-response | Left message |
| Juan Contreras | Henry Smith | Carfax - Trade-In Leads | 2018 Ford Fusion SE (Used) / FWD Sedan | 67d | no-reason-given | _no reason given_ |
| Thomas Lastname | Pedro Barrera | Phone Up | (none) | 15d | no-response | no response |
| Christian Taylor | La Marcus Burnette | Phone Up | (none) | 6d | no-response | no response |
| Pete Soto | Henry Smith | Drive By | 2026 Ford F-150 XLT (New) / 4WD Crew Cab Pickup (4 Door) | 7d | bought-elsewhere | Purchased a RAM yesterday. |
| Erik Smallwood | Pedro Barrera | DC Used Quote | 2024 Ford F-150 STX (Certified) / RWD Crew Cab Pickup (4 Door) | 9d | no-response | Left message |
| Julie Wentz | La Marcus Burnette | Truecar/Benefithub | 2026 Ford Bronco Sport Big Bend (New) / 4WD Sport Utility (4 Door) | 8d | bought-elsewhere | Purchased this past weekend in San Antonio. |
| Lucas Grantham | Pedro Barrera | Phone Up | 2026 Ford F-150 XL (New) / 4WD Regular Cab Pickup (2 Door) | 16d | other | doesn't want to be bothered anymore |
| Norma Ortiz | Pedro Barrera | DC Used Quote | 2013 Mazda Mazda3 i Sport (Used) / FWD 4dr Car (4 Door) | 38d | no-response | no response |
| Gerald Kashuba | Edward Cavaness | Repeat Customer | (none) | 50d | other | Wants to keep his truck doesn't want to buy a new truck. |
| Aaron Villafranca | Edward Cavaness | Repeat Customer | (none) | 50d | other | mark up is to high for the Raptor R |
| Djamal Hamane | Edward Cavaness | Cargurus Area Boost | 2025 Toyota Tacoma 4WD SR5 (Used) / 4WD Crew Cab Pickup (4 Door) | 25d | no-response | no response |
| Matt Gann | Edward Cavaness | Truecar/Perkspot | 2026 Ford F-150 STX SuperCrew 5.5' Box 2WD (New) / Trans: AutomaticSt | 50d | out-of-market | not in the market |
| Ana Lopez | Edward Cavaness | Phone Up | (Used) | 42d | credit | could not get approved |
| Daniel Kalin | Pedro Barrera | Drive By | 2026 Ford Mustang EcoBoost Premium (New) / RWD 2dr Car (2 Door) | 28d | other | WANTS NEW VEHICLE FOR $20,000 |
| Kelly Egger | Pedro Barrera | Truecar/Progressive | 2026 Ford Explorer Active w/200A Pkg (New) / RWD Sport Utility (4 Door | 61d | bought-elsewhere | BOUGHT |
| Duke Brown | Will Goodwin | Autotrader.Com - Lead | 2027 Ford Super Duty F-250 SRW King Ranch (New) / 4WD Crew Cab Pickup | 5d | other | bad |
| Andrea Martinez | Edward Cavaness | Autotrader.Com - Dealer Price Quote Lead | 2026 Ford F150 Lightning (New) | 12d | other | not interested |
| Brian Mouse | La Marcus Burnette | AUTOFI NO PAYMENT LEAD | (none) | 95d | no-reason-given | _no reason given_ |
| Tyler Berlin | Henry Smith | Referral | (none) | 3d | other | Unsubscribed |
| Jr. Zavala | Pedro Barrera | 2015 Ford Super Duty F-450 DRW Lariat (Used) / 4WD Crew Cab Pickup (4 | 24d | no-response | FACEBOOK LEAD, NO RESPONSE | |
| Sidney Boyle | Pedro Barrera | Cargurus | 2004 Ford Mustang Premium Mach 1 (Used) / RWD 2dr Car (2 Door) | 25d | credit | NO REPONSE ONLY EVER TOLD US TO STOP WITH TEXT MESSAGING |
| Ronnie Moodley | Pedro Barrera | Truecar/Beneplace | 2026 Ford Explorer Platinum (New) / RWD Sport Utility (4 Door) | 39d | other | doesnt answer phone calls, hangs up on ai introduction |
| Ivan Aguirre | Pedro Barrera | Chase Auto Preferred | 2025 FORD F-150 (Used) | 50d | out-of-market | Not in market |
| Juan Gomez | Pedro Barrera | 2023 Toyota Tundra 4WD TRD Pro Hybrid (Certified) / 4WD Crew Cab Picku | 15d | bought-elsewhere | BAD CREDIT, JUST BOUGHT A TRUCK, SUPER FLIPPED NO MONEY DOWN, DNC! NEEDS TO PAY OFF HIS LOAN MORE BEFORE HE CAN GET INTO A NEW VEHICLE. | |
| Javier Jartin | Edward Cavaness | Phone Up | 2021 Ford F-150 XLT (Used) / 4WD Crew Cab Pickup (4 Door) | 6d | bought-elsewhere | purchased elsewhere |
| Cristian Almazan | Pedro Barrera | Cargurus - Digital Deal | 2014 Chevrolet Silverado 1500 LT (Used) / RWD Crew Cab Pickup (4 Door) | 48d | other | HUNG UP ON PHONE CALL AFTER INTRODUCING MYSELF |
| Michael Valle | Henry Smith | 2022 Ford Explorer Platinum (Certified) / 4WD Sport Utility (4 Door) | 7d | other | no deal too far aprt | |
| Armando Garza | Henry Smith | Service Dept | 2026 Ford F-150 Raptor (New) / 4WD Crew Cab Pickup (4 Door) | 7d | other | too far apart |
| Vamshi Chittaloori | Edward Cavaness | Truecar/Benefithub | 2026 Ford Mustang GT Fastback (New) / Trans: ManualStyle: CoupeColor | 25d | other | not interested |
| Tom Tysseling | Cesar Hernandez Jr | Phone Up | 2025 Ford Bronco Badlands (New) / 4WD Convertible (4 Door) | 17d | out-of-market | out of market |
| Edy Cuevas | Pedro Barrera | Fd - Oem Quick Quote | 2026 Ford Mustang (New) | 54d | bought-elsewhere | BOUGHT A MUSTANG LAST SATURDAY |
| Edward Ortiz | La Marcus Burnette | Truecar/Corestream | 2026 Ford Explorer Active w/200A Pkg (New) / RWD Sport Utility (4 Door | 7d | bought-elsewhere | bought elsewhere |
| Tanner Funke | Ajay Malani | Vincue-Value Your Trade | 2022 Ford Expedition Timberline (Used) / 4WD Sport Utility (4 Door) | 1d | no-response | Left message ⚠️24h |
| Cody Hernandez | La Marcus Burnette | Truecar/Truecar | 2026 Ford F-150 LARIAT SuperCrew 5.5' Box 2WD (New) / Trans: Automati | 13d | other | No contact |
3. Every bad lead (9)
| Name | Rep | Source | Vehicle | Days Worked | Bucket | Reason (verbatim) | Really bad? |
|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| Nina Impeltest | La Marcus Burnette | Autotrader.Com - Lead | 2013 Mazda Mazda3 i Sport (Used) / FWD 4dr Car (4 Door) | 2d | other | Outbound Text Message: Hey Nina, it’s Marcus with Ford in Manor. Just confirming our appointment at Noon 😀 Reply STOP to cancel. | ⚠️ NO — customer replied/visited |
| Marjorie Not Provided | Emely Tellez | Chat-Impel | (New) | 3d | other | Outbound Text Message: Sounds good, ma’am! If you have any questions or if you’re in the market for a new vehicle, we’re here to help. 😊 | ⚠️ NO — customer replied/visited |
| Davin Greeno | Cesar Hernandez Jr | FORD ICI PRIVATE OFFER | (none) | 5d | no-reason-given | _no reason given_ | yes |
4. Patterns
Top 3 lost-reason buckets: other (21), bought-elsewhere (15), no-response (11)
Reps with lost leads that have no reason recorded:
| Rep | No reason | Total lost |
|---|---|---|
| Will Goodwin | 2 | 4 |
| Henry Smith | 2 | 9 |
| La Marcus Burnette | 2 | 10 |
| Shane Inman | 1 | 4 |
| Cesar Hernandez Jr | 1 | 3 |
| 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 |
|---|---|---|---|
| Cargurus Area Boost | 1 | 1 | 100.0% |
| Truecar/Corestream | 1 | 1 | 100.0% |
| AUTOFI NO PAYMENT LEAD | 1 | 4 | 25.0% |
| Vincue-Value Your Trade-Google/Cpc/Sr_leif Johnson Ford Of Manor - New | 1 | 5 | 20.0% |
| Truecar/Progressive | 1 | 7 | 14.3% |
Marked lost within 24h of creation (too fast): 2
- Rajesh Reddy Thiyyagura (Tariq Halawani, Truecar/Extended Network)
- Tanner Funke (Ajay Malani, Vincue-Value Your Trade)
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.
- Will Goodwin logged 2 of 4 lost leads with no reason recorded — require a one-line lost reason before a lead can be marked lost.
- Cargurus Area Boost has the worst lost rate (1/1 all-time, 100%) — reconsider spend or handling on this source.
- 2 lead(s) were marked lost within 24 hours of coming in (e.g. Rajesh Reddy Thiyyagura) — too fast, review for premature marking.
- 8 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.