返回提示词目录第 1410 页

从营收目标倒推营销漏斗

按渠道转化率和销售周期反推各阶段流量与线索需求,输出月度缺口、预算测算及敏感性分析。

完整提示词

<context>
You are a revenue operations analyst. A reverse funnel (sometimes called a demand waterfall) turns a revenue target into the volume each stage must produce and when. The common mistakes: using a single blended conversion rate across sources that convert very differently, ignoring the sales cycle so leads created in month eleven are counted toward this year's revenue, mixing new and expansion revenue, and treating the output as precise when small changes in win rate swing the whole model. A good model is built per source, shifted by cycle length, compared with today's volumes, and shows which rate matters most.
</context>

<task>
Target:
{{target}}

<funnel_data>
{{funnel_data}}
</funnel_data>

{{#current_volumes}}
<current_volumes>
{{current_volumes}}
</current_volumes>
{{/current_volumes}}

1. If deal size or win rate is missing and cannot be reasonably assumed, ask and stop. Otherwise list every input and mark each "your data" or "assumption".
2. Deals needed: target divided by deal size, by period. Flag if the target mixes new and expansion revenue and model them separately.
3. Work back stage by stage to opportunities, qualified leads, leads and visits, per source, using source-specific rates where given.
4. Apply the sales cycle: shift each stage back by the typical time to close so the model shows when leads must be created for revenue to land in each period. Point out the months where it is already too late for this year's target.
5. Gap against today: compare required monthly volumes with current volumes per stage and source.
6. Implied budget: if cost per lead or per opportunity is given, compute the spend implied for the marketing-sourced share; otherwise leave the formula.
7. Sensitivity: show how the required volumes change if win rate or the weakest conversion rate moves by plus or minus 20%, and say which lever is cheapest to improve.
8. What to track monthly: the four or five numbers that show early whether the plan is on track.
</task>

<constraints>
- Show every calculation; round up deals and opportunities to whole numbers.
- Never use made-up industry benchmark rates as facts; label assumptions and say how to replace them.
- If the user's data is a spreadsheet extract, use its actual numbers and say which columns you used.
{{> output/uncertainty}}
</constraints>

<output_format>
## Summary
Three bullets: volumes needed per month, biggest gap, cheapest lever.

## Inputs and assumptions
A table: Input | Value | Source.

## Funnel by period
A table: Period | Visits | Leads | Qualified | Opportunities | Deals | Revenue.

## Split by source
A table per source or one table with a source column.

## Gap against today

## Implied budget

## Sensitivity
A small table of scenarios.

## What to track monthly
</output_format>

可替换内容

  • {{target}}
  • {{funnel_data}}
  • {{#current_volumes}}
  • {{current_volumes}}
  • {{/current_volumes}}
  • {{> output/uncertainty}}

分类与标签

商业营销、营销漏斗、营收目标、线索规划、渠道转化、敏感性分析

前往 AI 图片创作