Sample Scorecard — Synthetic Data
Revenue Integrity
Scorecard
Northmark Software — Diagnostic Report
Company
Northmark Software
Stage
Series B · $22M ARR
GTM Team Size
85 people
Diagnostic Window
Jan – Jun 2025
CRM Source
HubSpot opportunity export
Opportunities Reviewed
1,248
Late-Stage Deals Inspected
42
Confidence
Medium-high

This is a synthetic example using fictional company data. It shows the structure, evidence depth, and decision support a client-facing scorecard is designed to provide.

Executive Summary
Overall Risk: High
Level 1
Spreadsheet Forecast
Level 2 — CurrentNorthmark
CRM Field Forecast
Level 3
Managed Inspection
Level 4
Signal-Based Forecast
Level 5
Revenue Integrity System
Finding 01
47% of pipeline has close dates pushed two or more times with no accompanying stage change — structural slippage treated as a timing adjustment.
Finding 02
CRM loss data is not usable for pattern recognition: 58% of closed-lost deals carry “Other” or a blank reason. Win/loss analysis is impossible at this quality level.
Finding 03
Forecast variance averaged 23% over six quarters. In four of those quarters, final-week changes exceeded 18% of the submitted number.
Diagnostic Evidence Base
Evidence Base Reviewed
  • 1,248 HubSpot opportunities, 6-month CRM history (Jan–Jun 2025)
  • Close-date movement patterns: tracked for every deal with two or more date changes without stage advancement
  • Stage aging distributions segmented by rep, segment, and deal size
  • Forecast category changes in the final 14 days of each quarter (Q1 and Q2 2025)
  • Next-step documentation quality: presence, recency, and buyer-observable specificity
  • Leadership inspection cadence: calendar data and documented deal review outputs
  • 42 late-stage deals ($50K+ ACV, Stage 4 or higher) reviewed via structured inspection protocol
  • Buyer-observable activity log: last meeting, last reply, last next step with date for all late-stage pipeline
Dimension Scores
Pipeline Integrity
High Risk
2.1 / 5
61% of new pipeline created in the final 3 weeks of Q2, consistent across all 6 analyzed quarters.
34% of Stage 4+ deals have no logged meeting, email, or next step in the past 21 days.
Average deal age at close-date push: 18 days past original close date.
Deal Motion Quality
Critical
1.8 / 5
47% of deals have had their close date pushed two or more times with no stage change.
Next-step documentation is missing or older than 14 days in 71% of late-stage opportunities.
38% of Commit-category deals have no buyer-confirmed timeline in the CRM record.
Forecast Process
High Risk
2.4 / 5
Forecast variance averaged 23% across the 6 quarters reviewed.
Final-week forecast adjustments exceeded 18% of pipeline in 4 of 6 quarters.
No documented inspection protocol for deals above $50K ACV; review is rep-initiated.
CRM Data Fidelity
Critical
1.6 / 5
58% of closed-lost opportunities carry “Other” or a blank loss reason.
Contact role (champion, economic buyer, blocker) is blank in 79% of late-stage deals.
CRM last-updated timestamp is more than 14 days old in 41% of open pipeline.
Leadership Inspection
Moderate
2.9 / 5
Inspection rhythm exists but is rep-initiated; manager-led structured review is not consistent.
Escalation protocol for stalled deals is informal and undocumented.
Board-level forecast is assembled approximately one day before submission with no structured review gate.
Top 5 Findings
01
Systematic close-date inflation without stage evidence

47% of opportunities had close dates pushed two or more times without any accompanying stage progression or documented buyer action. The pattern is consistent across all deal sizes and all six reps reviewed. This creates a false confidence layer in the committed forecast: deals appear active, but buyer momentum is not reflected in any field.

Estimated exposure: $2.1M in Commit or Best Case deals showing this pattern
02
CRM loss data is structurally unusable

58% of closed-lost deals carry “Other” or a blank as the loss reason. Win/loss pattern recognition is impossible at this data quality level. Pipeline health scoring, rep coaching by loss pattern, and ICP refinement all require reliable loss categorization. Currently, Northmark cannot answer the question: what do we most commonly lose to, and why?

Impact: Forecast modeling and pipeline qualification remain opinion-based
03
No buyer-observable activity in 34% of late-stage pipeline

Stage 4+ deals with no logged meeting, email reply, or documented next step in the past 21 days represent $1.4M in pipeline. These deals appear in the submitted forecast but carry no evidence of active buyer engagement. In 42 structured deal inspections, this pattern correlated with non-conversion in 89% of historical cases at a similar stage.

Estimated exposure: $1.4M in phantom pipeline currently included in Best Case or Commit
04
Quarter-end pipeline creation surge distorts linearity

61% of new pipeline was created in the final three weeks of Q2 2025. This pattern is consistent across all six quarters analyzed. Pipeline created under end-of-quarter pressure to hit coverage ratios has a historically lower conversion rate and longer sales cycle. It also distorts the following quarter’s forecast, since the pipeline count looks healthy but the vintage quality is lower.

Impact: Forecasting accuracy cannot improve until pipeline creation is linearly distributed
05
Forecast process is a negotiation, not an inspection

In four of six quarters, the final-week forecast submission changed by more than 18% from the prior week’s number. This is a symptom of deal advocacy overriding data review: managers accept rep positions rather than interrogating deal evidence. A structural change requires a documented inspection protocol applied before final numbers are locked, with defined criteria for what can be in Commit versus Best Case.

Impact: Board-level number lacks evidence foundation; variance will continue until the process changes
90-Day Priority Roadmap
Now
Weeks 1–2
Export full HubSpot opportunity history for all deals created in the past 18 months; establish a clean baseline dataset.
Identify and tag all open deals with two or more close-date pushes and no stage change — these become the inspection priority list.
Define five required fields for Stage 4+ advancement: economic buyer contact, documented next step with date, mutual action plan status, last buyer reply date, and primary competition.
Brief the sales management team on the five findings; establish shared language for “deal evidence” versus “rep position.”
30 Days
Weeks 3–6
Implement a close-date push alert in HubSpot: automated flag when a deal’s close date moves more than 14 days with no stage change.
Enforce a Stage 3 advancement rule: no deal moves to Stage 4 without a logged buyer meeting in the past 14 days and a documented next step.
Redesign the loss reason taxonomy: maximum 8 categories, required field, no “Other” option. Roll out with retroactive input on the past 90 days of closed-lost deals.
Run a structured 60-minute inspection of the top 20 open deals above $30K ACV using the MxM deal inspection framework.
90 Days
Weeks 7–13
Stand up a weekly structured inspection: manager-led review of all late-stage deals using standardized questions tied to buyer evidence, not rep narrative.
Build and launch Pipeline Integrity Dashboard 01 (close-date push exceptions) inside HubSpot — visible to all managers before weekly reviews.
Establish a forecast lockdown protocol: no changes to committed deals within 72 hours of board submission without VP-level approval and documented rationale.
Review Q3 forecast accuracy against the new evidence criteria; compare variance to the H1 2025 baseline established in this diagnostic.
Get the real version
Want this diagnostic for your revenue engine?
Book a Scorecard Call

No PII required  ·  No API access  ·  CSV exports only