avery

How to Build a Job Search Tracker That Actually Helps You Get Hired

Most Job Search Trackers Are Useless by Week Three

Most job seekers start a spreadsheet on day one of their search. Company name, role, date applied, status. By week three, the spreadsheet has 40 rows of "applied, waiting" and nobody is following up on anything. The tracker becomes a graveyard of dead leads.

A good tracker is not a record. It is an action engine. The right tracker tells you what to do today, who to follow up with, what stage each conversation is in, and where you are spending too much or too little energy.

This guide is the exact structure that works for active job searchers, with the columns, the views, and the weekly rituals that turn a search from chaotic into operational.

The Right Tool

You do not need fancy software. A Google Sheet or Notion database is enough. The structure matters more than the tool. Stripe-level engineers can build elaborate tracking systems and still miss follow-ups. Discipline beats sophistication.

If you want a polished option, Notion is the best free choice because of its database views. Coda, Airtable, and Trello also work. Pick whatever you will actually open daily.

The Columns You Actually Need

Most job trackers have too many columns and not enough action. Here are the columns that earn their place.

Company. The company name. Hyperlink to their careers page.

Role. Job title, level if known. Hyperlink to the job posting.

Source. Where you found the role (referral, LinkedIn, company page, recruiter outreach). This is the column that tells you which channels are working after a month.

Date applied. When you submitted.

Stage. The current stage. Use a fixed set: Researching, Applied, Recruiter Screen, Hiring Manager, Onsite, Offer, Closed (Won or Lost). No free-text stages.

Next action. The specific next thing you need to do, written as a verb-noun. "Follow up with Sarah on Friday." "Submit application." "Send thank-you to panel."

Next action date. When that action is due.

Contact name. The most relevant person at the company (recruiter, hiring manager, referral).

Notes. Free text. Recent conversation summary, gotchas, comp data, anything you want to remember.

That is it. Nine columns. Resist the urge to add more. Every extra column is friction that makes you not update the tracker.

The Two Views That Drive the Day

The magic of a real tracker is the views. You should never look at the raw spreadsheet. You look at filtered views that tell you what to do.

Today's actions view. Filter: Next action date is today or earlier. Sort by date. This is the only list you look at when you sit down to do search work. If this list is empty, you go pick three companies to research and add them.

Active pipeline view. Filter: Stage is not "Closed." Sort by stage descending. This is your live pipeline. You should know your active count at all times. A healthy active count for someone in full-time search is between 15 and 25 roles. Too few means you are not generating enough top of funnel. Too many means you are spread thin.

That is the daily rhythm. Open the today view. Do the work. Open the active view. Decide what to push.

The Weekly Review Ritual

Once a week, ideally Sunday evening or Monday morning, you do a 30-minute review of the full tracker. The questions to ask:

Where are my stalled conversations? Anything that has been in the same stage for more than 10 days without a next action. These are the ones to nudge or kill.

What is my conversion rate by stage? Of 50 applications, 12 became recruiter screens, 6 became hiring manager conversations, 2 became onsites, 1 became an offer. If your conversion drops sharply at a particular stage, that is the stage to improve.

Which sources are working? Look at the Source column. If 80 percent of your offers came from referrals and 0 percent came from cold applications, stop spending 80 percent of your time on cold applications.

What is the next set of companies to add? Spend the last 15 minutes of the review identifying 5 to 10 new companies to add to the tracker for the next week.

If you do this every week, your search compounds. If you skip it, the tracker becomes a graveyard.

The Follow-Up Cadence

The biggest single output of a good tracker is consistent follow-up. Most job seekers under-follow up. Here is the cadence that wins.

After applying: nothing for 7 days. Most companies move slowly. Following up at day 3 is annoying. Following up at day 7 is professional.

After recruiter screen: thank-you email within 24 hours, then nothing for 5 business days. If you have not heard back by day 6, send a check-in.

After hiring manager interview: thank-you within 24 hours that references something specific from the conversation. Then nothing for 5 business days. If you have not heard, check in.

After onsite: thank-you to each interviewer within 24 hours. Then nothing for 7 business days. If you have not heard, send a single, brief check-in.

If you do not get a response to a check-in within 5 business days, the conversation is effectively dead. Mark it closed, learn what you can, and move on.

For exact wording, see our guide on how to follow up after a job interview and our thank-you email templates.

How to Track Companies You Have Not Applied To Yet

The best searches keep a separate list of target companies you have not applied to. This is your top of funnel.

Use a second tab or a separate "Researching" view. Columns: Company, Why interested, Best contact (if any), Open roles (link), Status (researching, ready to apply, no fit).

Move companies from this list into the main tracker when you apply or have a meaningful conversation. Companies that sit in "researching" for more than 30 days without action either need to be applied to or removed.

For more on building this list, see our guide on how to build a target company list.

How to Track Networking Conversations

Networking conversations are a different shape than applications and deserve their own view or tab.

Columns: Name, Company, How we met, Last conversation date, Conversation summary, Next outreach date, Open ask (referral, intro, info, etc.).

The principle: every networking conversation should leave you with a next outreach date. If you talked to someone in March and your tracker says "next outreach: May 1," you will not let them go cold.

Mistakes to Avoid

A few common patterns that turn good trackers into bad ones.

Mistake 1: Too many statuses. "Applied, screened, in-progress, waiting for response, pending, interview scheduled, post-interview, follow-up sent..." Use a fixed set of 6 to 8 stages and stick to them.

Mistake 2: No next action. If a row does not have a next action, it is dead. Either add an action or move it to Closed.

Mistake 3: Tracking volume, not progress. 100 applications with no interviews is not progress. It is noise. Optimize for offers, not applications submitted.

Mistake 4: Not killing dead leads. Be ruthless about closing rows. Every dead row in your active view is mental tax.

Mistake 5: Tracking without strategy. The tracker is downstream of the search strategy. If your strategy is unclear, the tracker is just busywork. Spend time on the strategy first.

The Tracker Is a Mirror

A well-maintained tracker tells you the truth about your search. It tells you whether you are working on the right things, whether your funnel is healthy, whether your follow-ups are landing.

If your active view has 30 companies but no offers after two months, the issue is not effort. It is targeting or positioning. Use the tracker to see this, then read our guides on finding unposted jobs and how long a job search actually takes to recalibrate.

The tracker is a mirror. Look at it honestly.

Get the Top of Funnel Right

The most-tracked search in the world will not produce offers if recruiters cannot find your profile. Avery audits your LinkedIn in 24 hours and shows you the three changes that increase recruiter outreach. Free audit at heyavery.ai/pricing.

Ready to put this into action?

Get a personalized LinkedIn audit from Avery — built on 12,000+ real coaching sessions.

Get My Audit