Sales Operations Analyst Interview: A Pipeline Analysis Practice Case
If a sales operations interview gives you a pipeline export and asks whether the quarter looks safe, start by separating two questions: what’s open in the CRM, and what’s backed by a recent buyer action? Those numbers can be very different.
This fictional practice case gives you six deals and one decision to make. You can work through it on paper or in a spreadsheet. Give yourself 10 minutes before reading the worked answer.

The pipeline analysis exercise
It’s June 23, and the quarter ends June 30. The team has already closed $320,000 against a $450,000 target. The six deals below are all open and marked to close this quarter. The sales director asks: “How much of that pipeline should I feel good about, and what should we do this week?”
Use this practice rule: flag a deal if there’s no buyer-confirmed next step dated June 30 or earlier, or if the last two-way buyer contact was more than 14 days ago. A rep leaving a voicemail doesn’t count as two-way contact. A flagged deal is a follow-up priority, not a lost deal.
The six deals
Each line shows the deal value, current CRM stage, last two-way buyer contact, and buyer-confirmed next step.
A: $50,000 · Proposal · June 5 · None confirmed
B: $40,000 · Negotiation · June 19 · Legal review July 2
C: $30,000 · Negotiation · June 21 · Contract review June 26
D: $25,000 · Proposal · June 18 · Decision meeting June 27
E: $20,000 · Proposal · June 17 · None confirmed
F: $15,000 · Negotiation · June 20 · Approval call June 25
Calculate the remaining gap to target and the total open pipeline. Then flag the deals that meet the rule, explain why, and name the two actions you’d take first.
Worked answer: start with the gap
The gap is $130,000: $450,000 minus $320,000. The six open deals add up to $180,000. That’s about 1.38 times the remaining gap, but the total includes deals whose close dates aren’t well supported.
Deals A, B, and E account for $110,000, or about 61% of open pipeline by value. A has no confirmed next step and has gone 18 days without two-way contact. B has recent contact, but the buyer’s legal review is after quarter-end. E has recent contact but no confirmed next step.
C, D, and F pass the practice rule, for $70,000 combined. Even if all three close in full, the team would reach $390,000, still $60,000 short of target. Passing the rule doesn’t make a deal a commitment. A meeting to review a contract, for example, is not the same as a signed contract.
What I’d do next
Ask the owners of A and E to confirm a buyer action and date today. If the buyer can’t confirm a step that supports a June close, review the close date with the rep instead of carrying the deal forward on hope.
Ask B’s owner whether the buyer can move legal review into June and whether there is time left for any approvals or signatures after that. If the buyer confirms July timing, move the expected close date to the next quarter and explain the change to the sales director.
If the director asks for one item to track tomorrow, use the value of this quarter’s open deals missing a confirmed next step before quarter-end. This gives managers a short follow-up list and shows whether the next forecast is based on better evidence.
How to explain it in the interview
“We need another $130,000. The CRM shows $180,000 open, but $110,000 needs a timing or next-step check. The other $70,000 is still open, so even if it all closes, we’d be $60,000 short. I’d ask the owners of A and E for confirmed buyer actions, and verify B’s legal timing before counting it toward June. I’d update the forecast after those conversations.”
If an interviewer changes the brief, say which calculation changes. For example, if B confirms a June 26 legal review and its recent contact still qualifies, $110,000 would pass the practice rule instead of $70,000. The best-case total for those deals would be $430,000, still $20,000 short. You’d still need to check the steps after legal review.
Before you call the analysis finished, check that you can explain the difference between open pipeline, deals that pass your screening rule, and a forecast you’d stand behind. If you’re preparing for questions beyond the exercise, start with the sales operations interview questions guide.
Ready to walk into your next interview with confidence?
The Confident Interview Method gives you a focused, one-hour way to choose stronger examples, answer difficult questions, and speak clearly without memorizing a script. Start here if you want a complete preparation process you can reuse before future interviews.

The Confident Interview Method
$29
One focused hour with 10 practical lessons you can use in your very next interview.
“After spending hours reading blogs and articles, I am so glad that I bought this. It covered what I think are the most important parts of interviewing. Thanks for making this so concise.” - Drew Whitehead
Prefer a faster, lower-cost option?
The Interview Playbook eBook gives you practical strategies for preparation, communication, body language, and interview practice that you can start using right away.







Comments