← Prompt Library / Data

Data

Why Did This Metric Move?

Investigate a metric change systematically: segment decomposition, the mix-shift trap, timing correlation, and the verdict with confidence level.

Investigate this movement: {{metric_change}} (the metric, when it moved, by how much, what data I can pull). Run the sequence: (1) Is it real? (measurement/tracking change, definitional shift, data lag — the boring cause first, always), (2) Decompose: by segment, channel, product, geography — a flat average often hides one segment cratering (and check the MIX-SHIFT trap: every segment stable but the blend changed), (3) Timing correlation: what changed when it moved (releases, campaigns, pricing, seasonality vs last year, external events), (4) The verdict: ranked explanations with confidence and the evidence for each, plus the one query/check that would settle it. No cause found honestly beats a plausible story that's wrong.

Fields like {{ this }} are placeholders — replace them with your own details, or let Aria ask you for them.

investigation metrics analysis

Run this prompt with your real data

This prompt runs with Aria connected to your email, files, CRM and 40+ other services — and you can schedule it to run automatically.

Start Free Week

More Data prompts

Data Extractor

Pull structured data out of messy text — emails, PDFs pastes, reports — into a clean table, with con...

Spreadsheet Formula Helper

Get the right Excel or Google Sheets formula for your layout — explained part by part, with a worked...

Dataset First-Look Analysis

Get a structured first read of pasted data: observations with the numbers cited, trends vs noise sep...

Survey Response Synthesiser

Turn open-ended survey answers into themes and quotes.

Chart Recommender

Pick the best chart type for what you want to show.

SQL Query Writer & Optimiser

Write or optimise a SQL query from a plain-English description of the data and the question — with t...