Quarterly Client Report Prompt: Turn Campaign Data into Client Insights
Turn your raw campaign data into a client-facing quarterly report with KPIs, wins, honest misses, and a clear next-quarter plan — in one ChatGPT pass.
The Prompt
You are a senior account manager at a top-tier marketing agency who has run 200+ quarterly client reviews that resulted in renewals. You know that a good client report isn't about showing off your metrics — it's about proving you earned the next invoice.
I'm going to paste my campaign data for the past quarter. Write me a client-facing quarterly report that a real agency could send.
Return the report in these exact sections, with real content (no [brackets] placeholders):
**Section 1: The Quarter at a Glance** (150-200 words)
- 3-5 KPIs that matter to this client (not generic ones — the ones from our kickoff call)
- Each KPI: current value, target value, % change from last quarter
- One-line headline per KPI: "Wins" / "Watch" / "Growth opportunity"
**Section 2: What We Tried** (200-300 words)
- 3-5 initiatives we ran this quarter
- For each: hypothesis, what we did, what happened
- Name-drop any experiments that didn't work — transparency builds trust
**Section 3: What Worked** (200-300 words)
- Top 3 wins with specific numbers
- What made them work (the mechanism, not just the result)
- One "if we're doing this again" insight per win
**Section 4: What Didn't Work** (100-150 words)
- 1-2 honest misses
- What we learned, what we'll do differently
- Don't bury this — clients respect it
**Section 5: Next Quarter Plan** (200-300 words)
- 3-5 priorities for next quarter
- For each: expected impact, resources needed, timeline
- 1 "stretch goal" that's ambitious but tied to a real opportunity
**Section 6: Investment Continuity** (100-150 words)
- Restate the current monthly retainer
- One sentence on why this investment is worth continuing
- CTA: "Shall we lock in the same scope for Q[X], or do you want to adjust?"
Rules:
- All numbers must come from the data I paste — do not invent metrics or results
- If a metric is missing, say "data not provided" rather than guessing
- Tone: peer to peer, not agency to client. Confident but honest.
- No marketing fluff words: "seamless," "cutting-edge," "synergy," "unlock," "empower," "elevate," "best-in-class"
- Total length: 1000-1200 words
- Format for email body (no markdown, plain text with section headers)How to Use
- Copy the prompt into ChatGPT.
- Paste your quarter’s campaign data (Google Ads, Meta, GA4 exports work).
- Review the 6 sections — fill in any names the AI couldn’t infer, then send.
What You Get
A 1000-1200 word quarterly report with 3-5 KPIs, wins and misses, a next-quarter plan, and a renewal-ready close.
Related Prompts
- Client Proposal Prompt — set expectations before the quarter starts
- Pricing Strategy Prompt — justify the next retainer with data
