Deal Registration-to-Close Rate
Deal Registration-to-Close Rate: Percentage of registered deals that close.
Formula
Registration-to-Close = Closed deals / Registered deals × 100Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
count_distinct(field.registration_id where field.opportunity_stage = 'closed_won' and in_period(field.close_date)) / count_distinct(field.registration_id where in_period(field.registration_date))Unit: percent (the formula yields an unscaled ratio)
Notes: Registrations closed won in the period over registrations submitted in the period.
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 |
registration_id | deal_registration | string |
snapshot_date | deal_registration | date |
Example SQL (Postgres)
SELECT (CAST((SELECT COUNT(DISTINCT registration_id) FROM deal_registration WHERE snapshot_date = :period_end AND (opportunity_stage = 'closed_won' AND (close_date >= :period_start AND close_date <= :period_end))) AS DOUBLE PRECISION) / NULLIF((SELECT COUNT(DISTINCT registration_id) FROM deal_registration WHERE snapshot_date = :period_end AND (registration_date >= :period_start AND registration_date <= :period_end)), 0)) AS deal_registration_to_close_rate From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Deal Registration-to-Close Rate" }) or generate_query({ "metric": "Deal Registration-to-Close Rate", "adapter": "<your adapter JSON>" }).
Benchmarks
- Below 20%: Low quality or poor follow-through
- 20-35%: Average
- Above 35%: Good