| Customer Name | Assigned To | Assigned By | Source | Lead Type | Vehicle of Interest | Trade-In Vehicle | Appointments Created | Appointments Completed | Sold Deals | Conversion % | Avg. Response Time | Cost per Lead | Cost per Sold Unit |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| John Doe | Mike Smith | Primus CRM | Internet | 2023 Honda Civic | 2019 Toyota Corolla | 3 | 2 | 1 | 12% | 45 mins | $50 | $600 | |
| Maria Lopez | Sarah Johnson | Alex Brown | Google Ads | Phone | 2024 Toyota Camry | - | 4 | 3 | 2 | 18% | 30 mins | $40 | $450 |
| David Chen | Robert Lee | Primus CRM | Walk-In | Showroom | 2022 Ford Explorer | 2017 Nissan Rogue | 2 | 2 | 1 | 20% | 15 mins | $0 | $300 |
| Emily Davis | James White | Primus CRM | Email Campaign | Internet | 2023 BMW X5 | - | 5 | 4 | 2 | 25% | 50 mins | $60 | $700 |
| Ahmed Khan | Linda Green | Tom Walker | Referral | Phone | 2024 Hyundai Sonata | 2018 Kia Optima | 3 | 2 | 1 | 16% | 25 mins | $20 | $350 |
| Michael Brown | Chris Evans | Primus CRM | Internet | 2023 Audi A4 | - | 6 | 5 | 3 | 28% | 40 mins | $55 | $500 | |
| Sophia Martinez | William Harris | Anna Scott | Website Lead | Internet | 2024 Tesla Model 3 | 2020 Toyota Prius | 2 | 2 | 2 | 35% | 20 mins | $70 | $650 |
| Jason Clark | Emma Wilson | Primus CRM | Walk-In | Showroom | 2022 Jeep Wrangler | - | 1 | 1 | 0 | 0% | 10 mins | $0 | - |
| Hannah Lee | Daniel Thomas | Michael Young | Internet | 2023 Kia Sportage | 2015 Ford Escape | 3 | 2 | 1 | 14% | 35 mins | $45 | $550 | |
| Olivia Johnson | Jacob Allen | Primus CRM | Google Ads | Internet | 2024 Mercedes C-Class | - | 4 | 3 | 1 | 22% | 55 mins | $65 | $800 |
| Chris Taylor | Laura Martinez | Kevin Adams | Email Campaign | Phone | 2023 Toyota RAV4 | 2017 Honda CR-V | 5 | 4 | 2 | 20% | 28 mins | $52 | $580 |
| Aisha Patel | Brian Cooper | Primus CRM | Referral | Showroom | 2023 Nissan Altima | - | 2 | 2 | 1 | 18% | 22 mins | $25 | $400 |