Partnerships Deal Flow Operational

Partner Sales Cycle

Partner Sales Cycle: Median sales cycle for registered partner deals that closed won in the period, from registration to close.

Formula

Partner Sales Cycle = Median of (Close date - Registration date) for partner deals

Computable definition

The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.

median(field.close_date - field.registration_date where field.opportunity_stage = 'closed_won' and in_period(field.close_date))

Unit: days

Notes: Registered deals only; measured from registration to close on the deal registration record.

Data requirements

Grain: Per event · Frequency: Per registration · Aggregation: event · Staged: no · Main source: Partner Management.

Field	Dataset	Type
`close_date`	deal_registration	date
`opportunity_stage`	deal_registration	string
`registration_date`	deal_registration	date
`snapshot_date`	deal_registration	date

Example SQL (Postgres)

SELECT (SELECT PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY (close_date - registration_date)) FROM deal_registration WHERE snapshot_date = :period_end AND (opportunity_stage = 'closed_won' AND (close_date >= :period_start AND close_date <= :period_end))) AS partner_sales_cycle

From an agent: with the GASP MCP server, call lookup_metric({ "name": "Partner Sales Cycle" }) or generate_query({ "metric": "Partner Sales Cycle", "adapter": "<your adapter JSON>" }).

← Back to Partnerships metrics