将模糊需求整理为取数简报
把业务提问转成明确的指标口径、数据范围和交付要求,附待确认问题及回复消息。
完整提示词
<context>
You sit between business teams and the data team. "Can you pull the numbers on churn for last quarter?" can mean twenty different queries, and the analyst usually guesses one, delivers it a week later, and starts again. A good brief fixes the ambiguity in five minutes: it names the decision, pins down every definition, and lists exactly what will be delivered and when.
</context>
<task>
Turn this ask into a data request brief.
<ask>
{{ask}}
</ask>
<context>
{{context}}
</context>
1. Infer the decision or use behind the ask (a board slide, a pricing decision, a campaign review). If it is not stated, propose the most likely one and mark it "to confirm".
2. Rewrite the ask as precise questions, each answerable with one table or chart.
3. For every metric, write a definition: formula, unit, what is included and excluded (test accounts, refunds, internal users, free plans), grain, and time zone. Where a common term is ambiguous ("active users", "revenue", "churn", "conversion"), give the two or three plausible definitions and recommend one.
4. Fix the population and filters, time range (with exact dates, and whether the current incomplete period is included), comparison (previous period, last year, target), and breakdowns.
5. Specify the deliverable: format (number in a message, table, chart, dashboard, spreadsheet), level of detail, and who receives it.
6. Set the deadline and priority, and the smallest useful version that could be delivered sooner.
7. List the questions that must be confirmed before work starts, at most five, ordered by how much they change the result.
8. Write a short reply message to the requester that confirms the brief and asks those questions.
</task>
<constraints>
- Mark every inference "to confirm"; do not present guesses as agreed.
- Do not produce any numbers or results.
- Keep the brief to what fits on one screen. Use the requester's vocabulary and avoid jargon in the reply message.
- If the ask contains requests for personal data about individuals (for example a list of named customers), note whether aggregate data would serve the purpose and flag data-access approval if needed.
</constraints>
<output_format>
## Brief
A table: field | value. Fields: Requester, Decision or use, Questions, Metric definitions, Population and filters, Time range, Comparison, Breakdowns, Deliverable, Deadline and priority, Smallest useful version, Known caveats.
## Questions to confirm
A numbered list, at most five.
## Reply message
A short message ready to send to the requester.
</output_format>可替换内容
- {{ask}}
- {{context}}
分类与标签
办公效率、取数需求、指标口径、跨团队协作、需求确认