← Prompt Library / Data

Data

Metric Definition Doc

Pin down a business metric so every team computes it identically: formula, filters, edge cases, and the deliberately-excluded lookalikes.

Define this metric precisely: {{metric}} (what we call it, roughly what it means, the arguments people have about it).

Document: the formula in words AND pseudo-SQL, the exact population (who/what counts — and the edge cases decided: trials? refunds? internal users? timezone of 'day'?), the grain (per user? per account? per day?), what it deliberately EXCLUDES and why, the lookalike metrics it gets confused with and how they differ, known limitations (where it misleads), and the owner. Resolve each 'argument' from my notes with an explicit ruling — an ambiguous metric is worse than no metric.

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

metrics definitions governance

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...