What Should You Do When a Leasing Report Has Missing Data?

A missing number is not a zero. Mark it as unavailable, find out why it is missing, and keep it out of any total or comparison until you can verify it.

That sounds basic. It is also the difference between a report that shows what you know and a report that quietly turns a gap into a conclusion. The UK Government Data Quality Framework treats documentation of data limitations as part of data-quality practice. Source

What should you do first?

Freeze the interpretation before you repair the report. Do not fill an empty cell with zero, an estimate, or the prior period just to make a dashboard complete.

Add a clear status next to the missing field:

• Not collected: The source never captured the value.
• Not connected: The source exists but does not reach the report.
• Delayed: The source may arrive later.
• Unknown: You cannot yet tell which of those is true.

Those labels give the leasing manager and the person preparing the report the same starting point. A blank cell does not.

Is the data missing from the source or only from the report?

Check the original system before changing the report. A blank value on a report can come from a missing source record, a broken connection, a filter, a date setting, or a matching problem between two systems.

Work through the path in order:

1. Open the source record for the same reporting period.
2. Confirm the property, unit, channel, and date settings match the report.
3. Check whether the source field has a value.
4. Check whether the report includes that field and source.
5. Record the owner of the next check and the date it is due.

If the source does not have the value, the report cannot create it honestly. The next task is to decide whether the team needs to begin collecting it.

How should you show the gap in the leasing report?

Show the gap where it affects the decision. Do not hide it in a footnote after a total that depends on it.

Use a plain note such as: “Tour-to-application rate: unavailable. The tour source is not connected for this period.” That wording states what is known and what is not known. It does not imply that no tours occurred or that the rate was zero.

Keep three things separate:

• Observed values: numbers verified in the source.
• Unavailable values: numbers the report cannot currently support.
• Estimates: numbers calculated from an explicit method and labeled as estimates.

Do not combine those categories in one total. If a summary needs a total, label it as partial and name what it excludes.

When can you make a leasing decision anyway?

Make the decision only on the portion of the report you can support. Postpone a decision that depends on the missing field, or choose a smaller decision that does not.

For example, a team may be able to review verified application volume while it waits for a missing tour source. It should not claim a tour-to-application conversion rate without both parts of that calculation.

Google Analytics documents that reporting data can be subject to freshness windows and privacy thresholds. Those are different causes of incomplete reporting, but both require the reader to treat an absent value as a reporting limitation instead of a measured zero. Data freshness and data thresholds are useful examples of documentation worth checking when an analytics source is involved.

What should the report owner fix next?

Give one person a small, named next action. “Fix the data” is too broad to verify.

A useful follow-up note includes:

• The missing field.
• The report and reporting period affected.
• The suspected source of the gap.
• The person checking it.
• The next check date.
• The current decision limit.

For example: “Lead source is unavailable for this month. Leasing operations will confirm the source mapping before the next weekly report. Do not compare channel conversion until then.”

This turns a vague concern into work that can be closed or escalated.

What should a good leasing report say when it cannot answer a question?

A good leasing report says “unavailable” when the evidence is unavailable. It does not pretend certainty because the page has a blank space to fill.

That habit also makes later reporting easier to trust. The team can see whether a number is missing because collection needs to change, a connection needs repair, or a report needs a different definition.

If the missing value concerns what happens after a tour, start with the process itself. Our guide on what should happen after an apartment tour can help define the handoffs worth measuring. If the same gap keeps returning because the team relies on a spreadsheet or a manual merge, the issue may be a small internal system rather than a one-time cleanup. See internal tools for small teams.

A five-minute checklist for the next report

Before you send a leasing report with a blank field, ask:

• Is the value missing, delayed, not connected, or unknown?
• Did I check the original source for the same period and filters?
• Does any total or rate silently treat the gap as zero?
• Does the report state what decision the gap limits?
• Is one person assigned to the next check?

A report can be incomplete and still be useful. It becomes risky when it hides what it does not know.