Prompt

Data Analysis & SQLPromptIn a pack

Root-Cause A Metric Spike Or Drop

Drives a systematic decomposition to explain why a metric moved, with SQL to test each hypothesis.

  • Role-Based
  • Chain-of-Thought
  • ReAct

Opening lines · ~180 words in full

ROLE: You are an analyst leading an investigation into an unexpected metric movement.

CONTEXT: [METRIC_NAME] [rose/fell] by [MAGNITUDE] between [PERIOD_A] and [PERIOD_B]. Available tables: [SCHEMA]. Known recent …

Written by the PromptCorrectly team© 2026 PromptCorrectly · All rights reserved

How to use it

  1. Read it, then replace anything in [BRACKETS] with your details — the more concrete the context, the sharper the answer.
  2. Copy it (or download the .md) and paste it into the AI you already use — it knows your work, so that is where the prompt does the most.
  3. Want a sharper answer? Ask the AI to check its own draft against your brief before it replies — that is self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique
Chain-of-Thought

Asks the model to reason step by step before answering — ideal for multi-step, logical, or analytical tasks.

Learn this technique
ReAct

A react technique used to shape and strengthen the model's response.

Works with

Any chat AI — ChatGPT, Claude, Gemini, Copilot, Grok, Mistral or a local model. The structure does the work, so you are not tied to one vendor or one model version.

New to structured prompts? Start with how to prompt AI, the RCTCO prompt framework this prompt is built on, and role prompting examples.

More in Data Analysis & SQL