How to Track Job Applications Effectively (And Why Most People Do It Wrong)

A recruiter rings on a Thursday afternoon about a role you applied for three weeks ago. You cannot remember which company she is calling from, which of your four CV versions she has in front of her, or what the salary in the advert was. The advert itself is gone: the posting came down when the closing date passed.

That call is the whole argument for tracking. Not neatness, and not the satisfying feeling of a filled-in spreadsheet. Two specific things: being able to answer the phone properly, and being able to count what your applications are actually doing.

This article gives you the fields, what each one is for, and what to do with the numbers once you have twenty applications in the sheet.

Your Record Outlives the Employer's

People assume the employer is keeping all this, so why should they. The employer is not. The ICO's guidance on keeping recruitment records says employers should not keep recruitment records for unsuccessful candidates beyond the statutory period in which an applicant can bring a claim. The advert comes down sooner than that, usually on the closing date.

You do have a right to ask what an employer holds about you. The ICO's guide to getting copies of your information says you can ask an organisation for the information it holds about you, that it helps to put "subject access request" in the subject line, and that organisations usually have one month to respond. That is a real option after an interview that went strangely. It works only if you can say which role, which date and which person, which is exactly what a tracker holds.

One thing to be sensible about: your tracker contains other people's names and email addresses as well as your own history. Keep it in your own account rather than a shared drive at your current job, and do not publish it.

The Fourteen Fields

One row per application. A spreadsheet is fine; the fields are what matter, and most published templates are missing the three that do the work.

The three most templates leave out are advert saved, met every essential criterion and follow-up due. The first is the one you regret the week before an interview, when the job description you were going to prepare against has been taken down. The second turns a pile of rejections into a diagnosis. The third turns a log into something that tells you what to do on Thursday morning.

Logging a Row Takes Ninety Seconds

Do it as you press send, not on Friday. By Friday the advert may be gone, and you will be guessing at which CV you attached.

The order that works: save the advert first, since that is the part with a deadline on it. Then paste in the company, title, source and CV file name. Then the two judgement fields, closing date and essential criteria, while the advert is still in front of you. Then the follow-up date. The notes column can wait until something happens.

Update the stage the moment anything moves, and write the notes on the day of a call. A screening conversation you write up two days later loses the detail that was worth keeping: the salary they quoted, the question you fumbled, the name of the person who will interview you.

What the Numbers Say After Twenty Applications

Twenty of the same kind, plus two weeks for replies to arrive, is roughly where a pattern becomes readable. Below that, a single good week swings every percentage and you will end up changing the wrong thing.

Then do two counts, not one total. Count replies from a human by source, and count them by whether you met every essential criterion. Those two splits carry nearly all the information in the sheet:

• One source produces almost all the human replies — move next week's hours to it, and stop treating the quiet source as a numbers game that will come good.
• Replies appear only where you met every essential criterion — targeting, not the CV. Narrow the titles you apply for.
• Nothing from any source, referrals included — look at the CV itself.
• Replies but few interviews — something at the screening stage: salary, location, notice period, or how you describe the work on a call. Your notes column should show the pattern.

The full version of that diagnostic, worked through with example numbers, is in the job search strategy guide. Change one thing at a time afterwards, give it another twenty applications, and you will know which change did it. Change three at once and a better fortnight tells you nothing.

Two cautions when you read the sheet. Silence is weak evidence: some of it belongs to adverts that nobody was ever going to answer, which is what ghost jobs are about, so weigh rejections and replies more heavily than nothing at all. And your CV version column only tests anything if you change one thing between versions. Two CVs that differ in six ways cannot tell you which of the six mattered.

Keeping It Going

Half an hour on a Friday: update stages, close anything silent for four weeks, sort by the follow-up column and send what is due. That is the habit. Everything else in this article is setup.

Closing dead rows matters more than it sounds. Twelve open applications, four of which have been silent for six weeks, is not twelve chances. Marking them closed changes what you do on Monday, because eight live applications visibly needs more work behind it.

Start the tracker before your next application rather than after it. The fields you cannot reconstruct later are the ones that turn out to matter: which CV, which source, and whether you really met every essential criterion when you pressed send.

Frequently Asked Questions