Are you spending hours each week wrestling with spreadsheets, trying to compile data from a dozen different platforms just to report on basic KPIs? That time could be spent on strategy and creative work. This one prompt eliminates that friction entirely.
It automates the data aggregation and initial analysis, turning a multi-hour task into a 60-second request. Imagine getting a coherent performance snapshot, complete with insights and suggested actions, in seconds. This is the next level of automating marketing tasks.
📋 The Prompt
**Core Task:**
Synthesize performance data from our key platforms: Meta Ads, Google Ads, Google Analytics 4, and our Email Service Provider (e.g., Klaviyo).
**Required Data Points:**
– Key Metrics: Impressions, Clicks, CTR, Spend, Conversions (specify: Purchases/Leads), Conversion Rate, Revenue, ROAS/CPA, and any relevant platform-specific health metrics (e.g., quality score).
– Top 3 performing assets by ROAS.
– Worst 3 performing assets by CPA.
– Notable week-over-week changes (highlight increases/decreases >15%).
**Report Structure:**
1. **Executive Summary:** Two sentences summarizing the week's overall performance trend.
2. **Platform Deep Dive:** A concise paragraph for each platform (Meta, Google, etc.) with key metrics and one primary observation.
3. **Key Insights & Actions:** List 3-5 data-backed insights. For each insight, recommend one clear, tactical next-step action (e.g., "Pause Ad Set X," "Increase budget for Keyword Y," "Test subject line variant Z").
4. **Weekly Priority:** Based on the data, what is the single most important task for the coming week?
**Format:** Present the report in clear, scannable sections using markdown. Use bold for key metric values and trends.
How It Works
This prompt works because it replaces a vague request with a structured, role-playing command. You’re not just asking for data; you’re instructing an expert analyst to execute a specific workflow.
The “Act as…” frame sets the tone for professional output. The prompt explicitly asks for synthesis, not just listing numbers. This forces the AI to connect dots across platforms.
Notice the structure: data input, required points, and a clear output format. This mirrors how a human analyst would work. The AI knows exactly what to look for and how to organize it. The inclusion of “Key Insights & Actions” is critical. It pushes the AI beyond reporting into strategy, which is where real productivity gains happen. For more on building these strategic frameworks, see our guide on advanced AI strategy prompts.
By standardizing this report format, you create a consistent baseline. Every week, you get the same type of analysis, making trend-spotting effortless. This prompt turns raw data into a ready-to-share briefing document.
Pro Tips & Variations
Advanced Tweaks: To get deeper competitive analysis, add a line like: “Incorporate a SWOT analysis based on the performance trends.” For creative testing, specify: “Analyze ad creative themes (e.g., UGC vs. product shots) and correlate with performance.”
Common Mistake: The biggest error is providing insufficient context. The prompt needs the [Campaign/Brand Name] and [Date Range] filled in. Also, be specific about your conversion goal (Purchases vs. Leads). Vague goals lead to vague reports.
For Different Results: To focus purely on optimization, change the core task to: “…identify the top 3 budget reallocation opportunities for the next week.” This yields a hyper-tactical plan. Alternatively, for a quarterly review, expand the date range and ask for trend analysis versus previous periods. Explore more ways to refine your process with our digital marketing optimization hacks.
Frequently Asked Questions
Can I use this prompt if I only use one platform, like Meta Ads?
Absolutely. Just modify the ‘Core Task’ section. Instead of listing multiple platforms, specify ‘Meta Ads’ and adjust the required data points accordingly. The structured thinking of the prompt still applies perfectly.
What if the AI hallucinates or provides incorrect data?
This prompt is designed for synthesis, not data entry. You must input the correct metrics from your platforms into the chat. Think of the AI as your analyst who writes the report based on the numbers you provide.
How do I make the insights more actionable for my team?
Be more specific in the ‘Key Insights & Actions’ request. Add: ‘Frame each action as a direct instruction to a team member (e.g., Graphic Designer: Create 3 new assets based on top performer X).’ This assigns clear ownership.
Can this prompt generate charts or visuals?
Most AI text models (like ChatGPT) cannot create true image charts. However, you can instruct it to ‘suggest a chart type for each key insight (e.g., line chart for spend over time).’ You then create the visuals manually—but now you know exactly what’s needed.
Is this just for weekly reports, or can it be adapted?
It’s highly adaptable. For a daily check-in, shorten the date range and ask for ‘urgent flags.’ For a monthly strategy doc, expand the range and ask for ‘narrative trend analysis and forecast.’ The core framework scales beautifully.
