wowprompt

Pivot summary and key insights from pasted CSV data

Reads pasted CSV data, builds summary tables by the dimensions you choose and writes the insights a manager would act on. Use it for quick analysis of sales, traffic or operations exports without building a pivot table by hand.

Two summary tables grouped by chosen dimensions, a list of five numbered insights with figures and three recommended actions
The output this prompt produced, unedited.

The prompt

Fill in these first

  • What the data is: [e.g. monthly orders export from an online store]
  • Question to answer: [e.g. which regions and products drive growth]
  • Group by: [column names to summarise by, e.g. Region, Product]
  • Measure: [column to total or average, e.g. Revenue]
  • Time column, if any: [column name]
  • Data: [paste the CSV here, with the header row]

Task

Summarise the data like a pivot table, then explain what it shows in plain language.

Output format

  1. Data check: row count, date range, and any blank, duplicate or odd values found.
  2. Summary table 1: totals of the measure by the first group-by column, with share of total as a percentage, sorted highest first.
  3. Summary table 2: the measure by both group-by columns, or by period if a time column is given.
  4. Insights: five numbered findings. Each states the figure, the comparison and why it matters, in one or two sentences.
  5. Recommended actions: three actions tied directly to the insights.
  6. Chart suggestion: one chart type and which columns go on each axis.

Quality rules

  • Calculate from the data provided only; show numbers rounded consistently.
  • Every insight contains at least one number.
  • Separate what the data shows from what it might suggest. Use "may" for anything causal.
  • If the data is too small or incomplete to support a finding, say so rather than stretch it.
  • Use the currency or unit that appears in the data.
csv data analysispivot table summarydata insightssales data analysisdata summary report

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