Partner Deal Registration Volume

Partner Deal Registration Volume: Number of deals registered by partners.

Formula

Deal Registrations = Count of partner-registered deals in period

Computable 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 in_period(field.registration_date))

Unit: count

Data requirements

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

Field	Dataset	Type
`registration_date`	deal_registration	date
`registration_id`	deal_registration	string
`snapshot_date`	deal_registration	date

Example SQL (Postgres)

SELECT (SELECT COUNT(DISTINCT registration_id) FROM deal_registration WHERE snapshot_date = :period_end AND (registration_date >= :period_start AND registration_date <= :period_end)) AS partner_deal_registration_volume

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

← Back to Partnerships metrics