wowprompt

Survey results analysis with themes from open answers

Analyses survey responses, including rating questions and open text, and returns percentages, themes with quotes and priorities. Use it after a customer, employee or product survey to report findings without reading every answer by hand.

A results table per question with percentages, a theme table with counts and representative quotes, and a prioritised action list
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Survey purpose: [e.g. why trial users did not upgrade]
  • Audience and number of responses: [who answered, how many]
  • Rating or choice questions: [paste the questions and responses]
  • Open text question: [paste the question]
  • Open text answers: [paste the answers, one per line]
  • Segment to compare, optional: [e.g. new vs returning customers]

Task

Summarise the closed questions with numbers and group the open answers into themes, then turn both into priorities.

Output format

  1. Response overview: total responses, completion notes, and any segment sizes.
  2. Closed questions: for each, a table with option, count and percentage. If an NPS question is included, show promoters, passives, detractors and the score.
  3. Themes from open answers:

| Theme | Description | Count | Share of answers | Two representative quotes |

  1. Segment differences: up to three notable gaps between segments, if a segment was given.
  2. Priorities: a ranked list of up to five actions, each tied to a theme or result, with an effort estimate of low, medium or high.

Quality rules

  • Percentages add to 100 for single-choice questions; note when multiple choice allows more.
  • One answer can belong to more than one theme; say so in the notes.
  • Quote answers word for word and keep them anonymous.
  • Create a theme only when at least three answers support it; group the rest as "Other".
  • Flag small samples: under 30 responses, describe findings as directional.
survey analysiscustomer feedback analysisopen ended responsesthematic analysisnps analysis

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity