Use Case

One deal pipeline from first site visit to executed deal

A national multifamily real estate development company replaced scattered Excel trackers with one Airtable pipeline for land acquisition. Land Acquisition and Field Operations teams move every site through the same lifecycle stages, while broker email replies are parsed automatically and linked to the right contact and opportunity instead of retyped by hand.

The problem

Land acquisition data lived in regional Excel trackers that did not talk to each other, so the same site could be tracked differently by two analysts in two markets. Broker emails arrived by the dozen, and someone had to read each one, figure out which deal and contact it belonged to, and retype the details.

Field teams captured site conditions on their phones, but those photos and notes rarely made it back into the same record as the deal terms and pro forma. Regional inconsistency made it hard for leadership to compare pipelines or spot a stalled deal early.

What they built

Land Acquisition, Analysts, and Field Operations now run every site through one Airtable pipeline with consistent lifecycle statuses from initial evaluation to executed letter of intent and under construction. Outlook automations parse incoming broker emails and auto-link the sender and message to the correct contact and opportunity record.

The base connects to CoStar for market data, SharePoint and OneDrive for document storage, and a mobile app so field staff can attach site photos directly to the deal record they belong to, no separate folder to reconcile later.

The outcome

Deal progression moved faster because nobody waits on a spreadsheet update from another region. Analysts spend less time on manual email triage and more time evaluating sites, and pro forma history is centralized instead of buried in old file versions.

Leadership finally has one source of truth across every active site, from first evaluation through executed deal, with a consistent lifecycle status that means the same thing in every market.

Inside the solution

Land Acquisition Pipeline and Deal Tracking

Sales & CRM

  • Land deal lifecycle tracking
  • Broker email parsing and contact auto-linking
  • Bulk deal book outreach orchestration
  • Pro forma and capital stack management
  • Field site photo capture
  • Manual data entry from forwarded emails
  • Scattered deal data in regional spreadsheets
  • Difficulty matching replies to the correct contacts and opportunities
  • Inconsistent regional setups
  • Accelerated deal progression
  • Reduced manual email parsing
  • Centralized historical analysis for pro formas
  • Single source of truth across regions
  • Land Acquisition
  • Analysts
  • Field Operations
  • SharePoint
  • OneDrive
  • CoStar
  • Outlook
Build out this use case

Regional Land Acquisition Pipeline & Deal Tracking

Track every land site through one shared lifecycle (from initial evaluation to executed letter of intent and under construction) with broker contacts, parsed inbound email, versioned pro formas and mobile site captures all attached to the deal record they belong to. Regional leads get one dashboard, a kanban board and a weekly stalled-deal digest instead of comparing spreadsheets across markets.

Regional Land Acquisition Pipeline & Deal Tracking - Overview dashboard
How it works

From scattered spreadsheets to one regional pipeline

Copy the templates

Start from the investor deal flow template above, then rename deal stages to match your acquisition lifecycle from initial evaluation to executed letter of intent. Add the business development CRM structure for broker contacts.

Centralize the pipeline

Load every active site into one linked table so every region uses the same lifecycle status and every deal resolves to one owner and one record.

Automate the intake

Connect Outlook so broker replies parse automatically into the right contact and opportunity, and give field staff a mobile path to attach site photos directly to the deal.

FAQ

Frequently asked questions

Every site is a record with the same lifecycle stages, from initial evaluation through executed letter of intent to under construction, regardless of which region owns it. That consistency is what lets leadership compare pipelines across markets on one dashboard.

Outlook automations parse incoming broker emails and auto-link the sender and message content to the correct contact and opportunity record, so analysts no longer retype details from forwarded messages.

Field Operations captures photos through a mobile app, and each photo attaches directly to the deal record it documents, so site conditions and deal terms live in the same place instead of a separate folder.

Every region set up its own spreadsheet differently, which made it impossible to compare deals or spot a stalled site early. Moving to one base gave every market the same lifecycle status and the same reporting structure.

Not for the core pipeline tracking. The account uses AI on the capital markets side of the same workflow to parse investor email replies, and the deal and contact data built here is the foundation that AI workflow depends on.