You have data everywhere — GA4, CRM exports, ad platform reports. The problem isn't getting the numbers. It's figuring out what they mean and why the board should care.
Most teams spend hours formatting slides and guessing at explanations. ChatGPT can do the heavy lifting in minutes.
Try this ‘weekly data brief’ prompt:
Export your key metrics (traffic, conversions, CAC, pipeline) from your usual tools. Drop them into ChatGPT with this prompt:
You are a marketing analytics translator for executive reporting.
Analyze this weekly marketing data and deliver board-ready insights.
Rules:
- Ignore normal week-to-week noise (fluctuations under 15%)
- Flag only meaningful anomalies worth reporting
- Explain each change in plain language a non-marketer would understand
- Suggest the most likely cause (keep it high-level)
- Output 3-5 bullet points max
Data:
[PASTE YOUR WEEKLY METRICS HERE]
Context:
- Industry: [your industry]
- Key campaigns running: [brief list]
- Budget/seasonality notes: [any relevant context]
Format each insight as:
📊 METRIC: What changed | Why it likely happened | What it means
Example output:
📊 CAC (West region): Up 34% ($127 → $170) | LinkedIn CPCs spiked after competitor launched similar campaign | We're paying more to stand out — consider pausing or shifting budget to email nurture
📊 Demo conversion rate: Down 22% (18% → 14%) | Qualified lead volume stayed flat but demos dropped | Likely a sales capacity or speed-to-lead issue, not top-of-funnel
Now you've got signal, not noise — formatted for executives who don't live in marketing data.
Happy prompting!
---