Skip to content
Solution Blueprint

Real-Time Deal Completeness Scoring for a Security Software Vendor

147 custom deal properties sat at 18% population, and roughly 600 deals scored 0% complete, so an all-properties completeness check told the sales team nothing useful. A four-section core of 35 properties replaced it, with a real-time workflow writing five scores back on every save.

Executive Summary

context-header-icon

Context

A bot mitigation and account fraud security vendor selling into Fortune 500 e-commerce, financial services, airline, media and healthcare accounts had built an Enterprise HubSpot portal well ahead of what its sales team used: 200+ workflows and 200+ deal properties, most under 10% filled.

what-we-built-header-icon

What We Built

We consolidated 147 custom deal properties into a governed core of 35 across four sections. We then built a real-time workflow that scores every deal and writes five completeness percentages back to the record, feeding a dashboard for stage, owner and section visibility.

tech-stack-header-icon

Tech Stack

  • HubSpot Sales Hub Enterprise
  • HubSpot Marketing Hub Enterprise
  • HubSpot workflows
  • Gong
  • Slack

Not a fit if your reps won't populate a shared set of deal fields: a completeness score only works when the sales team fills in what it measures. It also assumes an Enterprise-tier CRM already licensed, with enough property history to consolidate.

the-challenge-header-icon

The Challenge

147 custom deal properties had built up on the deal record, and most were rarely maintained: they averaged 18% populated. Eight fields built to score deal quality averaged 3.3% fill, and only one cleared 40%, so managers couldn't tell which deals were ready to progress.

Scoring every property didn't help. The result came out near zero for most of the pipeline, because the score couldn't separate a field nobody needed from one a deal hadn't reached yet. Roughly 600 deals scored 0% complete.

our-approach-header-icon

Our Approach

We first tried scoring against all 147 properties, and it failed: the number couldn't tell a deal that was actually behind from one that had simply skipped fields outside its vertical. So we classified every property as core, optional or unused, and agreed 35 core properties across four sections. We didn't delete anything outside that set.

A real-time workflow, the Deal Completeness Scorer, fires whenever a deal field is saved. It writes five percentages back to the record, one overall and one for each section. A dashboard reads those scores and shows the score distribution, completeness by stage and owner, a manager alert list, and a section breakdown.

The 112 properties outside the core set stayed in the portal, so the score measures only what every deal is expected to carry, and the rest sit unscored.

Solution: HubSpot Customization & Optimization · Industry: Technology & Software

impact-header-icon

Impact

check-icon

A completeness score that updates the moment work happens

The Deal Completeness Scorer recalculates the moment a rep saves a deal, so the five percentages reflect the pipeline's current state, not a snapshot from the last audit. Sales leadership and RevOps read the same dashboard.

check-icon

A core property list confirmed by the business itself

The 35 core properties across four sections were confirmed complete by the client's own RevOps manager, not accepted on faith. That sign-off gave the sales team a fixed target to populate rather than an open-ended list of 147 fields.

check-icon

Completeness broken down by stage, owner and section

Because the dashboard breaks completeness down by stage, owner and section, a manager can tell whether a low score belongs to a slow-moving deal, an under-filled section, or a specific rep. The section-level view points a rep at the exact fields to fix.

check-icon

A consolidation that did not require deleting anything

The 112 properties outside the core set stayed in the portal rather than being removed, so anything a future workstream needed, from finance fields to product detail, remained available without a separate recovery effort. The core set carries the day-to-day scoring; the rest sits in reserve.

Technical Blueprint
1

A real-time HubSpot workflow fires on any deal-property save and recalculates five completeness percentages: one overall and one for each of the four core sections. It runs on every save, not on a schedule, so the score is never more stale than the last edit.

2

The 35 properties kept for scoring are grouped into four sections: commercial deal basics, product and service detail, deal-quality scoring, and one further operational section. Scoring by section lets the dashboard show which part of a record is thin.

3

One dashboard surfaces five views: score distribution across the portfolio, completeness by stage, completeness by owner, a section-level breakdown per deal, and a manager alert list. Sales leadership and RevOps read the same dashboard, so a stage-level or owner-level pattern is visible to both.

4

Deals that are both in an active stage and critically incomplete surface on a standing alert list rather than waiting for a periodic review. That list turns the completeness score from a reporting metric into something a manager acts on inside the same sales cycle.

Saving a HubSpot deal field triggers a workflow that writes five completeness scores to a sales dashboard.

The 147 custom deal properties averaged 18% populated, so scoring against all of them left roughly 600 deals at 0% complete. Now we score against 35 core properties across four sections. The Deal Completeness Scorer runs whenever a deal field is saved and writes five percentages back to the record, one overall and one per section. The other 112 properties stay in the portal, unscored.

FAQ

How do you score deal completeness without penalising reps for fields that do not apply to them?

You separate core properties from optional and unused ones instead of scoring everything a portal has ever collected. Here, that meant taking 147 custom deal properties down to a governed set of 35 across four sections, so the score only measures fields every deal is expected to carry.

Does consolidating deal properties mean deleting the ones you stop scoring?

No. The properties outside the core set stayed in the portal rather than being removed, so historical data tied to them remained available. Only the scoring logic changed: it now runs against 35 core properties instead of all 147.

Continue reading

209049052786

Bot mitigation security vendor: audit of 224 workflows resets the roadmap

209049052786

Enterprise HCM and payroll SaaS: 73 lifecycle-writing workflows audited

209049052786

Cybersecurity trainer: 595 workflows audited for debt

209049052786

Australian geospatial software provider: scoring rebuild, MQLs up 150%

209049052787

Molecular diagnostics lab: banded Deal Score and company-level scoring

209049052786

Australian expense SaaS platform: lead scoring and ANZSIC industry codes

footerCTA footerCTA-mobile
Spice up your inbox
Sign up for our newsletter
Don't worry - we only average, like, two emojis per subject line.