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
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
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.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Audit driver-based models for compounding optimism bias
Expose subtle, compounding growth assumptions across pipeline stages and conversion metrics. Use this during quarterly budget reviews and board deck prep.
Build three scenarios for revenue and demand forecasts
Generate structured best, base, and worst-case forecast models to prepare for demand swings. Use this during annual planning or runway updates.
Clean inconsistent date formats and text categories
Turn chaotic timestamp formats and varied categorical spellings into unified standards. Use it when mismatched export values break dashboards.
Compare cumulative customer lifetime value across monthly cohorts
Spot whether newer customer groups spend faster or retain better than older cohorts. Use this to audit acquisition quality over time.
Create an anomaly investigation checklist for analytics teams
Run a disciplined diagnostic process before investigating metric shifts. Use this checklist whenever unexpected data spikes or drops appear in reports.
Differentiate structural null values from missing data
Identify whether null values represent expected business logic or export dropouts. Use it when auditing schema quality or preparing datasets for modeling.
- Estimate potential revenue recovery across funnel drop-off points
- Evaluate past forecast variances to set accurate targets
- Isolate regional or platform drivers behind KPI drops
- Map inconsistent export columns to target schemas
- Normalize retention comparisons for immature recent customer cohorts
- Resolve split device identities into single user records