Workflow · Sales and growth · Opening soon

NPS by segment

Calculate NPS by customer segment and month from exported survey scores. Use 9 to 10 as promoters and 0 to 6 as detractors.

Book a demo

Someone typed

“calculate NPS by customer segment and month from survey scores: promoters minus detractors”

The agent read it as

Calculate NPS by customer segment and month from Delighted survey responses export: promoters minus detractors, using Promoters 9–10, detractors 0–6.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

Delighted survey responses export

CSV export · 24 rows

Step

Calculate NPS by segment and month

Step 1

Result

Segment Month NPS

9 rows

Schedule

Runs when you say

Proposed

File
Delighted survey responses export
CSV export · 24 rows
Step
Calculate NPS by segment and month
Step 1
Result
Segment Month NPS
9 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 9 rows came out.

Download Delighted survey responses export sample (24 rows)Delighted: Responses > Export CSV

What you get back

The result of that run, the rows to look at first.

Segment Month NPSSample data9 rows

Customer segment	Month	Promoters	Detractors	Responses	NPS
enterprise	2026-09-01	2	0	3	66.67
enterprise	2026-10-01	2	0	4	50
enterprise	2026-11-01	1	0	1	100
smb	2026-09-01	0	0	2	0
smb	2026-10-01	1	2	4	-25
smb	2026-11-01	1	0	2	50
trial	2026-09-01	0	2	2	-100
trial	2026-10-01	0	3	3	-100
trial	2026-11-01	0	3	3	-100

9 rows in the result. Sample data: illustrative figures, not business results.

How do you calculate NPS by customer segment and month?

Export your survey results from Delighted, then group the scores by customer segment and month. Mark 9 to 10 as promoters and 0 to 6 as detractors, then calculate NPS as promoters minus detractors.

How it works

How to use the Segment Month NPS workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Segment Month NPS: questions

What export should you use?

Use the survey export that includes the score, customer segment, and date or month fields. If your export uses different column names, map them to those fields before you run the steps.

What happens to rows that do not match the rules?

Rows that do not match the rules are left out of the calculation for that step. You can review them separately and decide whether to fix the values or leave them out.

How do you change the rules?

Change the rules by editing the written conditions for each step. For example, adjust the score ranges, add a new segment rule, or change the month field you group by.