nps_response_trend

The nps_response_trend semantic model tracks which trends are associated with NPS responses. Each record links a response to a trend. Use this semantic model for trend analysis across NPS data.

Dimensions

Name	Type	Description
id	string	Response-trend link ID (primary key)
type	string	NPS category: Promoter, Passive, or Detractor
created_at	time	When the record was created
updated_at	time	When the record was last updated
provider_organization_id	string	Organization ID
response_id	string	Associated NPS response ID
trend_id	string	Associated trend ID
trend_name	string	Trend display name

Measures

Name	Type	Format	Description
count	count		Total number of response-trend associations
detractor_count	count		Associations where the response type is Detractor
passive_count	count		Associations where the response type is Passive
promoter_count	count		Associations where the response type is Promoter
detractor_percentage	number	percent	Percentage of associations that are detractors
passive_percentage	number	percent	Percentage of associations that are passive
promoter_percentage	number	percent	Percentage of associations that are promoters

Example Query

Detractor and promoter percentage by trend:

SELECT
  nps_response_trend.trend_name,
  MEASURE(nps_response_trend.count),
  MEASURE(nps_response_trend.detractor_percentage),
  MEASURE(nps_response_trend.promoter_percentage)
FROM nps_response_trend
GROUP BY 1
ORDER BY MEASURE(nps_response_trend.detractor_percentage) DESC
LIMIT 10;