Skip to main content

Job Application Tracker: Columns, Stages and Weekly Routine

By Bhavishya SinglaUpdated Nov 20263 min read

In short

A job application tracker is one row per application with the company, role, link, date applied, the resume version you sent, the stage, the next action and its date, and the contact person. Use a fixed list of stages (saved, applied, interview, offer, closed) so you can count them. Review it once a week: send follow-ups that are due, close dead applications, and look at where applications stop moving, because that tells you whether to fix your resume, your targeting or your interviews.

On this page
  1. Why track your applications
  2. The columns you need
  3. Stages, and what counts as each one
  4. A 20-minute weekly routine
  5. What your tracker tells you after 30 applications
  6. Spreadsheet or tracker tool?
  7. Questions people ask

Why track your applications

After a dozen applications, people forget which resume went where, miss follow-up dates and cannot tell what is working. A tracker fixes three things:

  • Follow-ups happen. Each row has a next action and a date.
  • You prepare for the right interview. You can see the exact ad and resume you sent when a recruiter calls weeks later.
  • You learn from the numbers. Where applications stop tells you what to change (see the table below).

The columns you need

ColumnWhat to put in it
CompanyName of the employer
RoleExact job title from the ad
LinkThe job ad. Save a copy or screenshot too; ads disappear
SourceCareer page, LinkedIn, referral, recruiter, campus, job site
Date appliedThe day you submitted
Resume versionFile name of the resume you sent, for example "Data-Analyst-v3"
StageOne value from a dropdown (next section)
Next action"Follow up", "Prepare case study", "Send references"
Next action dateWhen to do it
ContactRecruiter or referrer name and email or LinkedIn
NotesSalary range, interview questions asked, what they cared about

Keep it to these. Extra columns tend to stay empty. In Google Sheets or Excel, freeze the header row, make Stage a dropdown (Data, then Data validation) so the labels never vary, and sort by next action date so the most urgent rows sit at the top.

Try it on your profile

The free LinkedIn PDF to Professional Resume Maker applies this in a minute.

Open the tool

Stages, and what counts as each one

  • Saved: you plan to apply. Move it on within a few days or delete it.
  • Applied: submitted, no response yet.
  • Screening: a recruiter call, an online test or an assignment.
  • Interview: any interview with the team or hiring manager.
  • Offer: a verbal or written offer.
  • Closed: rejected, withdrawn, or no response after two follow-ups. Add the reason in Notes.

Counting only works if every row uses exactly these words.

A 20-minute weekly routine

  1. Sort by next action date and do everything that is due: follow-ups, thank-you emails, preparation.
  2. Close applications with no reply about three weeks after your second follow-up. Templates: how to follow up on a job application.
  3. Add new applications with the resume version you used.
  4. Count rows per stage and write the numbers in a small summary at the top of the sheet.

What your tracker tells you after 30 applications

What you seeLikely causeWhat to change
Almost no repliesThe resume does not match the ads, or the roles are a stretchTailor each resume to the ad's words (how), check ATS keywords, apply to roles closer to your level
Replies, but you fail screening testsA skill gap the ads testPractise the test type; build one project in the tested skill
Interviews, but no offersInterview answers or fitPrepare STAR stories, do mock interviews (common questions), ask for feedback
One source works much betterReferrals and direct applications often doSpend more time on that source, for example asking for referrals
One resume version gets more repliesIts wording or order matches the ads betterUse it as the base for the next applications

Recruiters often check your LinkedIn after the resume. If replies are low, run the free LinkedIn profile check to see whether your profile tells the same story.

Spreadsheet or tracker tool?

A spreadsheet is free and flexible, and is enough for most people. Its weak points are reminders and keeping the exact resume next to each row.

If you have a LinkedInRank account, the applications tracker keeps the same stages (saved, applied, interview, offer) with notes and follow-up reminders you can add to Google Calendar, and applications you make from Tailor are saved with the resume and cover letter written for that ad (part of the Job Pack, with a free trial). To build the base resume itself, use the free resume maker.

Questions people ask

What should a job application tracker include?

Company, role, job link, source, date applied, resume version, stage, next action and its date, contact person and notes. Keep the stage to a fixed list so you can count applications at each step.

How do I track job applications in Google Sheets?

Make one row per application with the columns above, freeze the header row, turn the Stage column into a dropdown with data validation, and sort by next action date each week.

When should I mark an application as closed?

When you are rejected, when you withdraw, or when there is no reply about three weeks after your second follow-up.

How many applications should I send per week?

It depends on your field and level. Fewer tailored applications usually do better than many identical ones. Use your tracker to see your reply rate and adjust.

Written by Bhavishya Singla

Founder of LinkedInRank. Writes about how recruiters search LinkedIn and what makes a profile show up.

Google Search

Add LinkedInRank as a preferred source on Google

See our new LinkedIn guides first in Google results.

Keep reading

All guides