Metric Definition & Governance System
End the "whose number is right" argument: map every conflicting metric definition, write canonical definition contracts down to grain, timezone and late-arriving data, certify and assign owners, retire the duplicates without breaking a dashboard, and catch definitions that silently drift from their code. Works in any chat model, no connected tools.
A 5-step agentic workflow pack for research built to run with ChatGPT, Claude, and Gemini. Open the Markdown files, fill the variables, and paste into your model. Most buyers get a reviewable result in about 15 minutes.
- Cluster metrics that are secretly the same metric, and name the exact axis they differ on
- Rank definition disputes by decision exposure, divergence and blast radius so you fix what costs money
- Fill a sixteen-field definition contract covering grain, time basis, timezone, late data, nulls and denominators
- Get acceptance checks an engineer can implement, so a definition is testable instead of aspirational
- Install four certification tiers with entry criteria, single accountable owners and four change classes
- Retire duplicate metrics on a five-stage ladder with dual-run variance and ready-to-send consumer notices
- Catch silent definition drift each quarter against a ten-pattern catalog and issue recertification verdicts
Prompt Customization Service — optional help adapting variables and output to your brand voice. Choose your tier at checkout (not tied to this prompt's price).
This pack is $10 on its own. Buying every pack separately costs $1538. The Lifetime Bundle is $149 one-time — you save $1389 (90% off) and unlock every future pack free.
Get the Lifetime Bundle — $149Paste the license key from your receipt. It must match this prompt pack.
What ships with your purchase
Prompt files
Plain Markdown files with `{{variables}}` you fill in, ready to paste into ChatGPT, Claude, or Gemini. No setup, no tooling required.
Usage guide
Variable reference, model compatibility, examples, and customization tips so you can adapt the pack to your brand voice.
Lifetime updates
When we improve the pack, you get the new version automatically. Email support included with every purchase.
Works with: ChatGPT, Claude, Gemini.
The workflow inside this pack
5 composable prompts you run in order — each one picks up where the last left off.
- Step 1
Metric Inventory & Conflict Map
Paste your BI or dbt metric list plus the meeting notes where two numbers disagreed.
- Step 2
Canonical Definition Contract Builder
Paste one conflict cluster plus the SQL, dbt, LookML or spreadsheet formula behind each competing version.
- Step 3
Certification Tiers & Change Control
Paste your finished contracts, the conflict severity ranking, and your team roster.
- Step 4 · optional
Duplicate Retirement Planner
Paste the conflict clusters, your certification register, and the list of dashboards, reports and jobs consuming each version.
- Step 5 · optional
Definition Drift Review
Paste your certified contracts and a fresh export of the code that computes each metric today, plus change history and published values if you have them.
Perpetual (lifetime) use license
Your one-time purchase includes an ongoing right to use this prompt pack with the AI tools and models you control for your own and your clients' work — not for resale or public redistribution of the files as a product.
We keep the copyright
The prompt files, guides, examples, and bundled assets stay our copyrighted works (or our licensors'). Payment grants the limited license in our Terms only — it does not transfer ownership.
Need help adapting this prompt to your team? Add Prompt Customization Service at checkout.