Build a Job Application Tracker

Almost everyone starts a job search without a tracker, and almost everyone regrets it around week four. That’s when the symptoms show up: applying to the same role twice through two different boards, not knowing which resume version went where, a recruiter calling about a job you can’t place, and no way to answer the only question that matters — is any of this working?

A tracker fixes all of that. It takes ten minutes to build and about ninety seconds per application to maintain. Here’s what should be in it.

The columns that earn their place

Company — plain text.

Role title — as written on the posting, not paraphrased. You’ll need to recognise it in six weeks when someone emails “regarding your application.”

Date applied — the single most important field, because almost every decision downstream is a function of elapsed time.

Source — where you found it: company careers page, a specific job board, a referral, a recruiter, a direct approach. This column is the one people skip and the one that pays off most; after thirty applications it tells you which channels actually convert.

Resume version — a short label like backend-v3 or ops-tailored. You will end up with several. Knowing which one is in play before an interview is worth a great deal.

Link — to the posting. Postings get taken down; if you can, paste the description text into a notes field or a linked doc, because you’ll want it before the interview and it will be gone.

Contact — name and email of a recruiter or hiring manager, if you have one.

Status — a small controlled vocabulary. See below.

Last action / next action — what you last did and what you owe next. This is the field that drives your week.

Follow-up due — a date. Fill it in the moment you apply.

Notes — free text: salary range if published, referral name, why you wanted it, anything odd about the process.

Outcome — filled at the end: offer, rejected, ghosted, withdrew.

Twelve fields. Most take a few seconds; several are dropdowns.

The status vocabulary

Keep it short and mutually exclusive. Long status lists produce inconsistent data and defeat the purpose.

• Found — on the list, not applied yet
• Applied
• Screening — recruiter call scheduled or done
• Interviewing — any stage past the screen
• Offer
• Rejected
• Ghosted — no response past your cutoff (see below)
• Withdrew

The distinction between Rejected and Ghosted matters more than it looks. Rejections mean your application was read. Ghosting can mean many things, but a search full of ghosting and no rejections tells you a different story than one full of rejections and no ghosting — the first suggests you’re not reaching a human, the second that you are and something later isn’t landing.

Pick a cutoff for Ghosted — 30 days is a reasonable default in most fields — and apply it consistently, so the number means something.

Columns to leave out

Excitement rating out of ten. Feels useful, is noise, and you’ll stop filling it in by week two.

Estimated salary you made up. If it’s published, record it. If it isn’t, leave the cell empty rather than guessing; a column of guesses is worse than a column of blanks.

Long free-text summaries of each company. The notes field is for one line. Anything longer belongs in a linked document, or nowhere.

Anything requiring more than a few seconds. This is the real design constraint. A tracker with twenty columns is a tracker you abandon, and an abandoned tracker is worse than none because you’ll trust it and it’ll be wrong.

Spreadsheet or app?

A spreadsheet, almost certainly. It’s free, it’s yours, it exports, it sorts, and you can add a column when you discover you need one. Whichever spreadsheet tool you already use is fine.

Dedicated job-search apps and browser extensions exist and some are good. The trade-off is that your data lives in someone else’s product, the schema is theirs, and if the service shuts down or moves behind a paywall mid-search you have a problem at the worst possible moment. If one genuinely saves you time — auto-capturing postings, for instance — use it, but keep an export.

Whatever you pick: one tracker. Not a spreadsheet plus a notes app plus browser bookmarks plus your email starred folder. The value is in the single source of truth, and it evaporates the moment there are two.

The three views that make it useful

A flat list of rows is a record. Three filtered views turn it into an operating tool.

1. Owed by me. Everything where next action is mine and the date has passed. This is your to-do list; work it first in every session.

2. Follow-up due. Everything where follow-up due is today or earlier and status is still Applied. Handle these in a single batch — it takes fifteen minutes and it’s the highest-value quarter-hour in the week.

3. Live processes. Everything in Screening, Interviewing, or Offer. These are worth an order of magnitude more than anything in Applied, and when you’re busy they’re the things that must not be dropped. Look at this view before you send a single new application.

In a spreadsheet these are three saved filters. That’s the whole setup.

What the tracker tells you after three weeks

This is the payoff, and it’s why the source column matters.

Once you have twenty-five or thirty rows with dates and outcomes, you can answer questions that no article can answer for you:

• What’s my response rate? Applications that got any human reply, divided by applications sent.
• Which sources convert? Referrals versus job boards versus direct applications. Nearly everyone finds a large difference here, and nearly everyone is surprised by which way.
• How long does a response take? Once you know your own median, you know when to stop waiting — and your follow-up cutoff stops being a guess.
• Where do I drop out? Lots of applications and no screens is a different problem from lots of screens and no second rounds. The first is a targeting or document problem; the second is something happening in the conversation.

Be careful about comparing your response rate to numbers you read online. The figures that circulate are unverifiable and vary enormously by field, seniority, and market conditions. Your own number, tracked over time, is the only benchmark worth acting on — and the useful comparison is you-this-month against you-last-month.

Maintenance

Update it at two moments only: immediately after applying, and immediately after any reply. Not later, not in a weekly catch-up session. Ninety seconds each time, and the ninety seconds is only cheap because you do it while the context is in your head.

Once a week, in your review block, do a five-minute pass: move anything past your cutoff to Ghosted, check the follow-up view, and look at the last two weeks’ numbers. That’s it.

The tracker isn’t the job search. It’s the instrument panel — and running a four-month search without one is flying by feel through a process specifically designed to make you lose track of things.