The One-Week Tracker
Run the Kit for One Week.
You have the kit. This is the spreadsheet that makes it run.
Add one row for every new inquiry. At the end of the week it shows you the gap that matters: how long your real replies actually took.
Free. A single spreadsheet. No sign-up and nothing to send back.
How it works
Three steps. That is the whole job.
Download the tracker
One spreadsheet. Open it in Excel, Numbers, or Google Sheets. It comes ready to fill, with the columns and the working already set up.
Add one row per inquiry
Every new lead gets its own row, all week long. Seven columns, nothing more. The sheet works out the last column for you.
Open the Scorecard
It reads your rows and counts your week: replies inside the standard, bookings, and the leads you lost.
The seven columns
What one row looks like
Seven columns, and one more the sheet fills in for you.
| Arrived | Source | Urgency | Owner | Acknowledged | First real reply | Outcome | Gap |
|---|---|---|---|---|---|---|---|
| Mon 7:42 AM | Google Ads | Routine | Dana | 7:42 AM | Mon 7:46 AM | Booked | 4 min |
| Mon 11:15 AM | Website form | Routine | Mike | 11:15 AM | Mon 11:21 AM | Booked | 6 min |
| Tue 2:17 PM | Angi | Routine | Mike | 2:17 PM | Wed 9:10 AM | Lost | 1,133 min |
- Source
- Google Ads
- Urgency
- Routine
- Owner
- Dana
- Acknowledged
- 7:42 AM
- First real reply
- Mon 7:46 AM
- Source
- Website form
- Urgency
- Routine
- Owner
- Mike
- Acknowledged
- 11:15 AM
- First real reply
- Mon 11:21 AM
- Source
- Angi
- Urgency
- Routine
- Owner
- Mike
- Acknowledged
- 2:17 PM
- First real reply
- Wed 9:10 AM
The Gap column is the only one you do not type. It is worked out from the two times you enter.
The date and time the inquiry came in.
Phone, web form, text, DM, Google, referral, Angi, or wherever.
Emergency, urgent, or routine.
The one named person responsible for the reply.
The time the automatic or manual receipt went out.
The time of the first call, personal text, or personal email.
Booked, lost, or no contact.
Filled in for you. First real reply minus Arrived, in minutes.
How to read it
The one number that matters
The gap that matters is First real reply minus Arrived. That number is the truth.
Same lead, two different gaps
Sample numbers.
Looks great. It is nearly zero whenever automation is working.
The truth. Nobody answered this lead for almost a day.
An automatic acknowledgment is not a real reply. It is a receipt. The tracker records both times, so a fast receipt can never sit quietly on top of a lead that nobody answered.
What it measures against
The standard the tracker uses
This is our standard, not a figure from somewhere else. These are our own default numbers: what we hold ourselves to, and what we teach.
Your sheet starts on Monday to Friday, 7:00 a.m. to 5:00 p.m. If your hours differ, change the two cells at the top of the Scorecard sheet and everything updates.
Ready? Run your own week.
Download it, fill it in for one week, and let your own numbers do the talking.
Open it in Excel, Numbers, or Google Sheets.