Marketing ROI & Channel Attribution Performance Review
Audit blended vs. paid CAC, channel payback periods, and cohort LTV decay to reallocate marketing budgets with precision.
Compatibility & Specs
Compatible AI Models
ClaudeChatGPTGemini
Last UpdatedOct 3, 2026
Customizable Variables3 parameters
Main Prompt Template
161 words • 1210 characters
You are a Chief Marketing Officer and Marketing Finance Partner. I need to conduct a rigorous quarterly Marketing ROI and Channel Attribution Review to defend our marketing budget and reallocate spend toward our most profitable channels.
Current Monthly Marketing Spend & Channel Breakdown:
[channel_spend_data]
Customer Acquisition Metrics (Blended vs Paid):
[acquisition_metrics]
Average Contract Value & Payback Horizon:
[acv_payback_data]
Generate an executive-level Marketing Performance & Allocation Memo:
1. Channel Efficiency Scorecard: Rank each channel by estimated Paid CAC, CAC Payback Period (in months), and Pipeline Quality (win rate of deals generated).
2. Attribution Trap Analysis: Identify where last-touch or first-touch attribution is misleading the team (e.g., giving too much credit to branded search while starving top-of-funnel awareness).
3. Budget Reallocation Recommendations: Provide a concrete rebalance plan shifting 25% of underperforming capital to high-efficiency or uncrowded channels with clear justification.
4. CFO Defense Script: A concise 3-paragraph executive narrative explaining the difference between Blended CAC and Paid CAC to reassure executive board members.
Tip:Variables marked in purple brackets can be tailored below.
Customize Prompt
Fill in the variables below. Your customized prompt updates instantly in the browser — no AI API needed.
Parameters (3)* Indicates required field
[channel_spend_data]
Monthly budget allocated across various acquisition channels
[acquisition_metrics]
Leads, opportunities, and customers generated by channel
[acv_payback_data]
Average Annual Contract Value and target payback period
3 parameters active
Live Customized OutputLive Preview
228 wordsYou are a Chief Marketing Officer and Marketing Finance Partner. I need to conduct a rigorous quarterly Marketing ROI and Channel Attribution Review to defend our marketing budget and reallocate spend toward our most profitable channels.
Current Monthly Marketing Spend & Channel Breakdown:
Total Monthly Budget: $50,000. Google Paid Search: $22,000; LinkedIn Sponsored Content: $18,000; Organic Content & SEO Agency: $7,000; Podcast Sponsorships: $3,000.
Customer Acquisition Metrics (Blended vs Paid):
Google Search: 45 demos, 10 closed deals (CAC $2,200). LinkedIn: 28 demos, 3 closed deals (CAC $6,000). Organic/SEO: 32 demos, 9 closed deals (CAC $777). Podcasts: 8 demos, 2 closed deals (CAC $1,500).
Average Contract Value & Payback Horizon:
Average ACV is $9,600 ($800/mo). Gross margin is 80%. Target CAC payback is under 12 months.
Generate an executive-level Marketing Performance & Allocation Memo:
1. Channel Efficiency Scorecard: Rank each channel by estimated Paid CAC, CAC Payback Period (in months), and Pipeline Quality (win rate of deals generated).
2. Attribution Trap Analysis: Identify where last-touch or first-touch attribution is misleading the team (e.g., giving too much credit to branded search while starving top-of-funnel awareness).
3. Budget Reallocation Recommendations: Provide a concrete rebalance plan shifting 25% of underperforming capital to high-efficiency or uncrowded channels with clear justification.
4. CFO Defense Script: A concise 3-paragraph executive narrative explaining the difference between Blended CAC and Paid CAC to reassure executive board members.
How to Use This Prompt
Follow this 3-step workflow to extract high-signal responses from any compatible AI model.
01
1. Tailor the Parameters
Use the interactive customizer above to substitute the bracketed placeholders with your exact context, requirements, and constraints.
02
2. Send to AI Model
Copy the prompt and paste it into Claude, ChatGPT, Gemini, or Copilot. These models follow structured multi-step constraints reliably.
03
3. Review and Iterate
Review the output against the verified benchmark below. Follow up in the conversation to stress-test edge cases or refine tone.
Prompt Variables & Parameters
Reference breakdown of every dynamic variable embedded in this prompt template.
| Placeholder | Parameter Name | Type | Status | Description & Guidance |
|---|---|---|---|---|
| [channel_spend_data] | Channel Spend Breakdown | textarea | Required | Monthly budget allocated across various acquisition channelsDefault: Total Monthly Budget: $50,000. Google Paid Search: $22,000; LinkedIn Sponsored Content: $18,000; Organic Content & SEO Agency: $7,000; Podcast Sponsorships: $3,000. |
| [acquisition_metrics] | Acquisition Metrics | textarea | Required | Leads, opportunities, and customers generated by channelDefault: Google Search: 45 demos, 10 closed deals (CAC $2,200). LinkedIn: 28 demos, 3 closed deals (CAC $6,000). Organic/SEO: 32 demos, 9 closed deals (CAC $777). Podcasts: 8 demos, 2 closed deals (CAC $1,500). |
| [acv_payback_data] | ACV & Payback Horizon | text | Required | Average Annual Contract Value and target payback periodDefault: Average ACV is $9,600 ($800/mo). Gross margin is 80%. Target CAC payback is under 12 months. |
Example Execution & Benchmark Output
Sample input arguments and the verified AI response demonstrating expected quality and formatting.
Sample VariablesInputs
[channel_spend_data]
Total Monthly Budget: $50,000. Google Paid Search: $22,000; LinkedIn Sponsored Content: $18,000; Organic Content & SEO Agency: $7,000; Podcast Sponsorships: $3,000.
[acquisition_metrics]
Google Search: 45 demos, 10 closed deals (CAC $2,200). LinkedIn: 28 demos, 3 closed deals (CAC $6,000). Organic/SEO: 32 demos, 9 closed deals (CAC $777). Podcasts: 8 demos, 2 closed deals (CAC $1,500).
[acv_payback_data]
Average ACV is $9,600 ($800/mo). Gross margin is 80%. Target CAC payback is under 12 months.
Expected AI ResponseVerified Result
### 1. Channel Efficiency Scorecard
- **Organic/SEO (Leader):** CAC $777 | Payback: ~1.2 months | Status: Extremely efficient, underfunded.
- **Podcast Sponsorships (High Potential):** CAC $1,500 | Payback: 2.3 months | Status: Strong niche authority signal.
- **Google Paid Search (Workhorse):** CAC $2,200 | Payback: 3.4 months | Status: Healthy, within target payback.
- **LinkedIn Ads (Dangerous Outlier):** CAC $6,000 | Payback: 9.4 months | Status: High lead friction, poor win rate.
### 2. The Attribution Trap
LinkedIn is currently credited with 3 closed deals at an alarming $6,000 CAC. However, survey data shows many Google Search prospects first discovered the brand via LinkedIn thought leadership. If you abruptly shut off LinkedIn, Google Search volume may drop. The fix is to shift LinkedIn from expensive 'Lead Gen Forms' to lighter ungated brand distribution.
### 3. Reallocation Blueprint
- **Cut LinkedIn Paid Forms by $8,000** (from $18k to $10k), focusing strictly on high-intent retargeting.
- **Increase Organic/SEO Agency by $5,000** (from $7k to $12k) to produce high-intent comparison and alternative pages.
- **Increase Niche Podcast Sponsorships by $3,000** (from $3k to $6k) to double down on captive audio audiences.
Best Use Cases
Scenarios and roles where this prompt produces maximum leverage.
CMOs preparing quarterly budget reviews and board presentations
Growth leads optimizing paid ad allocations to decrease company-wide blended CAC
Finance directors auditing sales and marketing efficiency metrics
Tips for Best Results
Techniques to elevate response fidelity
- •Explicitly define your Ideal Customer Profile (ICP), their acute pain points, and current legacy alternatives.
- •Provide strict negative constraints: list corporate clichés, overused jargon, or vague promises the model must avoid.
- •Ask the model to critique its own copy from the perspective of a cynical, time-pressed prospect before finalizing.
Common Mistakes to Avoid
Frequent failure modes and anti-patterns
- •Failing to define a singular, clear Call-to-Action (CTA), resulting in unfocused and diluted messaging.
- •Accepting high-level marketing buzzwords that sound impressive but say nothing concrete to users.
- •Not fact-checking competitive claims, legal guarantees, or pricing specifications generated by the model.
Part of Curated Collections
This prompt is sequenced as part of these goal-oriented workflows
Related AI Prompts
Complementary workflows in Marketing
Emailbeginner
High-Stakes Difficult Feedback & Boundary Email Drafter
Draft professional, high-empathy emails for difficult workplace situations and boundary setting.
claudechatgptcopilot
#email#executive-comms#communication
Marketingadvanced
B2B Ideal Customer Profile (ICP) & Buyer Persona Profiler
Build a multi-dimensional ICP profile detailing economic buyers, technical champions, blocker personas, and trigger events.
claudechatgptgemini
#icp#buyer-persona#b2b-marketing
Marketingintermediate
Omnichannel Product Launch Campaign Playbook
Orchestrate an end-to-end multi-channel marketing campaign across email, social, PR, webinars, and partner amplification.
claudechatgptgemini
#marketing-campaign#product-launch#omnichannel
Related Engineering Guides
Deep-dive playbooks and system prompt methodologies for Marketing