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
  • 1
    Calculate ROI at multiple attribution models
  • 2
    Include opportunity cost in investment calculation
  • 3
    Consider both short-term and long-term returns
  • 4
    Track ROI over time - some investments compound
ROI Calculation - AI Marketing Prompt | AI CMO