The ₦10M Pipeline Leak: How to Measure Exposure Without Inventing Lost Revenue
The ₦10 million figure in this article is a hypothetical example. It is not a Vanora client result, revenue claim or forecast.
A sales pipeline can look healthy while qualified opportunities quietly sit without an owner or next action.
That does not automatically mean revenue has been lost.
But it does mean commercially relevant pipeline is exposed.
The useful question is:
How much qualified pipeline currently has no visible next action?
That is something a business can calculate using its own data.
A Simple Illustrative Example
Suppose a business receives 100 relevant enquiries in one month.
After applying its agreed qualification criteria:
- 20 become qualified opportunities.
- 15 have an owner and dated next action.
- 5 qualified opportunities have neither.
Now assume the business has verified from its own clean historical records that the average value of a qualified opportunity is:
₦2,000,000
The exposed pipeline value would be:
`5 unworked qualified opportunities × ₦2,000,000 = ₦10,000,000 exposed pipeline value`
That is where the ₦10M Pipeline Leak headline comes from.
But there is an important distinction.
Exposed Pipeline Is Not Lost Revenue
The calculation does not prove that the business lost ₦10 million.
Some opportunities:
- Would not have closed
- May be duplicates
- May be disqualified later
- May return at another time
- May already be progressing through another route
So the correct language is:
₦10 million of qualified pipeline currently has no visible next action.
Not:
The business lost ₦10 million.
That difference matters.
Otherwise a diagnostic tool quickly turns into a fictional revenue claim.
Add Probability Only When You Have Evidence
If the organisation has reliable historical data, it can create a probability-weighted view.
Use:
`Exposed pipeline value × verified stage probability = probability-weighted exposure`
Suppose comparable qualified opportunities have historically closed at 20%.
Then:
`₦10,000,000 × 20% = ₦2,000,000 probability-weighted exposure`
That gives an illustrative expected-value view of ₦2 million.
Again, this is not guaranteed lost revenue.
It is a planning estimate based on historical performance.
Do Not Borrow a Conversion Rate From the Internet
The probability should come from the organisation's own reliable history where possible.
Do not simply use:
- An industry benchmark
- A vendor's marketing statistic
- An arbitrary 25%
- A rate copied from another company
- A number chosen because it makes the presentation more dramatic
Different businesses have different:
- Offers
- Markets
- Deal sizes
- Qualification rules
- Sales cycles
- Channels
- Commercial teams
Use comparable historical opportunities.
Document the methodology.
Define “Qualified” Before You Calculate Anything
The calculation only works if qualified opportunity has a clear definition.
For example, qualification may require:
- Relevant business problem
- Fit with the target customer profile
- Appropriate stakeholder
- Commercial relevance
- Reasonable timing
- Willingness to continue
- Agreed next step
A reply such as:
“Send me your brochure.”
should not automatically become a qualified opportunity.
If the qualification rule is weak, the exposure calculation will also be weak.
Define “No Next Action”
A qualified opportunity should count as exposed only when the expected action is genuinely missing.
A useful next action should include:
- Specific activity
- Owner
- Due date
- Relevant buyer context
For example:
Weak: Follow up.
Better: Send revised proposal by Tuesday and review pricing with the buyer on Thursday.
The second action is inspectable.
Why the Calculation Is Useful
The real value of the calculation is not the number itself.
It exposes a process question:
Why did qualified opportunities reach this point without an owner or dated next action?
That is what management should investigate.
Audit the Journey
A useful review may examine seven areas.
1. Capture
Did the opportunity enter the working system correctly?
Check:
- Source
- Timestamp
- Account
- Contact
- Need
- Relevant consent status
2. Deduplication
Is this genuinely a separate opportunity?
Duplicates can exaggerate pipeline exposure.
Check whether the same buyer or account appears across multiple records.
3. Qualification
Why is the opportunity considered qualified?
Look for evidence, not enthusiasm.
4. Ownership
Who accepted responsibility for the opportunity?
Assignment alone may not be enough.
A stronger process distinguishes:
Assigned → Accepted
5. Due Time
Does the next action have a real date?
“Follow up soon” is not a due date.
6. Pause and Stop Logic
Should the workflow still be active?
The record may need to pause or close because the buyer:
- Replied
- Booked
- Opted out
- Was disqualified
- Entered another workflow
7. Manager Visibility
Can management easily see qualified records with:
- No owner
- No next action
- Overdue action
- Failed handoff
If those records are difficult to find, the system is hiding exposure.
Fix the Control, Not Just the Reminder
Suppose five qualified opportunities repeatedly reach the same gap.
The immediate reaction may be:
“Send more reminders.”
That may help temporarily.
But investigate the underlying control.
The problem might be:
- Routing failure
- No acceptance event
- Poor CRM adoption
- Unclear ownership
- Weak qualification
- Overloaded salesperson
- Missing escalation
- Broken automation
Fix the reason the opportunity became unowned.
Do not simply generate additional notifications about the same broken process.
Build an Exception View
A useful CRM or revenue-operations view might surface:
Qualified opportunities with no owner
Qualified opportunities with no next action
Next actions overdue
Opportunities with failed routing
Opportunities with conflicting ownership
These exception views can be more useful than another generic pipeline dashboard.
They tell managers where intervention is required.
Measure Exposure Over Time
Do not calculate exposure once and forget it.
Track whether the operating process improves.
Useful measures may include:
- Qualified opportunities
- Accepted ownership
- Qualified records with no next action
- Overdue next actions
- Average time to owner acceptance
- Exposure value
- Probability-weighted exposure
- Correction rate
Keep the reporting window visible.
For example:
October 2026
20 qualified opportunities
5 without dated next actions
25% next-action gap
That creates a measure the team can improve.
Segment the Problem Before Drawing Conclusions
If exposure is high, break it down.
Look at:
- Lead source
- Salesperson
- Product
- Segment
- Geography
- Opportunity stage
- Age
You may discover that the problem is concentrated in one handoff rather than across the entire sales organisation.
That leads to a more targeted fix.
A Better Management Conversation
Instead of saying:
“We lost ₦10 million because sales did not follow up.”
say:
“₦10 million of qualified pipeline currently has no visible next action. Based on our verified historical stage probability, the probability-weighted exposure is ₦2 million. We now need to understand why those records became unowned.”
That statement is much more defensible.
It separates:
Known fact
from
Planning estimate
from
Process diagnosis
Build the Calculation From Your Own Data
A simple Pipeline Exposure Calculator needs only a few inputs:
Number of exposed qualified opportunities
How many valid qualified records lack the required next action?
Verified average opportunity value
What is the average value for comparable qualified opportunities?
Historical stage probability
Optional. Use only when supported by clean historical data.
Then calculate:
Exposed pipeline value
and, where appropriate:
Probability-weighted exposure
Keep the assumptions visible.
The Goal Is Not a Bigger Number
The point is not to produce the largest possible “revenue leak” for a management presentation.
The point is to find a process gap that deserves attention.
The most useful outcome may be:
- Better routing
- Faster owner acceptance
- Cleaner qualification
- Stronger next-action discipline
- More visible exceptions
- Better CRM adoption
That is how the calculation becomes operational rather than theatrical.
Where Vanora Fits
Vanora helps organisations examine the revenue journey across:
- Lead capture
- Qualification
- Ownership
- CRM workflow
- Next-action discipline
- Pipeline visibility
- Automation
- Revenue measurement
The objective is not to manufacture a dramatic lost-revenue number.
It is to identify where qualified pipeline lacks ownership or movement and fix the operating control behind it.
Use the Pipeline Exposure Calculator
Use the Pipeline Exposure Calculator to review qualified opportunities that currently lack a clear next action.
Record:
- Qualified opportunities reviewed
- Records with no owner or dated next action
- Verified average opportunity value
- Historical stage probability, where available
- Exposed pipeline value
- Probability-weighted exposure
- Root cause
- Owner
- Corrective action
Then explore Vanora Partners: