Survey Summarizer
Someone ran a great survey, got 200 responses, and now faces a wall of free-text answers they'll never systematically read. They'll skim 20, form a biased impression, and present that as 'findings.' The Survey Summarizer runs a rigorous coding pass instead — themes by frequency and intensity, sentiment by theme, verbatim quotes preserved, and the actions each theme demands.
What this skill does
Survey data sits in spreadsheets rotting. The default workflow is to skim 20 responses, form a biased impression, and present that as "what customers said." This skill replaces that with the THEME method — Tag, Hierarchy, Evidence, Magnitude, Exceptions — which forces every response through a structured coding pass and produces themes that survive scrutiny rather than themes that survived a coffee break.
Sample size determines what the skill will and won't say. Below 10 responses, it treats them as qualitative interviews with no percentages — each response gets individual attention. 10-29 gets counts, not percentages ("7 of 15 respondents," never "47%"). 30-99 allows percentages but flags segment comparisons as directional only. 100+ unlocks full statistical analysis with reliable segment splits when each segment has 30 or more. These guardrails matter because a "23% prefer X" headline from 13 responses is the kind of claim that survives a meeting and gets a product roadmap wrong.
Bimodal distributions get treated separately rather than averaged. If responses cluster at both 9-10 and 2-3 on satisfaction, reporting the average of 5 describes nobody. The skill detects bimodal patterns, splits the report, and investigates what distinguishes the two groups — which is usually the most important finding in the survey. Same logic for thematic clustering: a theme mentioned by five furious customers outweighs a mild suggestion from thirty, so frequency and intensity are reported as separate columns rather than collapsed into a single rank.
Verbatim quotes are preserved as the strongest evidence. The phrases customers use to describe your value are better marketing copy than anything your team will write — "it's like having a CFO without the £150K salary" beats any sentence that contains "comprehensive financial oversight." The skill flags phrases that appear repeatedly across different respondents as headline candidates, with the count, and leaves them in the customer's words rather than paraphrasing them into corporate-speak.
You get the quantitative snapshot with bimodal flags, the theme map ranked by frequency AND intensity, sentiment overlay per theme, response-rate-driven trust assessment (below 20% gets flagged for non-response bias, above 50% gets called a strong sample), the top three findings with evidence, recommended action, owner, and urgency, and a blind-spots section naming what the survey didn't capture and what the follow-up should ask. Comparative surveys get trend lines per theme and statistical significance flags on between-wave changes. The skill refuses to spin: if data is overwhelmingly negative, it stays negative; if one theme dominates, minor themes don't get equal weight for aesthetics. Observation gets separated from interpretation throughout — "23 respondents mentioned slow response times" is fact; "this suggests understaffing" is inference, and the skill labels which is which.
When this triggers
- ·You have a survey with 50+ open-ended responses and no time to read each one
- ·NPS comments are piling up and you want themes, not a vibe check
- ·Customer interviews or feedback forms have rich qualitative data sitting unmined
- ·You need to present survey findings to a stakeholder and 'most people said X' isn't going to fly
- ·You ran a comparative or longitudinal survey and want to see what's actually changed wave-over-wave
Example
Trigger
User pastes 120 NPS responses from a fractional CFO product: scores plus free-text, 6 months of data.
Output
Survey Overview Audience: paying customers | N: 120 | Period: Oct-Mar Response rate: 41% (adequate, directional findings reliable) Quantitative Summary NPS: +34 (Promoters 51%, Passives 32%, Detractors 17%) Distribution: bimodal at 9-10 and 4-5 — investigate the 4-5 cluster separately, the average hides them. Theme Map | Theme | Freq | Intensity | Sentiment | |--------------------------|------|-----------|-----------| | "CFO replacement" framing| 28 (23%) | High | Positive | | Bank connection friction | 19 (16%) | High | Negative | | Pricing comprehension | 14 (12%) | Med | Mixed | | Speed of insights | 17 (14%) | High | Positive | | Onboarding step 3 | 9 (8%) | High | Negative | Sentiment by theme Positive themes dominate promoter responses. Detractor cluster concentrates on bank connection (12 of 21 detractor mentions) and onboarding step 3 (6 of 21). Pricing comprehension splits between passives and detractors. Key Findings & Actions 1. FINDING: Bank connection is the single biggest detractor driver EVIDENCE: Mentioned by 19 (16%), 12 of 21 detractors QUOTE: "Spent 40 minutes trying to connect Monzo, gave up twice" ACTION: Audit and rebuild bank connection flow URGENCY: Now 2. FINDING: "CFO replacement" framing is your strongest market handle EVIDENCE: 28 separate near-verbatim mentions QUOTE: "It's like having a CFO without the £150K salary" ACTION: Move this phrasing to landing page hero URGENCY: This quarter 3. FINDING: Bimodal NPS distribution — two products, not one EVIDENCE: Cluster at 9-10 (loves automation), cluster at 4-5 (wants more advisory). Average misleads. ACTION: Segment users by use case before next survey URGENCY: Now Blind spots · 59% non-respondents — unclear if silent users are happy or churning · No churn-cohort comparison — recommend separate exit survey
Get this skill + 8 more
Get the full Data & Analysis pillar (9 skills) or the complete library.
Get the full stack — $299What you get
- 146-line SKILL.md, ready to drop into ~/.claude/skills/
- Tested through 3 Karpathy-loop iterations (versions v1.0.0 → v1.3.0)
- Triggers automatically when relevant — no command to remember
- Lifetime updates as the skill is refined further
More from Data & Analysis
Doesn't just rate numbers — it finds the dangerous combinations that individual metrics hide
Doesn't build static spreadsheets — it builds dynamic models that answer "what if" questions
Doesn't just pick metrics — it designs information systems that make the right action obvious at a glance
Doesn't just explain what the data says — it constructs a story arc that makes the insight unforgettable and the next step obvious
Doesn't just pick a number — it models the unit economics, test pricing structures, and find the price point where profit, volume, and market positioning intersect
Doesn't produce data dumps with commentary — it produces documents that drive decisions
Browse the full library
297 skills across 31 categories. One purchase, lifetime updates.
See all bundles