Marketing ROI Calculator Prompt

Build a comprehensive marketing ROI measurement framework with channel-by-channel attribution.

**Business Type:** [B2B SAAS / B2C ECOMMERCE / SERVICE BUSINESS / MEDIA/CONTENT]
**Monthly Marketing Budget:** [$AMOUNT OR RANGE]
**Revenue Model:** [SUBSCRIPTION MRR / AVERAGE ORDER VALUE / CUSTOMER LTV]

**Channel-by-Channel Attribution Framework:**

**1. Paid Search (Google Ads):**
- Formula: ROI = ((Revenue from campaigns - Ad spend) / Ad spend) x 100
- Key metrics: Cost per click (CPC), Conversion rate, Average order value, Quality Score impact on CPC
- Attribution window: 30-day click, 1-day view
- Tracking setup: Google Ads conversion tracking, enhanced conversions, offline conversion import
- Benchmark targets by industry and keyword type

**2. Social Media Advertising (Facebook/Instagram/LinkedIn/Twitter):**
- Formula: ROAS = Revenue from ads / Ad spend (Return on Ad Spend)
- Key metrics: Cost per result, Frequency capping, Creative fatigue detection, Pixel tracking accuracy
- Attribution windows: 1-day click, 7-day click, 1-day view for Facebook; 15-day click for LinkedIn
- UTM parameter standardization across all campaigns
- Incremental lift testing methodology (geo holdout, audience split)

**3. Organic Content & SEO:**
- Formula: ROI = ((Organic revenue - Content production cost) / Content production cost) x 100
- Key metrics: Organic traffic growth, Keyword ranking improvements, Click-through rate from SERPs, Dwell time
- Revenue attribution: multi-touch attribution model (position-based or data-driven)
- Content ROI scoring: assign revenue value to each piece of content based on assisted conversions
- Time lag consideration: SEO typically takes 3-6 months to show full ROI

**4. Email Marketing:**
- Formula: ROI = ((Email-generated revenue - Email tool cost + labor) / Total email cost) x 100
- Key metrics: Open rate, Click-through rate, Conversion rate, Revenue per subscriber, Unsubscribe rate
- Segment-level ROI analysis (welcome series vs. promotional vs. nurture)
- List health scoring and its impact on deliverability and ROI over time

**5. Affiliate Marketing:**
- Formula: Net ROI = ((Affiliate-driven revenue - Commission payouts) / Total affiliate program cost) x 100
- Key metrics: Cost per acquisition via affiliates, Average order value from referred customers, Churn rate comparison
- Affiliate tier performance analysis (top performers vs. long tail)
- Fraud detection metrics and cost of fraudulent conversions

**Customer Lifetime Value Calculation:**
- LTV = Average Purchase Value x Purchase Frequency x Customer Lifespan
- Adjusted LTV: LTV - (COGS + support costs) for true profit-based LTV
- Cohort analysis: track LTV by acquisition month and channel
- Payback period: CAC / (LTV / months to calculate monthly contribution margin)
- Target: LTV:CAC ratio of 3:1 or higher

**Marketing Qualified Lead (MQL) Tracking:**
- MQL definition criteria specific to your business model
- MQL-to-SAL (Sales Accepted Lead) conversion rate
- SAL-to-Customer conversion rate
- Average sales cycle length by channel
- Revenue per MQL by channel for prioritization

**Budget Allocation Optimization:**
- Current spend breakdown by channel with ROI ranking
- Reallocation strategy: shift budget from low-ROI to high-ROI channels
- Testing budget allocation (10-20% of total budget for new channel experimentation)
- Seasonal adjustment framework for budget scaling
- Diminishing returns analysis per channel (at what spend level does marginal ROI decline?)

**Quarterly Marketing Review Template:**
- Executive summary: total marketing spend, total attributed revenue, overall ROI
- Channel performance comparison with trend analysis (quarter-over-quarter)
- Top 3 wins and top 3 learnings from the quarter
- Budget utilization report vs. planned allocation
- Next quarter recommendations based on data insights
- Board-ready visualization suggestions (charts, graphs, KPI dashboard layout)

How to Customize It

Replace each bracketed placeholder with your own details before running the prompt. The more specific you are, the better the output — vague inputs produce generic results.

• [B2B SAAS / B2C ECOMMERCE / SERVICE BUSINESS / MEDIA/CONTENT]Swap in your b2b saas or b2c ecommerce or service business or media or content.
• [SUBSCRIPTION MRR / AVERAGE ORDER VALUE / CUSTOMER LTV]Swap in your subscription mrr or average order value or customer ltv.

When to Use It

• Answering "what's marketing actually returning" with a defensible methodology instead of platform-reported numbers that sum to 300% of revenue.
• Reallocating budget across channels quarterly based on measured, comparable CAC.
• Building the marketing dashboard where every channel is accounted the same way.

Tips for Better Results

• 1Include content and organic channels with real cost accounting (hours × loaded rate) — measuring only paid channels guarantees you'll underinvest in the compounding ones.
• 2Ad-platform dashboards each claim full credit for shared conversions; reconcile against actual revenue monthly and scale their claims down proportionally.
• 3Pick one attribution model, document its known biases, and keep it stable — a consistent imperfect model beats a rotating cast of flattering ones.