Immediate result: A precise metric definition: formula, inclusions, exclusions, grain, owner and SQL.
Problem it solvesTwo teams report different numbers for 'active users' because nobody wrote the definition down.
'Activation rate' for a B2B SaaS — people mean different things
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.
Two teams reporting different numbers for 'active users' usually means nobody wrote the definition down. This skill writes it: a one-sentence business definition, the exact formula, grain and time window, inclusions and exclusions, edge cases, example SQL, an owner and a review date. Once agreed, the document ends arguments about whose number is right and makes onboarding new analysts faster. Run it for your ten most-quoted metrics and your company's reporting will become noticeably more consistent. To use it, paste the skill into your assistant and send the metric name and how your company currently talks about it; the reply is laid out as “Definition”, “Formula” and “Grain and window”.
# 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.Then sendThe metric name and how your company currently talks about it. For example: 'Activation rate' for a B2B SaaS — people mean different things
Upload it to Claude, add it to ChatGPT's Codex app, clone it into Claude Code, or download the SKILL.md for any agent. Full guide with screenshots →
Download the ZIP and upload it in Claude. Claude then uses the skill on its own whenever a request matches.
Download ZIP
OpenAI's Codex app reads the same SKILL.md format. Copy the skill into your Codex skills folder:
$ git -c http.version=HTTP/1.1 clone https://scienceofapps.com/skills/ai-skills.git
$ cp -r ai-skills/metric-definition-doc ~/.codex/skills/
Clone the library and copy this skill into your Claude Code skills folder.
$ git -c http.version=HTTP/1.1 clone https://scienceofapps.com/skills/ai-skills.git
$ cp -r ai-skills/metric-definition-doc ~/.claude/skills/~/.claude/skills/ for all projects, or .claude/skills/ inside one project.Download the skill file and put it in a folder named after the skill.
Download SKILL.md~/.claude/skills/metric-definition-doc/SKILL.md.Repositoryscienceofapps.com/skills/ai-skills.git · all 200 skills, one folder each, plain git over HTTPS
Two teams report different numbers for 'active users' because nobody wrote the definition down. The skill fixes that: a precise metric definition: formula, inclusions, exclusions, grain, owner and SQL.
Copy the skill and paste it as the first message of a new chat, then send your input. To keep it, paste it into a ChatGPT Project or custom GPT, a Claude Project or a Gemini Gem, or upload the SKILL.md file as a Claude Skill.
Send the metric name and how your company currently talks about it. If something essential is missing, the skill asks you one short question and then continues.
Yes. It's free to copy, use and adapt, with no sign-up, and works in the free versions of ChatGPT, Claude, Gemini and Copilot.
ProblemHundreds of open-text survey answers go unread, and only the scores get reported.
NPS survey, 340 answers to 'What's the main reason for your score?'
Slow delivery — 92 (27%) · 'Third late order this month'
Detractors mention delivery 3× more than promoters.
Action: show a realistic ETA at checkout, not the best case.
Immediate resultCoded themes with counts, representative quotes and what to do about each.
ProblemThe wrong chart hides the point — pie charts with twelve slices, dual axes that mislead.
Revenue by 9 product lines for 2025 vs 2026 · message: 3 lines drove all the growth
Chart: slope chart (or sorted dot plot), 9 lines, 2025 → 2026.
Why not grouped bars: 18 bars make the 3 winners hard to spot.
Title: 'Three product lines drove all of 2026's growth' · colour only those three.
Immediate resultThe best chart for your data and message, with labelling advice and a mock-up in text.
ProblemA retention table full of percentages doesn't tell you what's improving or why.
Monthly cohorts Jan–Jun 2026, months 0–5
Biggest drop: month 0 → 1 (100% → 38%).
Improving: May and June cohorts keep 46% at month 1 vs 34% for Jan.
Flattens at ~22% from month 3 — a real core, worth growing.
Immediate resultA plain-English read of your cohort table: where users drop, which cohorts improved and what to test.
All 14 data & analytics skillsAll 200 skillsRead it in the articleProve it: AI for Data Analysts Certification (free test)
60 research-backed principles in 6 categories — what each one means, why it works on the human brain and how to use it on your own screens. Written by Sushant Singh, founder of Science of Apps, who has scaled consumer apps to lacs of users and spent 10+ years leading product across startups and digital businesses in the US, EU & India.
110 real paywalls from top apps, taken apart, rated out of 5 and decoded with the Laws of UX — plus the frameworks, copy and checklists to ship your own. By Sushant Singh, founder of Science of Apps.