You close the chat after another “thanks, I’ll think about it.” An unpleasant feeling remains: something went wrong again. Maybe it is too expensive. Maybe the person was simply not serious. Maybe you need to redo the whole website, price list, and your entire life by Monday.
But after a few days, you can no longer remember all those chats. One client asked about timing, another disappeared after the price, a third wanted examples, a fourth kept clarifying details and eventually chose someone else. When all of this lives in messengers and in your memory, the same obstacle can easily disguise itself as coincidence. And the other way around: several random refusals can look like one big problem.
The most upsetting conversation is usually easier to remember than an ordinary one. So afterwards it is easy to decide that all clients think the same way. This is not laziness or bad intuition: memory simply was not made for honestly comparing dozens of similar conversations. It keeps the emotion, while the details are hard to retrieve without notes.
You do not need to solve every person immediately. You need to stop filling in explanations where there are none. For that, it is enough to keep a short record of lost leads - enquiries that could have become an order but did not. It will not promise sales or give you a magically precise answer for every chat. But it will help you see what actually repeats and what you merely remember well because it was upsetting.
This is not a separate complex system and not a reason to postpone work until you find the “right” service. You are not collecting dossiers on people, but working memory for yourself. Its task is simple: after another refusal, leave a trace you can return to without having to retell the story to yourself.
1. “Too expensive” is not yet a reason to lower anything
When a refusal sounds like “it is too expensive for me,” your hand reaches to lower the price. That is understandable: the phrase is short, painful, and seems to leave no room for another conclusion. But it does not always mean your price list is too high.
The person may have been comparing you with a different service format. They may not have understood what exactly is included in the offer. They may not have had the needed amount right now. They may have been looking for the lowest price, while you sell a different scope of work. Or they may have been ending the conversation politely without explaining the real reason. All these situations look similar from the outside, but you need to act differently in each one.
For example, Olena bakes custom cakes. After several messages about the cost, she decides to make everything cheaper. But when she starts recording conversations, she sees that in many of them people asked before the price whether morning delivery was available and whether they could see the fillings. She should not rush to cut her prices. First, it is more appropriate to clearly show the filling options, delivery terms, and examples of completed orders.
In this situation, you do not need to convince yourself that price does not matter at all. You need to form a more honest conclusion: “People mention the price, but before that they often do not find the information they need.” Then the next action becomes specific: add that information where people will see it before asking about the amount, and keep recording new conversations the same way.
If people directly compare your offer with another one, do not reduce this immediately to a fight against a lower number. Check whether you name the scope of work, timing, service contents, and the result the client will receive in the same way. Usually, comparison is easier when the offer can be explained in one clear sentence instead of being assembled from pieces of correspondence.
2. Five fields are enough, not a new office inside a spreadsheet
A spreadsheet is not meant to turn your work into correspondence accounting. It should take out of your head what your head stores poorly: many similar conversations in a row. A regular spreadsheet, a note with consistent lines, or a CRM - a program where contacts and progress on leads are stored - will do. If you do not have a CRM, that is not a reason to postpone tracking.
After every important conversation that did not become an order, record five things:
- the date;
- the service or product they asked about;
- the lead source - the place the person came from, such as a referral, website, or social media;
- the reason for the loss;
- the client’s brief words or important context.
These fields answer different questions. The date stops old and new conversations from blending into one overall impression. The service shows whether the problem concerns the whole business or only one offer. The lead source helps you notice that people coming from different places have different expectations. The reason and comment leave a trace of the conversation itself, not only your reaction to it.
Record it so you can return without translating it
You do not need to record the entire conversation, judge the person’s character, or invent complex categories in advance. If you sell different services, name them as you name them in your work. If the lead came “from Instagram,” do not turn that into a mysterious code. The spreadsheet should make sense to you when you are busy, not only when you have set it up beautifully.
The reason for the loss can be short too: “did not reply after the offer,” “chose someone else,” “asked to return later,” “timing does not work,” “price.” When the answer is unclear, write that: “unknown.” Do not change the name of a reason merely because another one sounds neater. If later you cannot explain how “no budget” differs from “too expensive,” those labels will not help you compare records.
As a rule, a short recurring list of reasons is more useful than a detailed document you stop opening after a few entries. If a field does not help you understand what happened in the conversation, remove it. If without it you have to guess, keep it.
3. Do not mix the client's words with your own explanation
The most common trap starts not in the spreadsheet, but in your head. A client says: “I’ll think about it.” You record: “too expensive.” After a while, it seems you have accumulated refusals because of price, although not everyone directly mentioned price.
To prevent this, keep three different states in your record. The first is the client’s direct answer: what the person actually said or wrote. The second is your assumption: a version of why the conversation stopped. The third is an unknown reason: when there is no answer or it is too vague.
In the comment, you can write: “Client: ‘I’ll come back after the season.’ My assumption: there is no budget right now.” But the reason for the loss remains “return later” or “unknown” for now, if the promise was simply a way to end the chat politely. This separation may seem minor, but it saves you from decisions built on your own mood.
You can ask about the reason gently if the conversation is open to it. For example: “Thank you for being honest. If it is convenient, could you tell me what was decisive: budget, timing, or something else? It will help me explain the offer better.” The person is not obliged to answer. Do not interrogate them, argue, or come back with the same question again. No answer is information too, just not about a specific reason.
Sometimes a client gives a very general reason: “Not for me,” “I changed my mind,” “Not relevant for now.” Do not force these words to mean more than they mean. Record the phrase and next to it only the context that was actually in the conversation. If later such answers repeat at one point in the process, you will have a reason to look at what exactly the person sees before refusing. Until there is a pattern, an honest “unclear” is more useful than a neat theory.
For the most part, this approach is useful for the team too. When one person records “the client is unreasonable” and another records the exact phrase from the conversation, it is impossible to discuss the problem. When there are facts and separate versions, you can argue about the next action rather than memory. Agree that everyone calls the same situations by the same words, otherwise one barrier will fall apart into several pseudo-reasons.
4. Look for a pattern, not the most painful chat
Once a week, review all losses together. Not to put yourself or the salesperson on trial. Look at which labels come up again: for which service, after which stage of the conversation, from which lead source, and with which client words.
You do not have to count everything down to the smallest detail. Look for the same answers and questions, and read similar records side by side: this is how you see a pattern rather than a random label.
Sometimes the signal will be obvious: several people do not understand what exactly they will receive. Sometimes it will be contradictory: some write about price, others about timing, and others simply disappear. Do not force the records to give an unambiguous answer before they can. If there are few reasons or they differ, your conclusion can be simple: “I do not yet know what matters most. I will keep recording consistently.”
Test one change at a time
When you can see a pattern, choose one change to test. Do not change the website, ads, script, price list, and packaging at the same time: otherwise you will not understand what had an effect.
Artem renovates apartments. Several times, his records repeat “the work start date does not work.” At the same time, these people came through referrals and hardly negotiated. Instead of a discount, Artem can test one simple change: before the estimate, state the nearest possible start date and explain how the queue is formed. If in new conversations there are fewer questions about timing or people disappear less often right after this point, there is a reason to continue the test. If nothing changes, that is not failure: the assumption was not confirmed, and you can look further. When there are too many changes, the process especially loves to ceremoniously announce five renovations and then hide which one was needed.
Before the next review, note next to the change what exactly you changed and why. Not for a report to anyone, but so that after a few conversations you do not forget what you were testing. This also protects you from the temptation to declare success or failure based on one vivid case.
For regular lead tracking, a analytics system may be useful, but its purpose is the same: not to collect data for data’s sake, but to connect it to the next decision.
5. When there is little data, do not invent certainty
The first records may feel awkward. Some reasons will be unknown. Several refusals may have nothing in common. You may see “price” and “too expensive” in different wording but not know whether they are one signal. This is a normal state at the start.
Instead of telling yourself “clients do not buy because of price,” say it more precisely: “In several conversations, people mentioned price; I do not yet know whether this is about the amount itself, a comparison, or an unclear offer.” This wording is not weaker. It leaves you options to test and does not force you to punish the price list for someone else’s vague answer.
If there are few records, do not draw a big conclusion. If there are many reasons, do not try to fix all of them. If the team names the same situation differently, agree on simple shared words in the list of reasons. If the problem seems obvious to you, find a direct client answer in the records, not only your own impression. The reverse happens too: a person seems to have named a reason, but it does not explain what to change. “Chose someone else” is a fact, but not a ready instruction to copy a competitor. First check whether that answer repeats for a particular service or after a particular moment in the conversation. If not, leave it on the list without a big reaction. Not every record has to end in a change.
Over time, the spreadsheet will become not an archive of failures but working memory. It will not replace a conversation with a client or make every offer successful. But it usually removes the most exhausting part: the need to start from an assumption every time.
The first step is simple: after the next important conversation that did not end in an order, record the date, service, source, reason, and the client’s exact phrase - or an honest “unknown.”
6. FAQ
7. Glossary
- втрачених заявок
- Enquiries that could have become orders but ended in a refusal, silence, or postponement without an agreement.
- джерело звернення
- The place or method through which a person learned about you and wrote to you: a referral, website, social media, or another channel.
- CRM
- A program for storing contacts and the progress of work on leads; it can simplify tracking but is not needed for the first record.
- пряма відповідь клієнта
- Words the person actually said or wrote about their refusal, without added interpretation from you.
