wowprompt

Survey results analysis with cross-tabs and coded open answers

Takes exported survey responses and returns a clear analysis: headline results, the differences between customer groups that matter, open-ended answers coded into themes with counts, and an honest note on sample size. Use it after a customer, employee or market survey closes and someone needs findings, not a pile of charts.

A survey findings summary with headline percentages, a cross-tab table by customer group, coded open-answer themes with counts, and limits stated
The output this prompt produced, unedited.

The prompt

What to give

  • Survey purpose: [e.g. find out why repeat customers buy less in winter]
  • Questions as asked, with answer options: [paste]
  • Responses: [paste the export, one row per respondent]
  • Groups to compare: [e.g. city, age band, new or repeat customer]
  • Who will read the findings: [e.g. the founder and the marketing lead]

Check before analysing

  1. Count total responses and complete responses; drop blank and duplicate rows and say how many.
  2. Flag any group with fewer than 30 people as too small to compare with confidence.
  3. Note questions that many people skipped.

Analyse

  1. Headline result for each question, as a percentage with the base number shown.
  2. Cross-tabs for the groups named, keeping only differences large enough to act on.
  3. Code every open answer into themes; one answer can carry two themes.
  4. Pick two or three quotes per main theme, word for word.

Output format

  1. Five key findings, one sentence each, with the figure behind them.
  2. | Question | Group A | Group B | Group C | Difference worth noting |
  3. | Theme | Definition | Count | Share of answers | Example quote |
  4. Recommended actions, each tied to a finding.
  5. Limits: sample size, who did not respond, and any wording that may have led answers.

Quality rules

  • Percentages always show their base, such as 42% of 210.
  • Never present a difference within a small group as a trend.
  • No names or contact details in the output.
survey analysiscross tabulationopen ended responsessurvey results reportcoding survey answerscustomer survey findings

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