agentleFS
guerrilla2799guerrilla2799/ops-and-scale-os/skills/reporting-architecture/SKILL.md

reporting-architecture

Skill1 starsChanged 3 months agoMITView on GitHub

Use when the user says "our dashboards disagree", "build a scorecard", "board reporting", "what should we report", "metric definitions", "too many dashboards", "nobody trusts the numbers", "what's our source of truth for reporting". Builds the metrics dictionary with one definition and one owner per metric, then a layered reporting stack that stops the recurring definition argument. Writes workspace/reports/metrics-dictionary.csv.

The file

We split this skill into the rules it gives an agent

2 rules. About 0 are common, 2 are distinctive, and 0 are very specific to this project.

  • ≈0

    Common · estimate

    Many files like this have a rule of this kind.

  • ≈2

    Distinctive · estimate

    This author's own choices. Worth a look.

  • 0

    Very specific

    Tied to their project's names, files or tools. Probably skip.

  • Common
  • Distinctive
  • Very specific
  1. Distinctive:

    Ask three people to define one important metric independently, in writing.

    line 25
  2. Distinctive:

    One dashboard per layer per function: Every additional dashboard is a maintenance liability and another place a definition can drift.

    line 52

≈ “Common” is an estimate: at least 1 in 5 of the 350,495 skill files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.

Keep what fits and drop the rest. Your version, ready for your agents.
Files
SKILL.md

Reporting Architecture

One metric, one definition, one owner. An undefined metric is not a measurement, it is a position in an argument.

When to use

  • Two dashboards report different numbers for the same thing
  • Board or investor reporting needs building
  • Dashboard count is growing and trust is falling
  • Somebody proposes buying BI to solve a disagreement

Inputs

  • Needs from user: every report currently in use, the metrics on each, who reads them, and the two reports that disagree
  • Reads: workspace/reports/attribution-model.md, workspace/reports/lifecycle.md

Workflow

1. Run the definition test first

Ask three people to define one important metric independently, in writing. Do this before building anything.

Three different answers, which is the usual result, means the problem is definitional. No tool fixes that. A warehouse lets the same three definitions disagree faster and at higher resolution.

2. Build the metrics dictionary

One row per metric. This is the artifact the whole skill exists to produce.

Metric | Definition (one sentence) | Formula | Source system |
Object counted | Date field used | Filters and exclusions | Owner | Refresh cadence

The four columns that resolve almost every real disagreement: object counted, date field used, filters, exclusions. When two numbers differ, one of those four differs, and finding which one is the entire investigation.

Every metric has one named owner. The owner arbitrates when a number is questioned. An unowned metric gets a new definition every time somebody builds a report.

3. Layer the reporting, three layers only

LayerAudienceCadenceContains
OperationalThe people doing the workDaily or liveQueues, SLAs, what to act on today
ManagementFunction leadsWeeklyTrends against target, stage conversion, what changed
ExecutiveBoard, exec teamMonthly or quarterlyOutcomes, efficiency, the small number of things that matter

Each layer has a different job, and mixing them produces a dashboard nobody uses. An executive view with operational detail is unreadable, and an operational view with only monthly rollups is useless.

One dashboard per layer per function. Every additional dashboard is a maintenance liability and another place a definition can drift.

4. Write the executive scorecard to fit on one page

GTM SCORECARD: <period>

OUTCOME
  Pipeline created            $n     vs target $n     n%
  Pipeline from <program>     $n
  Win rate                    n%     prior n%
  Sales cycle, median         n days prior n

EFFICIENCY
  CAC payback                 n mo   target <18
  Cost per qualified meeting  $n     prior $n
  Stack spend / ARR           n%     band 4-8%

SYSTEMS
  Tier 1 data coverage        n%
  Speed to lead, median       n min
  Attribution coverage        n%

Model: <attribution model, window, exclusions>

The model line at the bottom is not optional. It is what makes the numbers above it interpretable, and its absence is what starts the argument.

5. Kill the metrics that reward the wrong thing

Stop reportingReport instead
Records enrichedCost per usable record
Total leads in databaseTier 1 accounts with current data and mapped contacts
Emails foundVerified deliverable contacts on target accounts
Agent runs executedRuns kept without edit
Average eval scorePass rate and gate trip rate, separately
MQLsQualified opportunities and the stage rates behind them
Number of integrationsSync failure rate and tool utilization
Dashboard countMetrics with one agreed definition and a named owner

Each left-column metric rewards volume over value, and a team measured on it will produce more of the wrong thing competently.

6. Set the change protocol

Definitions will need to change. Changing one silently invalidates every prior period.

A definition change requires: the owner's approval, a dated note in the
dictionary, and a statement of which historical periods are affected.
Never restate history silently.

Output

  • Writes: workspace/reports/metrics-dictionary.csv, workspace/reports/scorecard.md
  • Uses: templates/metrics-dictionary.csv
  • Prints: the definition test result, the dictionary, the three-layer map, the one-page scorecard, and the stop-reporting list

Rules & quality bar

  • Run the definition test before building anything
  • One definition, one owner, one refresh cadence per metric
  • Object counted, date field, filters, and exclusions are mandatory columns
  • Three layers, one dashboard per layer per function
  • The attribution model appears on every report that uses it
  • Never buy BI to solve a definitional problem
  • Definition changes are dated, approved, and state what history they affect
  • Publish the stop-reporting list. Removing a bad metric is as valuable as adding a good one

Related skills

  • Requires: attribution-architecture, lifecycle-and-routing
  • Routes from: martech-stack-audit when a purchase was proposed for a definitional problem
  • See also: docs/metrics.md, docs/field-notes.md story 5

Download now (ZIP)

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

No reviews yet

People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.

  • It worked
  • Partly
  • It didn't
What did you use it for? e.g. Reviewing pull requests in a Rails app

Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.