Measure median first response time, unanswered leads and after-hours coverage from your own lead timestamps. Free, with a sample to try.
Paste or choose a CSV with one row per lead and two columns: received_at and first_reply_at. Leave the reply blank if nobody answered. Your data stays on this device.
After hours means outside Monday to Friday, 9 am to 5 pm, in the time zone on each received timestamp.
Take a recent batch and compare when each lead arrived with when someone first replied. Look at the median response time, the unanswered leads and the ones that arrived after hours. Pick one gap to fix before you buy more leads.
Three Facebook lead examples · worked example
Pick one source, such as Facebook Lead Ads, and one date range. Put the lead arrival time in received_at. Add the first team reply time in first_reply_at, or leave it blank if the lead is still waiting.
Use the full date, time and offset from UTC. The offset lets the tool compare real elapsed time and still tell whether the lead arrived outside local working hours.
The sample has two replies in 10 and 30 minutes. Its median is 20 minutes. The Friday evening lead is still waiting, so it counts under both unanswered and after hours.
Open this example in your spreadsheet. The first line is the header.
Scroll across the practice sheet to see every column.
| received_at | first_reply_at |
|---|---|
| 2026-11-05T10:00:00-05:00 | 2026-11-05T10:10:00-05:00 |
| 2026-11-06T14:00:00-05:00 | 2026-11-06T14:30:00-05:00 |
| 2026-11-06T18:30:00-05:00 | blank |
received_at,first_reply_at
2026-11-05T10:00:00-05:00,2026-11-05T10:10:00-05:00
2026-11-06T14:00:00-05:00,2026-11-06T14:30:00-05:00
2026-11-06T18:30:00-05:00,Use the time the lead first reached you from a form, ad or inbox. For the reply, use the first time a person actually replied or called, depending on what your team agreed to measure. A note that someone was assigned the lead is a different event.
Put the times in two columns with the exact headers shown above. One lead goes on each row. Leave the second cell blank for an unanswered lead. Names, numbers and messages can stay in the original export. The audit only needs the two times.
Use a local timestamp and its actual offset for the date in question. For example, the sample’s −05:00 offset matches New York in November. If your export is in UTC, convert arrival times to the local offset first if you want the after-hours results to match your team’s clock.
First response time is the time from arrival to the first reply. The median is the middle wait among replied leads after sorting them. With an even number of replies, the tool averages the two middle waits. A lead that is still waiting counts as unanswered and stays out of the median.
After hours means outside 9 am to 5 pm, Monday to Friday, using the local time in the arrival timestamp. Look at the unanswered count beside the median. Ten quick replies can look great while three weekend leads are still wondering if anyone saw their form.
Start with the oldest unanswered lead. Then run the same check for a second week using the same definition of a first reply. If Friday evening keeps coming up, give someone that shift or agree when the team will call back.
Pick one of the slow sources you found. Send a test enquiry through it, check who gets it and ask that person to plan a callback. Then use the same audit again after your next batch.
Use Kibi CRM to assign the next enquiry and save the callback on the same record. Start with the leads still waiting. If you use several sources, audit each one separately.
See how Kibi assigns new leads →14-day trial · No card needed
If you want to measure how fast a salesperson gets back to someone, use the first human reply or call. Keep automatic confirmations separate. Use the same rule for each row so the comparison is meaningful.
Check that the row has exactly two cells and a valid received timestamp with a time zone. A reply may be blank. If you enter a reply, it must have a valid timestamp and cannot be earlier than the arrival.
Kibi CRM can put connected leads into a shared enquiry list. Use lead assignment to give a teammate responsibility, then save a callback so it shows up in Today. Automatic routing rules are available on Team and Growth.
With your permission, Google Analytics measures visits and clicks so we can improve this site. It uses cookies. No advertising tracking or form contents. Cookie details
Your browser’s privacy signal is on. Optional analytics stays off.