Consulting Application Tracker: The Fields That Decide

What firms publish, and what they email you

Bain's digital assessment page is unusually direct about where the deadline lives. It says the deadline for completing the assessment will be provided in the email you receive, and it says that applications will not be considered if the digital assessment is not completed by the deadline. Both halves matter. The date is private, and missing it is fatal rather than costly.

The same page adds two more email-only facts. Which of the two assessments you get is decided after you apply, and you are told by email. In some markets the link arrives within a week of applying, though Bain says timing varies by office and region.

McKinsey describes the same split from the other side. Its interviewing page states that your interview experience will differ depending on the role for which you apply, that all candidates have at least one individual interview and the number of colleagues you meet will vary, and that your recruiter will confirm your interview details in advance. The firm publishes the shape and emails the specifics.

Read the right column again. Every row of it is a single email in a mailbox that also receives newsletters. A tracker is the copy you control.

The field nobody tracks, and what it costs

Bain runs two assessments with opposite rules, and the page states both plainly. For Test Gorilla it says to complete the test in one sitting. For Sova it says you do not need to complete the assessment in one sitting, as long as all sections are finished ahead of the deadline in your invitation email.

A tracker with one column called deadline flattens that into a single date and throws away the rule. A candidate who read somewhere that these things can be paused, was sent Test Gorilla, and stopped halfway has not lost points. The application is gone.

There is a second reason to give the rule its own column. It changes what you must protect on the day. A one-sitting assessment needs a block of time nobody will interrupt, a charged laptop and a browser the vendor recommends, because stopping is not an option the tool gives you. A split assessment needs the opposite discipline: it will sit half finished for days unless the deadline is somewhere you look.

Both facts come from the same short page, and a candidate who reads it once and takes no notes will remember the length and forget the rule. That is what the column is for.

The tools rule splits the same way and carries into what you practice. Bain allows pen, paper and a calculator on the assessment, and says calculators are allowed for that assessment only and not during any subsequent interviews. Two rows in a tracker, two different kinds of preparation.

The consulting application tracker grid, eleven columns

This grid is ours. No firm publishes a recommended tracker, and we are not going to pretend otherwise. What is sourced is the column list: each one exists because a firm published something that makes it load-bearing.

Two of those columns come straight from the firms rather than from us. Bain states that applicants can expect to hear within 60 days, which turns a vague silence into a date you can put in a cell. And Bain notes that a candidate who has already completed the assessment will not retake it unless directed otherwise, which is why the assessment name belongs in a row you can search across offices.

Yale's Office of Career Strategy is the only official voice we found prescribing the artifact itself. Its networking page tells students to create a spreadsheet to record names, meeting dates, contact information, and notes. That is four columns for people. Nobody publishes the equivalent for applications, which is why the eleven above carry our name.

The first hour after you submit

Do this once per application, in the hour you apply, while the job posting is still open in a tab.

1. Create the row and paste the posting text. Postings are taken down. The wording of the role is what you will reread before the interview.
2. Record the exact role title from the posting, rather than the family name used on a students page. The posting is the document the firm wrote for the seat.
3. Set a reminder for seven days out to check for an assessment link, and check spam on that day. Bain tells candidates to check the spam folder if the link has not arrived.
4. Set a second reminder at 60 days. That is Bain's published window and a reasonable default elsewhere, marked as your assumption rather than the firm's.
5. Write the one sentence you would say if the recruiter called now. It ages badly, and that is the point: rewriting it later shows you what changed.

What to write down after each interview

Berkeley's career office gives the cleanest instruction we found on what a record should contain, written for informational conversations and just as true here. It says to keep records, to capture key takeaways, to note the questions you still have, and to brainstorm next steps.

Three lines per interview is enough:

1. The question you handled worst, in the interviewer's words rather than yours. Your paraphrase is already a defense.
2. The number you were given and what you did with it. Most candidates remember the topic and forget the figure, and the figure is the part that gets checked.
3. Who you met and one thing they said about their own work. That is the raw material for a thank-you note that does not read like a form letter, and Berkeley's page puts the window at one to two days.

BCG's interview process page names four steps: application, skills interview, case interview, team interview. If your tracker shows you have met two of the four at one firm and one of four at another, you know where your week goes without thinking about it.

The ten-minute weekly review of your application tracker

A tracker that is only written to is a diary. The review is what makes it a tool, and it is short.

1. Sort by assessment deadline, ascending. Anything inside seven days outranks everything else in your week, including practice.
2. Find rows with no next action. An application with no next action is either finished or forgotten, and you should know which.
3. Find rows past their reply date. At Bain that is 60 days by the firm's own statement. Elsewhere it is your assumption, and a polite follow-up to the recruiter who wrote to you is the normal move.
4. Count interviews by type, across firms. Three skills interviews and no case interviews in a month tells you what to practice next. That is the only number in the sheet that should change how you spend Saturday.

Our method page explains how we score a case answer on four dimensions, and the weight we put on Coverage 45 is the one this review usually indicts: candidates who feel slow are usually incomplete rather than slow. A tracker that logs the failed question by name feeds that judgment instead of guessing at it.

What this application tracker cannot tell you

It cannot tell you whether you are competitive. No firm publishes an acceptance rate, a volume of applications, or a scoring threshold, and any tracker template that implies a benchmark invented it.

It cannot tell you what a silence means. Bain publishes a 60-day expectation; McKinsey and BCG publish none, so the same three weeks of nothing is unremarkable at one firm and unmeasurable at another.

It cannot tell you why you were rejected. Bain promises feedback after interviews in its process pages; most firms promise nothing, and a tracker that records a decision without a reason is recording half an event. Write down what you were told, word for word, and leave the interpretation blank when none was offered.

And it cannot reconstruct an email you deleted. The deadline, the assessment name and the round count exist in one place before you copy them, which is the whole argument for doing it in the first hour.

The deadline column itself has a source problem of its own, since most firms print their dates in a job posting rather than on a careers page. Our page on consulting application deadlines shows which firms published a 2027 date, with the day each line was read.

For the outreach side of the same spreadsheet, our networking email templates cover the request itself, and the follow-up templates cover what happens after. For the application documents, start with the consulting cover letter guide.