Funnel
Stage progression, dwell time, and layer views · as of 2025-12-31
Stage conversion funnel
new5
contacted76.7%10
test drive76.7%6
negotiation78.3%3
order placed84.3%38
delivered80.8%160
lost288(274)
510 leads in scope
Dwell time per stage
| Stage | Leads | Avg days | Median | P90 |
|---|---|---|---|---|
| new | 510 | 2.1 | 2.0 | 3.0 |
| contacted | 391 | 6.4 | 6.0 | 10.0 |
| test drive | 300 | 4.3 | 4.0 | 7.0 |
| negotiation | 235 | 8.4 | 9.0 | 14.0 |
| order placed | 198 | 15.1 | 15.0 | 28.0 |
Dwell = days from entering a stage to leaving it (capped at as-of).
Month-over-month (created-by-month, current status)
| Month | new | contacted | test drive | negotiation | order placed | delivered | Lost |
|---|---|---|---|---|---|---|---|
| 2025-06 | 6 | 19 | 30 | ||||
| 2025-07 | 1 | 16 | 43 | ||||
| 2025-08 | 2 | 26 | 37 | ||||
| 2025-09 | 5 | 30 | 35 | ||||
| 2025-10 | 9 | 37 | 44 | ||||
| 2025-11 | 6 | 31 | 58 | ||||
| 2025-12 | 5 | 10 | 6 | 3 | 9 | 1 | 41 |
Source-channel conversion
| Source | Leads | Delivered % | Lost % | Avg days |
|---|---|---|---|---|
| walk_in | 140 | 45.7% | 36.4% | 19.5 |
| website | 100 | 28.0% | 61.0% | 18.7 |
| referral | 83 | 30.1% | 56.6% | 17.7 |
| social_media | 72 | 13.9% | 77.8% | 17.3 |
| phone_enquiry | 72 | 27.8% | 66.7% | 16.3 |
| auto_expo | 43 | 30.2% | 58.1% | 16.8 |
Model-level funnel
| Model | Leads | Delivered | Lost |
|---|---|---|---|
| Camry | 35 | 10 | 21 |
| Fortuner | 94 | 30 | 50 |
| Glanza | 130 | 44 | 72 |
| Hilux | 11 | 4 | 7 |
| Innova Crysta | 53 | 17 | 32 |
| Innova Hycross | 83 | 28 | 43 |
| Urban Cruiser Hyryder | 104 | 27 | 63 |
Models with meaningful volume drive the delivery split.