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
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
| Column | What to put in it |
|---|---|
| Company | Name of the employer |
| Role | Exact job title from the ad |
| Link | The job ad. Save a copy or screenshot too; ads disappear |
| Source | Career page, LinkedIn, referral, recruiter, campus, job site |
| Date applied | The day you submitted |
| Resume version | File name of the resume you sent, for example "Data-Analyst-v3" |
| Stage | One value from a dropdown (next section) |
| Next action | "Follow up", "Prepare case study", "Send references" |
| Next action date | When to do it |
| Contact | Recruiter or referrer name and email or LinkedIn |
| Notes | Salary 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.
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
- Sort by next action date and do everything that is due: follow-ups, thank-you emails, preparation.
- Close applications with no reply about three weeks after your second follow-up. Templates: how to follow up on a job application.
- Add new applications with the resume version you used.
- 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 see | Likely cause | What to change |
|---|---|---|
| Almost no replies | The resume does not match the ads, or the roles are a stretch | Tailor each resume to the ad's words (how), check ATS keywords, apply to roles closer to your level |
| Replies, but you fail screening tests | A skill gap the ads test | Practise the test type; build one project in the tested skill |
| Interviews, but no offers | Interview answers or fit | Prepare STAR stories, do mock interviews (common questions), ask for feedback |
| One source works much better | Referrals and direct applications often do | Spend more time on that source, for example asking for referrals |
| One resume version gets more replies | Its wording or order matches the ads better | Use 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.
Add LinkedInRank as a preferred source on Google
See our new LinkedIn guides first in Google results.