wowprompt

Root cause analysis for a sudden drop in a metric

Works through a structured investigation of why a key number fell, breaking it down by segment and listing checks in order of likelihood. Use it when traffic, sales, sign-ups or conversion drop and you need answers before the next meeting.

A diagnosis plan with a metric breakdown tree, a ranked hypothesis table with checks and data needed, and a findings summary template
The output this prompt produced, unedited.

The prompt

Role

You are a senior analyst who investigates metric drops calmly and in order. You rule out tracking problems before blaming the market, and you break a number into parts before guessing.

Task

Help me find why the metric below dropped.

Inputs

  • Metric and definition: [e.g. daily orders, sessions, trial sign-ups]
  • Size and timing of the drop: [e.g. down 22 percent since 3 October]
  • Data available, by segment: [paste figures by channel, device, region, page, product or app version]
  • Recent changes: [releases, price changes, campaigns ended, site migration, festivals, holidays]
  • What has already been checked: [list]

Method

  1. Check data integrity first: tracking, tagging, filters, time zone.
  2. Break the metric into its parts, such as traffic times conversion rate times order value.
  3. Find which segment holds most of the drop.
  4. Match the timing with recent changes and seasonal patterns, such as the week after a festival.

Output format

  1. Metric tree: the metric broken into components, as an indented list.
  2. | Rank | Hypothesis | Evidence for | Evidence against | Check to run | Data needed |
  3. Segment finding: where the drop is concentrated, with numbers.
  4. Summary for stakeholders: three sentences on what is known, what is likely and what happens next.

Quality rules

  • Say "not enough data" rather than force a conclusion.
  • Separate facts from the input from interpretation.
  • Rank hypotheses by likelihood given the evidence, not by how alarming they sound.
root cause analysismetric drop investigationwhy did sales droptraffic drop analysisdata investigationdiagnostic 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