The Challenge

Salesforce gives sales teams everything needed to assess deal health — ActivityHistory, Opportunity Contact Roles, Stage timestamps, the NextStep standard field, and CloseDate. The problem is that nothing in a standard Sales Cloud configuration synthesizes those sObjects and fields into an actionable signal at the Opportunity record level. The result is a familiar set of expensive failure modes:

Pipeline reviews become manager interrogations rather than data-driven conversations, because reps are the only source of truth on Opportunity status and no CRM field surfaces a composite health signal. Opportunities stall silently — no logged Task or Event, no populated NextStep, no CloseDate update — and nothing in the org flags the record automatically. Forecast accuracy degrades because Opportunities stay at full value in the pipeline until they are visibly lost, with no intermediate signal that a record has gone cold in Salesforce. Opportunity Contact Role gaps go undetected — no Decision Maker, no Champion, no Economic Buyer on the OpportunityContactRole related list — until late in the deal cycle when it is too late to recover.

In CRM Infusion’s own production Salesforce org, we experienced this directly. Opportunities that appeared active in standard List Views had not had a related Task or Event logged in weeks. The data to identify the problem existed across multiple sObjects in the org. What was missing was a mechanism to synthesize it into an actionable signal on the Opportunity record itself.

The Solution

The Deal Health Score is a 0-to-100 composite calculated across six independently weighted factors. Each factor targets a specific CRM data quality or process execution gap that is directly measurable from Salesforce sObject data.

The solution replaces subjective rep self-reporting and manager intuition with a 0-to-100 composite score, a color-coded tier label, a factor-by-factor progress bar breakdown, and an actionable Fix These Now panel that fires only when a specific scoring factor hits zero — surfacing the exact Salesforce data gap hurting the deal and instructing the rep on the specific CRM action required to address it.

Technical Highlights

• Three-Trigger ArchitectureDealHealthTrigger (Opportunity after insert/update), DealHealthTaskTrigger (Task after insert/update), DealHealthContactRoleTrigger (OpportunityContactRole after insert/delete) — all delegate to DealHealthScoreService.recalculate().
• Governor-Limit SafeAll SOQL queries outside loops, single DML update against a List<Opportunity> constructed from Maps keyed by Opportunity ID. Fully bulkified across any batch size.
• DealHealth_Tier__c List View ColumnFilterable, sortable tier label derived from the composite score via nested IF() logic — instant pipeline triage without opening individual records.
• Fix These Now PanelFires conditionally only when at least one factor’s sub-score equals zero. Action prompts generated client-side by evaluating the wire adapter response — no additional @AuraEnabled Apex calls required.