Whitespace opportunity validation log

This whitespace opportunity validation log records what happens when a person checks a suggested customer/product gap. It connects each candidate to evidence, a reviewer and a disposition. The live summary shows the confirmed share of conclusive reviews and the value attached to confirmed candidates. It helps a manager distinguish a useful analytical lead from an opportunity that has never been checked.

What to enter

Use a stable candidate ID and record the customer ID, product, original estimated gap, disposition, evidence reference, reviewer and review date. Keep the original estimate in place when a candidate is rejected, so the review explains what the list originally proposed. Choose Not eligible for a documented rejection, Unknown when evidence cannot settle the question, and Unreviewed before anyone checks it.

Use the workbook

1. Copy a defined candidate population into the log and keep its selection rule in your review notes. Do not choose only accounts that already look promising.
2. Review each candidate for product fit, actual customer need, access and the estimate’s basis. Add a brief evidence reference and one disposition.
3. Read Review result, resolve incomplete adjudications, and use the confirmed value as a review amount rather than booked pipeline or expected revenue.

Keep the amber inputs separate from the pale blue calculation columns. The worksheet has 20 prefilled detail rows, from 13 through 32. If you need more records, extend every affected formula and summary range together, then check a first, middle and final row. Save a dated working copy before replacing the sample.

The synthetic example

The five sample rows include one confirmed $50,000 gap, one rejected $70,000 gap, one unknown, one unreviewed and one purported confirmation with missing evidence. There are two conclusive reviewed candidates, of which one is confirmed, giving 50.0%. Only $50,000 enters confirmed estimated gaps. Adding the missing evidence to OP-05 changes its result and updates both the count and value.

How the results update

A review result requires evidence, reviewer and date as well as its human disposition. Duplicate candidate IDs are flagged instead of being counted twice. The confirmed-share denominator includes Confirmed and Rejected results only. Unknown and incomplete outcomes stay visible in the detail. This is a descriptive result for the recorded sample; the workbook does not assign probabilities to untouched candidates.

Limits and a useful next step

Confirmation establishes a candidate for a conversation under your stated review criteria. It does not establish willingness to buy, product availability, a quoted price or contribution. A nonrandom sample may give an optimistic result. Keep the sampling approach and rejected reasons when comparing versions. The workbook records the review manually and does not contact customers, assign work or update CRM stages.

For the underlying method, read whitespace analysis. how to present a gap to a customer covers the adjacent question. If you want to review the required fields and one reporting output, discuss your setup. Views depend on your records and agreed definitions.