Analytics & insights
Company-wide funnel, lost reasons, delivery delays, and source performance · as of 2025-12-31
Sales funnel summary
new5
contacted76.7%10
test drive76.7%6
negotiation78.3%3
order placed84.3%38
delivered80.8%160
lost288(274)
510 leads in scope
| Stage | Reached | % of funnel | Drop-off |
|---|---|---|---|
| new | 510 | 100.0% | — |
| contacted | 391 | 76.7% | ↓ 23.3% drop |
| test drive | 300 | 58.8% | ↓ 23.3% drop |
| negotiation | 235 | 46.1% | ↓ 21.7% drop |
| order placed | 198 | 38.8% | ↓ 15.7% drop |
| delivered | 160 | 31.4% | ↓ 19.2% drop |
| lost | 274 | 0.0% | — |
Lost reason breakdown
288 lost leads with reasons recorded
| Reason | Count | % of lost |
|---|---|---|
| Better offer elsewhere | 40 | 13.9% |
| Not ready to purchase | 40 | 13.9% |
| Financing not approved | 38 | 13.2% |
| Unresponsive after follow-up | 38 | 13.2% |
| Budget constraints | 36 | 12.5% |
| Chose competitor brand | 30 | 10.4% |
| Dissatisfied with test drive | 28 | 9.7% |
| Relocated to another city | 24 | 8.3% |
| Unknown | 14 | 4.9% |
Delivery delay analysis
Breakdown of delayed deliveries and average time to deliver
Total deliveries
160
Delayed
72
45.0% of total
On time
88
55.0% of total
Avg days
18.3
Lead to delivery
Delivery timeliness88 on time · 72 delayed
● On time 55.0%● Delayed 45.0%
| Delay reason | Count | Share | Distribution |
|---|---|---|---|
| Customer requested date change | 18 | 25.0% | |
| Logistics delay in transit | 11 | 15.3% | |
| Vehicle allocation delayed from factory | 11 | 15.3% | |
| Accessory fitment backlog | 10 | 13.9% | |
| Finance disbursement pending | 9 | 12.5% | |
| RTO registration delay | 7 | 9.7% | |
| PDI rework required | 6 | 8.3% |
Lead source performance
Conversion rates by lead acquisition channel
| Source | Total | Delivered | Conversion |
|---|---|---|---|
| walk_in | 140 | 64 | 45.7% |
| website | 100 | 28 | 28.0% |
| referral | 83 | 25 | 30.1% |
| social_media | 72 | 10 | 13.9% |
| phone_enquiry | 72 | 20 | 27.8% |
| auto_expo | 43 | 13 | 30.2% |