How a 4,600-Unit Multifamily Operator Built a Leasing Velocity Dashboard in Power BI

For multifamily operators looking to build an AppFolio Power BI integration, getting accurate leasing data is harder than it looks. This is the story of a 4,600-unit owner-operator who had no automated way to track new leases signed each week — and how RentViewer solved it in days. If your CEO is asking questions your reports can’t answer, this case study is for you.

Executive Summary

• Who: A value-add multifamily owner-operator managing 4,626 units across 48 communities, using AppFolio
• The problem: Leadership had no reliable, automated way to track how many new leases were being signed each week — the CEO’s single most important performance metric
• The previous approach: The VP of Corporate Strategy manually searched email for countersigned lease alerts and counted them by hand — a process that took 4+ hours and only happened when someone specifically asked
• The gap: AppFolio’s application reports couldn’t distinguish signed leases from applications, and couldn’t separate new leases from renewals — making the data both incomplete and misleading
• The solution: RentViewer identified AppFolio’s Lease History report (which includes a countersigned date), then used Rent Roll data to filter out renewals by comparing Move-In Dates to Lease Start Dates
• The result: The operator now has an automated, always-current leasing velocity metric on their CEO-level Power BI dashboard
• Broader context: This metric sits alongside occupancy, collections, NOI, and staffing data as part of a complete executive performance view
• Time to build: Days, not weeks — from data identification to working dashboard tile

The Business Problem

When a CEO identifies a single metric as more important than anything else his team tracks, that metric needs to be accurate and available. It can’t depend on someone spending half a workday pulling it together.

For this operator, weekly leasing velocity — the number of new leases signed each week — was that metric. It’s the clearest leading indicator of revenue health for any multifamily portfolio. If lease signings slow down, occupancy drops in 30 to 60 days. If the team counts renewals as new leases, leadership makes decisions based on a number that doesn’t reflect actual market demand.

The problem wasn’t effort or motivation. The right data simply didn’t exist in an accessible, usable form. The workaround in place couldn’t scale across 48 communities.

The “Before” Reality

The VP of Corporate Strategy — who was also functioning as the organization’s data analyst — had no automated report to turn to when someone asked how many leases had been signed recently.

The process looked like this: open email, search for countersigned lease notification alerts from AppFolio, count them manually, report the number. Start to finish: at least four hours. And because it took so much time, the team tracked it on no regular basis. The CEO was asking for a metric nobody was measuring.

At scale — 48 communities, 4,600+ units — that kind of manual process breaks down fast. It doesn’t repeat reliably. It doesn’t audit cleanly. And it can’t go on a dashboard.

Why Existing Tools Weren’t Enough

The team had already tried using AppFolio’s application reports to get at this data. On the surface, that seems logical. But applications and signed leases are not the same thing. An application can be withdrawn, denied, or abandoned. That report can’t tell you which applications converted to executed leases — or when.

The deeper problem was separating new leases from renewals. A portfolio of 4,600 units generates a significant number of renewal signings every week alongside true new move-ins. Including renewals in a “leases signed” count inflates the number and misleads leadership. The metric overstates actual new demand — exactly the kind of bad data that drives poor decisions.

No single existing report in AppFolio solved both problems at the same time.

The Solution

The foundation of this AppFolio Power BI integration for multifamily operators is two reports used together.

Finding the Right AppFolio Reports

AppFolio Lease History Report This report includes a countersigned date — the actual date an executed lease was signed by all parties. This is the right timestamp for measuring leasing velocity. It answers the question your CEO is actually asking: on what date was this lease locked in?

Filtering Out Renewals

To exclude renewals, RentViewer pulled in the Rent Roll report and compared two fields for each record: the tenant’s original Move-In Date and their current Lease Start Date. The logic is straightforward — if a tenant moved in before their current lease started, they were already a resident when that lease was written. That’s a renewal. If the Move-In Date matches or follows the Lease Start Date, it’s a new lease.

What the CEO Sees Now

With both reports connected and the renewal filter applied, the dashboard now surfaces a clean, defensible leasing velocity metric every week. The CEO sees it in context alongside occupancy, collections, NOI, and staffing data — with no manual work required.

The Results

With a working AppFolio Power BI integration in place, the operator’s leasing velocity metric went from a 4-hour manual task to an always-current dashboard tile.

A 4-hour manual process is now automated. A metric that previously required hours of email searching — and was only tracked when someone specifically requested it — is now an always-current dashboard tile available every week without any staff time.

The number is now accurate. By isolating new leases from renewals using Move-In Date vs. Lease Start Date logic, the leasing velocity figure now reflects actual new demand. The inflated blended count that misled leadership is gone.

The CEO’s most important metric finally has a reliable home. The dashboard now surfaces weekly leasing velocity automatically, in context, alongside the other KPIs the executive team reviews. For the first time, leadership can act on it in real time rather than waiting for someone to pull it together.

The infrastructure scales. With 48 communities and 4,600+ units, manual tracking was never a long-term option. The data foundation now in place supports consistent monitoring across all 48 communities, every week. No additional headcount required.

When the CEO says a metric is the most important thing you’re tracking, the answer can’t live in someone’s inbox — it needs to live on a dashboard, and it needs to be right.

Q&A

Why can’t we just use our application reports to track lease signings? Application reports show who applied for a unit — not who signed a lease. An application can be withdrawn, denied, or abandoned before it ever becomes an executed agreement. To track leasing velocity accurately, you need a report that captures the countersigned date: the moment a lease was legally finalized by all parties. In AppFolio, that is the Lease History report.

Why does it matter whether we include renewals in the count? New leases and renewals represent fundamentally different business activity. New leases reflect market demand — they tell you whether your leasing team is converting prospects and whether your units are competitive. Renewals reflect retention. Blending them into a single number hides both signals. If your CEO wants to know whether the portfolio is growing, new leases need to be tracked on their own.

How do you filter out renewals when there’s no renewal flag in the data? Compare each tenant’s original Move-In Date to their current Lease Start Date. If they moved in before the current lease started, they were already a resident when that lease was written — that’s a renewal. If the Move-In Date matches or follows the Lease Start Date, it’s a new lease. This logic works consistently across AppFolio data and doesn’t require any custom fields.

How long does it take to set this up? Identifying the right AppFolio reports, connecting them to a data foundation, and applying the renewal filter logic can typically be completed in days, not weeks. The Power BI dashboard is then built on top of clean, trusted data — not a workaround.

What other metrics belong on an executive leasing dashboard? Leasing velocity is a leading indicator — it shows what’s coming. To give it full context, it should sit alongside lagging and operational metrics: occupancy rate, collections performance, NOI by property, and staffing levels. Together, those five views give leadership a complete picture of portfolio health without switching between systems or waiting on reports.

Ready to stop counting leases in your inbox?

If your CEO is asking questions your reports can’t answer, the problem isn’t the question — it’s the data. builds AppFolio Power BI integrations for multifamily owner-operators need to run the portfolio on live numbers — not last week’s export.