Most candidates start a job search with a confident mental model of where they've applied and end it three weeks later unable to remember the recruiter's name at a company they actually want to hear back from. The information is in their inbox somewhere, or maybe in LinkedIn's "Jobs I've applied to" view, or maybe lost.

A personal application tracker — a single spreadsheet or Notion page — fixes this. It takes 20 minutes to set up and 15 minutes daily to maintain. The point isn't enterprise project management. The point is to not lose threads. This post is the minimum structure that works.

What a tracker needs (and doesn't)

What a personal tracker actually needs

Six fields

Identifier

Company + role + date applied

Bare minimum. Without this row you don't know what you applied to. Add a link to the JD before they take it down.

Source

How you found the role + channel

Referral, LinkedIn, careers page, niche board. This is the column that tells you over months which channel is actually producing your interviews.

Stage

Current pipeline stage

Applied / Phone / OA / Onsite / Offer / Closed. Five states keep the system usable. More states create maintenance overhead you'll abandon.

Last action

Date + brief note

What you last did and when. 'Sent thank-you 5/12' or 'Heard nothing, follow up 5/18.' The note is what makes follow-up feasible at scale.

Next step

What you owe + when

'Send tailored cover letter by 5/10.' 'Email recruiter Tuesday.' If empty, the row is either closed or stalled — both useful signals.

Outcome

Why it ended, briefly

'No response after 30 days,' 'Rejected at onsite,' 'Withdrew — low base.' This column is the most valuable in month two — your pattern recognition lives here.

A working personal application tracker has roughly six columns. Adding more is the most common failure mode — over-engineered trackers become abandoned trackers.

Identifier: Company + role + date applied. The bare minimum row. Add the JD link before the company takes the posting down.

Source: How you found the role and through what channel. This is the column that tells you over weeks which channels are actually producing your interviews. Most candidates discover their hires come from a channel they were under-investing in.

Stage: Where the application is in their funnel right now. Five states: Applied / Phone / OA (online assessment or take-home) / Onsite / Offer / Closed. Five is the right number. Ten is too many — you'll abandon the system within two weeks.

Last action: Date and a 5-10 word note on what you last did. "Sent thank-you 5/12." "Heard nothing." "Recruiter said decision by end of week." Specific notes are what make follow-up scalable.

Next step: What you owe and when. This is the column you actually act on. Empty next-step columns mean the row is either closed or stalled — both useful signals.

Outcome: Why the row closed. Most candidates skip this column. It's the most valuable one in month two of a search because it's where pattern recognition lives — "I lose at the onsite stage when the comp question comes up," "I never get past the recruiter screen at mid-market companies."

A 20-minute build

Build it in 20 minutes

Five steps

1. 01
   Open a spreadsheet

   Google Sheets, Excel, Notion, Airtable, or paper. The tool doesn't matter. The discipline of using it does. Don't spend 4 hours evaluating ATS tools.

2. 02
   Create six columns

   Company, role, date applied, source, current stage, next step. Add an outcome column at the right. That's the whole structure.

3. 03
   Add a 'follow-up date' column

   Sort or filter by this column daily. The single highest-leverage habit is following up on threads on the day you said you would.

4. 04
   Backfill the last 30 days

   Reconstruct from your email and LinkedIn 'Jobs I've applied to.' This takes 30 minutes and is immediately useful — you'll spot the dormant threads you'd already lost track of.

5. 05
   Update once daily, never more

   Update at the same time every day — 5pm, after dinner, whatever. The tracker is for the next day's decisions, not real-time monitoring.

The mechanical setup:

1. Open a spreadsheet. Google Sheets is fine. Excel is fine. Notion is fine if you're already in Notion. Airtable is fine if you like databases. The tool doesn't matter — the discipline of using it does. The hours spent comparing tools are hours not spent applying.

2. Create the six columns. Company, role, date applied, source, stage, next step. Add an outcome column at the far right that stays blank until the row closes.

3. Add a 'follow-up date' column. Sort or filter by this column daily. The single highest-leverage habit a job seeker can build is following up on threads on the day you said you would — not three weeks later when you remember.

4. Backfill the last 30 days. Reconstruct from your email "applied" folder and LinkedIn's "Jobs I've applied to" view. This takes 30 minutes and is immediately useful: you'll spot 2-4 dormant threads where a quick follow-up is still in play.

5. Update once daily, never more. Update at the same time every day — 5pm, after dinner, before bed. The tracker is for tomorrow's decisions, not real-time monitoring. Constantly updating it during the day is anxiety, not productivity.

What the data tells you in week three

What systematic tracking actually unlocks

3 stats

0%100%

▼

35%

Of candidates who skip tracking lose 2+ active threads to dormant follow-up within 6 weeks of an active search.

0%100%

▼

2.4×

Higher interview-to-offer conversion among candidates who track outcomes and review weekly — partly from learning, partly from follow-through.

0%100%

▼

15min

Daily time investment for a tracker that handles 50+ active applications. Past 15 minutes, you're over-engineering it.

The compounding value of a tracker becomes obvious around week three of an active search. A few patterns the tracker will reveal that most candidates miss without it:

Where your interviews actually come from. Most candidates spend their effort proportional to volume of applications. A tracker often reveals that referrals are converting at 25% and LinkedIn Easy Apply is converting at 1.5% — but the candidate is sending 80% of their applications via Easy Apply. Reallocating effort follows naturally once you can see the data.

Where you stall. Some candidates lose at the recruiter screen. Some clear the recruiter screen and lose at the hiring-manager round. The pattern is invisible without the tracker — once it's visible, you can target your prep at the actual gap.

Where you ghosted yourself. Most candidates have 2-4 active threads they let go dormant. The tracker reminds you that the recruiter at Company X said "we'll be in touch in 2 weeks" three weeks ago, and a polite check-in is overdue.

Whether your application volume is sustainable. Tracking shows the math: if you're applying to 5 thoughtful roles a week and 3 are advancing to phone, your funnel is healthy. If you're applying to 30 and only 1 is advancing, the volume is hiding a quality or fit problem. See how-many-jobs-to-apply-to.

What not to track

A few categories of column that look useful and aren't:

Salary research. Tempting to track. Becomes a data-entry hobby. Keep salary research in a separate doc.

Detailed interviewer notes. Useful to have, but separate from the tracker. The tracker is operational — who, what, when, next. Interview notes are content — what was discussed, follow-ups, etc. Different jobs, different files.

Resume version sent. Useful if you have 4+ resume variants, otherwise overhead. See master-resume-with-variants for the resume side.

Sentiment columns ("how I felt about this interview"). These age badly. Two weeks later, "felt strong" tells you nothing actionable.

Weekly review: 15 minutes on Friday

The tracker pays back with a 15-minute weekly review. The pattern:

• Filter by "no response, 14+ days" — decide on follow-ups for each.
• Filter by "next step empty" — decide what's stalled and what's actually closed.
• Look at the outcome column — what was the pattern of the last week's closes?
• Count active threads. If under 5, plan more applications. If over 25, you're spread too thin.

This 15 minutes is where the tracker creates leverage — the daily updates accumulate into a Friday view of the search that you can actually act on.

When to drop the tracker

Two situations where the tracker becomes overhead, not leverage:

• You've accepted an offer and are wrapping up. Track the remaining closes for a week, then archive the file. Don't carry an old tracker into the new job.
• You're not actively searching. Passive open-to-roles candidates don't need a tracker. The threshold is roughly: if you're not making 3+ applications a week or having 3+ recruiter conversations a month, the maintenance overhead exceeds the value.

For the broader strategy of a focused search, see job-board-comparison-where-to-search and how-many-jobs-to-apply-to.

What this isn't

A few clarifications:

• It's not a CRM. The tracker is for your job search. Resist the urge to make it a full pipeline tool with reminders, automations, and dashboards. The simpler version actually gets used.
• It's not a substitute for thinking. The tracker captures actions; it doesn't make decisions. The decisions still belong to you — what to apply to, who to follow up with, when to withdraw.
• It's not permanent. Archive it when the search ends. Carrying a job-search tracker into a new role is a low-grade source of anxiety.

The short version: spreadsheet, six columns, 20-minute setup, 15-minute daily update, 15-minute weekly review. Don't over-engineer it. The point is to stop losing threads, not to build a tool.