How to Build a Job Search Tracker That Actually Works

A job search tracker solves the most common problem in an active job search: losing track of where things stand. When you're applying to 15 companies, networking with 8 contacts, and waiting to hear back from 4 hiring managers, the details blur together fast. Did you follow up with the recruiter at Stripe? Was the Figma application due this Friday or last Friday? Who referred you to the person at Datadog?

According to the Bureau of Labor Statistics, the median job search takes about five months. That's five months of applications, conversations, interviews, and follow-ups. Without a system to track all of it, you'll miss deadlines, forget to follow up, and waste time on opportunities that already fizzled out.

This guide walks you through building a tracker from scratch. No fancy software required. A Google Sheet or Excel file and 20 minutes of setup time will get you a system that keeps your entire search organized.

Why Most Job Search Trackers Fail

Most job seekers start a tracker at some point. A spreadsheet, a Notion board, a list in the Notes app. Most of those trackers get abandoned within two weeks. The reason is simple: they track too much or too little, and they don't connect to any specific action.

A tracker with 25 columns per entry creates overhead. You spend more time updating the sheet than searching for jobs. So you stop updating. Within a week the data is stale and useless.

A tracker with three columns (Company, Role, Date Applied) doesn't give you enough information to act on anything. You can see where you applied but you can't see what to do next. There's no follow-up trigger, no status, no contact information.

The sweet spot is a tracker that answers one question: "What do I need to do today?" Every column you add should serve that question. If a column doesn't help you decide your next move, delete it.

What Columns to Include in Your Job Search Spreadsheet

A well-built job search spreadsheet needs ten columns. These fields give you enough context to act on every opportunity without creating busywork. Here's each column and why it earns its spot.

Column	What to Enter	Why It Matters
Company	Company name	Your primary identifier for each opportunity
Role Title	Exact title from the posting	Reference for follow-ups and interview prep
Date Applied	When you submitted or first reached out	Triggers follow-up timing
Source	Job board, referral, networking, recruiter	Shows which channels produce results
Contact	Name of recruiter, hiring manager, or referrer	Personalizes every follow-up
Contact Method	Email, LinkedIn, phone	Tells you where to follow up
Status	Applied, Phone Screen, Interview, Offer, Rejected, Ghosted	Your pipeline view at a glance
Next Action	The specific thing you need to do next	Eliminates "what should I work on" paralysis
Next Action Date	When that action needs to happen	Prevents missed follow-ups
Notes	Key details, conversation highlights, salary info	Context for future you

That's it. Ten columns. You might be tempted to add things like "salary range," "job posting URL," or "company size." Those can go in the Notes column when relevant. The moment your tracker has more than 12 columns, the update friction goes up and the update frequency goes down.

How to Set Up the Status Pipeline

The Status column is the most important column in your tracker. It tells you, at a glance, how your entire search is progressing and where your efforts are concentrated. Use a consistent set of statuses with clear definitions.

Here are the six statuses that cover 95% of job search scenarios:

• Researching: You've identified the company and role but haven't applied or reached out yet. This is your prospect list.
• Applied: You've submitted an application through a portal, sent a cold email, or had an intro made on your behalf. The ball is in their court.
• Phone Screen: You've had an initial conversation with a recruiter or hiring manager. There's mutual interest.
• Interview: You're in the formal interview process. This includes technical screens, panel interviews, take-home projects, and final rounds.
• Offer: You've received an offer (verbal or written). Time to negotiate.
• Closed: The opportunity has ended. Either you were rejected, you withdrew, or you accepted. Add a note about why.

Color-code these in your spreadsheet. Green for Offer, blue for Interview, yellow for Applied, red for Closed. The visual pattern shows you where your pipeline is healthy and where it's thin. If you have 20 rows in Applied and zero in Phone Screen, your applications aren't converting. If you have 5 in Interview and none in Applied, you're about to run dry.

When to Follow Up Based on Your Tracker

Your tracker's Next Action Date column is a built-in follow-up engine. Sort your sheet by this column every morning and you'll know exactly what needs attention today. No guessing. No forgotten follow-ups.

Here are the follow-up windows to use for each status:

• Applied (no response): Follow up 7-10 business days after applying. One short email to the recruiter or hiring manager. If you applied through a referral, follow the warm intro follow-up sequence.
• After Phone Screen: Send a thank-you within 24 hours. If they said "we'll get back to you by Friday" and Friday passes, follow up on Monday.
• After Interview: Thank-you within 24 hours to each interviewer. Follow up 5-7 days after if no update.
• After Silence (2+ weeks): One final follow-up, then change status to Closed with a note: "No response after follow-up." Don't keep stale opportunities in your active pipeline.

According to Glassdoor's research, the average hiring process in the US takes about 23 days from first interview to offer. Use that as a rough benchmark. If you're at day 30 with no update despite following up, the role has likely moved forward without you.

How to Track Networking and Referral Activity

Applications are only one part of a job search. Networking conversations, referral requests, and informational interviews should all live in your tracker too. This is where the Source and Contact columns earn their keep.

For every networking-driven opportunity, record:

• Who connected you (the referrer)
• Who you were connected to (the target)
• When the intro was made
• What the current status is

This data reveals something powerful over time: your referral conversion rate. Jobvite data shows that referred candidates get hired at roughly 4x the rate of portal applicants. But your personal rate might be higher or lower depending on the strength of your network and how well you're targeting your asks. Tracking it lets you know.

If you've had 10 referrals and 3 led to interviews, your referral-to-interview conversion is 30%. If you've submitted 40 portal applications and 2 led to interviews, that conversion is 5%. That kind of data changes how you allocate your time. For more on balancing these activities, see our guide on how to split your job search time between applications and networking.

How to Use Your Tracker for Weekly Reviews

Set aside 30 minutes every Sunday evening or Monday morning to review your tracker. This weekly review is the habit that makes the entire system work. Without it, the tracker is just a spreadsheet you update occasionally.

Here's a five-step weekly review process:

1. Update all statuses. Go row by row and make sure every entry reflects reality. Move things to Closed if they're dead. Update statuses for anything that advanced.
2. Set next actions for every active row. Every row that isn't Closed should have a specific next action and a date. "Follow up with recruiter" on "Tuesday" is actionable. "Wait and see" is not.
3. Count your pipeline. How many active opportunities do you have at each stage? A healthy pipeline for most searches has 5-10 in Applied, 2-4 in Phone Screen or Interview, and a steady flow of new Researching entries.
4. Check your source mix. Are all your opportunities coming from job boards? That's a sign to invest more time in networking. Are they all from referrals? You might be underusing job boards for discovery. A balanced mix of sources reduces the risk of your pipeline going dry.
5. Archive closed entries. Move Closed rows to a separate tab. Keep your active sheet clean and scannable.

This review takes 20-30 minutes. It replaces the vague anxiety of "I should be doing more" with a concrete plan for the week. You'll know exactly which companies need a follow-up, which connections to reach out to, and where to focus your application energy.

Tracker Mistakes to Avoid

After watching hundreds of job seekers use trackers, a few patterns consistently sabotage the system.

Tracking applications but ignoring networking. If your tracker only has portal applications, you're missing the highest-ROI activity in your search. Warm intros, informational interviews, and referral requests all need tracking. The referral advantage is well-documented: referred candidates get hired faster and at higher rates.

Never closing dead opportunities. If you haven't heard back in three weeks despite two follow-ups, it's over. Mark it Closed. Keeping 40 stale entries in your active pipeline makes your search feel bigger and more productive than it is. Honesty in your tracker leads to honesty about your strategy.

Forgetting to update after conversations. The best time to update your tracker is right after a call, interview, or email exchange. The details are fresh. The next step is clear. If you wait until your weekly review, you'll forget the recruiter's name, the team's timeline, and the specific thing they asked you to send.

Overcomplicating the system. If you spend 30 minutes setting up Notion databases with linked tables, formulas, and automations, you've spent 30 minutes not searching for a job. A simple Google Sheet with 10 columns works. Perfecting the system is a form of procrastination that feels productive.

Not using conditional formatting. Conditional formatting is the one "fancy" feature worth setting up. Color-code the Next Action Date column: red for overdue, yellow for today, green for this week. This turns your spreadsheet into a visual priority list you can scan in five seconds.

Frequently Asked Questions