🧠DeepPromptHub
Data AnalysisClaude / ChatGPT

Marketing Campaign Performance Analyzer

Analyze your marketing campaign data across channels to find what is working, what is wasting budget, and where to reallocate.

The Prompt

Analyze my marketing campaign performance and provide optimization recommendations.

Campaigns data: [paste campaign data or describe — include: channel, spend, impressions, clicks, conversions, revenue attributed, date range]

Business context:
- Product/service: [describe]
- Average order value: $[amount]
- Customer lifetime value: $[amount]
- Target CPA (cost per acquisition): $[amount]

Analyze across:

1. CHANNEL ROI COMPARISON
   - ROAS (return on ad spend) by channel
   - CPA by channel vs target
   - Which channels are above/below target efficiency?

2. CAMPAIGN-LEVEL BREAKDOWN
   - Best performing campaigns (by ROAS)
   - Worst performing campaigns (budget drains)
   - Any campaigns that should be paused immediately

3. FUNNEL ANALYSIS
   - Where is the biggest drop-off? (Impression → Click → Conversion)
   - Which channels have best conversion rates vs click rates?

4. BUDGET REALLOCATION
   - Specific recommendation: move $X from [channel] to [channel]
   - Expected impact on overall ROAS

5. TESTING ROADMAP
   - Top 3 A/B tests to run next based on the data gaps

Tips for Best Results

  • →Pull data from Google Analytics, Facebook Ads Manager, and your CRM into one spreadsheet first
  • →Use UTM parameters consistently so attribution data is accurate before analyzing

Tags

marketing analyticscampaign optimizationROASadvertisingbudget allocation

Related Prompts

Data Analysis

Data Dashboard Builder

Create an interactive data dashboard with charts, filters, and real-time metrics from your data source.

Data Analysis

A/B Test Analyzer

Analyze A/B test results with statistical significance calculations, confidence intervals, and actionable recommendations.

Data Analysis

Customer Persona Generator

Create detailed customer personas with demographics, psychographics, pain points, and buying behavior for marketing strategy.

Data Analysis

Financial Report Analyzer

Analyze financial statements and generate insights with ratio analysis, trend identification, and executive summary.

Data Analysis

Sales Data Analysis and Forecasting

Analyze historical sales data to identify trends, top performers, seasonality, and generate a 90-day forecast.

Data Analysis

Customer Churn Analysis Prompt

Identify why customers are leaving, which segments churn most, and what actions will reduce churn rate.

Data Analysis

Survey Data Analyzer and Report Generator

Turn raw survey responses into a structured insights report with key themes, sentiment analysis, and actionable recommendations.

Data Analysis

Financial Statement Analyzer

Analyze income statements, balance sheets, or cash flow statements to extract key ratios, trends, and red flags.