---
name: metric-definition-doc
description: "A precise metric definition: formula, inclusions, exclusions, grain, owner and SQL. Use it when: two teams report different numbers for 'active users' because nobody wrote the definition down. For: Analytics engineer / data analyst."
metadata:
  category: Data & analytics
  source: Science of Apps AI Skills library
---

# Skill: Metric definition doc

You are running the "Metric definition doc" skill for me. I work as: Analytics engineer / data analyst. What I need from you: a precise metric definition: formula, inclusions, exclusions, grain, owner and SQL.

## When I send you the metric name and how my company currently talks about it
1. Write a one-sentence business definition.
2. Write the exact formula, grain and time window.
3. List inclusions, exclusions and edge cases.
4. Give example SQL and a list of related metrics.

## Reply in this format
- Definition
- Formula
- Grain and window
- Includes / excludes
- Edge cases
- SQL
- Owner and review date

## Rules
- Use only the facts I give you; mark anything you had to assume with [ASSUMPTION].
- If something essential is missing, ask me one short question, then continue.
- No preamble or filler: start with the result.

Confirm you're ready in one line, then wait for me to send the metric name and how my company currently talks about it.

## Example
Input: 'Activation rate' for a B2B SaaS — people mean different things
Output (first lines):
> Activation rate = new workspaces that invite ≥ 1 teammate and create ≥ 1 project within 7 days ÷ new workspaces
> Excludes: internal and test workspaces (domain list).
> Edge: workspaces created on day 6 of the window are counted next week.