Funnel Analysis Prompt Template and Example

Reusable prompt

Find where the funnel leaks and recommend focused improvement actions.

Task type: Funnel Analysis
Objective: Find where the funnel leaks and recommend focused improvement actions.

Context:
- [Project, product, or topic]: [Project, product, or topic]
- [Audience and situation]: [Audience and situation]
- [Constraints, must-haves, and things to avoid]: [Constraints, must-haves, and things to avoid]

Inputs to provide:
[Paste source material here]

Expected output:
1. Metric movement
2. Segment breakdown
3. Root causes
4. Priority actions
5. Watch metrics

Quality bar:
- Be specific and avoid generic advice.
- State assumptions explicitly.
- Prefer actionable next steps over broad theory.
- If important information is missing, ask up to 3 clarifying questions before answering.
- For time-sensitive or factual claims, label what is known, inferred, and needs verification.

Worked example

The example below fills the same prompt for a realistic Data & BI scenario. It is intentionally modest: the goal is to show how the prompt behaves, not to pretend one template solves every Data & BI problem.

Task type: Funnel Analysis
Objective: Find where the funnel leaks and recommend focused improvement actions.

Context:
- [Project, product, or topic]: A real Data & BI task using the Funnel Analysis prompt
- [Audience and situation]: A teammate who needs a useful answer and clear next steps
- [Constraints, must-haves, and things to avoid]: Be specific, state assumptions, avoid unsupported claims, and keep the output easy to act on.

Inputs to provide:
Sample material: The team needs help with Funnel Analysis. The current situation is messy, the goal is clear enough to start, and the answer should separate facts, assumptions, risks, and next actions.

Expected output:
1. Metric movement
2. Segment breakdown
3. Root causes
4. Priority actions
5. Watch metrics

Quality bar:
- Be specific and avoid generic advice.
- State assumptions explicitly.
- Prefer actionable next steps over broad theory.
- If important information is missing, ask up to 3 clarifying questions before answering.
- For time-sensitive or factual claims, label what is known, inferred, and needs verification.

How to use this prompt

1. Replace the placeholders with the actual Funnel Analysis task, audience, source material, and constraints.
2. Keep the requested output sections unless you have a strong reason to remove one; they are there to make the AI answer easier to evaluate.
3. Paste the finished prompt into your AI assistant, then ask one follow-up question that tests assumptions or missing evidence.

What a good answer should contain

• 1. Metric movementUse this section to make the answer concrete: Metric movement.
• 2. Segment breakdownUse this section to make the answer concrete: Segment breakdown.
• 3. Root causesUse this section to make the answer concrete: Root causes.
• 4. Priority actionsUse this section to make the answer concrete: Priority actions.
• 5. Watch metricsUse this section to make the answer concrete: Watch metrics.

Why this prompt works

• Funnel Analysis starts with an explicit task type and objective, which reduces vague answers.
• It asks for context, source material, and constraints before the model writes the final response.
• The 5 output sections make the answer scannable and easier to compare across attempts.
• The quality bar tells the assistant to ask clarifying questions and mark claims that need verification.

Common mistakes to avoid

• Leaving placeholders untouched and expecting the model to infer the missing context.
• Removing the output structure, then asking for a final answer that is hard to review.
• Using the prompt for time-sensitive facts without checking sources or dates.

Related prompt templates