Leasing Funnel

Mango Grove · 1070 · 07/08/2026 – 09/05/2026
60-day window
New guest cards
281
prospects created in 60 days
Lease executions
15
approved applicants with a signed lease
Conversion
5.3%
15 executions / 281 guest cards
Missed followups
151
14.0% of 1,080 due
Follow-up is the clearest operational issue.151 missed followups, 119 of them on Shirley Gutierrez; unresponsive is the leading lost reason.Review workload

Leasing pipeline

last 60 days · matched prospect cohort
New guest cards281
Appointments98
Shows79
Applications40
Approvals15
Lease executions15
Move-ins11
0281 prospects
115Calls
147Web leads
19Walk-ins and email

Every stage is a count of distinct prospects with that dated event, so the funnel is monotone and every move-in in the window traces to a prospect and the lease it produced. 2,072 activity-register events in the window.

Why prospects did not rent

164 lost in the window
Prospect Unresponsive106
Insufficient Income16
Moving to Another Property8
Unsure of Move-in Date8
Other reasons26

106 of 164 (64.6%) are unresponsive. 22 applications were denied.

Campaign lead volume

prospects per tracking number · top eight
Google Business Profile · 833431201862 / 2
Google Business Profile · 866635572241 / 0
Property Website · 877842843323 / 1
Apartments.com · 866733640621 / 0
Property Website · 866215108218 / 0
Property Website · 855295865218 / 0
Apartments.com · 833682738217 / 0
Walk-In · 844369245815 / 0

Bars are prospects created in the window; the small figure is rentals from that campaign. Campaigns are tracking numbers (or a reply address) per source.

Lead sources

leads and rentals
SourceLeadsRentalsLead → lease
Google Business Profile10321.9%
Property Website5911.7%
Apartments.com3800.0%
Zillow2200.0%
Walk-In1500.0%
RentCafe ILS1200.0%
Facebook800.0%
Resident Referral800.0%
Instagram800.0%
Signage400.0%
Reply Email400.0%

Leads by weekday

prospects created
0100SunTueThuSat

Traffic skews Tuesday to Thursday and is near zero on Sundays, as the source reports show.

Lead quality

104 invalid leads · 27.0% of raw inbound
Duplicate51
Hang-up32
Vendor Call15
Spam4
Wrong Number2

Dismissed leads by reason. Raw inbound = prospects created + invalid leads.

Agent workload

prospects assigned in the window · followups due to date
AgentProspectsAppointmentsShowsRentalsFollowupsCompletedMissed
Shirley Gutierrez10848383436317119
Ana Richardson782015027326112
Rosa Patel732420027425816
Not Assigned system1211038353
Property Website system522039381
ILS system522020200

System agents (Property Website, ILS, Not Assigned) hold leads nobody has picked up. Highlighted row is the agent carrying the most missed followups.

Conversion by unit type

leads to rentals
Unit typeLeadsShowsRentalsLead → lease
1 Bed / 1 Bath1363821.5%
2 Bed / 1 Bath992800.0%
2 Bed / 2 Bath461212.2%

Pipeline definitions

Guest cards are prospects by created date. Appointments, shows, applications and executions are distinct prospects with that dated event in the window. Approvals, lease executions and move-ins are prospect status: every approved applicant in this data has a signed lease, so executions equal approvals, and an approval can predate the window while its move-in falls inside it. Missed followups are due before the as-of date and not completed.

Conversion here is executions over guest cards in the same window, a reporting ratio, not a longitudinal lead-to-lease probability.

Prospect ledger

most recent 30
ProspectCreatedSourceAgentInterestLast eventStatusLost reason
Susan Foster
p0002633
09/05/2026Property WebsiteShirley Gutierrez1 Bed / 1 BathEmail · 09/05Active
Kwame Castro
p0002589
09/05/2026RentCafe ILSShirley Gutierrez1 Bed / 1 BathEmail · 09/05Active
Hiro Herrera
p0002540
09/05/2026Apartments.comShirley Gutierrez1 Bed / 1 BathWeb · 09/05Active
Brian Edwards
p0002430
09/05/2026Google Business ProfileAna Richardson1 Bed / 1 BathEmail · 09/05Active
Deborah Long
p0002271
09/05/2026Property WebsiteAna Richardson1 Bed / 1 BathEmail · 09/05Active
James Hughes
p0002471
09/04/2026Property WebsiteAna Richardson2 Bed / 1 BathEmail · 09/04Active
Maria Green
p0002312
09/04/2026Google Business ProfileAna Richardson2 Bed / 1 BathEmail · 09/04Active
Sarah Sanchez
p0002616
09/03/2026Google Business ProfileRosa Patel2 Bed / 1 BathEmail · 09/05Active
Daniel Diaz
p0002563
09/03/2026Property WebsiteShirley Gutierrez1 Bed / 1 BathSMS · 09/03Active
Steven Lindqvist
p0002494
09/03/2026Google Business ProfileRosa Patel2 Bed / 1 BathEmail · 09/03Active
Priya Guzman
p0002306
09/03/2026Apartments.comAna Richardson2 Bed / 1 BathEmail · 09/04Active
Nancy Gonzalez
p0002288
09/03/2026Apartments.comRosa Patel2 Bed / 1 BathEmail · 09/04Active
Rebecca Moore
p0002637
09/02/2026Property WebsiteShirley Gutierrez2 Bed / 1 BathSMS · 09/05Active
Tariq Reed
p0002601
09/02/2026Walk-InShirley Gutierrez2 Bed / 1 BathSMS · 09/02Active
Nadia Young
p0002555
09/02/2026Google Business ProfileAna Richardson2 Bed / 1 BathSMS · 09/05Active
Mark Alvarez
p0002543
09/02/2026Apartments.comRosa Patel1 Bed / 1 BathShow · 09/04Active
Pamela Turner
p0002395
09/02/2026ZillowRosa Patel2 Bed / 1 BathSMS · 09/02Active
Carlos Anderson
p0002323
09/02/2026InstagramShirley Gutierrez2 Bed / 1 BathSMS · 09/02Active
Helen Alvarez
p0002293
09/02/2026ZillowRosa Patel1 Bed / 1 BathSMS · 09/02Active
John Nguyen
p0002289
09/02/2026Google Business ProfileRosa Patel1 Bed / 1 BathCall · 09/05Active
Ashley Allen
p0002604
09/01/2026Property WebsiteAna Richardson2 Bed / 1 BathCall · 09/05Applied
Andre Mendoza
p0002538
09/01/2026Google Business ProfileNot Assigned1 Bed / 1 BathEmail · 09/01Active
Angela Petrov
p0002525
09/01/2026Apartments.comAna Richardson1 Bed / 1 BathWeb · 09/01Active
Jennifer Jimenez
p0002378
09/01/2026Google Business ProfileAna Richardson1 Bed / 1 BathEmail · 09/01Active
Pamela Guzman
p0002368
09/01/2026Google Business ProfileRosa Patel1 Bed / 1 BathSMS · 09/01Active
Jessica Chavez
p0002257
09/01/2026Property WebsiteShirley Gutierrez1 Bed / 1 BathShow · 09/03Active
Juan Brown
p0002498
08/31/2026Google Business ProfileAna Richardson2 Bed / 1 BathEmail · 08/31Active
James Ruiz
p0002438
08/31/2026Resident ReferralRosa Patel2 Bed / 1 BathShow · 09/02Active
Angela Miller
p0002422
08/31/2026Google Business ProfileAna Richardson2 Bed / 2 BathSMS · 09/03Active
Tariq Petrov
p0002490
08/30/2026Apartments.comShirley Gutierrez1 Bed / 1 BathEmail · 08/30Active
Definitions & report reconciliation

Unlike aggregate Yardi exports, every row here carries a prospect id, so the pipeline is a matched cohort: guest cards ≥ appointments ≥ shows ≥ applications ≥ approvals ≥ move-ins holds for every property, and the verify script asserts it. Rentals by Source, Property Performance and Team Performance by Agent are all views over the same prospect and event rows, so their counts agree.

Invalid leads are dismissed inbound contacts (duplicate, hang-up, vendor) and are not prospects. Campaign counts are prospects per tracking number; a prospect belongs to exactly one campaign.