Total Leads
3,841
+16% vs April
Site Visits
742
19.3% of leads
Payments
218
29.4% of visits
Bookings
84
38.5% of payments
Conv. Rate
2.2%
Target 2.5%
Revenue est.
₹105 Cr
Avg ₹1.25 Cr/ticket
Avg Response
38 min
+6 min vs target
Lead Volume & Bookings — 6 Months
Monthly leads vs bookings · dual axis
Master Funnel
3,841 leads → 84 bookings · May 2025
Leads
3,841
100%
↓ 76%
Followup
2,920
76%
↓ 66%
Interested
1,921
50%
↓ 39%
Site Visit
742
19%
↓ 29%
Payment
218
5.7%
↓ 39%
Booking
84
2.2%
Lead Source Mix
Where leads come from · May 2025
Conversion Rate by Project
Lead-to-booking % · all 6 projects
⚠ Hygiene Alerts
Leads requiring immediate action · today
Unassigned Leads3
L101 (45d) · L102 (120d) · L103 (30d)
Not Contacted2
Rahul: L201 (20d) · Ankit: L202 (90d)
Duplicate Leads2
L1001 (2 dups · 15m gap) · L1002 (3 dups)
Multi-Attempt No-Connect2
L401 (5 attempts) · L402 (7 attempts)
Pipeline Status Snapshot
All leads classified as of today
| Status | Count | % of total | Avg age (days) | Est. value | Action required |
|---|---|---|---|---|---|
| New / Uncontacted | 312 | 8.1% | 1.2 | — | Assign within 2 hrs |
| Contacted · Followup pending | 984 | 25.6% | 4.8 | ₹12.3 Cr | Send brochure / re-call |
| Interested · Visit not booked | 641 | 16.7% | 8.2 | ₹8.0 Cr | Book visit this week |
| Visit scheduled | 186 | 4.8% | 3.1 | ₹23.3 Cr | Pre-brief experience centre |
| Visit done · Negotiation | 214 | 5.6% | 11.4 | ₹26.8 Cr | Send payment options |
| Payment received | 218 | 5.7% | 6.2 | ₹27.3 Cr | Expedite legal / docs |
| Booked ✓ | 84 | 2.2% | — | ₹105 Cr | Handover process begin |
| Cold / Lost | 1,202 | 31.3% | 22.6 | — | Monthly re-nurture drip |
Lead → Followup
76%
-4% vs target 80%
Followup → Visit
25.4%
+2.1% vs April
Visit → Payment
29.4%
-1.6% vs April
Payment → Booking
38.5%
+3.2% vs April
Overall Conv.
2.2%
Target 2.5%
Funnel by Project — Visit Rate
Lead-to-visit % per project · May 2025
Funnel by Lead Source — Conv. Rate
Which sources convert best end-to-end
Stage Drop-off Analysis by Project
Where leads fall out at each stage
| Project | Leads | Followup % | Interest % | Visit % | Payment % | Booking % | Biggest drop |
|---|---|---|---|---|---|---|---|
| Sobha Neopolis Panathur Rd | 412 | 78% | 47% | 23% | 8% | 2.7% | Interest → Visit |
| Sobha City Tumkur Rd | 284 | 74% | 42% | 20% | 7% | 2.1% | Lead → Followup |
| Sobha Dream Acres Marathahalli | 748 | 76% | 44% | 19% | 6% | 1.9% | Payment → Booking |
| Sobha Hartland II Hebbal | 921 | 79% | 51% | 20% | 7% | 2.3% | Interest → Visit |
| Sobha Indraprastha Electronic City | 312 | 71% | 38% | 17% | 5% | 1.6% | Lead → Followup |
| Sobha Royal Pavilion Sarjapur | 164 | 68% | 34% | 13% | 4% | 1.2% | Lead → Followup |
Average Days at Each Stage
How long leads sit before moving forward
Funnel Trend — Visit Rate over 6 Months
Lead-to-visit conversion improving month on month
Lead Lifecycle — Stage Tracking
Current count · MTD · avg days in stage · stuck leads
| Stage | Today | MTD | Avg Days in Stage | Stuck Leads | Action |
|---|---|---|---|---|---|
| New | 120 | 540 | 1.2d | 15 | Assign within 2 hrs |
| Duplicate | 100 | 480 | 0.8d | 10 | Merge / discard |
| Unqualified | 90 | 430 | 1.5d | 12 | Review with RM |
| Qualified (QL) | 60 | 300 | 3.2d | 18 | Push to site visit |
| Visit Planned (VP) | 40 | 210 | 2.4d | 9 | Confirm visit date |
| Visit Confirmed (VC) | 30 | 170 | 2.0d | 7 | Pre-brief experience centre |
| Visit Done (VD) | 18 | 90 | 5.6d | 6 | Send payment options |
| Won ✓ | 6 | 28 | 9.5d | 0 | Begin handover docs |
| Lost | 40 | 220 | 2.1d | 0 | Re-engagement queue |
Re-engagement Pipeline
Cold leads re-contacted by bucket · conversion %
Stage Regression
Leads that moved backwards in the funnel
| Lead | From | To | RM |
|---|---|---|---|
| L801 | Qualified | Not Interested | Rahul |
| L802 | Visit | Dropped | Ankit |
Active Reps
32
Across 4 teams
Avg Calls / Rep
120
Target 130
Best Conv. Rate
2.8%
Kushal R. · Floor A
Team Avg Conv.
2.2%
Target 2.5%
Reps Below Target
11
Of 32 active reps
Rep Leaderboard — Bookings (May)
Total bookings attributed per rep
Rep Leaderboard — Visit Rate
Lead-to-visit conversion % per rep
Rep Performance Cards
Top 8 reps by bookings · May 2025
KR
Kushal R.
Sr. Sales · Floor A
Leads
142
Visits
38
Bookings
4
Conv.
2.8%
Visit rate
26.8%
F/U rate
82%
AR
Anish R.
Sr. Sales · Floor A
Leads
128
Visits
26
Bookings
3
Conv.
2.3%
Visit rate
20.3%
F/U rate
74%
PM
Priya M.
Sales · Floor A
Leads
119
Visits
22
Bookings
2
Conv.
1.7%
Visit rate
18.5%
F/U rate
70%
NK
Nisha K.
NRI Desk
Leads
84
Visits
26
Bookings
4
Conv.
4.8%
Visit rate
31%
F/U rate
94%
RK
Rahul K.
Sales · Floor A
Leads
108
Visits
18
Bookings
2
Conv.
1.9%
Visit rate
16.7%
F/U rate
68%
MS
Mohit S.
Sales · Floor A
Leads
96
Visits
14
Bookings
1
Conv.
1.0%
Visit rate
14.6%
F/U rate
62%
IP
Isha P.
Sales · Floor A
Leads
82
Visits
11
Bookings
1
Conv.
1.2%
Visit rate
13.4%
F/U rate
58%
TS
Tanvi S.
Jr. Sales · Floor A
Leads
88
Visits
10
Bookings
0
Conv.
0.0%
Visit rate
11.4%
F/U rate
41%
Rep × Stage Heatmap
Leads at each funnel stage per rep — darker = more
| Rep | New | Contacted | Interested | Visit Booked | Visit Done | Payment | Booked |
|---|---|---|---|---|---|---|---|
| Kushal R. | 18 | 42 | 38 | 22 | 16 | 12 | 4 |
| Anish R. | 14 | 36 | 32 | 18 | 12 | 8 | 3 |
| Priya M. | 12 | 32 | 28 | 14 | 10 | 6 | 2 |
| Nisha K. (NRI) | 8 | 24 | 28 | 18 | 16 | 12 | 4 |
| Rahul K. | 14 | 34 | 26 | 12 | 8 | 5 | 2 |
| Mohit S. | 12 | 28 | 24 | 10 | 6 | 3 | 1 |
| Tanvi S. | 16 | 26 | 18 | 6 | 4 | 2 | 0 |
Call Activity — Hour × RM
Total calls by time slot · today
Hourly Call Volume Heatmap
Calls per hour per RM — darker = more calls
10AM
11AM
12PM
1PM
2PM
3PM
4PM
5PM
6PM
Rahul
35
42
48
28
38
32
22
18
8
Ankit
28
35
40
32
36
30
20
15
6
Sneha
32
38
44
40
38
28
24
16
5
Call Outcome Distribution
Per RM · this month
Follow-up Depth
Attempts per lead · conversion rate
| RM | Avg Attempts | 1× | 3–5× | 7×+ | Conv% |
|---|---|---|---|---|---|
| Rahul | 3.8 | 20 | 12 | 5 | 9% |
| Ankit | 3.2 | 22 | 9 | 3 | 7% |
| Sneha | 4.1 | 18 | 14 | 6 | 11% |
Short Call Dumping ⚠
Calls under 10s / 20s — quality concern
| RM | <10s | <20s | Total | % Short |
|---|---|---|---|---|
| Rahul | 12 | 25 | 120 | 20.8% |
| Ankit | 15 | 30 | 110 | 27.3% |
| Sneha | 8 | 18 | 105 | 16.2% |
RM Utilisation & Load
Login hours · calling hours · lead overload
RM Utilisation
Login vs calling vs idle hours · today
Lead Overload
Assigned vs active vs dormant leads per RM
| RM | Assigned | Active | Dormant | Dormant % |
|---|---|---|---|---|
| Rahul | 120 | 70 | 50 | 41.7% |
| Ankit | 110 | 65 | 45 | 40.9% |
| Sneha | 115 | 80 | 35 | 30.4% |
Recycled Leads
Reassigned leads · first action delay · conversion
| Lead | Reassigned To | First Action Delay | Site Visits / QL | Status |
|---|---|---|---|---|
| L601 | Ankit | 10 hrs | 5% | In progress |
| L602 | Rahul | 6 hrs | 7% | Converted |
Active Projects
6
Bangalore metro area
Best Performer
Neopolis
2.7% conv. rate
Needs Attention
Royal Pav.
1.2% conv. rate
Highest Volume
Hartland II
921 leads
Avg Ticket
₹1.25 Cr
Range ₹98L–₹1.8Cr
Total Revenue
₹105 Cr
May bookings
Leads by Project
Volume and conversion rate comparison
Revenue Contribution by Project
Estimated booking value · May 2025
Project Performance Table
Full funnel · May 2025
| Project | Leads | Visits | Visit % | Payments | Bookings | Conv.% | Avg Ticket | Revenue | Inventory | Status |
|---|---|---|---|---|---|---|---|---|---|---|
| Sobha Neopolis Panathur Rd · Whitefield | 412 | 94 | 22.8% | 31 | 11 | 2.7% | ₹1.22 Cr | ₹13.4 Cr | 14 3BHK left | Sustenance |
| Sobha City Tumkur Rd · Yeshwanthpur | 284 | 58 | 20.4% | 22 | 6 | 2.1% | ₹1.74 Cr | ₹10.4 Cr | Good stock | Active |
| Sobha Dream Acres Marathahalli · ORR | 748 | 142 | 19.0% | 58 | 14 | 1.9% | ₹1.02 Cr | ₹14.3 Cr | Good stock | Plateau |
| Sobha Hartland II Hebbal · Bellary Rd | 921 | 184 | 20.0% | 68 | 21 | 2.3% | ₹1.38 Cr | ₹29.0 Cr | Good stock | Growing |
| Sobha Indraprastha Electronic City · Ph 1 | 312 | 54 | 17.3% | 22 | 5 | 1.6% | ₹1.01 Cr | ₹5.1 Cr | Good stock | Launch |
| Sobha Royal Pavilion Sarjapur · Attibele Rd | 164 | 21 | 12.8% | 8 | 2 | 1.2% | ₹96 L | ₹1.9 Cr | Good stock | Needs attn. |
Buyer Segment by Project
End user / Investor / NRI / Govt mix per project
Site Visit Funnel
Scheduled · completed · no-shows · reschedules
Visit Outcomes by Project
Completed vs no-show vs rescheduled
No-Show Recovery
Leads who no-showed · follow-up done · recovered
| Lead | Project | No-show Date | FU Done | Recovered |
|---|---|---|---|---|
| L901 | Neopolis | 12 May | Yes | No |
| L902 | Townpark | 12 May | No | No |
⚠ L902 — no follow-up done in 24hrs post no-show
Inventory Demand Signals
Unit type · budget band · floor / facing preference from calls
Unit Type Demand
Leads asking for each config · by project
Budget Band + Preferences
Budget distribution · floor & facing signals
| Project | ₹1–1.5Cr | ₹1.5–2Cr | ₹2Cr+ | High Floor% | East Facing% |
|---|---|---|---|---|---|
| Neopolis | 25 | 40 | 20 | 55% | 48% |
| Townpark | 28 | 32 | 13 | 50% | 52% |
💡 55% of Neopolis leads request high floors — prioritise high-floor units in pitch and ensure availability at site visit.
Lost Leads Analysis
Why leads are lost · at which stage · time to loss
Loss Reasons by Project
Price · location · competitor · not interested
Micro-Market Blind Spots
Areas with leads but low conversion — need pitch attention
| Area | Leads | Calls | Conv% | Signal |
|---|---|---|---|---|
| Whitefield | 120 | 300 | 7% | Underperforming |
| Sarjapur | 100 | 260 | 8% | On track |
⚠ Whitefield generates 120 leads but only 7% conversion — high-traffic area with low trust. Add RERA + Sobha delivery record to Whitefield pitch.
Inbound Call
1,382
2.4% conv. · +0.3%
Digital / Web
1,148
1.6% conv. · stable
Walk-in
486
4.1% conv. · best rate
Channel Partner
614
3.2% conv. · +0.6%
NRI Referral
211
4.7% conv. · #1 source
Lead Volume by Source
Monthly trend · all channels
Conversion Rate by Source
End-to-end lead-to-booking %
Funnel by Lead Source
Stage-by-stage breakdown per channel
| Source | Leads | Cost / Lead | Followup % | Visit % | Payment % | Booking % | Cost / Booking | Trend |
|---|---|---|---|---|---|---|---|---|
Inbound Call |
1,382 | ₹420 | 82% | 21% | 6.4% | 2.4% | ₹17,500 | ↑ |
Digital / Web |
1,148 | ₹680 | 71% | 16% | 4.8% | 1.6% | ₹42,500 | → |
Walk-in |
486 | ₹180 | 94% | 38% | 12.1% | 4.1% | ₹4,400 | ↑↑ |
Channel Partner |
614 | ₹1,240 | 88% | 28% | 9.6% | 3.2% | ₹38,800 | ↑ |
NRI Referral |
211 | ₹0 | 96% | 44% | 14.2% | 4.7% | ₹0 | ↑↑ |
Lead Source × Project Matrix
Which channels drive leads to which projects
Source Performance Deep-Dive
Contactability · qualification · calls per lead · booking rate
| Source | Leads | Contactability% | Qualification% | Visit% | Booking% | Calls/Lead | Best for project |
|---|---|---|---|---|---|---|---|
| Digital | 120 | 78% | 52% | 24% | 8% | 3.5 | Neopolis |
| PropTech | 95 | 75% | 48% | 22% | 7% | 3.2 | Dream Acres |
| Visited Data | 70 | 90% | 60% | 30% | 12% | 2.8 | All projects |
| Profiled Leads | 60 | 82% | 55% | 28% | 10% | 3.0 | Hartland II |
💡 Visited Data converts at 12% vs Digital at 8% — at 2.8 calls/lead vs 3.5. Prioritise re-engaging past site-visit leads before investing in new digital spend.
Active CPs
24
Bangalore registered
CP Leads (May)
614
+18% vs April
CP Bookings
20
3.2% conv.
CP Revenue
₹25 Cr
23.8% of total
Avg Commission
₹2.4L
Per booking paid
Top Channel Partners — Bookings
CP performance ranking · May 2025
CP Lead Quality — Conv. Rate
Not all CPs bring equal quality leads
Channel Partner Performance Table
All active CPs · May 2025
| Channel Partner | Leads | Visits | Visit % | Bookings | Conv.% | Revenue | Commission due | Preferred project | Status |
|---|---|---|---|---|---|---|---|---|---|
|
MH
Marathahalli Homes Marathahalli · Est. 2018 |
142 | 44 | 31% | 6 | 4.2% | ₹7.3 Cr | ₹14.4 L | Neopolis | Platinum |
|
KP
Koramangala Properties HSR Layout · Est. 2015 |
118 | 36 | 30.5% | 5 | 4.2% | ₹6.9 Cr | ₹12.0 L | Hartland II | Platinum |
|
WR
Whitefield Realty Whitefield · Est. 2019 |
96 | 26 | 27.1% | 3 | 3.1% | ₹3.7 Cr | ₹7.2 L | Neopolis | Gold |
|
HH
Hebbal Homes Hebbal · Est. 2020 |
84 | 20 | 23.8% | 3 | 3.6% | ₹4.1 Cr | ₹7.2 L | Hartland II | Gold |
|
BS
Bengaluru Spaces Indiranagar · Est. 2017 |
98 | 18 | 18.4% | 2 | 2.0% | ₹2.4 Cr | ₹4.8 L | Dream Acres | Silver · Watch |
|
OP
ORR Properties Marathahalli · Est. 2021 |
76 | 12 | 15.8% | 1 | 1.3% | ₹1.2 Cr | ₹2.4 L | Dream Acres | Review |
CP Lead Volume — 6-Month Trend
Top 4 channel partners month-on-month
MoM Lead Growth
+16%
2,100 → 3,841 (6mo)
MoM Booking Growth
+13.5%
42 → 84 (6mo)
Best Month
May 2025
84 bookings · ₹105 Cr
Weakest Day (May)
Sundays
Avg 3.2 leads · 0.4 visits
Monthly Lead & Booking Volume
Dec 2024 – May 2025 · absolute numbers
Conversion Rate Trend
Overall conv. % month on month
Daily Lead Volume — May 2025
Day-by-day inbound leads this month
Day-of-Week Pattern
Average leads and visits by weekday
Weekly Breakdown — May 2025
All KPIs by week
| Week | Leads | Followup % | Visits | Payments | Bookings | Conv. % | vs prev. week |
|---|---|---|---|---|---|---|---|
| Wk 1 (1–5 May) | 842 | 74% | 148 | 44 | 16 | 1.9% | → baseline |
| Wk 2 (6–12 May) | 968 | 77% | 178 | 52 | 20 | 2.1% | ↑ +2 bookings |
| Wk 3 (13–19 May) | 1,014 | 79% | 202 | 64 | 24 | 2.4% | ↑↑ +4 bookings |
| Wk 4 (20–31 May) | 1,017 | 76% | 214 | 58 | 24 | 2.4% | → steady |
Booking Pipeline — Hot Deals
Deals likely to close · stage · aging · unit type
| Project | Hot Deals | Deal Value | Stage | Avg Aging | Unit Type | Risk |
|---|---|---|---|---|---|---|
| Sobha Neopolis | 12 | ₹9.2 Cr | VD | 7.2d | 3BHK | Review |
| Sobha Townpark | 9 | ₹6.4 Cr | VC | 5.1d | 2BHK | On track |
Hot Leads Gone Cold ⚠
High-value leads with no activity in 4–5 days
| Lead | RM | Last Activity | Deal Value | Stage | Action |
|---|---|---|---|---|---|
| L501 | Rahul | 4 days ago | ₹1.8 Cr | Post Visit | 🔥 Call today |
| Last note: Interested in 4BHK, asked for revised payment plan. Rahul hasn't followed up in 4 days. Risk: budget decision window closing. | |||||
| L502 | Sneha | 5 days ago | ₹2.2 Cr | Negotiation | 🔥 Escalate |
| Last note: Was comparing with Prestige. Sneha mentioned a price revision coming — but didn't follow up. This lead may have gone to Prestige. | |||||
Weekend vs Weekday Pattern
Call volume · connect rate · conversion by day type
Weekday vs Weekend — Volume & Connect
Avg calls and connect % by day type
Day-of-Week Insight
Derived from call patterns · May 2025
Saturday — highest visit rate (42 avg). Experience centre walk-ins peak. Best day to close site visits.
Sunday — lowest call volume (62 avg leads). Team availability drops. Follow-up compliance drops 18%.
Monday–Tuesday — peak calling days. Best window for NRI calls (Gulf evening = India 7–9PM).
Total FU Missed
36
+4 vs yesterday
Missed Value
₹4.8 Cr
Hot leads × avg ticket
Critical (Negotiation)
14
At risk of losing to competitor
>48hr Missed
14
Oldest: 7+ days
Worst RM
Vikram
23.7% miss rate
Missed Followups — RM Summary
Click a row to see the lead drilldown
| RM | FU Due Today | Missed FU | Miss% | Missed Value | Critical (Neg.) | >48hr Missed | Status | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Rahul | 50 | 12 | 24% | ₹1.8 Cr | 5 | 4 | Review | ||||||||||||||||||||||||||||
|
Lead Drilldown — Rahul's Missed Followups
|
|||||||||||||||||||||||||||||||||||
| Ankit | 40 | 8 | 20% | ₹1.2 Cr | 3 | 2 | OK | ||||||||||||||||||||||||||||
8 missed followups — 3 in Post-Visit stage. No negotiation stage misses. Ankit's miss rate is within acceptable range but trending up. |
|||||||||||||||||||||||||||||||||||
| Sneha | 45 | 7 | 15.6% | ₹0.8 Cr | 2 | 3 | Good | ||||||||||||||||||||||||||||
Best miss rate on the team at 15.6%. 3 leads >48hrs missed are in Qualified stage — low financial risk. Sneha should address the 3 aging gaps. |
|||||||||||||||||||||||||||||||||||
| Vikram ⚠ | 38 | 9 | 23.7% | ₹0.9 Cr | 4 | 5 | Urgent | ||||||||||||||||||||||||||||
⚠ Highest miss rate at 23.7% with 4 leads in Negotiation stage. 5 leads >48hrs — escalate immediately. Manager should reassign critical leads today. |
|||||||||||||||||||||||||||||||||||
Missed FU — Aging Buckets
How long since the followup was due · value at risk
<24 hrs
15
₹0.9 Cr
1–3 days
12
₹1.1 Cr
3–7 days
9
₹1.2 Cr
7+ days
6
₹1.0 Cr
Missed FU — By Stage
Where in the funnel are missed followups happening
Negotiation
6
₹2.5 Cr
Post Visit
8
₹1.5 Cr
Post Qual.
10
₹1.2 Cr
⚠ ₹2.5 Cr at risk in Negotiation stage alone. These 6 leads are the most likely to go to a competitor if not contacted today.
Missed FU — By Project
Which projects are most affected
| Project | Missed FU | Value at Risk | % of Project Leads | Priority |
|---|---|---|---|---|
| Sobha Neopolis | 14 | ₹2.1 Cr | 3.4% | Critical |
| Sobha Townpark | 10 | ₹1.6 Cr | 2.8% | Review |
| Sobha Dream Acres | 8 | ₹0.9 Cr | 1.7% | OK |