Evaluate marketing channel efficiency from campaign performance data

Break down multi-channel campaign exports to compare CAC, conversion efficiency, and real ROI. Use during weekly or monthly performance reviews.

You getChannel Efficiency Ranking, performance Commentary and reallocation Recommendations

Prompt

Prompt
Act as a growth marketing director and financial analyst. Evaluate the campaign performance export pasted below to determine the true acquisition efficiency of each channel.

Rules:
- Calculate or compare key efficiency ratios: Cost Per Acquisition (CPA), Return on Ad Spend (ROAS), or Customer Acquisition Cost (CAC).
- Separate high-efficiency scaling channels from channels that are burning budget with poor conversion rates.
- Account for differing campaign volumes and avoid over-indexing on tiny sample sizes.
- Provide realistic adjustments based solely on the provided numbers without inventing attribution data.

Output format:
1. Channel Efficiency Ranking (Markdown table: Channel, Total Spend, Total Conversions, CPA, ROAS, Verdict)
2. Performance Commentary (Brief analysis of top performer and biggest laggard)
3. Reallocation Recommendations (Specific suggestions on where to shift budget)

Here is the campaign performance export:

Example output

Example for: Paid search, paid social, and newsletter ad spend from last month

1. Channel Efficiency Ranking
ChannelTotal SpendTotal ConversionsCPAROASVerdict
Google Brand Search$4,200280$15.004.8xHigh Performer
Meta Retargeting$6,100142$42.962.1xMaintain
LinkedIn Cold Video$8,50045$188.880.6xUnderperforming
Niche Newsletters$2,00062$32.252.8xScalable Opportunity
2. Performance Commentary
  • Top Performer: Google Brand Search delivers the lowest CPA ($15.00) and highest ROAS (4.8x), capturing high-intent demand efficiently.
  • Biggest Laggard: LinkedIn Cold Video consumes 41% of the total monthly spend while generating only 8% of conversions at a prohibitive CPA of $188.88, operating well below break-even.
3. Reallocation Recommendations
  • Reduce LinkedIn Cold Spend: Trim LinkedIn budget by 50% ($4,250 reduction) and re-test targeting strictly on job titles rather than broad industry audiences.
  • Expand Newsletter Sponsorships: Reallocate $2,000 to the newsletter channel, which shows strong conversion rates at a sustainable $32.25 CPA.
  • Protect Core Search: Keep Google Brand Search fully funded to prevent impression share loss to competitors.
Written by AI from this prompt. Your results will vary.

Paste your CSV export or table with spend, impressions, clicks, conversions, and revenue into ChatGPT, Claude, or Gemini. Ask this follow-up for more detail: 'What CPA target should I set for the underperforming channel to break even?'

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in Data Analysis