Here's a situation most active job seekers know too well:

You get an email asking to schedule a call. You have no idea what company it's from. You search your inbox, find the original job posting, and realize you applied 18 days ago and can't remember anything about the role.

You walk into the phone screen underprepared because your job search has no system — it's just a pile of tabs and sent emails.

This article gives you a complete job search tracking system, including a free spreadsheet template you can copy today.

Why Tracking Matters More Than You Think

Most job seekers manage their search reactively — they apply, they wait, they respond to whatever comes back. Without a tracking system, you can't answer the questions that actually tell you whether your search is working:

What's your callback rate? (Are you getting responses, or sending into a void?)
Which types of companies are responding? (Is there a pattern?)
How long does your process take? (Are you moving fast enough?)
Which applications are still pending and need a follow-up?

These questions have answers. But only if you're tracking the data.

A job search without tracking is like running a business without knowing your sales numbers. You're busy, but you don't know if it's working.

The 6 Columns You Actually Need

You don't need a complicated system. You need six columns and the discipline to fill them in.

Column 1: Company

The company name. Obvious, but also the first thing you need when a recruiter calls from a number you don't recognize.

Column 2: Role Title

The exact title from the job posting. This matters because the same role title means different things at different companies, and you need to be able to quickly recall what this specific job entails.

Column 3: Date Applied

When you submitted the application. This is how you track follow-up timing (more on this below) and how you calculate your response rate over time.

Column 4: Status

A simple categorical field: Applied / Phone Screen / Interview / Offer / Rejected / Ghosted / Withdrawn. Update this every time something changes.

Column 5: Contact Name

The recruiter or hiring manager's name and email if you have it. You'll want this for follow-ups and for tracking who you've spoken to at which companies.

Column 6: Notes

One or two lines of context: what makes this role interesting, how you found out about it, anything the recruiter told you, key things to mention in the interview. This is what saves you in that phone screen you forgot about.

The Follow-Up Rule

Most job seekers either never follow up or feel anxious about doing it. Here's a clean rule that removes the ambiguity:

If you haven't heard back 10 business days after applying, send one follow-up email.

Keep it short. Reference the role and date you applied. Ask if there's any update or additional information you can provide. That's it. One email. One time.

If there's still no response after the follow-up, mark it as "Ghosted" and move on. Don't send a third message.

If you've had a phone screen or interview and haven't heard back within the timeframe they gave you, follow up the day after that window closes — not before.

This system means every pending application has a clear next action and a clear deadline. Nothing falls through the cracks.

The Weekly Review (15 Minutes, Every Friday)

The tracking system only works if you actually use it. The habit that makes it sustainable is a 15-minute weekly review every Friday.

In those 15 minutes:

Add any applications you submitted this week
Update the status of anything that moved
Identify anything that's 10+ days old with no response — mark for follow-up
Look at your callback rate for the past 2 weeks — is it above 5%? If not, something needs to change
Set a target for next week — how many applications, which companies

That's it. 15 minutes. Keeps the system current and keeps you honest about whether your search is actually producing results.

The Free Template

Copy this Google Sheets template and make it your own:

Copy the free template →

(The template includes dropdown validation for the Status column, conditional formatting to highlight pending applications, and a callback rate formula that updates automatically.)

Tracking + Tools

A tracking system tells you what's happening. Tools like AURI help you improve what's happening — better resumes, better cover letters, better interview preparation.

The combination is what a real job search system looks like: organized tracking so nothing falls through, high-quality applications so your callback rate stays strong, and interview prep so you convert the callbacks you get.

Beta invite code: AURI-BETA-2026

Get early access to AURI →

The Complete Job Application Tracking System (Free Template Inside)