Prompt: Analyze This Campaign Data
Jay Banlasan
The AI Systems Guy
tl;dr
Turn raw advertising data into actionable insights with clear recommendations for what to change next.
Raw campaign data is just numbers in columns. Spend, impressions, clicks, conversions. The value is in what those numbers mean and what you should do about them. Most people stare at the data, make a guess, and hope they are right.
This prompt turns campaign data into analysis. Use it to prompt analyze campaign data ai so you get recommendations, not just observations.
The Prompt
Analyze this advertising campaign data and provide actionable recommendations.
BUSINESS CONTEXT: [What you sell, target CPA/ROAS, current goals]
PLATFORM: [Meta, Google, LinkedIn, etc.]
DATE RANGE: [Period this data covers]
BUDGET: [Total budget for this period]
Here is the data:
[PASTE: Campaign name, ad set name, ad name, spend, impressions, clicks, CTR, CPC, conversions, cost per conversion, ROAS/CPA]
Provide your analysis in this structure:
1. EXECUTIVE SUMMARY (3 sentences: What happened, what worked, what needs attention)
2. TOP PERFORMERS
- Which campaigns/ad sets/ads delivered the best results?
- Why are they working? (audience, creative, offer hypothesis)
- Recommendation: scale, maintain, or test variations
3. UNDERPERFORMERS
- Which are below target?
- Diagnosis: is it a traffic problem (low CTR) or conversion problem (high CTR, low conversion)?
- Recommendation: pause, fix, or give more time
4. BUDGET ALLOCATION
- Where is money being wasted?
- Where should budget shift?
- Specific reallocation recommendation with dollar amounts
5. TESTING PRIORITIES
- What should be tested next based on the data patterns?
- What hypothesis does each test validate?
6. RED FLAGS
- Any metrics trending in the wrong direction?
- Any data that seems unusual or needs verification?
Rules:
- Every recommendation must cite the specific data point that supports it
- Use the actual campaign/ad set/ad names from the data
- Do not recommend changes for campaigns with less than $50 in spend (insufficient data)
- If a metric looks unreliable, say so instead of building analysis on bad data
- Be direct about what to kill. Do not sugarcoat underperformance.
Reading the Analysis
Pay attention to the diagnosis in the underperformers section. A campaign with high CTR but low conversions has a landing page or offer problem, not an ad problem. A campaign with low CTR has a targeting or creative problem. The fix is completely different.
Running This Weekly
Make this part of your weekly campaign review. Same prompt, fresh data. Over time, the AI catches trends that a single week's snapshot misses. "This ad set's CPA has increased 15% each of the last three weeks" is an insight that requires longitudinal data.
Pairing With Action
Analysis without action is entertainment. After each analysis, pick the top two recommendations and implement them within 48 hours. Track the results. Feed them back into the next analysis cycle. This creates a feedback loop where your campaigns improve continuously.
Build These Systems
Ready to implement? These step-by-step tutorials show you exactly how:
- How to Build AI-Powered Bid Strategy Recommendations - Use AI to analyze data and recommend optimal bid strategies for each campaign.
- How to Create AI-Powered Drip Campaign Optimizer - Optimize drip campaign timing and content using AI analysis of engagement data.
- How to Build AI-Powered Audience Targeting Suggestions - Use AI to analyze your data and suggest new audience segments to test.
Want this built for your business?
Get a free assessment of where AI operations can replace overhead in your company.
Get Your Free Assessment