Home/Case Studies/Downtown Office Leasing Team
ShippedDowntown Office Leasing Team  ·  Commercial Real Estate

Prospect Contact Database for Expiring Lease Rollover

A master prospect database of 166 tenants, verified, contact-enriched, and outreach-ready, built overnight. Previously months of work.

166
Tenants Verified and Contact-Enriched Overnight
Months → Hrs
Research Work Compressed
100%
Prospects with Tailored Value Props

The Challenge

A Downtown San Diego office leasing team tracked 166 tenants whose leases were rolling over in the next 24 months. Every prospect required the same work: verify the tenant was still at the listed address (Google, their website, CoStar's tenant stack), identify the right decision-makers based on company size (CEO for small companies, CFO plus CEO for mid, CFO plus COO plus regional lead for large), pull their business emails and direct phone numbers from ZoomInfo while excluding personal and headquarters numbers, and draft a tailored value proposition for each prospect based on the lease expiry window and their square footage. Done by hand, the work would swallow months.

The Approach

The solution is a two-phase pipeline. Phase one verifies each tenant through a three-source cross-check and color-codes the results. Phase two enriches every verified tenant with the right decision-maker contacts, applying the team's contact targeting tiers based on employee count, keeping only business emails and direct phones, then generates a tailored value proposition using the lease expiry window and square footage. The enriched record is written to the Contacts sheet. The pipeline is resilient: it auto-resumes on interruption and re-authenticates when sessions expire. The team wakes up to a complete prospect stack with outreach-ready language.

Work Products

Tenant VerificationZoomInfo LookupContact TargetingValue Prop GenerationMaster Contact Database

Stack

OpenAI and Anthropic (verification and value prop drafting)ZoomInfo API plus browser automation (enrichment)Playwright (CoStar plus website checks)

Next Step

Have a Pipeline Like This? Let's Build It.

Every engagement starts with a no-cost briefing. Bring one deliverable your team runs every week and we'll map it end-to-end.

Apply to Work With Us All Case Studies