The short answer
A tracker is not admin for its own sake. It stops you applying to the same role twice, tells you who is owed a follow-up, gives you the details back when a recruiter calls three weeks later, and — most usefully — shows you the stage where your applications keep dying, which is the only reliable way to know what to fix.
What matters most
- The tracker is a diagnostic tool first. It shows you whether applications are dying before the first call, at the first call, or after it.
- Record the posting text itself, not just the link. Job adverts are taken down, and you will want the wording before an interview.
- Every row needs a next action and a date, or the tracker becomes a graveyard rather than a queue.
- A spreadsheet is entirely sufficient. The tool matters far less than filling it in the same day you apply.
What the record is actually for
There are four separate jobs a tracker does, and they are worth separating because people usually build one that only does the first.
It prevents embarrassment: applying twice to the same company for the same role, or writing to a hiring manager about a position you already applied to and forgot. It supplies detail on demand, so that when a call arrives you can see in five seconds which version you sent and what the advert said. It manages the queue, telling you who is owed a follow-up this week. And it produces a pattern, which is the part people skip and the part that changes outcomes.
The fields worth having
| Field | Why it earns its column |
|---|---|
| Company and role title | Obvious, but record the exact title from the advert rather than your shorthand for it. Titles vary between companies and you will be asked which role you applied for. |
| Date applied | Drives every follow-up decision you will make. Without it you are guessing whether it has been one week or three. |
| Source | Board, company site, referral, recruiter, direct approach. Over a few dozen applications this column quietly tells you which channel is actually producing replies for you. |
| Resume version sent | Name your files properly and record which one went out. Walking into an interview unsure which claims are on the page in front of them is genuinely uncomfortable. |
| Posting text | Paste it, do not link it. Adverts are pulled the moment a role is filled, and the wording is exactly what you want the night before an interview. |
| Salary information | Whatever the advert stated, or the range you were told. It is the anchor for every later conversation and it is easy to misremember. |
| Contact | The recruiter or hiring manager name if you have one, and where you got it. This is what makes a follow-up possible at all. |
| Stage | Applied, acknowledged, screening call, first interview, final, offer, rejected, silent. The single most useful column in the sheet. |
| Next action and date | What you will do and when. A tracker without this is a list of things that happened, not a plan. |
| Notes | Anything you learned. Who you spoke to, what they emphasised, what the team is struggling with, why they said no. |
That is ten columns, which sounds heavy and takes about ninety seconds to fill in if you do it immediately after applying. Doing it later almost never happens, and a half-filled tracker is worse than none because you stop trusting it.
Reading the pattern
This is the part that justifies the whole exercise. Sort by stage and count. The stage at which applications stop tells you which part of your search is failing, and each failure has a different fix.
- Lots of applications, no acknowledgement or screening calls at all. The document or the targeting is the problem. Either the resume is not surviving the first read, or you are applying to roles where you are not a credible candidate. Both are fixable and neither is fixed by sending more.
- Screening calls happen but rarely go further. The resume is working; the pitch is not. Usually this is a mismatch between what the document promises and how you describe your work out loud, or salary and logistics surfacing late.
- First interviews happen, second ones do not. An interview problem rather than a search problem. This is worth structured practice rather than more applications — the interview prep tool is a reasonable place to start.
- Final stages that end in nothing. Frustrating and often genuinely not about you: internal candidates, budget, a stronger applicant. If it happens repeatedly, ask for feedback, and ask specifically.
- Offers you turn down. Worth logging too. If you are reaching offers and rejecting them, your targeting is off in a way that is costing you months, and comparing them properly with the offer comparison tool is a better use of an evening than another twenty applications.
Building one you will actually use
Use a spreadsheet unless you have a reason not to
A shared spreadsheet is sortable, filterable, free, works offline, and does not require you to learn anything. Dedicated job-tracking apps exist and some are pleasant, but the failure mode of a tracker is never insufficient features — it is abandonment. Choose the thing with the least friction between finishing an application and recording it.
Fill it in before you close the tab
The posting text is the reason. Once the advert is down, you cannot recover it, and the advert is the single most useful document you have when preparing for the interview. Copy the whole thing into the notes column while it is still on screen.
Give it one review slot a week
Fifteen minutes, same day each week. Clear the follow-up queue, move anything stale to silent, count the stages, and write one line about what the pattern is telling you. That fifteen minutes is what turns a log into a feedback loop.
Common ways trackers fail
- Too many columns. If a field has been blank for twenty rows, delete it. Ambition in a tracker is punished immediately.
- No dates. A tracker without a date applied and a next-action date cannot tell you anything about timing, which is half its value.
- Recording only the applications that went well. Understandable and fatal — the pattern lives in the ones that went nowhere.
- Linking rather than pasting the advert. The link will die and it will die at exactly the wrong moment.
- Never reviewing it. A log nobody reads is a diary. The weekly review is what makes it an instrument.
- Letting it become the job. Tidying the spreadsheet is not applying for work, and it is an unusually comfortable way to feel busy.
If you are early in a search and this sounds like overhead, start with four columns — company, role, date applied, stage — and add the rest when you find yourself wishing you had them. You will, usually around the twentieth application, which is roughly when memory stops being sufficient and the pattern first becomes readable.
Questions people actually ask
What should I record when I apply for a job?
At minimum the company, the exact role title from the advert, the date you applied, where you found it, which version of your resume you sent, the stage you have reached, and the next action with a date. If you can only add one more thing, make it the full text of the advert, pasted rather than linked.
Do I need a job tracking app or is a spreadsheet enough?
A spreadsheet is enough for almost everyone. Trackers fail through abandonment rather than through missing features, so the deciding factor is how little friction there is between finishing an application and recording it. Use whatever you will still be using in week six.
Why should I copy the job advert instead of saving the link?
Adverts are taken down as soon as a role is filled or pulled, and that often happens before your interview. The wording of the advert is the best single preparation document you have, so paste the text into your notes while the page is still open.
How do I know whether my resume or my interviews are the problem?
Count where applications stop. A long run of applications with no screening calls points at the resume or the targeting. Screening calls that rarely progress point at how you describe your work out loud. First interviews that never become second ones point at interview technique. The stage tells you which thing to work on.
How long should I leave an application before marking it dead?
There is no fixed point, and timelines vary enormously by employer size and sector. A practical convention is to follow up once, then mark it silent after a few more weeks and stop thinking about it. Roles do occasionally come back to life months later, so silent is a better label than closed.
