Looker Studio Metric Definition Packet (No Invented KPI Totals)

Prompt

Act as a Looker Studio analytics ops lead who only uses a pasted field excerpt. You write a metric definition packet the excerpt already supports. You do not invent KPI totals, conversion rates, revenue figures, row counts not in Inputs. This is not a Google Marketing Platform sales deck; not a financial audit opinion.
You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs.

Inputs:
- Field excerpt I lock (metric names, dimensions, source notes present): [FieldExcerpt]
- KPI notes I lock (definitions named only if present): [KPINotes]
- Looker Studio / version notes I lock: [Version]
- Report or workspace label I may quote (or UNKNOWN): [ReportLabel]
- Metric labels already present (or UNKNOWN): [MetricLabels]
- Definition field names already present (or UNKNOWN): [DefFields]
- Flag rules already present (or UNKNOWN): [FlagRules]
- Words I must not use: [Banned]
- What I must never invent (KPI totals, conversion rates, revenue figures, row counts): [Never]
- Output format: [Format]
- Language: [Lang]

Generate:
1. Honesty ledger: FieldExcerpt nouns, KPINotes, Version, ReportLabel, MetricLabels, DefFields, FlagRules, Lang. Forbidden: invented KPI totals, conversion rates, revenue figures, row counts. Banner: not a Google Marketing Platform sales deck; not a financial audit opinion.
2. Metric definition packet: numbered cards keyed to MetricLabels. For each, list DefFields to verify and FlagRules triggers. Missing FlagRules write NOT IN INPUTS. Use Looker Studio Charts, Data sources, and Calculated fields language when FieldExcerpt supports it. Never print KPI-total or conversion VALUES not in FieldExcerpt or KPINotes.
3. KPI lock: quote KPINotes only. Unnamed items stay NOT IN INPUTS.
4. Version lock: print Version. Refuse Looker Studio features newer than Version if Version is named.
5. Refuse list: inventing KPI totals; inventing conversion rates; inventing revenue figures; inventing row counts.
6. Compliance pass: quote Banned and Never hits. Cut them. Format as Format.

Constraints:
- Deliverable from FieldExcerpt and KPINotes only. No invented KPI totals VALUES. Teach Looker Studio workflows, not a Tableau or Power BI swap.
- Honor Version. No emojis. Add a one-line not-advice banner.

Instructions

Replace every [bracket] with your details before running. Works on ChatGPT, Claude, and Gemini.

Generated Output

This image was generated using the prompt above.

Looker Studio Metric Definition Packet (No Invented KPI Totals) - Result

Examples

Example Input

FieldExcerpt: Harbor Quay sessions metric as pasted source GA4 as pasted; River Ops leads metric as pasted source CRM as pasted. KPI invent NONE. Conversion invent NONE.
KPINotes: sessions definition as pasted; leads definition as pasted. Revenue invent NONE.
Version: Looker Studio as pasted (do not invent unreleased AI insight pack)
ReportLabel: Harbor Quay weekly growth report as pasted
MetricLabels: sessions as pasted; leads as pasted. revenue UNKNOWN.
DefFields: formula note as pasted; grain as pasted. KPI total UNKNOWN.
FlagRules: missing source flag as pasted. Row count NOT IN INPUTS.
Banned: guaranteed growth, KPI invent, conversion invent, revenue invent
Never: invent KPI totals, invent conversion rates, invent revenue figures, invent row counts
Format: ledger + packet + kpi + version + refuse + compliance
Lang: English

Example Output

1. Ledger. FieldExcerpt: Harbor Quay sessions metric as pasted source GA4 as pasted; River Ops leads metric as pasted source CRM as pasted. KPI invent NONE. Conversion invent NONE. KPINotes sessions definition as pasted; leads definition as pasted. Version Looker Studio as pasted. ReportLabel Harbor Quay weekly growth report. MetricLabels sessions; leads; revenue UNKNOWN.. DefFields formula note; grain; KPI total UNKNOWN.. FlagRules missing source flag as pasted. Row count NOT IN INPUTS. Lang English. Banner: not a Google Marketing Platform sales deck; not a financial audit opinion. Forbidden: invented KPI totals, conversion rates, revenue figures, row counts, guaranteed growth.

2. Metric definition packet.
1. sessions | FieldExcerpt Harbor Quay sessions | DefFields formula note + grain | FlagRules missing source not triggered | KPI VALUES NONE | Looker Studio Calculated fields only.
2. leads | FieldExcerpt River Ops leads | DefFields formula note + grain | FlagRules missing source not triggered | conversion VALUES NONE.
revenue UNKNOWN so write MetricLabels revenue NOT IN INPUTS. KPI total UNKNOWN so write KPI VALUES NOT IN INPUTS. Revenue invent NONE.

3. KPI lock. sessions definition as pasted; leads definition as pasted. Revenue invent NONE.

4. Version lock. Looker Studio as pasted. Refuse unreleased AI insight pack.

5. Refuse list. inventing KPI totals; inventing conversion rates; inventing revenue figures; inventing row counts.

6. Compliance. Quoted Banned: guaranteed growth, KPI invent, conversion invent, revenue invent. Cut. Quoted Never: invent KPI totals, invent conversion rates, invent revenue figures, invent row counts. Cut. Format ledger + packet + kpi + version + refuse + compliance.

Missing-data policy: if a field was blank, write NOT IN INPUTS rather than guessing. Lock any tool version named in Inputs; if unnamed, write unknown. No invented testimonials, star ratings, or press logos. If legal, clinical, insurance, HR, education-plan, or veterinary content appears, add a one-line not-advice and de-identify banner. Quote banned-word hits and cut them. End with a gaps list of five bullets the user still owes you. Character and byte caps in the job are hard; print counts when relevant. Refuse to backfill DOIs, exam dumps, PHI, PII, or compensation promises not in Inputs.