How to Audit Your Rental Lead Response Time in One Week (with a Google Sheet)
TL;DR
- Most agents and landlords guess how fast they reply to rental inquiries.
- A one-week log in Google Sheets replaces the guess with your own numbers: when leads come in, how long they wait, and which hours go unanswered.
On this page
- How to Audit Your Rental Lead Response Time in One Week (with a Google Sheet)
- Why measure before you change anything
- Step 1: Set up a simple log
- Step 2: Log every inquiry for seven days
- Step 3: Calculate the wait for each lead
- Step 4: Summarize the week
- Step 5: Find your gaps by hour and day
- Step 6: Decide what to change, then measure again
- Where Sarah AI fits
- FAQ

How to Audit Your Rental Lead Response Time in One Week (with a Google Sheet)
Ask a busy agent or landlord how fast they reply to rental inquiries and the answer is usually "pretty fast." Then you look at the texts that came in during a showing, a closing or Sunday dinner, and "pretty fast" turns into "a few hours, sometimes."
You don't need software to find out the truth. One week of honest logging in a Google Sheet tells you how long renters actually wait, which hours of the day go uncovered, and where leads quietly drop off. This guide walks through the setup, the formulas and how to read the results. Every Sheets feature mentioned links to Google's own Docs Editors Help.
Why measure before you change anything
It's tempting to jump straight to a fix: a new auto-reply, a new tool, a new rule for the team. But without a baseline you can't tell if the fix helped. A short audit gives you three things:
- Your real typical wait time, not the one you remember on a good day.
- Your gaps: the hours and days when inquiries sit the longest.
- Your drop-off point: how many leads never got a reply at all.
We've written about what happens in the first fifteen minutes of a lead and about leads that never hear back. This article is the practical step before either: finding out where you stand.
Step 1: Set up a simple log
Create a new sheet with one row per inquiry and these columns:
| Column | Example | Notes |
|---|---|---|
| Lead received | 11/9/2026 9:42 PM | Date and time the text, call or form came in |
| Source | Zillow / yard sign / website | Where the lead came from |
| Channel | Text | Text, call, email, portal message |
| First reply sent | 11/10/2026 8:15 AM | Date and time of your first real answer |
| Replied by | Me / assistant / teammate | Who sent it |
| Wait (minutes) | (formula) | Calculated in Step 3 |
| Showing booked? | Yes / No | Did this lead get a showing time? |
Keep both time columns in a true date-time format so the math works. Google's guide to formatting numbers in a spreadsheet covers how to set a column to date time. If you type entries as they happen, the Google Sheets keyboard shortcuts page lists shortcuts to insert the current date and time in a cell.
A note on "first reply": count the first message that actually answers the renter, not an automatic "thanks, we'll get back to you." We explain why in a rental auto-reply isn't an answer.
Step 2: Log every inquiry for seven days
The audit only works if it's complete. For one full week, including the weekend, add a row for every new inquiry, whatever the source. A few habits help:
- Log the received time from the message itself, not from when you noticed it.
- If a lead never got a reply, leave "First reply sent" blank. Those blanks matter.
- If several people answer leads, share the sheet so everyone logs in one place. If your inquiries come from several sites, our guide to managing rental inquiries from multiple sites helps you catch them all.
Step 3: Calculate the wait for each lead
In the "Wait (minutes)" column, subtract the received time from the reply time. In Google Sheets, date-times are stored as numbers where one day equals 1, so multiplying the difference by 1440 (the minutes in a day) gives minutes. With "Lead received" in column A and "First reply sent" in column D:
=IF(D2="", "", ROUND((D2-A2)*1440))
The IF part leaves the cell empty for leads with no reply yet, so they don't distort your averages.
Step 4: Summarize the week
Add a small summary block next to the log. Three numbers tell most of the story.
Typical wait. Use MEDIAN rather than an average, because one lead that waited all weekend can drag an average far away from what usually happens:
=MEDIAN(F2:F200)
Leads with no reply. COUNTIFS, the multi-condition version of COUNTIF, counts rows where a lead was received but the reply column is blank:
=COUNTIFS(A2:A200, "<>", D2:D200, "")
Leads that waited longer than your target. Pick a target that fits your business, for example 30 minutes, and count how many missed it with COUNTIF:
=COUNTIF(F2:F200, ">30")
Step 5: Find your gaps by hour and day
Add two helper columns to the log: the hour each lead arrived and the day of the week.
=HOUR(A2)
=TEXT(A2, "ddd")
Now sort or filter by those columns and look at the wait times. Patterns usually jump out quickly: evenings after 7 PM, Saturday mornings during showings, the hour you're always in the car. Those are the windows where a renter texting about a unit gets silence, and often texts the next listing instead. We covered two of the most common ones in rental inquiries at night and weekend rental inquiry silence.
Step 6: Decide what to change, then measure again
Once you know your gaps, the fix is usually one of three things:
- Assign coverage. Make one person clearly responsible for the first reply during each window. See who owns the first reply on a real estate team.
- Remove steps. If renters reply but don't book, the booking path may be the problem. Our piece on rental tour booking with too many steps walks through that.
- Add after-hours help. If the gaps are hours you simply can't cover yourself, consider an assistant, human or software, for those windows.
Whatever you change, run the same one-week log again a few weeks later. Comparing the two weeks with the same formulas is the only honest way to know if it worked.
Where Sarah AI fits
If your audit shows the gaps are evenings, weekends and showing hours, that's the problem Sarah AI by NextGen Fusion AI was built for. Sarah is an SMS assistant that replies to property-inquiry texts 24/7, asks your qualifying questions, matches listings from your Google Sheet and books showings on your Google Calendar, with reminders and reschedules handled by text. You can take over any conversation from the dashboard. Setup is free and the first month is $1.
Book a demo of Sarah AI and bring your audit numbers. They make the conversation much more useful.
FAQ
How long should a response-time audit run? One full week, including a weekend, is enough to see your patterns. Shorter than that and you may miss the days when replies slip the most.
Should I count automatic replies as a response? Count the first message that actually answers the renter's question. An automatic "we'll get back to you" doesn't tell them anything about the unit, so it shouldn't stop the clock.
Why use the median instead of the average? A few very long waits, like a lead that sat over a weekend, can pull the average far above what typically happens. The median shows the middle of your results, so it's closer to a renter's usual experience. Track the long waits separately with a count.
What's a good response-time target? It depends on your volume and how you work. Set a target you can actually hit in your busy windows, measure against it, and tighten it once you're meeting it consistently.
Related
Text Sarah now.
Free 2-week supervised pilot.
(844) 681-7964Sarah is AI. Reply STOP anytime.
