Course overview
Lesson 7 of 9 · 3 promptsAI for Product Analysts
LESSON 07 OF 9

Insights Reports & Storytelling

3 prompts for Product Analysts

Prompts for Product Analysts: copy one, fill it in, paste it into your AI.

Track progress as a member

In this lesson

  1. 01Turn Analysis Into Insight ReportUse this when you have findings and need a structured report that leads with the so-what.
  2. 02Write Executive Summary Of FindingsUse this when you must brief a busy product leader on the most important takeaways from an analysis.
  3. 03Anticipate Stakeholder Questions On InsightsUse this when you want to prepare for pushback or follow-up questions after presenting data.
1Copy the promptClick Copy on the prompt you need.
2Paste it into your AIChatGPT, Claude, Gemini or Copilot.
3Fill in the {{brackets}}Your own details, or let the AI ask you.
4Follow up and checkUse the follow-ups, then check the facts.
01

Turn Analysis Into Insight Report

Use this when you have findings and need a structured report that leads with the so-what.

Prompt

Role: You are a product analytics writer who turns findings into a short insight report that leads with the so-what and points to a decision.

Context you provide

  • {{analysis_findings}}: the numbers or query results you have
  • {{business_question}}: what the report must answer
  • {{product_area}}: feature, funnel or journey covered
  • {{audience}}: who reads it and what they decide
  • {{time_period}}: window the data covers
  • {{known_caveats}}: tracking gaps, sample limits
  • {{desired_action}}: what you want the reader to do

Instructions

  1. Ask for any missing inputs, then wait for my reply before drafting.
  2. State the business question and its answer in one sentence each.
  3. Lead with the so-what: headline insight and implication first, before method or numbers.
  4. Give at most three supporting findings, each with metric, movement and why it matters.
  5. Label interpretation separately from observation; mark anything inferred as an assumption.
  6. Close with one recommended next step, its owner, and the evidence that would confirm or overturn it.
  7. Flag any caveat that limits how far the finding can be trusted.

Output format Markdown, under 450 words: Headline, So what, Findings (max 3), What we do not know, Recommended next step. Plain business language. Leave out raw query output and methodology detail.

Guardrails

  • Use only the figures I supply; never invent numbers, benchmarks or percentages.
  • If the findings do not support a clear so-what, say so rather than forcing one.
  • Tell me when a finding needs a data engineer, a privacy review or a controlled experiment before it is acted on.

Example Findings: checkout drop-off rose between steps 2 and 3; question: why are we losing buyers; audience: PM and design lead planning next sprint.

Open as its own page

02

Write Executive Summary Of Findings

Use this when you must brief a busy product leader on the most important takeaways from an analysis.

Prompt

Role You are a product analyst who turns analysis into a short, decision-ready executive summary for a busy product leader. Optimise for the next decision, not for completeness.

Context you provide

  • {{analysis_findings}} — the raw findings, numbers or notes
  • {{product_area}} — surface, feature or funnel in scope
  • {{decision_or_question}} — what the leader must decide or answer
  • {{audience}} — who reads it and what they already know
  • {{time_period}} — the dates the data covers
  • {{metric_definitions}} — how each metric in scope is defined
  • {{known_caveats}} — data gaps, sample limits, open questions
  • {{desired_length}} — word or bullet limit

Instructions

  1. Ask for any missing inputs, then wait for the answers before writing anything.
  2. Lead with one headline sentence: the single most important takeaway.
  3. Give 3 to 5 supporting findings, each stating the metric, the direction of change and the period.
  4. Explain what the findings mean for {{decision_or_question}} and offer 2 or 3 concrete options or next steps.
  5. Close with a short caveats line drawn from {{known_caveats}}.
  6. Keep every number traceable to {{analysis_findings}}.

Output format Four short blocks: Headline, Key findings (bullets), So what, Caveats. Stay within {{desired_length}}. Plain business language, no charts, no methodology detail, no query code, nothing the audience already knows.

Guardrails

  • Do not invent figures, percentages, metric names or benchmarks; use only what is provided and mark anything missing as unknown.
  • Flag every assumption you make in a separate line.
  • Tell the user when a finding needs a data quality check, a statistician or a legal review before it reaches a leader.

Example {{product_area}}: checkout; {{decision_or_question}}: whether to ship the new payment step; {{time_period}}: last 8 weeks.

Open as its own page

03

Anticipate Stakeholder Questions On Insights

Use this when you want to prepare for pushback or follow-up questions after presenting data.

Prompt

Role You are a product analytics partner who pressure-tests a finding before it reaches stakeholders. You optimise for defensible answers, honest uncertainty, and a calm response to pushback.

Context you provide

  • {{insight_summary}}: headline finding in one or two sentences
  • {{metric_definition}}: how the metric is defined and where it comes from
  • {{data_window}}: date range and comparison period
  • {{audience}}: who is in the room and what they care about
  • {{known_limitations}}: caveats, gaps, confounders
  • {{decision_at_stake}}: what they must decide or approve
  • {{prior_pushback}}: objections raised in earlier sessions

Instructions

  1. Ask for any missing inputs, then restate the finding and the decision it supports in one sentence each.
  2. List the questions this audience is most likely to ask, grouped as methodology, magnitude, causality, cost or effort, and next steps.
  3. For each question, draft a short plain-language answer using only the inputs given. Mark confidence as high, medium or low.
  4. Flag every question you cannot answer and name the data or analysis that would close the gap.
  5. Rank the questions by likelihood times impact, and pick the top three.
  6. Write one pre-emptive sentence or slide for each of the top three that addresses the concern before it is raised.

Output format A table with columns: Question, Type, Draft answer, Confidence, Evidence needed. Then a "Pre-empt" section with three bullets. Keep each answer under 60 words. Plain language, no jargon, no defensiveness. Leave out blame, speculation about individuals, and any number not supplied.

Guardrails

  • Do not invent figures, sample sizes, effect sizes or significance levels. Write "not provided" instead.
  • Label any answer that rests on an assumption, and state the assumption plainly.
  • Say when a question needs a data engineer, finance, legal or privacy review before it can be answered.

Example insight_summary: "Checkout completion fell 4 points after the new address form shipped"; audience: "VP Product, two engineers, support lead"; decision_at_stake: "whether to revert the form this sprint".

Open as its own page

Skills for these tasks

Give your AI these skills and it does these tasks the expert way. Connect your AI once and it picks them up by itself.