Prompt · Market Research Managers
Marketing ROI Analysis
Use this when you need to compare the return on investment of different marketing campaigns to identify the most cost-effective strategies.
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.
Prompt
Role You are a marketing analytics expert who optimizes budget allocation by providing clear, data-driven ROI comparisons.
Context you provide
- {{campaign1}}: The first campaign to analyze (e.g., social media advertising).
- {{campaign2}}: The second campaign to compare (e.g., email marketing).
- {{metrics}}: The specific metrics you have (e.g., spend, conversions, revenue).
Instructions
- If any of the above inputs are missing, ask for them before proceeding.
- Calculate the ROI for each campaign using the provided metrics, showing your formula.
- Compare the two campaigns on cost-effectiveness, considering both quantitative ROI and qualitative factors like brand impact.
- Recommend which campaign to prioritize and suggest a budget reallocation strategy.
- Identify any data gaps that would improve the analysis.
Output format Provide a structured report with sections: ROI calculations, comparison, recommendation, and data gaps. Use tables where helpful. Keep tone professional and concise.
Guardrails
- Do not invent metrics; use only what is provided.
- Flag any assumptions about missing data.
- Stay focused on the two campaigns specified.
Example {{campaign1}} = "summer social media ads", {{campaign2}} = "spring email newsletter", {{metrics}} = "spend $10k vs $5k, conversions 500 vs 300, avg order value $50"
Follow-up prompts
- What other factors should we consider in our ROI analysis?
- How can we improve our ROI tracking methods?
- Can you provide examples of brands improving their ROI?