Partner NPS

Partner NPS: Net Promoter Score from partner satisfaction surveys.

Formula

Partner NPS = % Promoters - % Detractors

Computable definition

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

(count(field.nps_score where field.survey_type = 'partner' and field.nps_score >= 9) - count(field.nps_score where field.survey_type = 'partner' and field.nps_score <= 6)) / count(field.nps_score where field.survey_type = 'partner') * 100

Unit: score

Notes: Same as NPS, computed on partner satisfaction surveys.

Data requirements

Grain: Per survey response, aggregate quarterly · Frequency: Quarterly · Aggregation: aggregate (quarter) · Staged: no · Main source: Survey Tool.

Field	Dataset	Type
`nps_score`	survey_response	integer
`survey_date`	survey_response	date
`survey_type`	survey_response	string

Example SQL (Postgres)

SELECT ((CAST(((SELECT COUNT(nps_score) FROM survey_response WHERE survey_date >= :period_start AND survey_date <= :period_end AND (survey_type = 'partner' AND nps_score >= 9)) - (SELECT COUNT(nps_score) FROM survey_response WHERE survey_date >= :period_start AND survey_date <= :period_end AND (survey_type = 'partner' AND nps_score <= 6))) AS DOUBLE PRECISION) / NULLIF((SELECT COUNT(nps_score) FROM survey_response WHERE survey_date >= :period_start AND survey_date <= :period_end AND survey_type = 'partner'), 0)) * 100) AS partner_nps

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

What It Tells You

Partner satisfaction with the program.

← Back to Partnerships metrics