Skip to content
cccskills
FreePublished on GitHub

metric-definition-and-data-quality

Test metric definitions and source data for freshness, coverage, duplicates, missing values, impossible values, and drift.

The English summary is being prepared. Showing the original description.

Run score Not tested

See how to install

Files included (1)

  • SKILL.md2.1 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Metric definition and data quality

Run this before trusting a KPI, anomaly, cohort, funnel, or experiment result.

Pin the expected shape

Record the source, covered period, extraction time, expected grain, primary or compound key, required fields, field types, allowed ranges, timezone, and known late-arrival window. State the metric formula and population separately from the file schema.

Test in order

  1. Freshness: latest event and extract time against the expected delay.
  2. Coverage: first and last dates, missing intervals, source partitions, and control totals.
  3. Schema: missing, renamed, added, or changed-type fields.
  4. Uniqueness: exact duplicates and duplicate keys.
  5. Completeness: null and blank rates by required field and period.
  6. Validity: negative durations, impossible dates, out-of-range rates, inconsistent currencies, and broken state order.
  7. Consistency: totals across independent supplied sources and stable metric definitions across periods.
  8. Join quality: matched, unmatched-left, unmatched-right, and many-to-many row multiplication.

Report the effect

For each issue give the check, expected result, observed result, affected rows and periods, likely metric impact, severity, and owner. Show results before and after any proposed exclusion. Do not drop a bad row silently.

Use blocked when the issue can change the answer enough to affect the stated decision. Use provisional when the result remains useful with a clear bound.

Safety rules

Never repair values by guess, backfill from an unrelated period, deduplicate on name alone, or hide a failed check. Avoid exposing raw personal or sensitive fields in the report. Treat a pipeline change as a possible cause of a metric move until an independent source confirms the business change.

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Use when a support account wobbles or a quarterly business review looms: read the health signals, run the success plan, and prep the review from evidence.

The English summary is being prepared. Showing the original description.

Significant-Gravitas/skills-catalog2Updated Oct 22, 2026

Reconcile accounts by comparing GL balances to subledgers, bank statements, or third-party data. Use when performing bank reconciliations, GL-to-subledger recs, intercompany reconciliations, or identifying and categorizing reconciling items.

The English summary is being prepared. Showing the original description.

Significant-Gravitas/skills-catalog2Updated Oct 22, 2026

Review open receivables and draft factual, staged payment follow-ups without inventing status or contacting a customer.

The English summary is being prepared. Showing the original description.

Significant-Gravitas/skills-catalog2Updated Oct 22, 2026

Write ad variants that each test one idea, within platform limits and supported claims.

The English summary is being prepared. Showing the original description.

Significant-Gravitas/skills-catalog2Updated Oct 22, 2026

Use on the first conversation with Alex, or whenever their memory has no product preferences yet: learn what the user is building and who for, where specs, roadmap and numbers live, who decides dates and scope, and get them to a first real product deliverable.

The English summary is being prepared. Showing the original description.

Significant-Gravitas/skills-catalog2Updated Oct 22, 2026

Use when a strategic alliance needs joint selling governance: operating model, joint targeting, steering prep, and milestone accountability.

The English summary is being prepared. Showing the original description.

Significant-Gravitas/skills-catalog2Updated Oct 22, 2026

See all skills by Significant-Gravitas

Report a problem with this skill