| Customer Name | Assigned To | Assigned By | Source | Lead Type | Vehicle of Interest | Trade-In Vehicle | Campaign Name | Date Sent | Sent | Delivered (#) | Open Rate % | Click Rate % | Response Rate % | Bounced/Invalid (#) | Unsubscribes (#) | Did Not Open (#) | Appointments Created | Appointments Completed | Deals Sold | ROI |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| John Doe | Sarah Smith | Primus CRM | Internet | 2023 Honda Civic | 2018 Toyota Corolla | Summer Sales Blast | Oct 7, 2025 10:55 AM | 500 | 480 | 60% | 25% | 10% | 20 | 5 | 200 | 30 | 18 | $25,000 / $5,000 | 400% | |
| Jane Smith | David Johnson | Primus CRM | Website | Internet | 2024 Toyota RAV4 | 2020 Honda CR-V | Fall Promotion | Oct 6, 2025 02:30 PM | 750 | 720 | 55% | 20% | 8% | 30 | 8 | 324 | 25 | 15 | $32,000 / $7,500 | 327% |
| Robert Brown | Mike Wilson | Primus CRM | Google Ads | Internet | 2022 Ford F-150 | 2018 Chevrolet Silverado | Truck Month | Oct 5, 2025 09:15 AM | 300 | 285 | 65% | 30% | 12% | 15 | 3 | 100 | 20 | 12 | $45,000 / $8,000 | 463% |
| Emily Davis | Sarah Smith | Primus CRM | Internet | 2023 Hyundai Tucson | 2019 Kia Sportage | SUV Special | Oct 4, 2025 11:45 AM | 400 | 380 | 58% | 22% | 9% | 20 | 6 | 160 | 18 | 10 | $28,000 / $6,000 | 367% | |
| Michael Johnson | David Johnson | Primus CRM | Internet | 2024 Subaru Outback | 2021 Mazda CX-5 | Adventure Ready | Oct 3, 2025 03:20 PM | 600 | 570 | 52% | 18% | 7% | 30 | 7 | 274 | 22 | 13 | $35,000 / $7,200 | 386% | |
| Sarah Miller | Mike Wilson | Primus CRM | Website | Internet | 2023 Jeep Wrangler | 2018 Ford Explorer | Off-Road Special | Oct 2, 2025 10:10 AM | 350 | 332 | 62% | 28% | 11% | 18 | 4 | 126 | 16 | 9 | $42,000 / $6,500 | 546% |
| David Wilson | Sarah Smith | Primus CRM | Google Ads | Internet | 2024 Ford Bronco | 2019 Jeep Wrangler | Bronco Launch | Oct 1, 2025 01:30 PM | 450 | 427 | 68% | 32% | 14% | 23 | 5 | 137 | 24 | 14 | $48,000 / $8,500 | 465% |
| Lisa Anderson | David Johnson | Primus CRM | Internet | 2022 Toyota Highlander | 2017 Honda Pilot | Family First | Sep 30, 2025 09:45 AM | 550 | 522 | 54% | 19% | 8% | 28 | 9 | 240 | 20 | 11 | $33,000 / $7,800 | 323% |