)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
HubSpot’s native NPS reporting gives you aggregate scores that don’t break down by product line. When you need to understand how customers feel about specific products, those overall numbers hide the insights you actually need.
Here’s how to get granular, product-specific NPS calculations that update automatically as new survey responses come in.
Import raw NPS data with product associations using Coefficient
CoefficientHubSpotThe key is accessing individual survey responses alongside contact properties that show product associations.connects yoursurvey data directly to spreadsheets where you can apply unlimited custom filtering and build proper NPS calculations for each product group.
How to make it work
Step 1. Import NPS survey responses with contact properties.
HubSpotConnect tothrough Coefficient and import your survey responses. Include contact properties like product associations, purchase history, and any custom fields that identify which products each customer uses. This gives you the raw data that HubSpot’s standard reports aggregate away.
Step 2. Apply product-specific filters to segment responses.
Use Coefficient’s filtering capabilities to create separate datasets for each product group. You can apply up to 25 filters with AND/OR logic, like “Product Category = Software AND Purchase Date > 2024-01-01.” Set up dynamic filters that reference spreadsheet cells so you can switch between product segments instantly.
Step 3. Build proper NPS formulas for each product segment.
For each filtered product group, create the correct NPS calculation: (% Promoters – % Detractors) × 100. Count responses of 9-10 as promoters, 0-6 as detractors, and calculate percentages based on total responses in that product segment. This gives you mathematically accurate NPS scores rather than simple averages.
Step 4. Set up automatic refreshes for live updates.
Schedule your imports to refresh hourly, daily, or weekly. As new survey responses come in, your product-specific NPS scores update automatically without manual intervention. Use Formula Auto Fill Down so your calculations extend to new data automatically.
Get actionable product insights instead of aggregate noise
Start buildingProduct-specific NPS scores reveal which parts of your business are thriving and which need attention. Instead of working with misleading averages, you get precise insights that drive better product decisions.your segmented NPS analysis today.
