SQL Result Explainer → Business Narrative
Convert raw query output into a concise, stakeholder-ready narrative with key takeaways and next steps.
Prompt Overview
Tips For You
Always include the exact time window in the summary. | Call out effect sizes with percentage points when conversion is involved. | List at least one concrete follow-up analysis task. | Flag any data freshness or sample size concerns early. | Avoid confident language for unproven causal claims.
From Operations TeamNexusAi TechnologyProblem It Solves
Raw tables don’t persuade. This turns result sets into clear, contextual insights and actions.
Executive-ready structure
Built-in sections fit stakeholder updates.
Evidence-first
Separates facts from hypotheses.
Actionable next steps
Turns insight into assigned tasks.
Risk register
Surfaces data quality concerns early.
AI Prompt Instructions
Act as: Analytics Lead and product decision translator.
Why this task matters: Leaders need the story behind the numbers—what changed, why it matters, and what to do next. Clear interpretation prevents misreads and speeds up action.
Important boundaries:
- Do not infer causes without evidence; label hypotheses.
- Quantify changes with absolute and percentage values; avoid vague terms.
- Flag data quality risks and sampling issues.
User inputs:
- Query objective and business context
- SQL used (or summary) and the result sample (10–50 rows)
- Metric definitions, time window, segments
- Any known experiments, holidays, outages
Objectives:
1) Summarize the metric trend and segment differences.
2) Identify likely drivers and plausible confounders.
3) Provide 3–5 actionable recommendations and a monitoring plan.
Analysis workflow:
1) Restate the question and metric definitions.
2) Profile the data: coverage, sparsity, outliers.
3) Compare period-over-period and segment deltas.
4) Draft hypotheses (evidence-backed vs. speculative).
5) Translate insights into decisions and task candidates.
6) Propose a lightweight follow-up analysis.
Required output format:
- Executive summary (≤120 words)
- Key findings (bullets with numbers)
- Risks & caveats
- Recommended actions (owner, metric, due date)
- Follow-up checks
Quality controls:
- All numbers must include units, windows, and segments.
- Separate facts from hypotheses explicitly.
Verification checklist:
- Do results align with KPI definitions and grain?
- Are anomalies acknowledged with a test plan?
Final instruction: Produce the narrative using the structure above. If inputs are thin, list clarifying questions first, then proceed with conservative interpretations.
Expected Outcome
Executive summary: Sign-ups grew 12.4% WoW, driven by mobile (+18.2%), while desktop was flat. Trial-to-paid conversion dipped 1.1pp, concentrated in APAC. Key findings: - Sign-ups: 8,420 → 9,465 (+12.4%); Mobile +18.2%, Desktop +0.8% - Conversion: 14.7% → 13.6% (-1.1pp); APAC -2.4pp - CAC steady; landing B bounce -3.1pp Risks & caveats: 9/5 payment gateway latency may inflate declines. APAC sample smaller post-holiday. Recommended actions: - PMM: Test APAC pricing copy; target +1.5pp in 10 days - Growth Eng: Optimize mobile onboarding step 2 drop; -10% drop in 14 days - Data: Validate APAC currency mapping by EOD Follow-up checks: Recut by device×region; compare cohort retention.
Implementation Journey
Summarize the table
Paste your SQL result sample into ChatGPT with this prompt. Ask for a 120-word executive summary, quantified deltas, and a clear distinction between facts and hypotheses.
6 minCross-check reasoning
Open Claude and paste the same inputs to sanity-check risks and confounders. Expect a second opinion highlighting missing segments or time windows to validate.
7 minPublish and track
Send the summary to your team’s Notes or Notion and create two follow-up tasks with owners and dates. Track the metric in a Google Sheet for the next 14 days.
8 min
