Career & Job Search · October 21, 2026
How to Track Job Applications So the Numbers Mean Something
A job search spreadsheet usually ends up as a list of companies with a status column. That answers "where is each application now?" but not the questions that change what you do next: are you getting interviews, from where, and what needs a follow-up today?
Track the furthest stage, not just the current one
When an application is rejected after an interview, changing its status to "Rejected" erases the fact that you got an interview. Count interviews from current status and your interview rate drops every time you hear no. That's backwards.
Record evidence instead: the date you applied, the date of the first reply, and each interview round on its own row. The furthest stage is then the furthest point any of that evidence reached, whatever the status says now. A recruiter screen counts as a reply, any other round counts as an interview, and a final round counts as a final round.
Define each number once
| Number | Definition |
|---|---|
| Sent | Has a date applied, or reached any stage at or past "Applied" |
| Positive reply rate | Reached a recruiter screen or further, divided by sent |
| Interview rate | Reached an interview past the screen, divided by sent |
| Days to first reply | First reply minus date applied, including rejections |
| No reply yet | Still open, no reply, and older than your threshold (21 days is reasonable) |
"Sent" includes a status check because people move an application straight to "Interview" without filling in the date. Without it, an interview rate can come out above 100%.
Make follow-ups automatic
Give every open application a follow-up date: the next action date you set, or the date you applied plus a fixed window (a week is common) if you haven't heard back. Then sort by that date. Anything overdue or due today is your list for the day; nothing depends on remembering.
In a spreadsheet that's one formula per row, for example:
=IF(NextActionDate<>"", NextActionDate, IF(AND(DateApplied<>"", FirstReply=""), DateApplied+7, ""))
Count by source
Once every application has a source (job board, referral, company site, recruiter), sum interviews per source. If one source produces most of your interviews, you want to know that three weeks in, not three months, so you can spend your time there.
Use the tracker
The Job Application Tracker does all of this in Excel or Google Sheets: furthest stage from your interviews tab, automatic follow-up dates, a no-reply flag, and a dashboard with every number above. Before you apply, the Job Fit Scorecard (in development) helps decide which jobs are worth the time.