Extract metrics, dates, and owners from a report

Author: AILesson6 min setupTested with:ChatGPTReviewed: 2026-08-28

Quick answer

Create a structured register while preserving units, periods, targets, and attribution. Provide: Source report, Extraction scope, Output and normalization rules. Expected result: Traceable metric, date, and owner tables with relationships and missing fields.

Add your context

Your text stays in this browser. AILesson Prompts does not send it to a model or server.

Source reportExtraction scopeOutput and normalization rules

Your prompt

Unfilled fields remain visible as placeholders, so you can still copy and edit the prompt

Extract metrics, dates, and owners from the report.

Report:
[report]

Scope:
[scope]

Output and normalization rules:
[schema]

Use only explicit report content. Return separate Metrics, Dates, and Owners tables plus a Relationships table linking them. Metrics must retain name, value, unit, reporting period, actual/target/forecast status, comparison baseline, scope, and evidence. Dates must distinguish reporting dates, deadlines, forecasts, and historical events. Owners must distinguish accountable owner, contributor, approver, and contact. Use Not specified rather than inferring missing fields. Preserve ranges, approximately signs, currencies, and percentage versus percentage-point differences. Flag duplicate labels, conflicting values, ambiguous pronouns, and dates without a year.

Try in Playground

Private by defaultPrompt assembly happens locally in your browser. Avoid placing confidential information into any AI service unless your organization allows it.

From input to outcome

A worked example

See how concrete context turns this recipe into a usable result

Actual input

Source report: [Q2 review, p.2] June active customers were 12,480, up 8% year over year; the Q2 target was 13,000. Retention was 91.2%, 1.5 percentage points below target. [p.4] Priya owns the retention recovery plan. Product and Support contribute. A revised plan is due 18 July and the COO will approve it. Finance forecasts annual recurring revenue of approximately £4.2m by 31 December 2026. The dashboard footnote lists active customers as 12,408.
Extraction scope: Extract performance metrics, targets, forecasts, deadlines, and named roles from the Q2 review.
Output and normalization rules: Use YYYY-MM-DD where the year is stated; otherwise keep the written date and flag it. Preserve original currency and units. Cite page labels; do not merge conflicting values.

Example output

Relationships: M2→O1 and D1; plan→O2/O3; M3→O4/D2. Review the active-customer conflict and confirm the year for June and 18 July.

Why this works

1
Typed tables prevent a target, forecast, and actual from collapsing into one unlabeled number.
2
A relationship table retains which owner and date belong to which metric or action.

Check the result

Does every value retain its unit, period, status, scope, and locator?
Are owners' roles explicit rather than inferred from nearby names?
Are ambiguous and conflicting entries preserved for review?

Use it with confidence

Frequently asked questions

Practical answers about when to use this recipe, what to provide, and where human review still matters

What should I prepare before using “Extract metrics, dates, and owners from a report”?

For “Extract metrics, dates, and owners from a report,” prepare Source report, Extraction scope, and Output and normalization rules. Replace placeholders only with information you can verify. If a detail is unknown, preserve that uncertainty explicitly instead of asking the model to infer it.

When is the “Extract metrics, dates, and owners from a report” result not ready to use?

The result is not ready if it does not yet deliver the stated outcome—Traceable metric, date, and owner tables with relationships and missing fields—from the supplied evidence, or if it relies on unresolved assumptions, missing approvals, or invented details. Use the checks as release gates: revise the source inputs or assign a named, authorized reviewer instead of polishing an unsupported output.

Which AI tools have recorded tests for “Extract metrics, dates, and owners from a report”?

The published test record for “Extract metrics, dates, and owners from a report” lists ChatGPT as of 2026-08-28. This confirms recorded runs, not guaranteed compatibility or identical results in later product versions. For another tool or version, keep every constraint visible and repeat the result checks before use.

More ways to explore

Where this recipe fits

Text prompts Document reading Document analysis For managers

Keep the work moving

Text prompt

Read clearly

Document reading 5 min setup

Extract decisions, risks, and actions from a document

Build a traceable register without turning proposals or discussion into commitments

Open recipe

Text prompt

Read clearly

Document reading 8 min setup

Extract contract or policy clauses that need human confirmation

Locate ambiguous, conflicting, incomplete, consequential, or authority-dependent clauses without offering a legal conclusion

Open recipe

Text prompt

Read clearly

Document reading 7 min setup

Compare two document versions for material changes

Distinguish changes in obligations, scope, dates, and meaning from editorial rewrites

Open recipe

AILesson · Recommended courses

Your next step: put AI to work

Go from understanding AI to getting things done. Practice prompting, reviewing, and improving results through interactive lessons for work and everyday life.

Explore all courses