Chicago office broker builds Claude+Airtable scoring system to predict tenant expansion across 9,000 companies

TheRoflTractor · reddit · 2026-11-12

A Chicago office-leasing broker shares an AI lead-gen system: architecture planned in ChatGPT, built as a Claude Project writing scores into Airtable, scoring 9,000 office tenants to spot companies about to need more space.

Key lesson: total headcount misleads. His first high-scoring account showed 640 employees on Sales Nav growing fast — but only 11 were in Chicago; all growth was elsewhere. Converting headcount at 120-170 sq ft per person, 11 vs 640 is the difference between a small suite and several floors. Since companies expand, contract, or sublease before lease expiry, city-level headcount change is the real leading signal. He asks how to get historic headcount by city across 9,000 companies at scale.

Original post →

More from coding & agent

coding & agent channel →