Job Search Tracker: Fields, Scores and Follow-Ups

About six applications for one interview. In a U.S. analysis of Current Population Survey data from May and September 2018, the Bureau of Labor Statistics found that jobseekers needed approximately that many applications per interview, while those with at least one interview had about a 37% probability of receiving an offer, compared with roughly 10% for those without interviews.

A job search tracker should expose those transitions, not reward you for collecting listings. Its most useful job is deciding whether silence deserves a follow-up, whether a listing is dead, or whether another application would waste your time.

Fields and Statuses That Show the Funnel

Build the tracker around decisions. Each row should connect an opening, your eligibility, the work you put into applying, and the employer’s response.

Start with the fields below. Splitting company from role and next action from its date gives you fifteen spreadsheet columns without turning the sheet into a database project.

Tracker fields and what each one decides

Saved isn’t Applied. Screen means an initial recruiter conversation; Interview means an assessment or substantive hiring conversation. Keep those definitions stable so your weekly counts mean something.

Keep eligibility separate from progress

A remote label doesn’t establish access. Read the country restriction, employment arrangement and attendance requirement before assigning a location rule.

For visa-dependent searches, start with visa-sponsorship openings and record the employer’s actual wording. A sponsorship track record supports Likely, not Stated, and neither guarantees that this particular opening qualifies.

For cap-subject U.S. searches, add a registration field with Registered, Selected, Not selected or Unable to proceed. USCIS reported 470,342 eligible registrations and 135,137 selected registrations for FY2025, approximately 28.7%, on its H-1B electronic registration process page. That’s a registration selection measure, not an individual’s visa approval probability.

Keep employer sponsorship confirmation and petition progress in the row’s notes. An employer saying yes to sponsorship isn’t the same event as immigration approval.

Counting rule: A board discovery, an employer-site submission and a recruiter message can belong to the same opening. Record them as touches on the existing row, not separate applications.

How to Set Up the Tracker in One Session

Build the structure before importing your entire search history. A useful tracker is quick to update while the application confirmation is still on screen.

The setup should leave you with a working daily view, not a collection of empty dashboards.

Build the working file

1. Choose one home. Use Google Sheets when formulas and charts matter most, Notion when you work through a board, or Airtable when employer records need to connect to several roles. Don’t build parallel versions to test them during an active search.

2. Paste the columns and freeze the header. Keep company, role, stage and next action visible without scrolling across the whole file. Wrap long titles, but keep notes out of the status column.

3. Add dropdowns. Stage, location rule and sponsorship signal need controlled values. Otherwise, Applied, Application sent and Submitted become different categories when you count them.

4. Require posting and discovery dates. Approximately 41% of applications arrived within 48 hours of posting and 56% within 96 hours in the online hiring study described by the Federal Reserve Bank of St. Louis. Those figures describe application timing, not a guaranteed advantage from applying early. The dates let you distinguish late discovery from slow preparation.

5. Assign the next action immediately. Choose Apply, Follow up or Close and give it a date. If you’re waiting for a promised update, use that date rather than an arbitrary reminder.

6. Create three views only. Active shows unfinished opportunities. Due today shows dated actions requiring attention. Closed this month preserves outcomes for review without cluttering the working queue.

7. Backfill the ten roles already in flight. Include rejections and unanswered applications, not just promising interviews. This is a practical starting batch, not a statistical sample.

Make dates usable across regions

Use the employer’s local date when the posting supplies one. For interviews and hard deadlines, store the time zone explicitly and create a calendar event in your own zone.

If the employer doesn’t publish a posting date, record Not shown rather than guessing from a board’s refreshed label. Your date-found field still tells you when the opportunity entered your search.

Keep the source as the discovery channel. A role found through a referral remains a referral-sourced opportunity even if the application form lives in Workday.

Stop configuring when you can log a straightforward opening, its score and its next action in under a minute. That’s a workflow target, not a reason to skip eligibility checks.

Use conditional formatting for overdue dates and missing actions. Decorative company logos and elaborate stage colors can wait; neither helps you decide what to do this morning.

Sample Row and Template to Copy

Test the layout with a hypothetical opening before adding real applications. Say Northwind Analytics advertises a Data Analyst role restricted to EU-based candidates, and you submit after checking the location requirement.

Paste this header into the sheet:

Company | Role | Source | URL | Date posted | Date found | Date applied | Location rule | Sponsorship signal | Stage | Next action | Next date | Fit score | Minutes | Outcome

A hypothetical filled row

These are illustrative dates, scores and effort, not an actual vacancy or a forecast. The follow-up date is a placeholder to test the view; set real reminders using the employer’s timeline and your stopping rule.

Before attaching a resume, check destination-specific presentation choices. AiHeadshots’ 2026 resume photo rules can help you decide whether a photo belongs in the version you’re preparing.

Filter Next date to today to create Due today. For daily use, include overdue actions too, so an unfinished task doesn’t disappear overnight.

• Keep touches together. Append a dated follow-up note to the existing record.
• Close cleanly. Clear Next action when the opportunity closes, but retain its outcome.
• Audit open rows weekly. A missing next date means you’ve left the decision unfinished.

Score Each Role Before You Spend Time

5.8% versus 3.73%. Resumes customized for each role converted to interviews, offers or hires at those rates, compared with resumes that weren’t customized, according to Huntr’s 2025 annual job-search report.

Use that difference to justify selective tailoring, not a rewrite for every opening. The comparison doesn’t prove that customization caused the higher rate. A strong application still needs to justify the time it takes.

Priority points before you tailor an application

Use this editorial scoring system to allocate effort consistently. It is not a validated prediction model, so adjust it as your own application results come in.

For source scoring, give full points to your strongest established channel, middle points to mixed results, and minimal points to channels that persistently produce silence. If you lack a comparable reply-rate baseline, use a neutral provisional score rather than an unrelated conversion measure.

If you don’t need sponsorship, award the clarity points when your work authorization and the employer’s hiring arrangement are confirmed compatible. Don’t penalize an otherwise eligible domestic application for lacking visa language.

Set a time budget before opening the form

Compare openings within one role family. A familiar title can conceal different seniority, licensing or domain requirements. Use a role-based jobs directory to keep that comparison focused.

Tailoring means emphasizing relevant accomplishments, skills and terminology you can substantiate. It doesn’t mean inventing experience or redesigning your resume.

Use these recommended cutoffs:

• 60 or higher, gate passed: Prepare a targeted application.
• 40–59, gate passed: Use an existing, appropriate resume without a substantial rewrite.
• Under 40 or gate failed: Skip, unless you can resolve a specific eligibility question quickly.

Record the minutes spent, including time on abandoned forms. At your monthly review, compare interviews per hour with interviews per application. Raise the cutoff if high-scoring applications consume time without producing better progress.

Follow Up Drop or Keep Waiting

59.0% of surveyed jobseekers named employer ghosting as a leading challenge, while 39.3% cited fake, outdated or never-intended-to-be-filled postings, according to iHire’s 2025 recruiting report.

Silence deserves a classification, not an endless reminder. Your response should depend on whether the opening still exists, whether a person has engaged, and whether the channel produces useful replies.

Separate waiting from a dead opportunity

Application silence means you submitted, the listing appears open and no human has responded. Send a short note if there’s a legitimate hiring contact, then stop chasing.

Likely stale means you have evidence that the listing is closed or unreliable. An expired employer page is useful evidence; a repeated board listing alone isn’t proof of fraud.

Active process means a recruiter or hiring manager has engaged and supplied a next step. Their promised update date should control your reminder.

When to follow up and when to stop

These are recommended operating limits, not universal employer response deadlines.

Stale is your operational decision to stop spending time, not proof that the employer rejected you. Retain No reply as the outcome reason, and reopen the row if a genuine response arrives.

A follow-up can be brief: identify the role, confirm continued interest and ask whether the hiring timeline is still active. Don’t send another resume unless something material changed.

One unanswered application doesn’t establish a bad channel. Repeated silence across eligible, relevant applications is a reason to move effort, not polish the same follow-up again.

Compare channels using the same measure. A human reply, an interview and an offer are different outcomes; don’t rank one source’s interview rate against another source’s acknowledgment emails.

Where to Keep the Tracker and What Syncs

One writable home. Everything else is an input. Google Sheets is the default recommendation when you need transparent formulas, fast edits and charts beside the application rows.

Notion and Airtable can work better for different working habits. Switching tools won’t fix missing next actions or inconsistent stage definitions.

Which tool holds the tracker

Don’t choose a tool on the assumption that every alert or database automation is included. Test the exact reminder you need before moving your pipeline.

A board is useful when you think in stages. A sheet is better when you want to inspect the score calculation or compare source performance without configuring relationships.

Keep supporting material outside the status fields

Interview preparation can include screenshots, company notes and visual references. If you prefer to capture notes and media visually, Walling can serve as a supporting workspace while the tracker retains the action date and stage.

Link that material from the relevant row. Don’t copy your entire pipeline into the notes workspace and create another version to maintain.

Employer portals aren’t your search record. Their candidate-facing views don’t give you a dependable place for your own fit score, eligibility assessment and follow-up deadline, and they omit opportunities you haven’t submitted.

• Update when you act. Paste the submission date or employer response into the home file immediately.
• Prefer one-way movement. An export or simple automation is easier to audit than bidirectional stage synchronization.
• Limit access. Give mentors and career coaches a filtered, view-only version, with comments where useful.

If Due today takes a navigation exercise to reach, simplify the workspace. The best home is the one you’ll open before checking another board.

Read the Weekly Numbers and Change the Mix

Reserve twenty minutes for a weekly review. That’s a recommended time budget, not an invitation to build another reporting system.

Use four metrics, calculated from consistent groups of applications. Don’t compare applications submitted yesterday with older applications that have had time to receive responses.

• Applications to interviews. Unique openings reaching Interview divided by submitted openings.
• Interviews to offers. Openings producing offers divided by openings reaching Interview.
• Follow-up window share. Unresolved submitted rows still inside your chosen waiting period divided by unresolved submitted rows.
• Interviews per hour. Interviews divided by logged application hours, split between high-priority rows and the rest.

Split source performance by location eligibility

Fully remote roles accounted for around 8% of U.S. postings but attracted approximately 43% of LinkedIn applications, according to the 2024 LinkedIn Economic Graph summary. Don’t treat a worldwide opening and a country-only remote opening as interchangeable opportunities.

Chart source beside location rule. If most unanswered applications were geographically inaccessible, change the filter before changing the resume.

High application volume with few interviews points toward fit, eligibility, materials or sourcing. Interviews without offers call for closer attention to the conversations, assessments and role expectations.

Move next week’s effort toward sources and location rules producing interviews. Retire channels that remain unproductive after a meaningful review, rather than treating the latest result as certainty.

Build a weekly bar chart of applications, screens and interviews. Add a line chart of interviews per ten applications, split by location rule, and keep both beside Due today.

Use application-date cohorts when interpreting conversion, and distinguish event counts from cohort outcomes. A screen this week may belong to an application submitted earlier.

Feed the Tracker from Ranked Saves

The tracker becomes useful sooner when discovery produces qualified candidates for the sheet, not another unranked reading list. Add your resume once in JobGlance; our Smart Match ranks listings with a 0–100 score against the actual experience in your resume.

Run the search with the visa or work-from-anywhere filter you need. Use the remote jobs directory to narrow discovery, then confirm each employer’s location wording before transferring a role.

Transfer decisions, not just bookmarks

Our Chrome extension collects job data only on LinkedIn, Glassdoor, Indeed, Wellfound, JobStreet, WeWorkRemotely, WorkingNomads and Jobspresso. Its saved pipeline stays in the browser, so transfer anything you intend to pursue into your chosen system of record.

Keep the resume-match score separate from your full priority score. Match contributes to fit; it doesn’t establish work authorization, listing freshness or employer responsiveness.

• Copy the essentials. Transfer the URL, date found, location rule and sponsorship signal alongside the score.
• Check the application document. Review what makes a resume ATS-friendly before marking your version ready.
• Verify sponsorship wording. Understand what visa sponsorship involves before treating an employer signal as confirmation.

Our Career Gap Analysis shows gaps across all saved jobs. Use recurring requirements to choose a focused resume edit or learning priority, rather than reacting to every isolated missing keyword.

Today, upload the resume, run the filtered search and log only eligible roles above your priority cutoff. Give each an action before closing the sheet.

---

JobGlance offers resume-ranked job search, visa and globally remote filters, and saved-job gap analysis to help you decide what deserves a tracker row. Visit JobGlance, run a search against your resume, and bring the eligible matches into your next-action queue.