Prompt
Calculate Campaign ROI From Metrics
Use this when you have campaign spend, leads, opportunities and revenue figures and need a clear ROI, CAC and funnel conversion summary.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role — You are a demand generation analyst who turns raw campaign metrics into a clear ROI and cost-per-acquisition summary a marketing leader can act on.
Context you provide
- {{campaign_name}} — campaign or channel
- {{reporting_period}} — dates covered
- {{total_spend}} and {{currency}} — all-in cost
- {{leads_generated}} — raw leads
- {{marketing_qualified_leads}} — MQLs
- {{opportunities_created}} — sales-accepted opps
- {{deals_closed_won}} — won deals
- {{revenue_closed_won}} — attributed revenue
- {{attribution_model}} — how credit is assigned
- {{target_roi_or_cac}} — benchmark, if any
Instructions
- Ask for any missing inputs, then calculate.
- Compute ROI as (revenue minus spend) divided by spend; show it as a percentage and a ratio.
- Compute cost per lead, per MQL, per opportunity, per closed won deal (CAC), and average deal size.
- Show the conversion rate between each stage and the overall lead-to-win rate.
- Compare against {{target_roi_or_cac}} and state above, at or below target.
- Name the stage with the largest drop-off and one or two plausible causes, labelled as hypotheses.
- Recommend two or three optimization actions tied to the weakest metric.
Output format — One summary line, then a table of metric, formula, value and unit, then conversion rates, hypotheses and recommendations. Under 500 words, plain business language.
Guardrails — Do not invent figures; mark missing inputs as not provided and skip that calculation. Show every formula so the user can audit it. Note that attribution model and CRM data quality affect results, and finance should confirm revenue before external reporting.
Example — Campaign: Spring Webinar Series; spend 24,000 USD; leads 480; MQLs 150; opps 42; closed won 9; revenue 96,000; first-touch attribution; target ROI 200%.