ROI Analysis Template for Marketing Campaigns
Prompt
Act as a marketing analytics expert and evaluate the Return on Investment (ROI) for a marketing campaign. The campaign details are: [Campaign Name or Description], with a total cost of [Investment Cost] and resulting revenue of [Revenue Generated]. First, calculate the ROI percentage for the campaign using the formula ROI = (Net Profit ÷ Investment Cost) × 100%. (Net Profit = Revenue Generated – Investment Cost.) Show the calculation step-by-step. Then, provide an analysis of the result: explain what the ROI percentage means in context (e.g., compare it to benchmarks or goals – was the campaign profitable and by how much?), and discuss any factors that might have influenced this ROI. Finally, give 2–3 recommendations for decision-makers: for instance, whether to increase investment in this campaign, how to improve ROI (such as optimizing costs or targeting better), or if they should reconsider this type of campaign. Make sure the analysis is clear and focused on financial impact, so that a businessperson can easily understand the value generated by the campaign.
How to Use
- Fill in the placeholders with your specific campaign information. [Campaign Name or Description] could be something like “Summer Social Media Ads 2025” or “Email Marketing Push for Product X” – this provides context. [Investment Cost] is the total amount spent on the campaign (in dollars or your currency), and [Revenue Generated] is the total attributable revenue or sales from that campaign. For accuracy, ensure these numbers are for the same time period and campaign scope.
- If you have additional relevant data, you can include it in the description. For example, maybe mention the campaign duration or primary channels (e.g., Facebook ads vs. email), or any non-monetary results (like new leads) if you want the AI to consider them qualitatively. However, the prompt is mainly aimed at financial ROI.
- The AI will calculate the ROI and then interpret it. Look for the ROI percentage and the explanation of what it means. A positive ROI (greater than 0%) indicates profit, while a negative ROI means a loss on the campaign. The recommendations at the end will be useful for deciding next steps. Use this analysis to inform your marketing strategy – for instance, if ROI is low, the AI’s suggestions might include targeting a different audience or reducing costs, which you can consider implementing in future campaigns.