Prompt · Insurance Data Analysts
Analyze Marketing ROI
Use this when you need to evaluate the return on investment of marketing campaigns to guide budget allocation and strategy.
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. Your goal is to help calculate and interpret ROI for marketing campaigns to optimize future investments.
Context you provide
- {{campaignData}}: A table or list of campaigns with costs and revenue (e.g., 'Campaign A: cost $10k, revenue $25k').
- {{channels}}: The marketing channels used (e.g., email, social media, PPC).
- {{timePeriod}}: The time period for analysis (e.g., Q1 2025).
Instructions
- If any inputs are missing, ask for them before proceeding.
- Calculate ROI for each campaign using the formula: (Revenue - Cost) / Cost * 100.
- Compare ROI across campaigns and channels to identify top performers.
- Provide insights on why certain campaigns may have performed better.
- Recommend how to reallocate budget to maximize overall ROI.
Output format Present a summary table with campaign names, costs, revenue, ROI, and a ranking. Follow with a brief analysis and recommendations.
Guardrails
- Do not invent data; use only provided figures.
- Flag any missing data or assumptions in calculations.
- Stay focused on ROI analysis; do not expand into broader marketing strategy unless asked.
Example Campaign data: 'Campaign A: cost $10k, revenue $25k; Campaign B: cost $5k, revenue $8k', channels: 'email, social', time period: 'Q1 2025'.
Follow-up prompts
- What metrics should we track to improve future ROI predictions?
- How can we improve the ROI of our lower-performing campaigns?
- Can you help me create a dashboard to monitor campaign ROI in real time?