A client does not book, and the agency records price too high. Nobody asked the client, the final total included an unclear transfer charge and the proposed start time did not suit the family. The loss reason sounds plausible but teaches the team very little.
A useful lost-quote review identifies where the decision stopped and what evidence supports the explanation. It should improve the agency’s discovery, product selection, proposal or follow-up process. It should not become a blame exercise or an automatic case for discounts. This guide sets out a small, repeatable review for independent agencies.
Decide what counts as a quote and an outcome
Define a quote as a specific proposal for a stated party, date and service scope with enough commercial information for a client decision. A generic brochure or rough idea may be an enquiry response, but mixing it into the same denominator makes the result hard to interpret.
Use distinct outcomes: booked, declined, expired without a decision, withdrawn by the agency, unavailable after checking and still open. Adapt the names to your process while keeping the underlying distinction. A client not replying is not proof that they chose a competitor or rejected the price.
Set a closure rule that reflects real deadlines. An activity date passing can resolve the outcome; an arbitrary short silence may not. Record the proposal date, relevant expiry and final closure date so you can tell whether an enquiry had a reasonable opportunity to conclude.
Keep revisions under one opportunity when they concern the same client decision. Five price updates should not become five lost quotes before the final booking. Use a new opportunity when the client is making a materially separate booking decision, and document the rule for the team.
Separate the sales stage from the reason
The stage tells you where progress stopped: discovery, supplier verification, proposal, client approval, payment or final confirmation. The reason describes the evidence for why it stopped. These are different fields. A proposal can fail at payment because the client changed plans, not because the payment process failed.
Identify the last completed meaningful step. Sending an email does not prove the client received or understood the quote. A supplier acknowledgement does not establish that every special request was accepted. Be precise about what happened before assigning a cause.
HubSpot’s default deal properties include deal stages and a closed-lost reason, illustrating the distinction in a commercial record. You can use the same logic in a simple manual system. This is a data-model reference, not a requirement to buy HubSpot or a claim of a Tripnatic connection.
Keep a short evidence note alongside the selected reason. A category helps comparison, while the note preserves meaning. Without it, different agents may use budget for entirely different situations.
Build a small reason list with an unknown option
Start with reasons you can actually act on: activity did not fit, schedule did not fit, client budget mismatch, supplier unavailable, client plans changed, insufficient information, approval or payment issue, and unknown. Add a category only when repeated cases justify it.
Distinguish stated reasons from agent interpretation. If the client says they booked a shorter activity elsewhere, record that statement and any relevant context. If the agent suspects price, mark it as a hypothesis. Do not turn a guess into a confirmed fact because the report requires a populated field.
The UK ICO accuracy guidance is a useful reference for separating fact, source and opinion in personal records. Keep your notes fair and practical, applying the privacy requirements relevant to your own business.
Avoid emotionally loaded descriptions such as time waster or difficult client. They discourage useful review and can mislead colleagues handling a future enquiry. Record the observable issue: the budget was below every suitable confirmed option, or the client needed an earlier return than the available departures offered.
Ask for feedback without reopening the sales pressure
For appropriate closed cases, send a brief optional question. Ask which part did not fit or what the client chose to do instead. Explain that the answer helps improve future recommendations. Do not ask them to justify declining or imply they owe the agency a detailed response.
Offer a few neutral prompts if that makes replying easier: timing, activity fit, budget, changed plans or something else. Keep unknown available internally when the client does not answer. The aim is better evidence, not a complete-looking spreadsheet.
Use clear, concise language, following W3C’s writing guidance. A short question is more respectful than a long survey attached to another sales offer. Keep any request consistent with the communication permissions and rules that apply to your client relationship.
If the client reports a service problem, route it through the appropriate resolution process rather than treating it only as a marketing insight. A missed reply or incorrect quote may need a direct response before it becomes a report category.
Compare a mature set of similar decisions
Choose a set of opportunities with enough time to reach a meaningful outcome. If you review quotes sent this week while many are still open, the apparent booking rate can be misleading. Define the cohort, the cutoff date and which outcomes are included.
Calculate rates with visible denominators. Booked quotes divided by resolved quoted opportunities answers a different question from bookings divided by all enquiries. Neither is automatically wrong, but the report must say which one it uses and why.
Segment only where the distinction helps a decision and the numbers remain interpretable. Private requests, same-day enquiries and standard activities may have very different planning burdens. A blended figure can hide an operational problem, while an excessively detailed breakdown can exaggerate random differences in tiny groups.
Do not rank staff from a handful of cases without considering enquiry mix, shifts and opportunity assignment. One agent may handle the complex requests everyone else forwards. Review the process and evidence before drawing conclusions about individual performance.
Worked example: the first answer is not a discount
Imagine a hypothetical agency reviewing thirty activity opportunities from a completed period. Twenty-four received a formal quote; six ended before quoting because they were outside scope or could not meet the required timing. Of the twenty-four quoted opportunities, ten booked, eight were explicitly declined and six expired without a client decision. These figures are invented.
The agency reports ten bookings from twenty-four quoted opportunities, approximately 42 percent, and ten from thirty total opportunities, approximately 33 percent. It labels both denominators. It does not claim either figure is an industry standard or a forecast for next month.
Among the eight explicit declines, three clients cite timing, two cite budget, one chooses another activity, one cancels the trip and one gives no specific reason. The six silent expiries remain unknown. Calling all fourteen unbooked quotes price losses would be an unsupported conclusion.
The team checks the three timing cases. Two proposals presented an early pickup despite the client requesting a later start. The third was clear, but the desired format was unavailable. The first improvement is therefore a discovery and shortlist check for start-time requirements, not a general discount.
For the two budget cases, the agency examines whether the stated ceiling included transport and fees. One client’s budget was simply below the available suitable options. The other had not understood the final total. These require different responses: honest early qualification in one case and clearer pricing in the other.
Examine effort and contribution alongside booking counts
A quote that takes several hours to produce has a different service cost from a standard activity proposal. Record a practical estimate of research and revision time for complex cases. You do not need minute-by-minute surveillance to identify repeated custom work that never reaches a decision.
Keep gross booking value separate from agency earnings and contribution. A large tour total is not the amount available to pay staff or fund growth. When reviewing commercial results, use the actual earning model and relevant costs rather than assuming a percentage or treating an unconfirmed quote as revenue.
Look at the pattern of work. Repeated revisions may indicate weak discovery, unclear decision authority or a product that needs a better briefing process. The private-tour brief guide can help reduce avoidable rework without limiting necessary client support.
A low booking count is not automatically a failure if the agency correctly declined unsuitable requests. Record those decisions separately. They may protect service quality while revealing a useful opportunity for a new supplier or clearer marketing about what the agency offers.
Turn the review into one testable improvement
Choose the issue with the clearest evidence and define a change your team can apply. For the hypothetical timing problem, add a firm start-time question to discovery and a check before shortlisting. Name an owner and a date to review the next relevant cases.
Write the expected mechanism: the change should prevent proposals that conflict with a stated requirement. Do not promise a conversion increase. First verify whether the process now captures the requirement and whether suitable alternatives are presented honestly.
Track comparable cases after the change, including those that do not book. Note any shifts in enquiry type, season, supplier capacity or pricing. A better result may coincide with other changes; a small before-and-after comparison cannot establish causation by itself.
Avoid changing price, wording, follow-up timing and product mix simultaneously if you want to understand what improved. Some urgent fixes must happen together, but record them as a combined change rather than attributing the result to your favourite part.
Keep a category definition beside the worksheet so new team members classify cases consistently. Review a few examples together when the definitions change. Otherwise an apparent shift in reasons may reflect different recording habits rather than a change in client behaviour.
A usable lost-quote review worksheet
Use one row or record per opportunity, with revisions linked underneath. Suggested fields are:
- Identity: opportunity reference, owner, enquiry source and product type.
- Client frame: date, party, broad purpose and relevant decision constraints.
- Quote: first proposal date, final version, total and earning basis where relevant.
- Progress: last meaningful completed stage and outstanding action at closure.
- Outcome: booked, declined, expired, unavailable, withdrawn or still open.
- Reason: concise category, evidence note and whether stated or inferred.
- Effort: research and revision estimate for cases where it matters.
- Lesson: preventable mismatch, supplier gap or no process issue identified.
- Action: proposed improvement, owner and review date.
If using a spreadsheet, Google Sheets’ official filtering guidance explains filters and filter views. Use them to inspect one cohort or reason without changing the meaning of the source records. A filtered view is a convenience, not evidence that the underlying categories are correct.
Before each review, check for duplicate opportunities and unfinished records. The same client can appear under a direct enquiry and a partner introduction, while a revised proposal may have been entered as a new case. Resolve those duplicates before calculating rates. Keep a note of the correction so the report remains explainable.
Also check that closed dates describe the intended event. An automatically updated CRM date may reflect when a staff member moved the record rather than when the client declined. Choose the relevant date consistently for the question you are analysing, and document that choice.
Keep the review fair and proportionate
Review a manageable set of recent resolved cases together. Ask what the record supports, what remains unknown and what action is justified. Include successful quotes occasionally so the team can see which practices helped, rather than learning only through failures.
Limit the personal information copied into analysis. The UK ICO data-minimisation guidance is a useful reference for proportionate records. A process review rarely needs passport details, personal diagnoses or entire private conversations.
Tripnatic’s agent workspace supports private quotes, client organisation and booking and earnings reporting. Agencies complete registration, verification and approval before activation. Combine accurate booking records with your own reason review; a quote does not represent reserved capacity, approved earnings or a completed sale.
Use the two-option proposal guide when the evidence shows clients struggle to compare formats. Keep the improvement specific and review whether it solves the observed problem. The purpose of lost-quote analysis is a better next recommendation, not a spreadsheet that turns every unanswered message into a reason to lower the price.
