This is a sample report with placeholder data for ACME, Inc. · Get your free report

ACME, Inc. · Apr 14, 2026

Revenue Leak Report

Estimated Revenue at Risk

$4.8M

across 147 open opportunities · $18.6M total pipeline

Sum of all pipeline at risk across decay, orphaned revenue, speed-to-lead losses, and fake pipeline. Represents revenue that may be lost without intervention.

Pipeline Decay

$3.2M

Dollar value of open opportunities with no activity in 30+ days, no next step, or stage age exceeding your historical benchmark.

Orphaned Revenue

$1.1M

Open pipeline owned by inactive users or sitting on accounts with no recent rep engagement. This revenue has no one actively working it.

Fake Pipeline

$5.6M

Deals that are past their close date, closing soon with no activity, or have been pushed 2+ times. Likely already lost but still in your forecast.

Data Quality

76%

Average field fill rate across key Opportunity and Contact fields. Low completeness means unreliable reporting and forecast risk.

Open pipeline by inactivity window

Shows how much open pipeline has gone stale. Each bar represents opps with no logged activity (calls, emails, meetings) within that time window.
No Next StepOpportunities where the 'Next Step' field is blank. Without a defined next action, deals are 2-3x more likely to stall.

34 · $4.1M

Open opps with no defined next step.

Stage Age Exceeds BenchmarkCompared each opp's time in its current stage against the average time won deals spent in that same stage. Flagged if 1.5x or more.

12 · $1.8M

Open 1.5x longer than historical average.

Inactive Owner OppsOpportunities where the owner's Salesforce user account is marked inactive. These deals have no one actively managing them.

8 · $1.1M

Open opps owned by deactivated users.

Inactive Owner LeadsLeads where the assigned owner is no longer an active user. These leads will never receive follow-up unless reassigned.

23

Leads assigned to deactivated users.

Jennifer WalshTom Rivera
Rachel NguyenTom Rivera
Brandon HayesLisa Park
Dormant AccountsAccounts that have at least one open opportunity but zero logged activities (calls, emails, meetings) in the last 30 days.

15 · $2.3M

Accounts with open pipeline but no activity in 30 days.

Conversion rate by response time

Shows lead-to-opportunity conversion rate based on how quickly the first task was logged after lead creation. Faster response times typically correlate with higher conversion.

Leads never touched

127

of 882 sampled (180 days)

Leads created in the last 180 days that have zero tasks logged against them. These leads were generated but never received any follow-up.

Est. pipeline lost from slow follow-up

$1.6M

avg deal size $85K

Calculated by comparing conversion rates of fast responders vs. slow responders, multiplied by your average deal size. Shows the gap between actual pipeline created and what could have been created with faster follow-up.
Open 287Contacted 156Nurture 89Unqualified 62No Response 40
Status breakdown of unconverted leads with no activity in 90+ days. Each chip shows a lead status and how many dormant leads are in that status.

634 of 1,480 unconverted leads have had zero activity in 90+ days.

Kevin O'Brien
Contacted206d
Priya Sharma
OpenNever
Carlos Mendez
Nurture191d
Emily Thornton
Contacted153d
Opportunity → Amount91%
Percentage of open opportunities that have an Amount value. Missing amounts make pipeline reporting unreliable.
Opportunity → CloseDate98%
Percentage of open opportunities with a close date. Required for forecast accuracy.
Opportunity → NextStep42%
Percentage of open opportunities with a defined next step. Critical for deal progression visibility.
Contact → Email87%
Percentage of contacts with an email address. Essential for marketing and outreach.
Contact → Phone64%
Percentage of contacts with a phone number. Important for sales outreach sequences.
Past-Due OpportunitiesOpportunities where CloseDate is before today but IsClosed is false. These are definitely pushed deals inflating your forecast.

19 · $2.9M

Close date passed but still marked open.

Closing Soon, No ActivityOpportunities with a close date in the next 30 days but no logged activity in the last 14 days. If nobody is actively working the deal, it's unlikely to close on time.

11 · $1.5M

Closing in 30 days with no activity in 14 days.

Deals Pushed 2+ TimesIdentified via OpportunityFieldHistory. The close date was changed 2 or more times, indicating repeated slippage. These deals are often kept alive artificially.

7 · $1.2M

Close date moved 2+ times without stage progression.

Recommendations

1
Reassign orphaned pipeline immediately$1.1M

8 opportunities worth $1.15M are owned by inactive users. Reassign these today to active reps with relevant account context.

2
Implement speed-to-lead SLA$1.6M

Only 9.5% of leads are contacted within 5 minutes, and those convert at 35% vs. 6% for leads contacted after 24 hours. A 5-minute SLA could recover an estimated $1.62M in pipeline.

3
Clean up past-due pipeline$2.9M

19 deals worth $2.87M are past their close date but still open. Review each one this week: close-lost, re-forecast, or create a concrete recovery plan.

4
Require next steps on all open opportunities$4.1M

34 opportunities worth $4.1M have no defined next step. Mandate next step entry via validation rule or process builder.

5
Launch lead recycling program

634 leads (43%) are dormant with no activity in 90+ days. Segment by original source and run a re-engagement sequence before writing them off.

6
Improve contact phone number coverage

Only 64% of contacts have a phone number. This limits outbound calling effectiveness. Run an enrichment pass or require phone on inbound forms.

Ready to fix these?

Book 30 minutes to walk through your results and build a plan to recover this pipeline.