Leasing Funnel

Bayview Commons · 1010 · 07/08/2026 – 09/05/2026
60-day window
New guest cards
256
prospects created in 60 days
Lease executions
20
approved applicants with a signed lease
Conversion
7.8%
20 executions / 256 guest cards
Missed followups
144
15.0% of 962 due
Follow-up is the clearest operational issue.144 missed followups, 118 of them on John Mitchell; unresponsive is the leading lost reason.Review workload

Leasing pipeline

last 60 days · matched prospect cohort
New guest cards256
Appointments98
Shows82
Applications35
Approvals20
Lease executions20
Move-ins15
0256 prospects
63Calls
186Web leads
7Walk-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. 1,882 activity-register events in the window.

Why prospects did not rent

138 lost in the window
Prospect Unresponsive97
Insufficient Income9
Unsure of Move-in Date6
Applicant Ungrouping5
Other reasons21

97 of 138 (70.3%) are unresponsive. 14 applications were denied.

Campaign lead volume

prospects per tracking number · top eight
Property Website · 866856630239 / 0
Property Website · 844225681938 / 1
Property Website · 833644282736 / 1
Google Business Profile · 866799713131 / 1
Apartments.com · 866930906125 / 1
Google Business Profile · 833508441123 / 2
RentCafe ILS · 855353275015 / 0
Zillow · 833316822710 / 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
Property Website11321.8%
Google Business Profile5435.6%
Apartments.com2514.0%
Zillow1900.0%
RentCafe ILS1500.0%
Instagram700.0%
Facebook600.0%
Resident Referral600.0%
Walk-In600.0%
Signage300.0%
Craigslist100.0%
Reply Email100.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

94 invalid leads · 26.9% of raw inbound
Duplicate42
Hang-up34
Vendor Call10
Spam6
Wrong Number2

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

Agent workload

prospects assigned in the window · followups due to date
AgentProspectsAppointmentsShowsRentalsFollowupsCompletedMissed
John Mitchell11538312460342118
Carolyn Chavez611915121720710
Pamela Roberts592622221520510
Property Website system977129281
ILS system764027225
Not Assigned system500014140

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 Bath1314132.3%
2 Bed / 2 Bath882522.3%
2 Bed / 2 Bath Furnished19700.0%
1 Bed / 1 Bath Furnished18615.6%

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
Karen King
p0000371
09/05/2026Google Business ProfilePamela Roberts2 Bed / 2 BathSMS · 09/05Active
Kwame Young
p0000370
09/05/2026Property WebsiteJohn Mitchell2 Bed / 2 BathWeb · 09/05Active
Rachel Reyes
p0000191
09/05/2026Google Business ProfileCarolyn Chavez1 Bed / 1 Bath FurnishedCall · 09/05Active
Omar Ruiz
p0000274
09/04/2026Reply EmailCarolyn Chavez1 Bed / 1 BathEmail · 09/04Active
Rafael Adams
p0000256
09/04/2026Apartments.comJohn Mitchell1 Bed / 1 BathEmail · 09/04Active
Jorge Evans
p0000165
09/04/2026Google Business ProfileJohn Mitchell1 Bed / 1 BathEmail · 09/04Active
Dmitri Roberts
p0000146
09/04/2026Property WebsitePamela Roberts2 Bed / 2 BathAppointment · 09/05Active
Amy Adams
p0000097
09/04/2026Property WebsiteJohn Mitchell2 Bed / 2 BathEmail · 09/04Active
Robert Fernandez
p0000079
09/04/2026Property WebsiteCarolyn Chavez1 Bed / 1 BathSMS · 09/04Active
Hiro Wilson
p0000355
09/03/2026Property WebsiteCarolyn Chavez1 Bed / 1 BathEmail · 09/03Active
Eric Reyes
p0000351
09/03/2026Google Business ProfileProperty Website1 Bed / 1 BathCall · 09/04Active
Michael Taylor
p0000260
09/03/2026Property WebsitePamela Roberts1 Bed / 1 BathSMS · 09/05Active
Mark Davis
p0000240
09/03/2026ZillowJohn Mitchell1 Bed / 1 BathEmail · 09/03Active
Rachel Patel
p0000154
09/03/2026Apartments.comPamela Roberts2 Bed / 2 BathSMS · 09/03Active
Daniel Delgado
p0000101
09/03/2026RentCafe ILSPamela Roberts2 Bed / 2 BathSMS · 09/04Active
Susan Smith
p0000322
09/02/2026Property WebsiteJohn Mitchell1 Bed / 1 BathSMS · 09/05Active
Valentina Chavez
p0000205
09/02/2026FacebookJohn Mitchell1 Bed / 1 BathWeb · 09/02Active
Thomas Hall
p0000192
09/02/2026Property WebsitePamela Roberts1 Bed / 1 BathSMS · 09/05Active
Maria Silva
p0000114
09/02/2026Property WebsitePamela Roberts1 Bed / 1 BathEmail · 09/02Active
Maria King
p0000111
09/02/2026Resident ReferralCarolyn Chavez2 Bed / 2 BathCall · 09/02Active
James Ruiz
p0000375
09/01/2026Google Business ProfileCarolyn Chavez1 Bed / 1 BathCall · 09/01Active
Kathleen Evans
p0000340
09/01/2026Property WebsitePamela Roberts1 Bed / 1 BathSMS · 09/01Active
Juan Morales
p0000333
09/01/2026Property WebsitePamela Roberts2 Bed / 2 BathCall · 09/01Active
Sofia Flores
p0000299
09/01/2026Google Business ProfileCarolyn Chavez1 Bed / 1 BathEmail · 09/01Active
Olivia Fernandez
p0000281
09/01/2026Apartments.comPamela Roberts2 Bed / 2 Bath FurnishedWeb · 09/01Active
Fatima Okafor
p0000222
09/01/2026Google Business ProfilePamela Roberts2 Bed / 2 BathSMS · 09/01Active
Barbara Wright
p0000041
09/01/2026Property WebsiteJohn Mitchell1 Bed / 1 BathEmail · 09/01Active
Miguel Mendoza
p0000026
09/01/2026Google Business ProfilePamela Roberts1 Bed / 1 BathAppointment · 09/02Active
Tariq Anderson
p0000022
08/31/2026ZillowCarolyn Chavez1 Bed / 1 Bath FurnishedSMS · 08/31Active
Carlos Davis
p0000087
08/30/2026ZillowPamela Roberts2 Bed / 2 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.