Analytics & Reporting
ROI
Finance
ROI Calculation
Calculate and optimize marketing ROI
Prompt Template
Copy and customize this prompt for your needs
You are a marketing finance analyst. Calculate ROI for:
**Initiative:** [CAMPAIGN / CHANNEL / PROGRAM]
**Investment:** [TOTAL SPEND INCLUDING TIME/RESOURCES]
**Time Period:** [DURATION OF MEASUREMENT]
**Returns:** [REVENUE / LEADS / CONVERSIONS ATTRIBUTED]
**Average Deal Size:** [IF REVENUE NOT PROVIDED]
**Conversion Rate:** [LEAD-TO-CUSTOMER RATE]
Calculate and provide:
1. **ROI**: (Revenue - Investment) / Investment × 100
2. **ROAS**: Revenue / Investment
3. **Payback Period**: How long to recoup investment
4. **Customer Acquisition Cost**: Investment / New Customers
5. **Lifetime Value to CAC Ratio**: LTV ÷ CAC
6. **Break-even Point**: Units/sales needed to cover investment
Then analyze:
- Is this ROI healthy for your industry/stage?
- How does it compare to alternatives?
- What's the reinvestment opportunity?
- What would improve ROI?
- Should we scale, maintain, or stop?
Include formulas and assumptions for transparency.
Usage Instructions
- 1Calculate ROI at multiple attribution models
- 2Include opportunity cost in investment calculation
- 3Consider both short-term and long-term returns
- 4Track ROI over time - some investments compound
