Why a spreadsheet beats your inbox
By the time you've applied to fifteen companies, "I'll just remember" stops working. You forget which recruiter you already followed up with, whether the online assessment had a deadline, and what you even said in your cover letter for the company that's now calling you back. A tracker isn't organization for its own sake. It's the difference between sounding prepared on a callback and stalling for ten seconds while you scroll through old emails.
The five columns that actually matter
Skip the templates with twenty columns for "notes," "priority," and "excitement level." You'll fill those in for the first three rows and never touch them again. Use these five instead:
- Company & role: the exact title, not "SWE intern" for three different postings
- Date applied: so you know when two weeks of silence becomes a real follow-up
- Status: Applied, OA, Phone Screen, Onsite/Final, Offer, Rejected, Withdrew
- Last contact: the date of your most recent email, call, or interview
- Next action: what you're doing next and by when, e.g. "follow up Thu if no reply"
| Company & Role | Applied | Status | Last Contact | Next Action |
|---|---|---|---|---|
| Datadog: SWE Intern | Jun 2 | Phone Screen | Jun 14 | Prep system design, interview Jun 18 |
| Capital One: Data Analyst Intern | Jun 5 | Applied | Jun 5 | Follow up Jun 19 if no response |
| Notion: Product Intern | May 28 | Rejected | Jun 10 | – |
The follow-up rule that gets replies
Two weeks of silence after applying isn't a rejection. It's a queue. Set a recurring reminder: if it's been twelve business days since you applied and you haven't heard anything, send a two-line email to the recruiter, not the hiring manager, restating your interest and asking for a timeline update. Log the date you sent it under "Last Contact" so you don't accidentally send two in one week.
The two-minute rule
Update the tracker the moment something changes: right after the email, right after the call ends. Wait until "later" and you'll spend fifteen minutes reconstructing what happened instead of two seconds logging it.
What "Status" actually means
- Applied: submitted, no response yet
- OA: completing or waiting on an online assessment
- Phone Screen: first live conversation, usually with a recruiter or one engineer
- Onsite/Final: the last round before a decision
- Offer: you have something in hand
- Rejected / Withdrew: closed, but keep the row. It's data for next cycle: which companies moved fast, which ghosted entirely.
Build it in five minutes
Open a spreadsheet, name two tabs "Active" and "Closed," add the five columns above as headers, freeze the top row, and color-code Status so "Offer" turns green and "Rejected" turns gray. That's it. Don't spend an hour customizing colors before you've applied anywhere.