Why did sales drop? Analysing it with a chain of questions from total to customer

Sales decline analysis is a method of review that narrows down, step by step, which sales rep, customer, product or period caused a fall in total sales. The goal is not to stop at a general “the market is bad” comment, but to see the concrete source of the decline and tie the action to that source.

In most meetings the topic opens the same way: the figure appears on the screen, everyone sees the target was missed, and each person offers a guess. Sales points to prices, finance to collections, operations to shipping. Yet when the right questions are asked in order, the discussion is short, because the answer is in the data.

Why is the total figure not enough?

Total sales is the sum of movements that offset each other. A large loss at one customer can be partly covered by small gains at several others. A decline that looks small in the total may hide a serious problem; conversely, a decline that looks large may come down to a single delayed order. That is why the total is a warning light, not a diagnosis.

Five questions from the total down to the customer

The order below narrows the decline from the general to the specific. Each question builds on the answer to the previous one.

1. Where are we against the target? Compare this month’s sales with the target and with the previous period. Is the decline real, or is it simply the effect of being early in the month?
2. Which reps have a gap? Rank target achievement by sales rep. Is the decline spread across the team or concentrated in a few people?
3. Which of that rep’s customers declined? Show the contribution to the change by customer. Most of the gap often comes from a few customers.
4. What changed at these customers? Look at order frequency, delayed orders and pending shipments. Is the problem in demand or in delivery?
5. Is this new or ongoing? Open the trend for the last few months. A one-month fluctuation and a loss that has lasted for months call for different actions.

A short scenario: the gap comes from two customers

Imagine a fictional textile wholesaler. At the Monday meeting the general manager sees that this month’s sales are below target. When the rep ranking is opened, two people turn out to be behind target. When the customer breakdown of one of them is opened, almost the whole gap comes from two customers; the other customers even show small increases.

At this point the conversation changes. Instead of “why can’t the rep sell”, the question becomes “what happened at these two customers”. The order history shows pending shipments at one and orders that stopped in recent weeks at the other. The first is a matter for operations, the second for a customer visit. The meeting ends with clear owners for each follow-up.

Asking the right question saves more time than searching for the answer.

Common mistakes

• Stopping at the average: While the team average looks reasonable, a serious loss at a single rep or customer can stay hidden.
• Mixing up periods: Comparing the first week of this month with the whole of last month shows a misleading decline. Compare periods of the same length.
• Starting over with every question: Rebuilding filters for each new report breaks the analysis. Moving forward in the context of the previous question keeps the line of thought.
• Focusing on the person: The rep breakdown is a starting point. The real issue usually lies with the customer, the product or the delivery.

Building the question chain with AI

Asking these five questions with ready-made reports often means several different screens and filters. With Fero, the Enterprise AI assistant, the same chain is built in everyday language, by voice or in writing: “Where are we against this month’s target?”, then “Show it by sales rep”, then “What is Can’s problem?” Follow-up questions keep the context; the screen is not reset with each message but is updated on the same topic or drills down into detail. The names in the example are fictional data from the demo screen.

If you want to discuss a sales decline in meetings with questions asked in order rather than with guesses, you can see how Fero works on the Enterprise AI page and request a live demo with your own data.