📧 Email Prompt
Gemini for Agency Account Managers: Fix Client Reporting Emails
Advanced Gemini prompts for Agency Account Managers writing client reporting emails that drive response and retention
The Prompt
You are an expert digital agency client communication specialist with 12 years of experience designing reporting email systems for marketing and creative agencies where monthly performance reports are the primary touchpoint for demonstrating value, managing client expectations, and reducing churn risk among clients who are evaluating their agency relationship. Help me build a drip email workflow so I can improve welcome sequence completion rate and create a structured reporting email process that turns monthly performance data into client communications that increase perceived agency value, reduce churn risk, and generate referrals from satisfied clients.
My situation:
- Agency type and service mix: [e.g., "a 12-person digital marketing agency — primary services are paid media management (Google and Meta), SEO, and content strategy — average retainer is $6,500/month, average client tenure is 14 months against a target of 24 months"]
- Current reporting process: [e.g., "a monthly PDF report generated from a dashboard tool is emailed to the client contact on the first of the month — the email body is a two-sentence introduction and the report attachment — average client open rate is 52%, average reply rate is 8%"]
- Client churn pattern: [e.g., "churn analysis shows 70% of clients who cancel in months 3-6 cited unclear ROI or lack of communication as the primary reason — 60% of those clients had not opened the monthly report in the 60 days before cancellation"]
- Client segment breakdown: [e.g., "22 active clients segmented by retainer size — under $5K (8 clients), $5K-$10K (10 clients), and over $10K (4 clients) — the over-$10K segment generates 41% of total revenue and receives no differentiated communication from the other segments"]
- Reporting data available: [e.g., "paid media ROAS, SEO keyword ranking movement, organic traffic growth, content engagement metrics, and a monthly strategic recommendation from the account manager — all available in the dashboard tool and exportable"]
- Email and project management tool: [e.g., "HubSpot for email, ClickUp for project management — can personalize with client name, company name, account manager name, and key metric values via HubSpot properties"]
- Client communication preference: [e.g., "a client survey found 68% of clients prefer a short email summary over a long PDF report, 55% want to know what the agency recommends doing next month before being told what happened last month, and 44% say they do not read the full PDF report"]
Deliver:
1. A monthly reporting email template that replaces the current two-sentence introduction — a 200-word email structure that leads with the single most important result from the month, explains what drove that result in one sentence, states the next month's priority action in one sentence, and links to the full report for clients who want the detail — making the email itself the communication and the report the supporting evidence
2. A client tier communication differentiation strategy — a modified reporting email for the over-$10K segment that includes a 50-word strategic commentary paragraph written by the account manager covering the market context for the month's results and one forward-looking recommendation, differentiating the agency's communication for the highest-value accounts without requiring a full additional report
3. A churn risk early warning email — a 150-word proactive email sent to clients who have not opened the last two monthly reports, acknowledging the communication gap without blame, offering a 15-minute results call as an alternative to the written report, and asking directly whether the current reporting format is working for them
4. A results milestone email template — a short, celebration-focused email sent when a client reaches a significant performance milestone (first $100K in tracked paid media revenue, first page-one keyword ranking, first month of organic traffic exceeding a target) — designed to be sent outside the monthly cycle to create a positive touchpoint that is not a report or an invoice
5. A referral invitation email — a 120-word email sent to clients in months 10-12 of the relationship, acknowledging the tenure milestone, summarizing the account growth over the period in two metrics, and making a direct, non-awkward referral ask with a specific incentive or reciprocal offer
6. A contract renewal preparation email — a 150-word email sent 60 days before the annual contract renewal date, summarizing the year's top three results, stating the agency's recommended scope for the next year, and opening the renewal conversation with a question that invites the client to shape the next year's strategy rather than simply renew the current one
7. A quarterly performance narrative template — a 300-word email sent at the end of each quarter replacing the standard monthly report format for that month, covering the quarter's progress against the annual goal, the top learning from the quarter, and the strategic priority for the next quarter, giving the agency's communication a quarterly rhythm that complements the monthly data cadence and demonstrates strategic thinking beyond execution
**Write every email template assuming the client contact is a marketing director who shares the monthly report with their CEO or board — every communication must be brief enough for a busy executive, specific enough to demonstrate measurable value, and forward-looking enough to make the agency feel like a strategic partner rather than a vendor delivering a data file.**
💡 How to use this prompt
- Implement the monthly reporting email template from output item 1 as a replacement for the current two-sentence introduction in the next reporting cycle before building any other part of the system. The 52% open rate on the current report email indicates the client is opening the email and then likely closing it without reading — restructuring the email body to lead with the key result and the next month's recommendation converts the monthly send from a PDF delivery notification into a strategic communication that generates reply conversations.
- The most common mistake is writing the churn risk email from output item 3 as a sales recovery message. An email that opens with "We noticed you haven't been reading the reports" reads as an accusation and accelerates the decision to cancel. The churn risk email must open from a position of service — acknowledging that the current reporting format may not be working and offering an alternative — giving the at-risk client a reason to re-engage rather than a reminder that they have been disengaging.
- Gemini's real-time web access is useful here for pulling current digital agency client retention benchmarks, churn analysis data, and client communication research before designing the reporting email system. For the final template copy and the quarterly narrative structure, paste Gemini's research into Claude for cleaner professional language that matches an agency tone.
Best Tools for This Prompt
🤖 Best AI Writing Tools for This Prompt
Tested & reviewed — run this prompt with the best AI tools
Related Topics
About This Email AI Prompt
This free Email prompt is designed for Gemini and works with any modern AI assistant including ChatGPT, Claude, Gemini, and more. Simply copy the prompt above, paste it into your preferred AI tool, and customize the bracketed sections to fit your specific needs.
Email prompts like this one help you get better, more consistent results from AI tools. Instead of starting from scratch every time, you can use this tested prompt as a foundation and adapt it to your workflow. Browse more Email prompts →