Job Search

How to Build a Job-Search Tracker (That You'll Actually Keep)

The exact columns, statuses, formulas and weekly cadence that turn a chaotic, anxious search into one calm system — so nothing slips, and your numbers tell you precisely what to fix next.

By Hollis Barnett, Principal Job-Search Strategist · Updated June 26, 2026 · ~40 min read

The Short Version. A job-search tracker is one document — a spreadsheet beats an app for most people — that holds every role you're pursuing in exactly one pipeline stage, with a next action and a date for each. Build it with a tight core of columns (company, role, link, source, status, next action, dates, notes), drive it with a small set of statuses, and add a dashboard that counts your conversion at each step. Update it in under a minute whenever something happens, and run one 30-minute weekly review. Done well, a tracker does two things at once: it stops follow-ups from slipping, and it turns "my search isn't working" into a specific, fixable bottleneck — a resume problem, an outreach problem, or an interview problem. Track outreach and referrals in it too, because the warm side door is where many roles are actually won.

Before: scattered everywhere 12 open tabswhich applied? sticky note"call back?" inbox searchrecruiter name? screenshotsalary? After: one tracker Company · Role · Status · Next action · Date Northwind · PM · Interview · prep STAR · Jun 28 Lumen · Analyst · Applied · follow up · Jun 27 Brightline · Lead · Outreach · 2nd touch · Jun 30
The whole point: collapse the scattered tabs, notes and inbox searches into one view where every role has a status and a next move.

Why a tracker changes your search

Most job searches don't fail for lack of effort. They fail for lack of a system. People apply to a role on Monday, get a promising reply on Wednesday, mean to send their availability "tomorrow," and then a more urgent week swallows the thread. Three weeks later they remember, and the recruiter, who genuinely liked them, has already moved three other candidates forward. Nothing about that person's qualifications failed. Their memory failed, because they were asking a human brain to do a database's job: hold dozens of companies, contacts, dates, and obligations in working memory while also doing the emotional labor of being in a search at all.

A job-search tracker is the fix, and it's almost embarrassingly simple: a single document that records every role you're pursuing and the precise state of each one. When you found it, where it came from, who you've spoken to, where the application stands, and, the most important field of all, what you owe next and by when. That's it. But the effect is out of all proportion to the effort, because it solves three different problems at the same time.

First, it stops things from slipping. The single most common avoidable loss in a job search is the dropped follow-up: an interview that was never thanked, a recruiter who went quiet and was never nudged, a referral offer that was never taken up. A tracker with a "next action" and a date makes those impossible to forget.

Second, it lowers anxiety. A search lives rent-free in your head precisely because it's unresolved and uncountable, a fog of half-remembered obligations. The moment you write everything into one place, your brain is allowed to let go of it. Externalizing the list is a documented way to reduce the background hum of stress; you stop carrying the search and start running it.

Third, and this is the part most people miss, a tracker is a diagnostic instrument. Once you're recording outcomes, you can count them. How many applications turned into replies? How many replies into interviews? How many interviews into offers? Those ratios convert a vague, demoralizing feeling ("nothing's working") into a specific, fixable bottleneck ("my applications convert fine, but my interviews don't — so the problem is interview preparation, not my resume"). We'll build that diagnostic engine later in the guide. For now, just hold onto the idea that a tracker isn't bookkeeping. It's the difference between a search you endure and a search you steer.

Key takeaway. A tracker does three jobs at once: it makes dropped follow-ups impossible, it lifts the search out of your head and lowers anxiety, and it gives you the numbers to find and fix whatever is actually stalling you.

The hidden cost of running a search from memory

It's worth dwelling for a moment on what a search without a tracker actually costs, because the costs are real but invisible, which is exactly why people tolerate them. Consider a typical week. You find six interesting roles, apply to three, get a reply from one, have a promising call, and exchange messages with a former colleague who might refer you somewhere. By Friday, how confident are you that you remember all of it precisely — which three you applied to, the exact role title at the company that replied, the name of the recruiter, what you promised to send and by when, and the name of the colleague's contact? Most people remember the broad strokes and lose the details. And in a job search, the details are the search. The recruiter's name is how you follow up warmly instead of generically. The promised attachment is how you stay credible. The follow-up date is the entire difference between "still in the running" and "forgotten."

The cost compounds in a particularly cruel way: the things you forget are disproportionately the warm, advanced opportunities, the ones where a human already engaged with you. A cold application you forget costs you little, because it was a long shot anyway. But a reply you forget to act on, an interview you forget to follow up after, a referral offer you forget to take up — those are the high-value threads, the ones closest to an offer, and they're precisely the ones a tired brain in a stressful week is most likely to drop. Running a search from memory doesn't fail you randomly; it fails you exactly where it hurts most.

There's an emotional cost layered on top of the practical one. An unmanaged search produces a specific, grinding kind of stress, the low background dread of knowing there's something you're forgetting but not knowing what. Your mind keeps half-running the list in the shower, at dinner, at 2 a.m., never able to set it down because it was never written down. This is not a character flaw; it's how working memory behaves when you ask it to be a database. The tracker doesn't just make you more effective. It gives your mind permission to stop carrying the search, which is its own quiet relief.

If you want the wider operating model this tracker plugs into — the weekly cadence, the single source of truth, the calm rhythm around it — our companion guide on how to organize your job search lays out the whole system. This article zooms all the way in on the tool at its center.

Spreadsheet vs. app vs. board: choosing your tool

Before a single column, one decision: what do you build the tracker in? There are three honest options, and the right one depends less on features than on which one you'll actually keep open and updated. A perfect system you abandon beats nothing; a plain system you maintain beats everything.

Option 1 — A spreadsheet (recommended for most people)

A spreadsheet in any free tool — a cloud spreadsheet you can reach from your phone, or a desktop one — is the default for good reason. It's free, completely private, works offline, and bends to whatever shape your search takes. You own the file, you can add a column the second you need it, you can build formulas and a dashboard, and you can export or back it up anywhere. The only "cost" is a few minutes of setup, which this guide eliminates with a ready template. For the overwhelming majority of searches, a spreadsheet is not a compromise; it's the best tool.

Option 2 — A board (kanban-style)

A board organizes roles as cards you drag between columns that represent stages — "Researching," "Applied," "Interviewing," "Offer." It's visually satisfying and great if you think spatially, and some people stay more motivated watching a card physically move toward "Offer." The trade-off is that boards are weaker at the thing a tracker most needs to do later: math. Counting conversion rates, sorting by next-action date, and reading trends are clumsier on a board than in a grid. A reasonable hybrid is a spreadsheet for the data and a board view layered on top if your tool offers one.

Option 3 — A dedicated job-search app or extension

Several apps and browser extensions promise to autofill applications, scrape a posting into a row with one click, and remind you to follow up. When they work, they save typing. But you trade control and portability for that convenience: your data lives in someone else's product, the column set is whatever they decided, and a confidential search may sit on a third-party server you'd rather it didn't. They're worth trying only if one specific feature genuinely saves you meaningful time. Start in a spreadsheet; graduate to an app only if it earns its place.

ToolBest forStrengthsWatch-outs
SpreadsheetAlmost everyoneFree, private, flexible, does the math, fully portableYou build it yourself (this guide solves that)
Kanban boardVisual thinkersMotivating, stage-at-a-glance, drag-to-advanceWeak at counting conversion and sorting by date
Dedicated app/extensionHigh-volume, autofill-heavyOne-click capture, built-in remindersLess control, your data on their server, fixed columns
Spreadsheet Company Role Status Next does the math Board drag to advance App one-click capture
The same pipeline in three tools. Pick the one you'll keep updated; a spreadsheet is the safe default because it also counts.

The columns that matter (and the ones that don't)

The most common way a tracker dies is over-engineering. People build a beautiful twenty-column masterpiece on day one, spend more time maintaining it than searching, and abandon it inside a week. The discipline here is the opposite of thoroughness: include the fewest columns that still let the tracker do its three jobs. Start with a tight core, and add a field only when you feel its absence.

The core columns (start here)

ColumnWhat it holdsWhy it earns its place
CompanyEmployer nameThe anchor for every other field; lets you spot duplicates.
RoleExact job titleYou'll apply to several roles at one company; the title disambiguates.
LinkURL of the postingPostings vanish; the saved link (or a copy) is your record of what you applied to.
Date foundWhen it entered your pipelineLets you measure how fresh your pipeline is and how fast you act.
SourceWhere it came fromJob board, referral, recruiter, company site — tells you which channels actually convert.
StatusCurrent pipeline stageThe heart of the tracker; every row sits in exactly one stage.
Next actionThe single next thing you oweThe field that prevents dropped follow-ups. Always a verb.
Next-action dateWhen it's dueLets you sort the whole search by "what's due now."
NotesAnything else worth rememberingNames, salary hints, interview impressions, the why-you-care.

High-value optional columns (add as needed)

  • Contact — the recruiter, hiring manager, or referrer's name. The bridge between an application and a relationship.
  • Fit / excitement score — a simple 1–5 on how much you actually want it. Prevents you from over-investing in roles you don't care about and helps you triage when time is short.
  • Salary range — the posted or researched compensation. Saves you from advancing a role that can't meet your floor; see our guide to evaluating a job offer for how to use this later.
  • Date applied and date of last contact — twin timestamps that power your follow-up timing and your conversion math.
  • Location / remote — on-site, hybrid, or remote, plus the city. Filters out mismatches fast.
  • Resume version — which tailored resume you sent. Invaluable when you A/B your materials and want to know what's working.
Pitfall: the column-count trap. Every column you add is a field you must keep filling forever. A tracker with nine columns you maintain beats one with twenty-two you abandon. If you've gone three weeks without ever filling a column, delete it. The best tracker is the one that's still alive in month two.

Notice what's not in the core: no "color-coded priority traffic-light," no elaborate tagging taxonomy, no formula-driven scoring on day one. Those can be wonderful additions once the habit is solid, but they're decoration, not structure. Build the skeleton first. You can always make it prettier; you can't recover a search you let rot because the tracker was too heavy to maintain.

How each column actually earns its keep in practice

It's easy to nod along to a column list and harder to feel why each one matters until you've been burned by its absence. Let me walk through the non-obvious ones. The Link column saves you more often than you'd expect, because job postings are ephemeral — a role you applied to three weeks ago is frequently taken down, and if a recruiter asks "remind me which position this was?" you'll want the exact title and description, not a vague memory. A useful habit is to paste the key requirements into the Notes field, or save the posting as a PDF, the moment you apply, so the record survives the posting's deletion.

The Source column looks trivial until you run your conversion math and discover that one channel produces nearly all your real conversations while another produces only silence. This is one of the most useful signals a tracker yields: if eight of your ten replies came from referrals and two from a single job board, while your other channels produced nothing across forty applications, the tracker has just told you where to spend the next month of effort. Without the Source column, that pattern is invisible and you keep spreading effort evenly across channels that don't deserve it.

The Fit / excitement score is the column people skip and later wish they hadn't. A simple 1–5 on how much you genuinely want each role does two things. It stops you over-investing in a role you applied to out of anxiety rather than real interest — when you're choosing where to spend a scarce evening of preparation, the score makes the choice obvious. And it protects you at offer time: when an offer arrives from a role you scored a 2, the tracker reminds you that you weren't actually excited, which is valuable context when you're tempted to accept anything just to end the search. Honest scoring at the front prevents regret at the back.

The Resume version column quietly turns your whole search into an experiment. If you're tailoring your resume, and you should be, noting which version you sent to which role means that when replies start coming, you can see which framing actually lands. Maybe the version that led with leadership outperforms the one that led with technical depth for a certain role type. That's a genuine, data-backed improvement to your materials, and it's only possible if you recorded which version went where.

Designing your pipeline statuses

If the columns are the tracker's anatomy, the status field is its nervous system. A good set of statuses lets you see your entire search in one glance — how many roles are in early research, how many are mid-process, how many are at the finish line — and, crucially, where things pile up and stall. The rule is simple: every row must sit in exactly one status at any time, and the statuses must describe a sequence. Vague or overlapping statuses ("in progress," "pending," "ongoing") tell you nothing. Sequential ones tell you everything.

The recommended status set

StatusWhat it meansTypical next action
ResearchingOn your radar; not yet acted onDecide: pursue or drop. Find a contact.
Outreach sentYou've messaged a contact or referrer firstWait, then a polite second touch.
AppliedFormal application submittedFollow up in ~5–7 business days.
RepliedA human respondedSchedule the call; send what they asked for.
Phone screenFirst conversation booked or donePrep, then send a thank-you.
InterviewIn the main interview roundsPrep stories; follow up after each round.
FinalLast stage / decision pendingSend references; prep negotiation.
OfferAn offer is on the tableEvaluate, negotiate, decide.
RejectedThey said noAsk for feedback; turn it into a referral.
WithdrawnYou chose to step outNote why, for future pattern-spotting.
GhostedGone quiet past a sensible windowOne final nudge, then archive.

The first eight are the live pipeline, in order. The last three are terminal — a row that reaches them is done moving and can eventually be archived. Putting "Ghosted" on the list as its own honest state matters more than it looks: it stops dead roles from masquerading as live ones and lets you measure how often you go quiet (a signal in itself). If you're routinely being ghosted after good conversations, that's a pattern worth diagnosing, and our guide on the job-search metrics that actually matter shows how to read it.

Why "in progress" is the status that ruins trackers

The most common status mistake is reaching for soft, catch-all labels — "in progress," "pending," "ongoing," "waiting." They feel safe because they're never wrong, and that's exactly the problem: a status that's never wrong is also never useful. If forty of your rows say "in progress," your tracker is telling you nothing about your search. You can't count them into a funnel, you can't see where things clog, and worst of all you can't tell a row that's genuinely advancing from one that's quietly dead. Vague statuses are how a pipeline silently fills with corpses while looking healthy.

The discipline of forcing each row into one specific, sequential stage feels slightly uncomfortable at first, and that discomfort is the point. When you have to decide whether a row is "Replied" or "Phone screen," you're forced to confront the actual state of that opportunity, and sometimes you realize, in that small moment of honesty, that a role you'd been mentally counting as "active" has actually been silent for two weeks and belongs in Ghosted. That tiny act of classification is the tracker doing its job: keeping you honest about where you really stand.

Should you split interview rounds into separate statuses?

A reasonable question is whether "Interview" should be one status or several — "Interview round 1," "Interview round 2," "Final." For most searches, keeping it as a single "Interview" stage plus a "Final" stage is the right level of granularity; the round number lives in the Notes field ("round 2 of 3"). Splitting every round into its own status creates more statuses than your funnel math benefits from, and the marginal insight rarely justifies the added complexity. The exception is a search concentrated on a few very high-stakes roles with long, multi-stage processes, for an executive search, say, where seeing exactly which round each role sits at genuinely changes how you allocate preparation time. As with columns, add granularity only when you feel its absence, not preemptively.

Researching Outreach Applied Replied Phone screen Interview Final Offer Terminal states — a row that lands here stops moving Rejected Withdrawn Ghosted
Eight sequential live stages plus three honest terminal states. Every row sits in exactly one — that's what makes the whole search legible.
Key takeaway. Make your statuses sequential and mutually exclusive, and name the uncomfortable ones honestly — especially "Ghosted." A status set you can sort by stage is what turns a list of rows into a pipeline you can actually read.

Build it step by step

Enough theory — here's the actual construction, in the order I'd do it. Each step takes a minute or two, and at the end you'll have a working tracker, not a half-finished spreadsheet you never return to.

Step 1 — Create the file and name it plainly

Open a new spreadsheet in a personal account (not a work one — more on that in the confidential search section). Name it something dull and private, like "2026 planning" rather than "JOB SEARCH." Put it somewhere you'll find it instantly, and pin it or bookmark it so opening it is frictionless. Friction is the enemy of habit; a tracker you have to hunt for is a tracker you won't update.

Step 2 — Lay out the header row

In row 1, type the core columns left to right: Company | Role | Link | Date found | Source | Status | Next action | Next-action date | Contact | Notes. Freeze the header row so it stays visible as you scroll. Make it bold. That's your skeleton.

Step 3 — Turn Status and Source into dropdowns

This is the single highest-leverage build step. Apply a data-validation dropdown to the Status column containing exactly your status set (Researching, Outreach sent, Applied, Replied, Phone screen, Interview, Final, Offer, Rejected, Withdrawn, Ghosted), and another to Source (Job board, Referral, Recruiter, Company site, Event, Other). Dropdowns do two things: they stop typos that would break your later counting ("Aplied" and "Applied" become two different statuses to a formula), and they make updating a one-tap action instead of a typing chore. Add conditional formatting so each status gets a color — green for Offer, soft red for Rejected — and the whole sheet becomes scannable at a glance.

Step 4 — Add a few rows and feel it work

Don't build in the abstract. Enter the three to five roles you're already chasing right now. The moment you do, two things happen: you discover whether your columns actually fit reality (you usually find one you don't need and one you forgot), and you feel the relief of seeing your real search in one place for the first time. Adjust columns now, while the sheet is small.

Step 5 — Add the dashboard later, not now

Resist building formulas on day one. Get the habit of logging rows solid first, a week of faithful updates, then layer the conversion dashboard on top (we build it in the dashboard section). A dashboard counting an empty or inconsistently-filled sheet is just discouraging noise. Earn it with a week of clean data.

1Createname it plainly+ pin it 2Headerscore columnsfreeze row 1 3Dropdownsstatus + source+ colors 4Add rowsyour real 3–5roles now 5Dashboardadd it later,after a week
Build in this order. The dropdowns in step three are what make the dashboard in step five possible later.

Copy-paste starter template

Here's a ready skeleton. Paste the header line into row 1 of a blank sheet, then use the sample rows as a model for format and tone. The columns are tab-separated so they'll split cleanly into cells in most spreadsheet tools when pasted.

Company	Role	Link	Date found	Source	Status	Next action	Next-action date	Contact	Notes
Northwind	Senior PM	[url]	2026-06-20	Referral	Interview	Prep STAR stories	2026-06-28	Chris (referrer)	Round 2 of 3; loved the team
Lumen DTC	Growth Analyst	[url]	2026-06-22	Job board	Applied	Follow up w/ recruiter	2026-06-27	—	Strong fit; tailored resume v3
Brightline	Support Lead	[url]	2026-06-23	Recruiter	Outreach sent	Second touch	2026-06-30	Sam (recruiter)	Replied warm; awaiting JD
Maple Co	Ops Coordinator	[url]	2026-06-24	Company site	Researching	Find a contact	2026-06-26	—	Excited 4/5; check Glassdoor

And here are the two dropdown lists to paste into your data-validation settings, so your Status and Source columns stay clean and countable:

STATUS (in pipeline order)
Researching, Outreach sent, Applied, Replied, Phone screen,
Interview, Final, Offer, Rejected, Withdrawn, Ghosted

SOURCE
Job board, Referral, Recruiter, Company site, Event, Other

Three formatting habits will keep this template healthy for months. Use ISO dates (YYYY-MM-DD) everywhere so they sort correctly and your formulas can do date math. Keep Next action a verb phrase — "Follow up with recruiter," not "recruiter" — so the cell tells you what to do, not just what exists. And keep Notes short and factual: the name you'll forget, the salary hint, the one impression from the call. The template is deliberately plain. Its power is in being filled, not in being fancy.

Or skip the spreadsheet entirely.

A Marqee strategist runs the whole pipeline for you — finding roles, doing the recruiter outreach, surfacing referrals, and tracking every thread — so you become a marquee candidate instead of a project manager of your own job hunt.

See how it works →

Tracking outreach & referrals — the side door

Here is the part of tracking that most templates ignore, and the part that matters most. The majority of roles are not won by being the best applicant in a public pile. They're won through the side door: a referral from someone inside, a warm introduction to a hiring manager, a recruiter relationship that surfaces a role before it's even posted. If your tracker only records applications, it's measuring the slow, crowded front door and ignoring the fast lane. Track the side door too, and you'll naturally invest more in it — because what gets tracked gets done.

Two ways to weave outreach into the tracker

The lightweight way: use the columns you already have. The Source field already distinguishes a referral from a cold application; the Contact column already names the person; the Status already includes "Outreach sent" as a stage that precedes "Applied." For many searches that's enough — a referral conversation and the role it relates to live in the same row, exactly where you want them.

The thorough way: add a second tab, a People sheet, for relationships that aren't yet tied to a single role. Columns: name, company, how you know them, last contacted, the ask, and the status of the relationship (new, warming, asked, helped). This is where you nurture the second-degree connections and former colleagues who become referrals later. Link a person to a role by putting their name in the main sheet's Contact column. Now your search has two engines, applications and relationships, and both are visible.

People-tab columnExamplePurpose
NameRenata SolbergWho the relationship is with
CompanyNorthwindWhere they can open a door
How you know themFormer colleagueDetermines how warm the ask can be
Last contacted2026-06-21Paces your follow-up so you're neither pushy nor forgotten
The askReferral for Senior PMKeeps the request specific and trackable
Relationship statusAskedNew → Warming → Asked → Helped

Tracking outreach changes behavior in a quiet but profound way. When you can see that you've sent twelve applications this week but only two pieces of warm outreach, the imbalance is obvious, and you'll correct it, because the empty column nags at you. If you want the deeper mechanics of running that side door well, our companion piece on how many jobs to apply to makes the case for fewer applications and more targeted, relationship-led pursuit, and a tracker is what makes that disciplined approach measurable instead of just aspirational.

The relationship-status lifecycle

The People tab is most powerful when you treat each relationship as moving through its own small lifecycle, mirroring the way your role pipeline has stages. A contact starts as New, someone you've identified but not yet reached. They move to Warming once you've had a genuine, low-stakes interaction that isn't an ask: a comment on their work, a useful share, a reconnection note. Only then, when there's real warmth, do they move to Asked, the point at which you make a specific, reasonable request. And finally Helped, when they've acted on your behalf, which is the moment to thank them concretely and note how you might reciprocate. Tracking this lifecycle stops the single most common networking error: jumping straight from "New" to a cold "Asked" with no warming in between, which is the relationship equivalent of proposing on a first date.

Seeing your contacts arranged by relationship status also keeps you in the warming work that's easy to neglect. Asks are memorable and warming is forgettable, so without tracking, people drift toward making asks of contacts who aren't ready and neglecting the patient relationship-building that makes future asks land. A column that shows you have eight contacts stuck at "New" and none being warmed is a nudge to do the unglamorous, compounding work that the side door actually runs on.

Logging what you actually said

A small but high-value habit: in the Notes for each contact or outreach thread, jot a few words on what you actually said and what they said back. Not a transcript, just enough that when you follow up two weeks later, you can reference the specific thing you discussed rather than sending a generic "just checking in." "Mentioned her team's expansion into the EU; she said hiring picks up in Q3" is the kind of note that lets a follow-up feel like a continuation of a real conversation rather than a cold nudge. This is the texture that distinguishes outreach that builds a relationship from outreach that merely pesters one, and it's nearly impossible to do well from memory across dozens of threads.

Front door — public posting you, one of hundreds — slow, crowded Side door — referral & outreach you ref tracked contact opens the door — fast, warm hiringmgr hiringmgr
Both doors reach the same hiring manager. A tracker that records outreach and referrals is what keeps you investing in the faster one.

The dashboard & conversion math

Now for the feature that elevates a tracker from a to-do list into a diagnostic instrument. Once you've logged a couple of weeks of activity, build a small dashboard — a handful of cells, usually on a second tab — that counts your pipeline and computes your conversion rates. This is what answers the question every searcher is secretly asking: "Is this working, and if not, where exactly is it breaking?"

The counts to compute

Using a count-if function against your Status column, tally how many rows sit in each stage and each terminal state. Then compute the ratios between stages — these are your conversion rates, and they're the whole diagnostic.

MetricHow to read itHealthy-ish signal
Active pipeline countRows in live stages (Researching → Offer)Enough to not pin hopes on one role; ~10–20 quality roles
Application → reply rateReplies ÷ applicationsIf very low, suspect resume/targeting or channel
Reply → interview rateInterviews ÷ repliesIf low, suspect the phone screen or fit framing
Interview → offer rateOffers ÷ interviewsIf low, suspect interview prep and storytelling
Outreach → reply rateWarm replies ÷ outreach sentIf low, suspect message quality or targeting
Ghost rateGhosted ÷ everything that reached a humanHigh = follow-up gaps or weak interest signals

A few formulas to copy

Assuming your Status values live in column F starting at row 2, these patterns work in common spreadsheet tools:

Applied count        =COUNTIF(F:F,"Applied")
Replied count        =COUNTIF(F:F,"Replied")
Interviews (≥screen) =COUNTIF(F:F,"Phone screen")+COUNTIF(F:F,"Interview")
                      +COUNTIF(F:F,"Final")+COUNTIF(F:F,"Offer")
Offers               =COUNTIF(F:F,"Offer")

Apply→reply rate     =Replied / Applied
Interview→offer rate =Offers / Interviews
Due this week        =COUNTIFS(H:H,">="&TODAY(),H:H,"<="&TODAY()+7)
Overdue actions      =COUNTIF(H:H,"<"&TODAY())

That last pair, "due this week" and "overdue actions," is worth its weight in gold. A single cell that shows you have three overdue follow-ups turns a vague guilt into a concrete, finishable task list. Many people add a conditional-formatting rule that turns the Next-action-date cell red when it's in the past, so overdue rows glow at them the moment they open the sheet.

Reading rates, not raw counts

The single most important habit in reading your dashboard is to look at rates between stages rather than raw counts at any one stage. A raw count is almost meaningless on its own. "I've applied to forty roles" tells you nothing about whether your search is working — forty applications with twelve replies is a strong, well-targeted search, while forty applications with zero replies is a flashing red warning that something upstream is broken. The number forty is identical in both; only the rate distinguishes a healthy search from a stuck one. Train yourself to read your dashboard as a series of ratios, what fraction advanced from each stage to the next, and the diagnosis becomes obvious.

This reframing also rescues you from a demoralizing trap. When you stare at raw counts, a slow search looks like failure: "forty applications and only one offer." But when you read the rates, the same data might reveal that you're actually converting beautifully at every early stage and simply need a little more volume in the pipeline, or that one specific late stage is the only leak. Rates turn a wall of discouraging numbers into a precise, almost clinical readout of what's working and what isn't. They replace despair with a diagnosis, and a diagnosis you can act on.

How much data before the numbers mean anything?

A fair caution: conversion rates need a minimum amount of data before they're trustworthy. If you've sent three applications and gotten one reply, your "33% reply rate" is noise — one more reply or one less would swing it wildly. Treat your rates as rough directional signals until you have a reasonable sample: roughly ten or more data points at the stage you're examining. Below that, read the dashboard for the obvious — overdue actions, pipeline size, glaring zeros — and hold off on over-interpreting precise percentages. The funnel becomes a reliable instrument once a few weeks of activity have accumulated; before that, it's still useful for keeping things moving, just not yet for fine diagnosis. The trap to avoid is making a dramatic strategic change, "I'm going to completely rewrite my resume," on the strength of five data points. Let the sample build first.

Your conversion funnel (example) Applications40 Replies30% of applications Int.5 — 42% of replies (healthy) 1 offer — 20% of interviews Bottleneck: interview → offerapplications convert fine; fix interview prep, not the resume
The funnel reads itself: when the early steps convert well and the last step doesn't, the fix is interview preparation — not more applications.
Key takeaway. Conversion rates between stages are the diagnostic. A wide drop at one specific step tells you exactly where to invest — and saves you from "fixing" the part of your search that was already working.

Diagnosing a stuck search from the numbers

This is where the tracker pays you back for every minute you put in. "My job search isn't working" is not actionable. But your tracker can translate that feeling into one of a few specific, very fixable problems. Here's how to read the pattern.

Pattern 1 — Lots of applications, almost no replies

If you've applied to thirty roles and heard back from one or two, the breakdown is at the very top of the funnel. The likely culprits, in order: your resume isn't landing for these roles, you're applying to roles you don't genuinely fit, or you're relying entirely on the crowded front door. The fixes are upstream — sharpen and tailor the resume, tighten your targeting, and crucially, add warm outreach so you're not invisible in a pile. A tracker that also logs your Source will often reveal that your one reply came from a referral, which tells you exactly where to spend more energy.

Pattern 2 — Good replies, but they stall before interviews

If recruiters reply and have a first call, but it rarely advances to a real interview, the leak is at the screen. Often it's a misalignment surfacing on the call — salary expectations, location, level — or a phone-screen presentation that isn't landing. This is a conversation problem, not a paper problem, and it's very coachable.

Pattern 3 — Plenty of interviews, no offers

This is the most frustrating pattern and, paradoxically, the best news: everything upstream is working. Your resume, targeting, and outreach are all good enough to get you in the room repeatedly. The leak is the interview itself — usually storytelling, structure, or how you handle specific question types. Don't touch your resume; it's fine. Pour your energy into interview preparation and practice.

Pattern 4 — A healthy-looking pipeline that never closes

Sometimes every stage looks reasonable but nothing reaches an offer, and the tracker reveals why: half your "active" rows are actually ghosted or stale, propped up by follow-ups you never sent. The fix is the discipline of the next section: honest statuses and a real follow-up cadence.

What the numbers showThe likely problemWhere to focus
Many applications, few repliesTop-of-funnel: resume, targeting, or channelTailor the resume; add warm outreach & referrals
Replies that don't reach interviewsScreen-stage misalignment or presentationPhone-screen prep; clarify fit early
Interviews but no offersInterview execution, not materialsStorytelling and structured interview practice
Big pipeline, nothing closesStale rows & missed follow-upsHonest statuses; a real follow-up cadence

Pattern 5 — A pipeline that's too small to diagnose

One more pattern deserves its own mention, because it masquerades as the others. Sometimes the tracker shows poor conversion everywhere, and the real problem is simply that the pipeline is too thin to read. With only four live roles, a single rejection feels like a catastrophic conversion collapse when it's just normal variance. If your active pipeline is consistently down to a handful of roles, the first fix isn't to optimize conversion; it's to widen the top of the funnel with more quality opportunities and outreach, so the numbers become meaningful and so you're never emotionally pinned to one or two hopes. A search living on three roles is fragile in a way no amount of conversion tuning can fix. Build pipeline depth first, then diagnose.

The danger of fixing the wrong thing

The reason this diagnostic discipline matters so much is that, without it, people reliably fix the wrong part of their search, usually the most visible part, the resume, regardless of what's actually broken. Someone getting plenty of interviews but no offers will spend a weekend agonizing over resume bullet points, when their resume is demonstrably working (it's getting them into rooms) and their interview performance is the real leak. Someone getting no replies at all will obsess over interview answers they're never getting the chance to give. The tracker's funnel cuts through this misdirected effort with cold clarity: it points at the one stage where candidates are actually being lost and tells you to spend your limited energy precisely there. Effort aimed at the real bottleneck is worth ten times the same effort sprayed across a search at random.

For a deeper treatment of each leak and how to read the full set of search metrics, not just counts but rates and trends over time, see our dedicated guide to job-search metrics. The tracker is what generates those numbers; that guide is how you interpret them at depth.

The weekly maintenance routine

A tracker is only as useful as it is current. A sheet you updated enthusiastically for four days and then abandoned is worse than no tracker, because it lies to you. The solution is a two-tier rhythm: tiny real-time touches, and one structured weekly review. Together they keep the tracker trustworthy for the length of an entire search without ever becoming a burden.

The real-time touch (under a minute, whenever something happens)

The instant anything moves — you apply, you get a reply, you book a call, you send outreach — open the tracker and update that one row. Change the status, set the next action and its date, drop one note. Under sixty seconds. The discipline here is immediacy: if you tell yourself you'll log it later, "later" is where follow-ups go to die. Make the tracker the reflexive last step of every job-search action, the way you'd reflexively save a document.

The weekly review (about 30 minutes, same time each week)

Block thirty minutes at a fixed time, and many people pick a calm slot like Friday afternoon or Sunday evening, then run the same checklist every week:

  1. Clear the overdue. Sort by next-action date. Handle or reschedule everything that's due or overdue. This alone prevents the dropped-follow-up loss.
  2. Advance or retire stale rows. Any row untouched for two weeks gets a decision: nudge it, or move it to Ghosted/Withdrawn. Keep the pipeline honest.
  3. Read your dashboard. Glance at your counts and conversion rates. Has anything shifted? Is one stage clogging?
  4. Top up the pipeline. If your active count has dropped, add new quality roles and outreach so you're never down to a single hope.
  5. Plan the week's actions. Decide the handful of moves that matter most in the coming week, and set their dates.
Daily touches<1 min, as it happens Weekly review — 30 min, same time 1 · Clear overdue actions 2 · Retire / advance stale rows 3 · Read the dashboard 4 · Top up the pipeline 5 · Plan the week's moves …and the loop repeats, keeping the tracker always current
Two tiers keep the tracker alive: under-a-minute daily touches, plus one fixed 30-minute weekly review that loops back into the week.

Making the habit stick

The maintenance routine is simple to describe and genuinely hard to sustain, not because it's difficult, but because it competes with the emotional reality of a job search, where some weeks you'd rather not look at the tracker at all. A few small design choices make the habit far more durable. First, anchor the weekly review to something you already do reliably: right after a standing Friday meeting, with your Sunday-evening coffee, immediately after a recurring workout. Habits attach most easily to existing habits. Second, keep the review genuinely short — thirty minutes, capped — because a review that sprawls into two hours is one you'll start dreading and skipping. Third, lower the stakes of the daily touch by making it absurdly easy: the tracker pinned and one tap from open, the status as a dropdown rather than typed text, so logging is a reflex rather than a task.

It also helps to forgive yourself the occasional miss without abandoning the system. If you skip a weekly review during a hard week, don't conclude the tracker has failed and walk away. Just open it at the next opportunity, spend a few extra minutes catching up the stale rows, and continue. The goal isn't a perfect, unbroken streak; it's a tracker that's trustworthy most of the time and easy to bring back to current when it drifts. A system that survives your bad weeks is infinitely more valuable than a pristine one you abandon the first time life interrupts it.

Key takeaway. Immediacy plus a fixed weekly slot is the whole maintenance secret. Log the moment it happens; review the same time every week. A current tracker is a trustworthy tracker, and one you can bring back to current after a missed week is better than a perfect one you abandon.

The next-action discipline

If you take one habit from this entire guide, make it this: every live row always has a next action and a date. A row with a blank next-action field is a silent leak, a role drifting with no one steering it. The discipline is simple to state and transformative in practice: whenever you finish an action on a role, immediately define the next one before you close the sheet. Sent the application? Next action: "follow up with recruiter," dated five business days out. Finished an interview? Next action: "send thank-you," dated today; then "follow up if no word," dated a week out.

This single rule is what converts a passive list into an active system. It means you never have to wonder "what should I be doing about Northwind?" because the row already tells you, with a date attached. And when you sort the whole tracker by next-action date, your entire search reorganizes itself into a clean, prioritized to-do list: everything due today and this week floats to the top, and you simply work down it. The anxiety of an unbounded search ("I should be doing… something?") dissolves into a finite, finishable list.

A good next action has three properties. It's a verb ("Follow up," "Send portfolio," "Prep STAR stories"), not a noun. It's specific enough to do without re-deciding ("Email Sam to ask about timeline," not "deal with Brightline"). And it has a real date, even if that date is "a week from now to follow up." Timing matters more than people think — a thoughtful follow-up sent at the right interval is the difference between staying top-of-mind and being forgotten. If you're unsure how to pace those nudges so you're persistent without being a pest, your tracker's dates plus a sensible cadence are the answer; the warm-but-not-annoying rhythm is a craft worth getting right.

Pitfall: the blank next-action field. A live row with no next action is a role you've silently abandoned. At your weekly review, scan for empty next-action cells the way you'd scan for a fire — each one is an opportunity quietly slipping away. Fill it or retire the row; never leave it hanging.

Sorting the search into a single to-do list

The quiet magic of the next-action discipline is what it lets you do at the start of any working session: sort the entire tracker by next-action date and let the search organize itself. Suddenly you're not staring at a list of companies wondering where to begin — you're looking at a clean, dated queue. Everything overdue sits at the top in red; today's actions come next; the rest recede into the future where they belong. You work down from the top until your time runs out, and whatever you don't reach is already scheduled. There's no decision fatigue, no paralysis about priorities, no nagging sense that you've forgotten something — the sort has done the prioritizing for you. This is the moment a tracker stops feeling like record-keeping and starts feeling like a co-pilot.

It also fixes the peculiar paralysis of an open-ended search. The reason a job hunt feels so heavy is that it has no natural edges — there's always more you could do, which curdles into a sense that you should be doing everything all the time, which produces the guilt of never doing enough. A dated next-action list draws a bright line around the work: these are the moves that matter today, and when you've done them, you're genuinely done for the day. You're allowed to close the laptop. That permission — to have a finite, finishable day inside an open-ended search — is one of the most underrated benefits of running the whole thing through a tracker.

Pacing follow-ups so you're persistent, not a pest

The dates you attach to next actions are also how you solve the perennial follow-up anxiety: how long is too long to wait, and how often is too often to nudge? The tracker turns this fraught judgment into a simple rule you set once. A common, sensible rhythm: after applying, wait about five to seven business days before a first follow-up; after a good conversation, follow up within a day with thanks and then again after a week or so if you've heard nothing; and as a general matter, no more than one nudge per week on any single thread. The exact numbers matter less than having them encoded as dates in the tracker, so that following up becomes a scheduled action rather than an anxious 2 a.m. debate about whether enough time has passed. Persistence executed on a calm cadence reads as professional interest; the same persistence executed on impulse reads as desperation. The tracker is what keeps you on the right side of that line.

Confidential searches while employed

If you're searching while still employed — and many of the most effective searches happen exactly this way, calmly, from a position of strength — the tracker is not just a productivity tool. It's a discretion tool. A careful, low-noise search has more moving parts than an open one (you're juggling timing, confidentiality, and your current job), which makes a single private source of truth even more valuable. But it has to be built with privacy as a first principle.

  • Personal account, personal device. Build the tracker in a personal cloud or local account, never your work one, and update it on a personal device. A work laptop and work email are visible to your employer in ways you may not control. This is the non-negotiable rule.
  • Keep the file private, not link-shared. Don't share it by an open link or store it where colleagues can stumble across it. A confidential search leaks through carelessness, not malice.
  • Name it innocuously. "2026 planning" or "personal budget," not "JOB SEARCH 🚀." A glance over your shoulder shouldn't give you away.
  • Log to personal contact channels. Record recruiter and referrer conversations that happen through your personal email and phone, and note in the tracker which channel each thread is on, so nothing accidentally routes through work.
  • Track your discretion signals. Add a small note when you've taken a confidentiality step — asked a recruiter to keep it quiet, marked yourself open only to recruiters and not publicly. The tracker becomes a record that you ran a careful process.

Used this way, the tracker actively protects you: it lets you run a deliberate, well-paced, confidential search without the slips that happen when everything lives in your head and your work inbox. The discipline of one private system is exactly what keeps a quiet search quiet. For the broader playbook on moving carefully while employed — timing, references, and managing the overlap — pair this with our guide on job searching while employed.

Tracker mistakes that quietly hurt

Most tracker failures aren't dramatic. They're small habits that slowly erode the tracker's trustworthiness until you stop opening it. Here are the ones I see most, and the fix for each.

The mistakeWhy it hurtsThe fix
Over-building on day oneYou maintain instead of search, then quitStart with the nine core columns; add only when you feel the gap
Inconsistent statuses ("aplied," "in prog")Breaks every count and conversion formulaLock Status to a dropdown so values stay clean
Updating "later""Later" never comes; rows go stale and lie to youMake logging the reflexive last step of every action
No next action on live rowsRoles drift with no one steering themEvery live row always carries a verb + a date
Tracking only applicationsIgnores the side door where roles are wonLog outreach, referrals, and contacts too
Hoarding dead rowsA bloated sheet hides the live pipelineArchive terminal rows to a separate tab monthly
Confusing volume with progress100 stalled rows feel like work but aren'tWatch conversion, not raw application count
Building it on a work deviceRisks your confidential searchPersonal account, personal device, private file

The through-line in all of these is the same: a tracker's only real failure mode is becoming untrustworthy. The moment you can't believe what the sheet tells you — because statuses are messy, rows are stale, or half your activity isn't in it — you stop using it, and you're back to running your search from memory. Every rule above exists to keep the tracker honest, because an honest tracker is one you'll keep.

Scaling, archiving & running multiple searches

As a search runs for weeks, your tracker grows, and a little housekeeping keeps it sharp.

Archive terminal rows

Once a row hits Rejected, Withdrawn, or Ghosted and you've extracted any lesson from it, move it to an Archive tab. Don't delete it — the archive is a record you'll mine later (which sources rejected you, what feedback recurred, which roles you withdrew from and why). But getting dead rows out of your main view keeps your live pipeline legible. A monthly sweep during your weekly review is plenty.

Turn rejections into future leads

An archived rejection isn't a dead end; it's a warm contact for next time. The recruiter who passed on you for one role may have a better-fitting one in three months, and the relationship is already started. Keep those names in your People tab with a note. A "no" tracked well becomes a "not yet."

If you're running more than one kind of search

Some people search across two distinct tracks, say two different role types or two industries during a pivot. Resist the urge to split into two files; one tracker with a "track" column you can filter by keeps everything in a single source of truth while still letting you analyze each path separately. The whole value of a tracker is consolidation; don't fragment it.

Hand-off readiness

A well-kept tracker has a quiet superpower: it makes your search legible to anyone helping you. A mentor, a friend who offers to make introductions, or a professional strategist can look at one clean sheet and instantly understand your whole pipeline, your bottleneck, and where they can help. A search trapped in your head can't be helped; a search in a clean tracker can be amplified.

Become a marquee candidate.

You've now got the full system. If you'd rather have a real expert run the pipeline — finding the roles, doing the recruiter outreach, surfacing referrals through the side door, and keeping every thread on track — that's exactly what Marqee does. You stay the candidate; we run the search.

See plans →

Beyond the tracker: who actually runs it

Here's the honest truth a guide like this should end on. A tracker is a phenomenal tool, and building one is one of the highest-leverage hours you can spend on your search. But a tool is only as good as the hands that keep it. The tracker doesn't write the tailored resume, send the outreach, build the referral relationship, or prepare the interview story. It tells you what to do and whether it's working, but you still have to do all of it, week after week, often while holding down a job and managing the emotional weather of a search.

That's the real reason the tracker matters so much: it makes the work visible, and visible work is work you can either do with discipline or delegate. When the entire pipeline lives in one clean system — every role, every contact, every next action, every conversion rate — it becomes possible for someone to run it with you or for you. At Marqee, that's the model: a real human strategist who keeps the pipeline full, does the recruiter outreach, surfaces the referrals through the side door, tailors the materials, and tracks every thread so nothing slips, while you stay the marquee candidate at the center of it, getting top billing with the people who hire. The tracker you've just learned to build is, in effect, the cockpit of that whole operation.

Run it yourself or have it run for you; the principle is the same. A search held in your head is a search at the mercy of memory and mood. A search held in a clean, honest, current tracker is a search you can steer, calmly, measurably, and all the way to an offer. Build the tracker. Keep it honest. Let it tell you the truth. And spend the energy you save on becoming the kind of candidate people remember.

To go deeper on any piece of this, our resources library covers the whole search end to end — from the system around the tracker in organizing your job search, to reading your search metrics, to running a careful confidential search while employed. And the strategist behind this guide, Marqee Editorial, has spent fifteen years building exactly these systems for people working through layoffs, pivots, and quiet moves.

Frequently asked questions

A job-search tracker is a single document, usually a spreadsheet or a board, that records every role you're pursuing and the exact state of each one: when you found it, who you've contacted, where the application stands, and what you owe next. It replaces scattered tabs, screenshots and memory with one source of truth you can scan in seconds.

A plain spreadsheet wins for most people. It's free, private, infinitely customizable, works offline, and lets you build your own formulas and dashboard. Dedicated apps and browser extensions can save typing, but you trade control and portability for convenience. Start in a spreadsheet; switch only if a specific feature genuinely saves you time.

At minimum: company, role, link, date found, source, status, next action, next-action date, and a notes field. Most people then add a contact name, an excitement or fit score, salary range, and the dates of each application and interview. Keep the core set tight enough that you'll actually fill it in.

A clean pipeline runs: Researching, Outreach sent, Applied, Replied, Phone screen, Interview, Final, Offer — plus the terminal states Rejected, Withdrawn, and Ghosted. The point is that every row sits in exactly one stage, so you can see your whole search at a glance and spot where things stall.

Touch it the moment anything happens, logging an application or reply in under a minute, and hold one fuller weekly review of about thirty minutes to advance stale rows, schedule follow-ups, and read your numbers. Daily micro-updates plus a weekly review keeps the tracker trustworthy without becoming a second job.

Quality beats volume. Most effective searches keep ten to twenty live, genuinely-fitting opportunities in active stages rather than a hundred low-effort applications. A tracker makes this visible: if your pipeline is huge but stalled, the problem is conversion, not volume.

Yes — that's its second job. By counting how many applications become replies, how many replies become interviews, and how many interviews become offers, a tracker turns a vague feeling of being stuck into a specific bottleneck you can fix: a resume problem, an outreach problem, or an interview problem.

Track outreach and referrals right alongside applications, because the warm, side-door path is where many roles are actually won. Add a contact column and an outreach-date column to your main sheet, or keep a linked second tab for people, so a referral conversation and the role it relates to live in one view.

Build the tracker in a personal account on a personal device, never your work laptop or work email. Keep the file private rather than shared by link, name it something dull, and log outreach to personal addresses. The tracker itself is a discretion tool: it lets you run a careful, low-noise search without slipping.

Even a five-role search benefits, because the cost of a dropped follow-up — a recruiter who liked you, never heard back, and moved on — is high and invisible without one. A tracker takes minutes to start and immediately frees the mental energy you were spending trying to remember everything.