AI Blocks › Track your numbers
Metric mismatch tracer
Tell it which number differs between two reports. Get the gap, the step where they split and a fix.
Metric mismatch tracer is a free AI skill for the job "Track your numbers". Give the instructions to an AI assistant that supports the required files and tools, then review its output.
Free · No account · MIT licence · Made by Nimrod Fisher · Thinking: high
Made by Nimrod Fisher. See the original on GitHub; we copied it as it is, with its licence.
What it does
The reason two reports show different numbers for the same metric, and the exact step where they split. Name the metric and the two sources, and it finds the gap, the cause and a fix. It first confirms the exact definition: top and bottom of the ratio, filters, time zone and period. It pulls both values, row counts included, and works out the gap in amount and percent. A gap inside an agreed tolerance is noted and closed. Otherwise it walks each query step by step, looking at join types, filter order and time zones. The cause is sorted into types such as definition, freshness or aggregation, then written up with a fix.
You give it
- The metric and its business definition
- Both sources: queries, dashboard SQL or raw data
- The period with the gap
- Recent changes to pipelines or rules (optional)
- Spreadsheet (optional)
You get
- The size of the gap
- The step where the two diverge
- The root cause by type
- A corrected query or tolerance note
- A completed reconciliation report
Use it when
- Two dashboards show different revenue for the same month.
- A number changed after a pipeline update.
- A leader doubts a figure and you need a firm explanation.
- You are retiring an old report and must check the new one matches.
How to use it
- Add it to your AI once: download it and add the folder to Claude, ChatGPT or Codex as a skill.
- Ask for the job in your own words. Your AI opens the skill when it fits.