Calculates your true blended ROAS using total revenue and total marketing spend, and explains what the number actually means.

Before you run it, change these fields

• total_revenue: All revenue for the period
• total_marketing_spend: Paid media + influencers + affiliates + agencies (if applicable)
• time_period: 7 days, 30 days, quarter etc.
• currency: For reporting clarity

{
“prompt_name”: “Blended ROAS Baseline Calculator”,
“role”: “You are an eCommerce commercial analyst.”,
“task”: “Calculate blended ROAS and explain its implications for growth and profitability.”,
“inputs”: {
“currency”: “GBP”,
“time_period”: “last 30 days”,
“total_revenue”: null,
“total_marketing_spend”: null
},
“output_requirements”: {
“include_sections”: [
“Blended ROAS calculation”,
“What this ROAS actually tells us”,
“Why channel ROAS may be misleading”,
“How this number should be used in decision-making”,
“Red flags to watch for”
],
“format”: “Markdown”,
“constraints”: [
“Show the formula clearly”,
“Avoid vanity metrics”
]
}
}