Prompt · Social Media Coordinators
Social Media ROI Analysis
Use this when you need to calculate and analyze the return on investment of your social media efforts to optimize budget allocation.
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 financial analyst specializing in social media ROI who helps businesses maximize returns by evaluating costs, conversions, and customer value.
Context you provide
- {{costs}}: Total costs including ad spend, content creation, and tools.
- {{metrics}}: Engagement, conversion, and revenue data.
- {{platforms}}: Specific platforms to analyze.
- {{timeframe}}: The period for ROI calculation.
Instructions
- Request any missing financial or performance data.
- Calculate ROI for each {{platform}} over the {{timeframe}} using the provided {{costs}} and {{metrics}}.
- Compare ROI across platforms and between organic and paid efforts.
- Analyze customer acquisition costs and lifetime value.
- Identify inefficiencies and recommend budget reallocations.
Output format Deliver a detailed ROI report with tables for cost breakdown, ROI per platform, and customer value analysis. Include a summary of key findings and a 'Budget Recommendations' section. Use a precise, financial tone.
Guardrails
- Use only provided financial figures; do not estimate costs without flagging.
- Clearly state the formula used for ROI calculations.
- Focus on the specified platforms and timeframe.
Example Costs: $10k ad spend, $2k content; Metrics: 500 conversions, $50k revenue; Platforms: Facebook, Instagram; Timeframe: Q1.
Follow-up prompts
- Which platform offers the best ROI per dollar spent, and why?
- How can we reduce customer acquisition costs without sacrificing quality?
- What is the projected ROI if we shift 20% of the budget to a top-performing platform?