PromptSharpPrompt LibraryMarketing › Metric dictionary: kill the double-counted number

Analytics & ReportingFREE

Metric dictionary: kill the double-counted number

Two dashboards disagree about 'leads' again — in front of your boss. Write the metric definitions document that ends the recurring argument.

The prompt — copy and run it

You are a marketing data steward writing a metric dictionary. I will list our reporting metrics and known disagreements. Produce:

A) A METRIC DICTIONARY table: metric name, exact definition (including time window, deduplication, and filters), source system, owner, and — where I flagged a disagreement — the known gap between systems.
B) CONFLICT TRIAGE: each disagreement classified as DEFINITIONAL (two valid definitions that need different names), DATA BUG (one number is simply wrong), or TIMING (window/refresh mismatch) — with the resolution path per class.
C) THE GOVERNANCE LINE: which number is canonical for which audience (operational, executive, client or board), and the one-line rule for introducing any new metric to reporting.

My metrics: [PASTE: metrics used in reporting, the system each comes from, the disagreements you have hit, who consumes which report]

Rules: Do not invent, estimate, or fabricate any statistic, benchmark, or performance figure — if a number is not in the material I give you, write "not provided" and flag it. Mark every claim I should verify in my analytics or source systems before it is published or presented. Never include customer personally identifiable information or client-confidential terms.

How to use this prompt

  1. Copy the full prompt above with the Copy button.
  2. Add your context. This prompt runs as-is — paste it, then add the specific details, data, or files it should reason over.
  3. Paste into ChatGPT, Claude, or Gemini and run. Read the reality guardrail below before you act on the output.

Why this prompt works

Most reporting fights are two correct numbers with different definitions wearing the same name. Splitting conflicts into definitional-versus-bug ends the recurring meeting — and naming a canonical number per audience means executives stop catching the discrepancy before you do.

Get a prompt like this every day

The PromptSharp Marketing Brief ships one desk-ready prompt every weekday — free on the web today. Free forever. Today's Marketing issue is live on the web right now — subscribe and we email you the sample issue immediately, then the Marketing daily every weekday as its email edition ships. Unsubscribe anytime.

Subscribe free → Read a sample issue
Reality guardrail: this prompt makes the model reason from data you paste — it does not source or verify facts for you. Check every claim, keep confidential data out of consumer AI tools, and follow your employer's AI-use policy.

Frequently asked

When should I use this prompt?

Two dashboards disagree about 'leads' again — in front of your boss. Write the metric definitions document that ends the recurring argument.

Why does this prompt work?

Most reporting fights are two correct numbers with different definitions wearing the same name. Splitting conflicts into definitional-versus-bug ends the recurring meeting — and naming a canonical number per audience means executives stop catching the discrepancy before you do.

Related Marketing prompts

Marketing

Anomaly runbook: the metric moved — check in this order

A KPI spiked or cratered and the channel wants answers now. Work the ordered runbook before anyone ships a theory that sticks.…

Marketing

Executive one-pager: 3 numbers, 3 insights, 3 asks

Leadership wants the marketing readout on one page — and every number on that page will be challenged. Compress without losing the…

Marketing

Post-campaign wash-up that tells the truth

Campaign is done, the readout is due. Write the retro that says what the numbers support — not the one that launders the result in…

Marketing

Budget reallocation: the marginal-dollar argument

There is pressure to move budget into the 'winning' channel. Build the reallocation case that respects diminishing returns and att…

Marketing

Scale, kill, or keep testing: the audience portfolio call

Performance by audience is in and the meeting wants decisions. Make the scale/kill/test calls on stated criteria — with an honest …

Marketing

Welcome flow blueprint: each email has one job

The welcome flow is one email from 2023. Blueprint the sequence where every email has a single job, a trigger, and its own success…

Marketing

Promo cadence guardrails: are you training customers to wait?

Every soft month ends in a discount. Check whether the program is building revenue or training customers to wait for 20% off — fro…

All Marketing free prompts

The PromptSharp Marketing Brief page — five full free prompts plus today's issue.

PromptSharp Daily — free

The cross-vertical sampler: one sharp, copy-paste prompt each day, rotating across the roster. Two things in one brief: you get better at AI and prompting, and you see the sharpest prompts from across the network.

Double-opt-in. Unsubscribe anytime. No spam, ever.

Better together
Make prompts remember you: Brainfile

Even a sharp prompt starts from zero unless your AI knows you. Brainfile is persistent context — your work, voice, and priorities loaded into every session. Brainfile is the memory; PromptSharp is the playbook. Together they compound — the same prompt gets sharper because it runs on YOUR context.

Set up your brainfile →

Want both? The All-Access + Brainfile annual bundle covers the pair.

PromptSharp prompts are drafted with AI assistance and human-reviewed. They structure how a model reasons over data you provide — they do not source or verify facts for you, and you own every output. Nothing here is financial, legal, tax, or investment advice. Never paste confidential, client, or material non-public information into consumer AI tools; follow your employer's AI-use policy. © 2026 PromptSharp.