What you need
Data sources
- Property management system — unit inventory, current occupancy status, lease start/end dates, asking rents, and concessions offered
- Market data API — comparable property rents, vacancy rates, absorption trends, and new supply pipeline
- Marketing platform — lead sources, listing views, tour conversion rates, and marketing spend by channel
Knowledge spaces
- Pricing guidelines — upload your revenue management policies, including maximum discount thresholds, concession approval rules, and seasonal adjustment factors
- Market research reports — upload quarterly market surveys, submarket analysis, and competitor positioning data
| Component | Name | Definition |
|---|---|---|
| Object | Unit | Maps to the units table in the property management system. Represents a rentable unit with type, square footage, and occupancy status |
| Object | Comparable | Maps to comparables in the market data API. Represents a competing property with rent, vacancy, and amenity data |
| Metric | Occupancy Rate | Percentage of total units that are occupied, measured at the property and portfolio level |
| Metric | Effective Rent per Square Foot | (Asking rent - concessions) / unit square footage, annualized |
| Dimension | Unit Type | Classifies units by configuration (studio, 1BR, 2BR, 3BR, commercial, retail) |
| Dimension | Market | Groups properties by submarket or MSA for benchmarking |
Agent setup
Create the agent
Go to Agent Space → New agent.
| Field | Value |
|---|---|
| Name | Portfolio Analyst |
| Role | Occupancy and Revenue Optimization Specialist |
| Goal | Analyze occupancy patterns, benchmark against market conditions, recommend pricing adjustments, and support leasing strategy decisions with data |
Set the description
You are a portfolio analyst specializing in occupancy and revenue optimization for a multi-property real estate portfolio. You analyze vacancy trends, compare asking rents against market comparables, and identify pricing opportunities at the unit and property level. You evaluate marketing channel effectiveness and recommend budget allocations based on lead conversion data. You present recommendations with supporting market data and financial projections so decision-makers can act with confidence.
Scope data access
Grant access to:
- Property management system (units, occupancy, leases, rents)
- Market data API (comparables, vacancy rates, absorption)
- Marketing platform (leads, conversions, marketing spend)
- Pricing guidelines knowledge space
- Market research reports knowledge space
- Unit and Comparable objects, Occupancy Rate and Effective Rent per Square Foot metrics
Add skills
Vacancy analysis
Vacancy analysis
Trigger: User asks about current vacancy, occupancy trends, or exposure risk.
- Query the property management system for all units with their current occupancy status and lease expiration dates.
- Calculate the current occupancy rate and project 30/60/90-day vacancy exposure from upcoming expirations.
- Identify unit types and properties with the highest vacancy concentrations.
- Compare occupancy against the market vacancy rate from the market data API.
- Return a vacancy analysis with current occupancy, projected exposure, problem areas, and market context.
Pricing recommendation
Pricing recommendation
Trigger: User asks for a pricing recommendation for a specific unit, unit type, or property.
- Retrieve the unit details and current asking rent from the property management system.
- Pull comparable rents for similar units in the submarket from the market data API.
- Load the pricing guidelines from the knowledge space, including maximum discount and seasonal factors.
- Calculate the recommended rent range based on comparables, time on market, and seasonal adjustments.
- Estimate the revenue impact of pricing at the low, mid, and high end of the range.
- Return a pricing recommendation with the suggested rent, comparable support, revenue scenarios, and the applicable guideline reference.
Marketing channel analysis
Marketing channel analysis
Trigger: User asks about marketing effectiveness or where to spend the leasing budget.
- Pull lead volume, tour conversion rate, and lease conversion rate by marketing channel from the marketing platform.
- Calculate cost per lead and cost per lease for each channel.
- Identify the highest-performing and lowest-performing channels.
- Compare channel performance by property and unit type.
- Return a channel analysis with performance rankings, cost efficiency metrics, and reallocation recommendations.
Automation
Playbook: Weekly occupancy and pricing review
Set the trigger
Set the trigger to Schedule — Weekly on Tuesday at 7:00 AM, giving leasing teams updated recommendations for the week.
Build the workflow
The workflow analyzes occupancy and pricing across the portfolio and flags units needing attention:
- Query all units from the property management system with current occupancy status, asking rent, days on market, and lease expiration schedule.
- Query the market data API for current comparable rents, submarket vacancy rates, and absorption trends.
- Python code block — compute pricing recommendations for each vacant unit. The code compares the asking rent against the weighted average of comparable rents, applies a days-on-market decay factor (suggesting a reduction for units vacant longer than 30 days), and adjusts for seasonal demand patterns. It produces a recommended rent, a confidence score, and the estimated revenue impact of the adjustment.
The pricing optimization step uses a Python code block to compute market-adjusted rent recommendations with days-on-market decay and seasonal adjustments. You can customize the comparable weighting, decay rate, and seasonal factors.
- Condition — flag any unit where the recommended rent differs from the current asking rent by more than 5%.
- Loop — for each flagged unit, generate a brief pricing rationale with comparable support.
- Delivery — distribute the weekly occupancy and pricing report.
Configure delivery
- Email — send each property manager their property’s occupancy summary, pricing recommendations, and flagged units
- Slack — post a portfolio-wide occupancy snapshot to
#leasing-opswith overall occupancy rate, week-over-week change, and the count of units with pricing flags
What’s next
Property financial reporting
Generate automated financial reports with variance analysis across your property portfolio.
All Real Estate use cases
See the full list.

