Marketing Email CampaignsIntermediate45 minSaves 1 hour

Weekly Marketing Analytics Summary for Leadership

Marketing analytics leads, quickly draft weekly performance emails for CMOs. Summarize key trends, propose actionable recommendations, and outline strategic questions for leadership.

Marketing analytics leads: craft weekly insights emails for leadership. Condense complex data into a headline chart, three insights, three actions with owners, and a strategic question. The output ensures clarity and drives action, tailored for executive review.

ChatGPT Claude Gemini

READY-TO-USE PROMPT

Copy Prompt

prompt.txt

Role: Assume the role of a highly competent Marketing Analytics Lead. Your expertise lies in translating intricate marketing performance data into clear, actionable intelligence for senior leadership. You are tasked with providing strategic clarity and driving data-informed decision-making.

Context: You are preparing a critical weekly executive summary email for the Chief Marketing Officer (CMO), {{cmo_name}}. This communication is vital for keeping leadership abreast of marketing performance, identifying areas of opportunity or concern, and guiding strategic adjustments. The email must be concise, diagnostic in its assessment, and strongly action-oriented, providing a comprehensive yet digestible overview of the past week's marketing performance. The overarching objective is to highlight the most significant trends, explain their underlying implications, propose concrete, executable actions, and stimulate pertinent strategic discussion. The reporting period specifically covers the week ending {{week_ending_date}}, focusing on recent performance shifts and their potential impact. Your analysis will be based on the {{raw_analytics_data}} you will provide.

Task: Generate a professional email that effectively summarizes the past week's marketing analytics. This email must be structured to include the following specific elements:

1. **Headline Chart Description**: A concise, impactful description of one primary headline chart. This chart should visually represent the most significant performance trend, anomaly, or key metric change observed from the provided data, clearly stating its importance.
2. **Key Insights (3)**: Three distinct, data-backed insights derived directly from the provided {{raw_analytics_data}}. Each insight should clearly articulate "what happened" (the observation) and "why it matters" (its business implication or potential impact). Avoid superficial observations; focus on causal links or significant deviations.
3. **Recommended Actions (3)**: Three specific, well-defined recommended actions. For each action, clearly assign a responsible owner (e.g., "Paid Media Team," "Content Strategy Lead," "Product Marketing Manager," "CRM Specialist") and suggest a realistic timeline for implementation (e.g., "Next 2 weeks," "Q3," "Ongoing," "End of Month"). These actions should directly address the insights.
4. **Strategic Open Question (1)**: One thoughtful, strategic open question for the CMO. This question should be designed to prompt discussion, encourage deeper investigation into a critical area of marketing performance or strategy, or explore a future direction based on the week's data.

Constraints:

* Maintain a consistently diagnostic, objective, and action-oriented tone throughout the entire email.
* Ensure all language is professional, clear, and direct. Avoid technical jargon without explanation and use simple terms wherever possible to enhance executive readability.
* The email's structure must facilitate quick comprehension for an executive audience, utilizing clear headings, bullet points, or numbered lists for insights and actions.
* Every insight and recommendation presented must be demonstrably supported by the analytics data that will be supplied to you. Do not invent data points or conclusions.
* The email should reflect a forward-looking perspective, emphasizing how current performance informs future strategy.

Output Format: A complete, ready-to-send email. Include a compelling subject line that summarizes the email's focus, a clear salutation to the CMO, and a professional closing from the Marketing Analytics Team.

Estimated results

DifficultyIntermediate

Setup time45 min

Time saved1 hour

Best modelsChatGPT, Claude, Gemini

Best audienceMarketing, Business Analytics

Editor's note

Why this prompt matters

Marketing analytics leads frequently face the challenge of distilling complex weekly performance data into concise, actionable insights for senior leadership. This task demands more than just presenting numbers; it requires strategic interpretation, identifying root causes, and proposing concrete next steps, all under tight deadlines. The process of sifting through metrics, identifying critical trends, and crafting a narrative that informs and guides strategic decisions can be time-consuming.

This workflow is designed for marketing analytics professionals who regularly report to a Chief Marketing Officer or other marketing executives. It addresses the pain point of translating raw data into an executive-ready summary that is both diagnostic and forward-looking. By structuring the analysis around key insights, recommended actions with clear ownership, and strategic questions, it helps ensure that leadership receives a consistent, high-quality update without the need for extensive manual drafting each week.

Reach for this workflow when you need to quickly generate a comprehensive yet digestible overview of the past week's marketing performance. It's particularly useful for recurring weekly reporting cycles where the objective is to highlight significant trends, explain their business implications, and prompt strategic discussion, thereby streamlining communication and fostering data-informed decision-making within the marketing department.

Anatomy

Prompt engineering breakdown

Role

Assume the role of a highly competent Marketing Analytics Lead. Your expertise lies in translating intricate marketing performance data into clear, actionable intelligence for senior leadership. You are tasked with providing strategic clarity and driving data-informed decision-making.

Context

You are preparing a critical weekly executive summary email for the Chief Marketing Officer (CMO), {{cmo_name}}. This communication is vital for keeping leadership abreast of marketing performance, identifying areas of opportunity or concern, and guiding strategic adjustments. The email must be concise, diagnostic in its assessment, and strongly action-oriented, providing a comprehensive yet digestible overview of the past week's marketing performance. The overarching objective is to highlight the most significant trends, explain their underlying implications, propose concrete, executable actions, and stimulate pertinent strategic discussion. The reporting period specifically covers the week ending {{week_ending_date}}, focusing on recent performance shifts and their potential impact. Your analysis will be based on the {{raw_analytics_data}} you will provide.

Goal

Generate a professional email that effectively summarizes the past week's marketing analytics.

Constraints

Maintain a consistently diagnostic, objective, and action-oriented tone throughout the entire email. Ensure all language is professional, clear, and direct. Avoid technical jargon without explanation and use simple terms wherever possible to enhance executive readability. The email's structure must facilitate quick comprehension for an executive audience, utilizing clear headings, bullet points, or numbered lists for insights and actions. Every insight and recommendation presented must be demonstrably supported by the analytics data that will be supplied to you. Do not invent data points or conclusions. The email should reflect a forward-looking perspective, emphasizing how current performance informs future strategy.

Output format

A complete, ready-to-send email. Include a compelling subject line that summarizes the email's focus, a clear salutation to the CMO, and a professional closing from the Marketing Analytics Team.

Why this structure works

This prompt structure works by clearly defining the 'role' of the AI, which grounds the tone and perspective. Explicit constraints on tone and data integrity ensure the output is reliable and appropriate for an executive audience. The structured output format, specifying elements like 'Key Insights (3)' and 'Recommended Actions (3)', guides the model to produce a consistent, easily digestible summary.

Pick your version

Prompt variations

BeginnerWorks with any model

For users new to prompt engineering or who need a very straightforward output without extensive detail.

prompt.txt

You are a marketing analyst. Write a weekly summary email for your CMO, {{cmo_name}}, about last week's marketing performance, ending {{week_ending_date}}. Use the {{raw_analytics_data}} to identify one main trend, three key insights, and three actions with owners. Also, include one question for the CMO. Keep the language simple and clear, focusing on what happened and what to do next. The email should be easy for a leader to read quickly.

ProfessionalBest with chatgpt

When a comprehensive, detailed, and structured executive summary is required, mirroring the original prompt's intent.

prompt.txt

Role: Assume the role of a Marketing Analytics Lead, translating intricate data into actionable intelligence for senior leadership.Context: Prepare a weekly executive summary email for CMO, {{cmo_name}}, covering the week ending {{week_ending_date}}. This email must be concise, diagnostic, and action-oriented, providing a digestible overview of marketing performance based on {{raw_analytics_data}}. The goal is to highlight significant trends, explain implications, propose concrete actions, and stimulate strategic discussion.Task: Generate a professional email with:1.  **Headline Chart Description**: A concise description of the most significant performance trend.2.  **Key Insights (3)**: Three data-backed insights (what happened, why it matters). Focus on causal links or significant deviations.3.  **Recommended Actions (3)**: Three specific actions, each with a responsible owner (e.g., "Paid Media Team") and a realistic timeline. Actions must directly address insights.4.  **Strategic Open Question (1)**: One thoughtful question for the CMO to prompt discussion or explore future strategy.Constraints: Maintain a diagnostic, objective, action-oriented tone. Use professional, clear language, avoiding jargon. Structure for quick executive comprehension (headings, bullets). All insights and recommendations must be supported by provided {{raw_analytics_data}}. Emphasize a forward-looking perspective.Output Format: Complete, ready-to-send email with a compelling subject line, salutation, and professional closing.

Short VersionWorks with any model

For quick drafts or when only the most critical information is needed without extensive detail.

prompt.txt

Draft a concise weekly marketing analytics summary email for CMO {{cmo_name}} regarding performance for the week ending {{week_ending_date}}. Analyze the {{raw_analytics_data}} to identify the most critical trend. Your email should include a description of one headline chart, three primary insights explaining 'what happened' and 'why it matters,' three specific recommended actions complete with assigned owners and timelines, and one strategic open question to foster leadership discussion. Maintain a diagnostic, action-oriented tone, delivering only essential, data-backed information for quick executive review.

EnterpriseBest with claude

In large organizations where stakeholder alignment, compliance, and risk mitigation are primary concerns.

prompt.txt

Role: You are a Lead Marketing Analytics Strategist, responsible for executive reporting that informs not just strategy but also compliance and cross-departmental alignment.Context: Compose a weekly executive summary email for CMO {{cmo_name}}, covering the week ending {{week_ending_date}}. This report, derived from {{raw_analytics_data}}, must offer strategic insights while also considering potential stakeholder impact and regulatory implications. The goal is to drive informed decisions, mitigate risks, and ensure alignment across departments.Task: Generate a professional email structured with:1.  **Headline Chart Description**: The most critical performance trend, assessing its potential impact on key business objectives and compliance.2.  **Key Insights (3)**: Three data-backed insights, detailing "what happened," "why it matters," and any associated risks or cross-functional dependencies.3.  **Recommended Actions (3)**: Three specific actions, each with a responsible owner, timeline, and an assessment of its impact on other departments or compliance standards.4.  **Strategic Open Question (1)**: One thoughtful question for the CMO, exploring strategic directions, potential risks, or requirements for inter-departmental collaboration.Constraints: Maintain a diagnostic, objective, and action-oriented tone. All content must be professional, clear, and direct. Explicitly consider stakeholder implications, data governance, and potential compliance requirements for all insights and recommendations. Emphasize a forward-looking perspective, including risk mitigation and strategic alignment across the organization.Output Format: A complete, ready-to-send email, including a subject line that hints at strategic and compliance considerations, salutation, and professional closing.

What you'll get

Expected output

Subject: Weekly Marketing Performance Review: Oct 27, 2023 - Conversion Rate Dip & Email Engagement

Dear Sarah Chen,

Here is the weekly marketing performance summary for the week ending October 27, 2023, highlighting key trends and strategic implications.

Headline Chart Description A line graph depicting Website Conversion Rate (WCR) over the past eight weeks, showing a noticeable 2% week-over-week decline for the week ending October 27, 2023, following a period of steady performance. The chart highlights that while overall traffic increased, the efficiency of converting that traffic into leads or sales has decreased, indicating a potential friction point in the user journey or offer relevance.

Key Insights

Website Conversion Rate Decline Despite Traffic Growth: While overall website traffic increased by 15% week-over-week (WoW), the site-wide conversion rate dipped from 3.8% to 3.6%. This suggests that the quality of new traffic sources or on-site user experience may be hindering conversion, leading to inefficient traffic acquisition spend, especially if traffic quality is not aligned with conversion intent.
Paid Search ROAS Stagnation Amidst Increased Spend: Paid search spend increased by 10% WoW, yet the Return on Ad Spend (ROAS) remained flat at 2.5x. This indicates diminishing returns on current campaign structures or keyword targeting, preventing scaling efforts from translating into proportional revenue growth. It points to a need for deeper optimization to maintain efficiency as investment grows.
Strong Performance in Targeted Email Segment: Our recent re-engagement campaign targeting inactive subscribers saw a 5% increase in open rates and a 3% uplift in click-through rates, exceeding benchmark performance for this segment. This validates the effectiveness of personalized content and segmentation strategies when applied to specific, under-engaged audience groups.

Recommended Actions

Conduct UX Audit on Key Landing Pages: Initiate an immediate audit of top-traffic landing pages and conversion funnels to identify friction points and A/B test new layouts or calls-to-action based on user behavior analytics. (Owner: Product Marketing Manager; Timeline: Next 2 weeks)
Optimize Paid Search Campaign Targeting & Bidding: Review current keyword performance, adjust bidding strategies for underperforming terms, and explore new audience segments to improve ROAS and ensure spend efficiency. (Owner: Paid Media Team; Timeline: End of Month)
Expand Personalized Email Content Strategy: Develop a plan to replicate the successful re-engagement campaign's personalization tactics across other inactive or under-engaged email segments to foster higher engagement. (Owner: CRM Specialist; Timeline: Q1 2024 Planning)

Strategic Open Question Given the persistent challenge in converting increased traffic and the flat ROAS for paid channels, how should we re-evaluate our top-of-funnel acquisition strategy to prioritize conversion efficiency over raw traffic volume in the coming quarter, ensuring our spend delivers better business outcomes?

Best regards, Marketing Analytics Team

Under the hood

Why this prompt works

This workflow produces effective executive summaries due to several key prompt engineering techniques.

Role Priming sets the model's persona as a "highly competent Marketing Analytics Lead." This instruction directs the model to adopt a strategic, analytical, and executive-level communication style, moving beyond simple data regurgitation to provide meaningful interpretation and actionable advice. The output reflects the perspective of an expert translating complex data for leadership.

Context Setting provides the scenario—preparing a "critical weekly executive summary email for the Chief Marketing Officer"—and clearly defines the objective: strategic clarity and data-informed decision-making. This directs the model to filter information through a business lens, ensuring relevance to senior leadership's concerns and priorities, rather than a general data analysis.

Explicit Constraints are crucial for shaping the output's quality and utility. Directives such as "diagnostic, objective, and action-oriented tone," "professional, clear, and direct language," and the requirement that "every insight and recommendation presented must be demonstrably supported by the analytics data" prevent the generation of vague or speculative content. These constraints ensure the email is credible, focused, and immediately usable for an executive audience.

Finally, the Structured Output requirements, broken down into specific elements like a "Headline Chart Description," "Key Insights (3)," "Recommended Actions (3) with owners and timelines," and a "Strategic Open Question (1)," provide a clear framework. This scaffolding ensures all necessary components of an executive summary are included and presented logically, making the output far more comprehensive and digestible than a single, unstructured request.

Model fit

Best AI models for this prompt

ChatGPT

ChatGPT excels at structuring text and synthesizing information into clear summaries. Its ability to follow complex instructions for specific output formats makes it reliable for generating the email's sections (chart description, insights, actions, questions). It might require refinement on the "why it matters" aspect for insights without very explicit data context. See the full ChatGPT hub for deeper guidance.

Claude

Claude is strong in long-form text generation and maintaining a professional, nuanced tone. Claude can connect disparate data points into coherent narratives, which is beneficial for crafting the insights and the strategic open question. It performs well with detailed context, but less detailed input might lead to more generic insights. See the full Claude hub for deeper guidance.

Gemini

Gemini is good at multi-modal inputs, though for this text-only prompt, its strength lies in its conciseness and ability to extract key information efficiently. Gemini can quickly draft the core components of the email, making it useful for rapid iteration. Ensure the input data is well-structured to get the most precise outputs. See the full Gemini hub for deeper guidance.

When to use

When preparing a weekly marketing performance summary for executive leadership.
When you need to translate complex analytics data into concise, actionable insights.
When a structured, consistent format is required for recurring leadership communications.
When aiming to align marketing team actions directly with observed data trends.
When seeking to stimulate strategic discussion based on recent performance shifts.

When not to use

For daily operational updates; the scope and detail are more suited for weekly reviews.
When the underlying analytics data is unverified, incomplete, or speculative.
For in-depth, granular analytical reports that require extensive data visualization and detailed methodology.
When the target audience is not senior leadership, as the tone and focus are executive-level.
For initial strategy brainstorming sessions where data is not yet available or primary.

Get more from it

Pro tips

1
Validate your raw analytics data thoroughly before input to prevent the generation of misleading insights or actions.
2
Clearly specify the `cmo_name` and `week_ending_date` variables for personalized and contextually accurate email generation.
3
Experiment with the level of detail in your `raw_analytics_data` input to fine-tune the depth and focus of the generated insights.
4
Review the suggested owners and timelines for recommended actions, adjusting them to fit your specific organizational structure and priorities.
5
Use the strategic open question as a starting point; refine it to precisely address key strategic dilemmas or future planning considerations.
6
If the initial insights feel superficial, try adding more comparative context or potential causal factors to your input data description.

Don't ship this

Common mistakes

✗ Inputting raw, undigested data without any pre-summarization or interpretation.
Fix — Pre-process your analytics data into key metrics, trends, and anomalies. Highlight what's significant for better output.
✗ The generated actions are too generic or lack specific ownership assignments.
Fix — Provide examples of roles (e.g., 'Paid Media Lead', 'SEO Specialist') within your input to guide the model's suggestions.
✗ Insights merely state observations without explaining their business implications or 'why it matters'.
Fix — Explicitly include the business context or potential impact for each data point or trend in your `raw_analytics_data`.
✗ The headline chart description doesn't align with the most critical trend you want to highlight.
Fix — Emphasize the single most important trend or anomaly within your `raw_analytics_data` input for accurate headline generation.
✗ The strategic open question is too tactical, failing to prompt high-level executive discussion.
Fix — Frame your `raw_analytics_data` input with broader strategic implications to encourage a more elevated, thought-provoking question.

Frequently asked questions

Q.Can I use this prompt for a reporting frequency other than weekly, such as monthly or quarterly?

Yes, you can adapt this prompt for different reporting frequencies. Simply adjust the week_ending_date variable to reflect your chosen period (e.g., month_ending_date). Ensure your raw_analytics_data aligns with that reporting interval for accurate results.

Q.How detailed should the `raw_analytics_data` input be to get good results?

Aim for a concise summary of your most critical KPIs, significant trends, and any notable anomalies. Avoid pasting raw data tables. Focus on 3-5 key metrics, their current values, and comparison points (e.g., week-over-week, vs. target) to provide enough context without overwhelming the model.

Q.Will this prompt work for B2B marketing analytics, or is it more suited for B2C?

This prompt is effective for both B2B and B2C marketing analytics. The underlying structure focuses on data interpretation and action planning. Provide relevant B2B metrics like MQLs, SQLs, pipeline value, or account-based marketing performance, and the output will adapt accordingly.

Q.What if I don't have specific owners or timelines in mind for the recommended actions?

The model will generate plausible owners and timelines based on common marketing roles and project cycles. However, for maximum utility, review and adjust these suggestions to precisely match your team structure and implementation capacities after the email is generated.

Q.Can I ask for more than three insights or recommended actions?

The prompt is designed for three insights and three actions to maintain executive brevity and focus, which is crucial for leadership communications. While you could modify the prompt, exceeding this limit often dilutes the message and makes it harder for executives to absorb.

Q.How do I ensure the output maintains a professional and objective tone?

The prompt explicitly instructs the model to maintain a diagnostic, objective, and action-oriented tone. Consistently providing clear, factual, and unbiased language in your raw_analytics_data input reinforces this and helps prevent any deviation from the desired tone.

Version 1.0Last reviewed July 12, 2026

Reviewed by PromptInFlow Editorial Team