How to audit missed calls in your call log in 30 minutes
By Antony Boguslavskiy · · 7 min read
The short answer
To audit missed calls, pull two to four weeks of your call log, tally the missed ones by hour and weekday, and split numbers you don’t recognize from known customers. Multiply the weekly count of missed new callers by your own share of real prospects, close rate and job value. It takes about 30 minutes and gives you a number that is actually yours.
How many calls did your business miss last Tuesday? Most owners can’t say, and that is not a criticism: nobody counts what didn’t happen. But the answer is sitting in your call log right now, and it takes about half an hour to turn it into something useful.
This is a worksheet for how to audit missed calls without any special software. You pull the log, tally it on paper or in a spreadsheet, and finish with three things: when you miss calls, who you are missing, and roughly what that is worth per month, using your own numbers instead of an industry average.
Where to find your call log (carrier, mobile, VoIP)
Your call log lives wherever your business number lives: on the phone itself, in your carrier’s online account, or in your phone system’s admin portal. Pull at least two weeks, and four if you can, so one slow or chaotic week doesn’t distort the picture.
| Your business line is | Where to look | What you get |
|---|---|---|
| A mobile phone | The phone’s Recents or Call history, filtered to missed calls | Quick, but may only go back a limited time and rarely exports |
| A mobile on a business plan | Your carrier’s online account or app, under usage or call details | Dates, times and numbers; sometimes downloadable |
| A landline (cable or phone company) | The online account, or call detail on your bill | Often outgoing and long-distance only; ask the carrier if incoming calls are listed |
| A VoIP or cloud phone system | The admin portal’s call history or call reports | Usually the best: missed, answered and voicemail, exportable to a spreadsheet |
| Google Voice | Call history on the web or app | Dates, times, numbers and voicemails |
If your log doesn’t show missed calls separately, look for calls marked with no duration, or for voicemails. If it only goes back a few days, start keeping screenshots daily for two weeks. That is slower but works on any phone.
How to audit missed calls: the 30-minute tally by hour, weekday and caller
The tally answers two questions: when you miss calls, and whether the missed callers were new. Set a timer, open a spreadsheet or grab a sheet of paper, and work through the log once, top to bottom.
Step 1: draw the grid (2 minutes)
Make a grid with your opening hours down the side and the days across the top. Add a row for “before opening” and one for “after closing,” because those often matter most.
| Hour | Mon | Tue | Wed | Thu | Fri | Sat | Sun |
|---|---|---|---|---|---|---|---|
| Before opening | |||||||
| 8 to 9 | |||||||
| 9 to 10 | |||||||
| … one row per hour … | |||||||
| After closing |
Step 2: mark every missed call (15 minutes)
For each missed call in the log, put a mark in the right box. Use two symbols:
- N for a number you don’t recognize, which is probably a new customer.
- K for a known number: an existing customer, a supplier, a family member.
Skip numbers you know are spam, and note how many you skipped. If the same unknown number called three times in 20 minutes, mark it once and circle it; repeat calls usually mean urgency.
Step 3: total it up (5 minutes)
Add up each row and each column, then fill in this summary:
| Your number | |
|---|---|
| Weeks in the log | |
| Missed calls, total | |
| Missed calls from new numbers (N) | |
| Missed new callers per week (N ÷ weeks) | |
| Busiest missed hour | |
| Busiest missed day | |
| Unknown numbers that called back more than once | |
| Missed calls that left a voicemail, if you can tell |
Step 4: spot-check five (8 minutes)
Pick five N numbers at random and look them up: search the number, check your CRM or past invoices, or listen to the voicemail if there is one. Write down what each one wanted. This keeps you honest about how many unknown numbers were really prospects.
Turning the tally into a monthly figure with your own numbers
A rough monthly value comes from five numbers, and you supply all of them: missed new callers per week, the share who were real prospects, your close rate, your average job value, and 4.3 weeks per month. Multiply them together. The point is not precision; it is replacing a hunch with a figure you can test.
| Line | What it is | Your number |
|---|---|---|
| A | Missed new callers per week (from the tally) | |
| B | Share who were real prospects (from your spot-check, e.g. 3 of 5 = 0.6) | |
| C | Your close rate on prospects who do reach you (e.g. 0.4) | |
| D | Average value of a job or new customer | |
| E | A × B × C × D × 4.3 = rough monthly value of missed new callers |
A worked example with made-up numbers. Say a landscaping company finds 9 missed new callers a week. The spot-check suggests 3 in 5 were real prospects (0.6). It usually wins 4 in 10 prospects who reach it (0.4). An average job is $600. That is 9 × 0.6 × 0.4 × $600 × 4.3, or about $5,570 a month in work that might have been won. Your figures will be different, possibly very different. Use yours.
Two cautions. Not every missed caller is lost: some call back or leave a message you return in time. And existing customers (the K marks) have value too, even if they are more patient. For the step after this, deciding whether answering those calls is worth paying for, use our AI receptionist break-even worksheet.
Patterns that point to a fix
The grid usually shows a shape, and the shape suggests the fix. Missed calls are rarely spread evenly. They bunch at predictable times, which means you can often fix most of them without covering every hour.
| What your grid shows | Likely cause | Fixes to consider |
|---|---|---|
| A cluster at opening time | Everyone calls when you open; the line is busy | A second line, a callback queue, or overflow answering for the first hour |
| A cluster at lunch | Nobody covers the desk | Stagger breaks, or forward only during lunch |
| Evenings and weekends | You are closed | After-hours answering, or a voicemail promising a specific callback time |
| Spread across the working day | Everyone is on jobs or with clients | Ring-first forwarding, so calls you can’t take go to someone who can |
| One day stands out | A recurring meeting, a delivery day, a short-staffed shift | Fix the schedule before buying anything |
| Lots of repeat unknown numbers | Urgent callers trying again | Prioritize those; consider an answering option that handles urgent calls |
For a broader look at where missed callers go and what voicemail does and doesn’t catch, see what happens to the calls your business misses.
What to do with the result
Pick one fix for your biggest cluster, run it for two weeks, and run the same tally again. If the number of missed new callers dropped, keep it. If not, try the next fix. Repeating the audit is what turns it from a one-off scare into a habit.
A few practical next steps, depending on your result:
- Under a handful of missed new callers a week, all during business hours: a schedule change or a second person at peak times may be enough.
- Mostly after hours: an after-hours answering option, or a clear voicemail with a callback time, covers most of it.
- All day, every day: you probably need every call answered when you can’t, by a person, a service or an AI.
If you try an AI answering service, the audit becomes easier to repeat. Vocenya, for example, lists every call on the Calls page with a summary and transcript, and can alert you to missed calls and send a summary after each call by email or app notification; the call summaries and notifications guide shows the options. You can forward only after-hours calls first if that is where your cluster is.
Run the tally this week, before you buy anything. If the result points toward answering more calls, compare plans and the 14-day free trial on the pricing page.