Salesforce

Salesforce exposes a broad object model: Opportunity, Account, Lead, Contact, Case, Task, Event, Campaign, and hundreds of standard and custom objects beyond those. This integration focuses on three object types that form the core of the sales value chain: Opportunity for pipeline and revenue outcomes, Lead for top-of-funnel conversion, and Activity for rep effort signals. Objects such as Account, Contact, and Campaign were not included in this version, as they relate primarily to segmentation and relationship management rather than to individual performance flows that can be cleanly attributed to a rep. Seven KPIs were selected against three criteria: ability to attribute to an owner via the OwnerId field resolved to an email, resistance to gaming when paired with complementary indicators, and balance between leading and lagging signals.

Pipeline and revenue: reading the opportunity funnel

Five KPIs operate on the Opportunity object, covering the full arc from pipeline creation to closed revenue. They are designed to be read in combination, not in isolation.

Pipeline health and revenue outcomes

Pipeline Created measures the total value of new open opportunities a rep generates in a period. Revenue Won measures the total value of deals closed in the same period. These two indicators form the core tension of any sales operation: Pipeline Created is a forward-looking commitment signal, while Revenue Won is the backward-looking confirmation. A rep with strong Revenue Won but declining Pipeline Created is drawing down on a pipeline they built in prior periods; the shortfall will surface in revenue two or three quarters later. Reading both together provides a structural view of rep sustainability that neither indicator delivers alone.

Conversion efficiency and velocity

Win Rate measures the fraction of closed opportunities that were won. Average Sales Cycle measures the average number of days from opportunity creation to close for won deals. These two indicators carry the same structural tension as in any pipeline-based CRM: a rep with a high Win Rate and a long sales cycle may be over-investing in a small number of easy deals; a rep with a short cycle and a low Win Rate may be pursing volume without qualification rigor. Win Rate also carries a gaming risk of its own — a rep can improve it by closing or deleting poorly qualified deals rather than by improving their conversion practice. Pipeline Created serves as the counterweight here: if Win Rate rises while Pipeline Created falls, it signals tightening of entry criteria rather than improvement in execution.

Pipeline movement: Stuck Deals as an early warning

Stuck Deals counts open opportunities that have not advanced to a new stage in 30 days. Unlike the four other opportunity KPIs, it is not an outcome measure — it is a state measure. A deal that stops moving rarely closes. The value of this indicator is operational and immediate: an increase in Stuck Deals identifies which parts of the pipeline require active intervention before they become losses. When read alongside Average Sales Cycle, it distinguishes between deals that are slow because of the nature of the sale and deals that are slow because they have been neglected.

Top-of-funnel quality: Leads Converted

Leads Converted counts the number of leads a rep has qualified into opportunities in a given period. Its role in the KPI set is to validate that prospecting activity produces real commercial substance rather than noise. A rep generating high activity volume but few converted leads is investing effort without producing pipeline. When read against Pipeline Created, Leads Converted reveals the qualification efficiency of the top of the funnel: if the two indicators move together, the rep is converting what they prospect; if they diverge, it signals either poor lead quality entering the funnel or poor qualification practice at the conversion step.

Activity as a health signal: Activities Logged

Activities Logged counts completed tasks and events recorded by a rep in the period — calls, meetings, emails entered into Salesforce. This is the highest-gameability KPI in this set: a rep can log activities that did not occur, or log a high volume of low-value contacts to meet a threshold. For this reason, Activities Logged is not treated as a standalone performance indicator. It functions as a floor signal: a rep with a very low activity count is structurally unlikely to generate pipeline, regardless of other indicators. Its meaningful interpretation requires pairing with Leads Converted and Pipeline Created. If activity volume is high and pipeline creation is low, the rep is busy without producing commercial output. If activity volume is low and revenue outcomes are strong, the rep may be operating in a regime of concentrated, high-value relationships that a raw count does not capture.

Scope and limits of the integration

Salesforce records what is entered into it, not what happens in the field. A deal marked closed-won reflects the outcome of a commercial interaction; it says nothing about the quality of the negotiation, the strategic importance of the account, or the conditions under which it was won. Similarly, a lead converted to an opportunity confirms that a rep exercised judgment and created a record — it does not confirm that the resulting opportunity is well-qualified. Stage names and close dates in Salesforce vary by organization; this integration uses the IsWon and IsClosed boolean flags rather than stage labels, which makes KPI definitions portable across organizations but cannot account for the semantic differences in how organizations define deal progression.

The attribution model relies on OwnerId resolving to a user email. In organizations that route opportunities through queues, group-owned records are excluded from per-rep KPI calculation. The reliability of all seven KPIs depends directly on the data-entry discipline of the sales team: consistent use of stage fields, prompt closure of lost deals, and accurate activity logging are prerequisites for the metrics to reflect actual performance. In organizations where CRM hygiene is weak, the indicators will undercount activity and misrepresent pipeline health proportionally.