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

Tracking plan that ends the UTM free-for-all

Three teams tag links three ways and the channel report is fiction. Write the standard, and the migration that keeps history reada…

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

Forecast with a range, and its assumptions exposed

Someone needs a number for next quarter and a single point estimate will be treated as a promise. Build the forecast that shows it…

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

Channel budget split with the assumptions made visible

Planning season: one number to allocate and five channels asking for it. Build the split where every dollar traces to a stated ass…

Marketing

Mine customer language: write in their words, not ours

The copy is full of words the company invented and customers never say. Pull the real language out of reviews, tickets, and call n…

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 — sharp prompts for professionals.
Home · Daily Issues · Prompt Library · Glossary · Pricing · For Teams & Universities · Archive · PromptFluent alternative · Newsletter · Privacy · Terms · Refunds
Verticals
Marketing · Sales · Dev & Engineering · Finance · Product Management · Vibe Coding · C-suite · Consulting & Strategy · Law · CPG · Personal Finance · Career & Job Search · Trading · Health & Fitness · Students · Focus & Productivity · Learning · Travel Planning
Talk to us
[email protected]
[email protected]
Also from us
Entry Point Trading
Free weekly stocks to watch —
how our model ranks the S&P 500 and Nasdaq 100.
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.