nps_response

The nps_response semantic model contains NPS (Net Promoter Score) survey responses with scoring metrics. Each record represents one survey response.

Use dimensions to filter and group results, and measures for NPS aggregations.

Dimensions

Core

Name	Type	Description
id	string	Response ID (primary key)
score	number	NPS score (0–10)
category	string	NPS category: Promoter, Passive, or Detractor
status	string	Response status: Open, Closed
comment	string	Free-text comment from the respondent
body_region	string	Body region associated with the response

Timestamps

Name	Type	Description
created_at	time	When the response was submitted
updated_at	time	When the response was last updated
deleted_at	time	When the response was soft-deleted

Display Names

Name	Type	Description
patient_first_name	string	Patient's first name
patient_last_name	string	Patient's last name
patient_full_name	string	Patient's full name
location_name	string	Location name
location_display_name	string	Location display name
provider_first_name	string	Provider's first name
provider_last_name	string	Provider's last name
payer_name	string	Payer name
nps_survey_name	string	Survey name

Internal IDs

Name	Type	Description
provider_organization_id	string	Organization ID
location_id	string	Location ID
provider_id	string	Provider ID
referring_provider_id	string	Referring provider ID
patient_id	string	Patient ID
payer_id	string	Payer ID
owner_id	string	Owner (user) ID
nps_survey_id	string	Survey ID

External EMR IDs

Name	Type	Description
external_patient_id	string	Patient ID in external EMR
external_location_id	string	Location ID in external EMR
external_provider_id	string	Provider ID in external EMR
external_payer_id	string	Payer ID in external EMR
external_referring_provider_id	string	Referring provider ID in external EMR

Measures

Name	Type	Format	Description
count	count		Total number of responses
detractor_count	count		Number of detractor responses (score 0–6)
passive_count	count		Number of passive responses (score 7–8)
promoter_count	count		Number of promoter responses (score 9–10)
score_sum	sum		Sum of all scores
detractor_percentage	number	percent	Percentage of responses that are detractors
passive_percentage	number	percent	Percentage of responses that are passive
promoter_percentage	number	percent	Percentage of responses that are promoters
net_promoter_score	number		NPS: promoter percentage minus detractor percentage
mean_net_promoter_score	number		Mean score across all responses

Segments

Name	Description
not_deleted	Excludes soft-deleted responses (deleted_at IS NULL)

Example Query

NPS score by location:

SELECT
  nps_response.location_name,
  MEASURE(nps_response.count),
  MEASURE(nps_response.net_promoter_score),
  MEASURE(nps_response.promoter_percentage),
  MEASURE(nps_response.detractor_percentage)
FROM nps_response
WHERE nps_response.not_deleted = true
  AND nps_response.created_at >= '2024-01-01'
GROUP BY 1;