Lab 22 • RevOps & CRM Architecture
CRM Data Quality & Weighted Forecast Lab
Audit synthetic pipeline opportunities. Review duplicate candidates sharing identical contact emails, calculate stage-weighted forecasts, and prevent artificial pipeline inflation.
Gross Unweighted Pipeline
$255,000
Face value of open deals
Weighted Forecast
$160,500
Sum of (Amount × Stage %)
Duplicate Alert
1 Candidate
Review duplicate contact
Active Opportunities
5
Verified deals in flight
Pipeline Opportunities Grid
| Deal ID | Account Name | Contact Email | Stage | Probability | Face Amount | Weighted Amount |
|---|---|---|---|---|---|---|
| deal-101 | Acme Health Systems | procure@acmehealth.com | proposal | 50% | $45,000 | $22,500 |
| deal-102 | Acme Health (Old Duplicate) | procure@acmehealth.com | discovery | 20% | $45,000 | $9,000 |
| deal-103 | BlueSky AI Corp | finance@bluesky.ai | negotiation | 80% | $80,000 | $64,000 |
| deal-104 | Zeta Financial | ops@zetafin.com | discovery | 20% | $25,000 | $5,000 |
| deal-105 | Omega Retail | it@omega.org | closed won | 100% | $60,000 | $60,000 |