When a metric suddenly spikes, drops, or behaves differently than expected.
Business Metric Spike Detection AI Prompt
Business Metric Spike Detection is a intermediate prompt for anomaly detection. This prompt is designed to uncover unusual values, events, or patterns that differ from the normal behavior in a dataset. It helps the AI separate likely data errors from legitimate but important business exceptions. Use it when you need to investigate spikes, drops, outliers, or suspicious records in a structured way. It is best suited for direct execution against a real dataset. The requested output can include more technical detail, prioritization, and interpretation while still staying practical.
Scan all business metrics in this dataset for unusual spikes or drops: 1. For each metric, compute the week-over-week and month-over-month percentage change 2. Flag any change greater than 2 standard deviations from the historical average change rate 3. For flagged metrics, check whether the spike is isolated to one dimension (e.g. one region, one product) or affects the whole metric 4. Determine whether the spike is a one-off event or the start of a new trend 5. Rank flagged metrics by business impact (highest volume or revenue first) Return a spike report table and a plain-English summary of the top 3 most concerning changes.
When to use this prompt
When you need to separate genuine business events from likely data issues.
When monitoring operational, financial, or product data for exceptions.
When you want a ranked list of unusual records or periods for investigation.
What the AI should return
The AI should return a ranked anomaly report with the relevant records, metrics, time periods, or row indices clearly identified. It should explain which detection methods were used, why each anomaly was flagged, and whether it looks like a data issue or a real-world event. Summary tables should be supported by a short interpretation that prioritizes what to investigate first. When appropriate, the answer should include severity scores, hypotheses, and next diagnostic steps.
How to use this prompt
Open your data context
Load your dataset, notebook, or working environment so the AI can operate on the actual project context.
Copy the prompt text
Use the copy button above and paste the prompt into the AI assistant or prompt input area.
Review the output critically
Check whether the result matches your data, assumptions, and desired format before moving on.
Chain into the next prompt
Once you have the first result, continue deeper with related prompts in Anomaly Detection.
Frequently asked questions
What does the Business Metric Spike Detection prompt do?+
It gives you a structured anomaly detection starting point for data analyst work and helps you move faster without starting from a blank page.
Who is this prompt for?+
It is designed for data analyst workflows and marked as intermediate, so it works well as a guided starting point for that level of experience.
What type of prompt is this?+
Business Metric Spike Detection is a single prompt. You can copy it as-is, adapt it, or use it as one step inside a larger workflow.
Can I use this outside MLJAR Studio?+
Yes. The prompt text works in other AI tools too, but MLJAR Studio is the best fit when you want local execution, visible Python code, and reusable notebooks.
What should I open next?+
Natural next steps from here are Multivariate Anomaly Detection, Root Cause Analysis Chain, Statistical Outlier Detection.