Structure your open-ended survey responses into clear themes and actionable insights so you can make faster, more confident product and business decisions.
Template components
Survey Context
Summarize the survey goal, the audience it was sent to, and the specific question(s) you are analyzing.
Example: Post-onboarding survey sent to 120 new SaaS users after their first 7 days. Key question: "What almost stopped you from completing setup?"
Raw Response Log
Paste or list every open-ended response verbatim, numbered, so nothing gets lost or paraphrased before analysis.
Example: 1. "I couldn't figure out where to connect my data source." 2. "The tooltips disappeared too fast." 3. "Wasn't sure if I needed to invite my team first." 4. "The progress bar helped but I still felt lost after step 3."
Theme Clusters
Group responses by the underlying problem or topic they share, give each cluster a short label, and note how many responses fall into it.
For each theme, write one specific action the team should take, who owns it, and a rough priority level (high / medium / low).
Example: "Navigation confusion" → Redesign data source connection flow with inline guidance. Owner: Product. Priority: High. "Unclear onboarding progress" → Add a persistent progress tracker. Owner: Engineering. Priority: Medium.
Full Copyable Template
<div class="tmpl-full-doc">
<div class="tmpl-full-header">
<div class="tmpl-full-title">Survey Response Analysis Template (free)</div>
<div class="tmpl-full-meta">Product Research Team · 2026-05-04 · Post-onboarding NPS survey, 187 responses</div>
</div>
<div class="tmpl-full-section">
<div class="tmpl-full-section-title">1. Analysis Setup</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Project / Study name</div>
<div class="tmpl-full-field-value">Q2 onboarding survey review for AcmeOps analytics workspace</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Research objective</div>
<div class="tmpl-full-field-value">Identify what helps or blocks new admins from reaching first value within the first 14 days after signup.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Survey source</div>
<div class="tmpl-full-field-value">In-app NPS follow-up and open-text onboarding survey sent to trial users after workspace setup completion.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Response volume analyzed</div>
<div class="tmpl-full-field-value">187 total responses reviewed; 162 usable open-text comments after removing blanks and duplicates.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Audience segment</div>
<div class="tmpl-full-field-value">New B2B SaaS customers: operations managers, RevOps leads, and admin users from companies with 50–500 employees.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Key survey questions</div>
<div class="tmpl-full-field-value">“What almost stopped you from getting value?” “What was easiest?” “What felt confusing or missing?”</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Unit of analysis</div>
<div class="tmpl-full-field-value">One response can receive multiple codes when it mentions more than one distinct idea.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Coding rule</div>
<div class="tmpl-full-field-value">Code only explicit statements in the text; use a secondary note when sentiment is implied but not directly stated.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Analyst notes before coding</div>
<div class="tmpl-full-field-value">Watch for repeated friction around CSV import, Salesforce sync, dashboard setup, and unclear permissions language.</div>
</div>
<div class="tmpl-full-tip">💡 Tip: Before coding, skim 20–30 responses first and confirm your code list matches the language people actually use in the survey.</div>
</div>
<hr class="tmpl-full-divider">
<div class="tmpl-full-section">
<div class="tmpl-full-section-title">2. Coding Guide</div>
<div class="tmpl-full-q">
<div class="tmpl-full-q-text"><strong>Time-to-value clarity</strong> — Comments about whether users quickly understood how to get to a meaningful outcome after signup. Example: "I created the workspace, but I still wasn't sure what the first useful report was supposed to be."</div>
</div>
<div class="tmpl-full-q">
<div class="tmpl-full-q-text"><strong>Data import friction</strong> — Mentions of trouble uploading CSVs, mapping fields, or cleaning source data before the product becomes usable. Example: "The CSV importer rejected two columns and didn't explain what format it wanted."</div>
</div>
<div class="tmpl-full-q">
<div class="tmpl-full-q-text"><strong>Integration setup confusion</strong> — Feedback about connecting external systems such as Salesforce, HubSpot, or Slack and not understanding required steps or permissions. Example: "The Salesforce sync looked straightforward until I hit the permissions page and had no idea what to grant."</div>
</div>
<div class="tmpl-full-q">
<div class="tmpl-full-q-text"><strong>Dashboard customization limits</strong> — Responses saying the default dashboards are useful but too rigid, or that key filters, widgets, or saved views are missing. Example: "The pipeline dashboard is nice, but I can't break it down by region without rebuilding everything from scratch."</div>
</div>
<div class="tmpl-full-q">
<div class="tmpl-full-q-text"><strong>Permissions and team access uncertainty</strong> — Statements about not knowing who can see, edit, or share reports, dashboards, or workspaces. Example: "I didn't want to invite the sales managers until I knew whether they could accidentally change the master dashboard."</div>
</div>
<div class="tmpl-full-q">
<div class="tmpl-full-q-text"><strong>Terminology mismatch</strong> — Cases where product labels, feature names, or setup language do not match how customers describe their workflow. Example: "We call these territories, not segments, so I kept second-guessing whether I was in the right place."</div>
</div>
<div class="tmpl-full-q">
<div class="tmpl-full-q-text"><strong>Support and documentation effectiveness</strong> — Mentions of help center articles, onboarding emails, chat support, or walkthroughs either resolving or failing to resolve a problem. Example: "The setup article existed, but it skipped the exact admin step I got stuck on."</div>
</div>
<div class="tmpl-full-q">
<div class="tmpl-full-q-text"><strong>Evidence of product value</strong> — Specific moments where a user describes the product proving its usefulness through saved time, clearer reporting, or stakeholder visibility. Example: "Once the weekly churn dashboard populated, I finally had something I could share with leadership immediately."</div>
</div>
<div class="tmpl-full-tip">💡 Tip: Keep codes narrow enough that two analysts would tag the same response similarly, but broad enough to capture repeated patterns across dozens of comments.</div>
</div>
<hr class="tmpl-full-divider">
<div class="tmpl-full-section">
<div class="tmpl-full-section-title">3. Theme Log</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Theme: Data import friction · <span style="font-weight:400;color:#888">41 mentions</span></div>
<div class="tmpl-full-field-value">Many new admins hit avoidable friction in the CSV Importer when mapping custom fields and date formats, delaying first analysis by hours or days. Top quote: "I had our pipeline export ready, but the importer kept flagging close_date and owner_id without telling me what valid formatting looked like." → Recommended action: add inline field-format examples, show row-level validation errors, and provide a one-click sample CSV for common CRM exports.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Theme: Integration setup confusion · <span style="font-weight:400;color:#888">33 mentions</span></div>
<div class="tmpl-full-field-value">The Salesforce and HubSpot connectors create momentum at first, but permission scopes and sync-status messaging cause drop-off before users trust the data. Top quote: "The Salesforce connection said 'connected,' but nothing was pulling in, and I couldn't tell if it was still syncing or if I broke it." → Recommended action: redesign connector onboarding with clearer permission instructions, estimated sync time, and a visible troubleshooting checklist inside the setup flow.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Theme: Dashboard customization limits · <span style="font-weight:400;color:#888">27 mentions</span></div>
<div class="tmpl-full-field-value">Users appreciate the default Executive Overview dashboard, but power users quickly want region filters, custom formulas, and reusable widget layouts that are not obvious or not available. Top quote: "The Executive Overview got me 80% there, but the minute my VP asked for EMEA-only conversion rates, I had to duplicate the whole dashboard and hack around it." → Recommended action: prioritize segment-level filters, easier widget duplication, and a 'save as team template' option for common dashboard variants.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Theme: Permissions and team access uncertainty · <span style="font-weight:400;color:#888">22 mentions</span></div>
<div class="tmpl-full-field-value">Admins hesitate to invite collaborators because report editing rights, viewer access, and workspace-level permissions are not easy to understand during setup. Top quote: "I held off inviting our CS lead because I couldn't tell whether 'editor' meant they could edit just their view or change the company dashboard for everyone." → Recommended action: simplify role labels, add plain-language permission previews, and show exactly what each role can do before invites are sent.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Theme: Evidence of product value · <span style="font-weight:400;color:#888">19 mentions</span></div>
<div class="tmpl-full-field-value">When users reach a live dashboard with their own data, they describe a sharp jump in confidence and are more likely to mention sharing insights with leadership or their GTM team. Top quote: "The first time the Weekly Pipeline Health board populated with our actual stages, I screenshotted it and sent it straight to our CRO." → Recommended action: accelerate users toward a populated first dashboard by auto-generating a recommended view immediately after import or sync completion.</div>
</div>
<div class="tmpl-full-tip">💡 Tip: A good theme card captures three things in one place: what happened repeatedly, evidence from a verbatim quote, and what the team should do next.</div>
</div>
<hr class="tmpl-full-divider">
<div class="tmpl-full-section">
<div class="tmpl-full-section-title">4. Pattern Checks and Interpretation Notes</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Segment differences observed</div>
<div class="tmpl-full-field-value">Operations managers mentioned CSV import friction more often, while RevOps leads more frequently raised concerns about Salesforce permission scopes and sync reliability.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Responses with multiple themes</div>
<div class="tmpl-full-field-value">A common pairing was integration setup confusion + time-to-value clarity, suggesting users do not just struggle with setup—they also lose sight of the payoff while blocked.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Outliers worth reviewing separately</div>
<div class="tmpl-full-field-value">A small number of enterprise respondents requested audit logs, SSO mapping, and sandbox environments; these are important but should not be merged into core onboarding themes for SMB and mid-market trials.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Potential bias or limitations</div>
<div class="tmpl-full-field-value">This sample overrepresents users who finished initial setup and chose to answer an in-app survey, so the analysis may understate problems faced by users who dropped before activation.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Questions for follow-up research</div>
<div class="tmpl-full-field-value">Should we run 5 moderated onboarding sessions focused on Salesforce connection setup, and should we compare import completion rates by template type?</div>
</div>
<div class="tmpl-full-tip">💡 Tip: Add interpretation only after coding is complete; otherwise, early assumptions can bias which themes you notice most often.</div>
</div>
<hr class="tmpl-full-divider">
<div class="tmpl-full-section">
<div class="tmpl-full-section-title">5. Summary Findings</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Top 3 themes by volume</div>
<div class="tmpl-full-field-value">1) Data import friction (41 mentions), 2) Integration setup confusion (33 mentions), 3) Dashboard customization limits (27 mentions)</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Most urgent action</div>
<div class="tmpl-full-field-value">Improve the CSV Importer experience first, because it is the largest onboarding blocker and directly delays users from reaching a populated dashboard.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Metric to track</div>
<div class="tmpl-full-field-value">Activation rate to first populated dashboard within 7 days, plus CSV import completion rate and connector setup completion rate by source.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Key takeaway for stakeholders</div>
<div class="tmpl-full-field-value">Users believe the product can deliver clear reporting value, but setup friction in imports, integrations, and permissions prevents that value from being realized consistently.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Priority actions for next sprint</div>
<div class="tmpl-full-field-value">Ship importer validation improvements, add connector progress states, and rewrite permission labels with clearer role descriptions.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Share with</div>
<div class="tmpl-full-field-value">Product manager, onboarding squad, design lead, lifecycle marketing, customer success leadership, and sales engineering.</div>
</div>
<div class="tmpl-full-field">
<div class="tmpl-full-field-label">Stakeholder notes</div>
<div class="tmpl-full-field-value">Engineering should review whether current import errors can be surfaced client-side; Customer Success should align setup documentation with the top friction points found here; Marketing can reuse value-proof quotes in onboarding messaging once setup blockers are reduced.</div>
</div>
<div class="tmpl-full-tip">💡 Tip: End with decisions, not just observations—your summary should make it obvious what the team should fix, who needs the findings, and how success will be measured.</div>
</div>
</div>
How to use it
Collect and paste all responses Export your open-ended survey answers into the Raw Response Log section so every piece of feedback is in one place before you begin.
Read through once without categorizing Do a single pass of all responses to get a feel for the overall tone and recurring language before you start assigning themes.
Group responses into theme clusters Re-read each response and assign it to an existing theme or create a new one, then count how many responses belong to each cluster.
Define one action per theme For every cluster, write a single concrete next step, assign an owner, and set a priority so insights actually move to execution.
What it looks like filled in
Confusing Data Connection Step
"I spent 20 minutes trying to find where to plug in my spreadsheet — I nearly gave up entirely."
→ Add a prominent "Connect your data" CTA on the dashboard home screen with a short explainer video linked inline.
Unclear Progress During Setup
"I had no idea how many steps were left or if I had already missed something important."
→ Implement a persistent step-by-step progress bar visible throughout the entire onboarding flow.
Uncertainty About Team Invitations
"I wasn't sure if I was supposed to add my colleagues before or after I finished the initial setup."
→ Add a contextual tooltip on the team invite screen clarifying that invitations can be sent at any point after account creation.
Why teams skip the template
Manual grouping takes hours at scale Reading through hundreds of open-ended responses and hand-sorting them into themes is time-consuming and introduces inconsistency when different team members categorize the same response differently.
You miss low-frequency but high-impact signals When scanning manually, it is easy to over-weight the loudest or most repeated responses and accidentally ignore a small cluster of feedback that points to a critical churn risk or unmet need.
Insights go stale before they reach the team By the time you finish coding responses, writing up themes, and formatting a shareable summary, the window to act on timely feedback has often already closed.
Analyze your survey responses automatically — no template needed