How do I use the "Create Automated Email Report" prompt?

Copy the prompt template, fill in the variables (REPORT_TYPE, FREQUENCY, AUDIENCE, DATA_SOURCES, KEY_METRICS, TIME_PERIOD, NUMBER_OF_KPIS, BUSINESS_OBJECTIVE), and paste it into ChatGPT, Claude, or Gemini.

What AI tools work with this data prompt?

This prompt works with chatgpt, claude, gemini. Simply copy and paste the template into any of these AI assistants.

Tips for getting the best results?

Customize the KPI threshold alerts based on your specific business goals and historical performance Include data source timestamps to ensure stakeholders know how current the information is Use conditional formatting in your template to automatically highlight concerning metrics Keep the executive summary under 50 words for busy executives who scan emails quickly Test your email template across different devices and email clients before automation

data intermediate

Create Automated Email Report

Generate professional automated email reports with data insights, visualizations, and actionable recommendations using this detailed AI prompt.

Works with: chatgptclaudegemini

Prompt Template

Create a comprehensive automated email report template for [REPORT_TYPE] that will be sent [FREQUENCY] to [AUDIENCE]. The report should analyze [DATA_SOURCES] and focus on [KEY_METRICS]. Structure the email report with the following components: 1. **Executive Summary**: Write a compelling 2-3 sentence overview highlighting the most critical insights from [TIME_PERIOD] 2. **Key Performance Indicators**: Present the top [NUMBER_OF_KPIS] metrics in a clear, scannable format with: - Current values - Comparison to previous period - Trend indicators (↑↓→) - Brief context for significant changes 3. **Data Insights Section**: Provide 3-4 actionable insights derived from the data, including: - What the data reveals - Why it matters - Potential impact on [BUSINESS_OBJECTIVE] 4. **Visual Data Representation**: Suggest how to present data visually (charts, graphs, tables) and describe what each visualization should show 5. **Recommendations**: Include 2-3 specific, actionable recommendations based on the data analysis 6. **Alerts & Exceptions**: Highlight any metrics that fall outside normal ranges or require immediate attention 7. **Next Steps**: Outline follow-up actions and timeline Ensure the tone is professional yet accessible, use clear headings, and optimize for mobile reading. Include automated data refresh timestamps and source attribution.

Variables to Customize

[REPORT_TYPE]

The type of report being generated

Example: Weekly Marketing Performance Report

[FREQUENCY]

How often the report is sent

Example: weekly

[AUDIENCE]

Who receives the report

Example: marketing team and C-suite executives

[DATA_SOURCES]

Where the data comes from

Example: Google Analytics, Facebook Ads, email marketing platform, and CRM system

[KEY_METRICS]

Primary metrics to track

Example: website traffic, conversion rates, cost per acquisition, and email engagement

[TIME_PERIOD]

Reporting period

Example: this week

[NUMBER_OF_KPIS]

Number of key metrics to highlight

Example: 5

[BUSINESS_OBJECTIVE]

Main business goal

Example: increasing qualified leads and revenue growth

Example Output

**Weekly Marketing Performance Report - Week of [Date]** **Executive Summary** This week showed strong momentum with a 23% increase in qualified leads and improved email engagement rates, though paid social costs rose above target thresholds requiring optimization attention. **Key Performance Indicators** • Website Traffic: 12,450 visitors (↑ 18% vs last week) • Conversion Rate: 3.2% (↑ 0.4% vs last week) • Cost Per Acquisition: $127 (↑ $23 vs last week) ⚠️ • Email Open Rate: 24.8% (↑ 2.1% vs last week) • Social Media Reach: 45,200 (→ flat vs last week) **Key Insights** 1. **Blog Content Driving Traffic**: Our latest SEO-optimized blog posts generated 34% of organic traffic, indicating strong content-market fit 2. **Email Segmentation Success**: Segmented campaigns outperformed broadcast emails by 67% in click-through rates 3. **Social Ad Efficiency Declining**: Facebook CPM increased 41% week-over-week, suggesting audience saturation **Recommendations** • Pause underperforming Facebook ad sets and reallocate budget to Google Ads • Expand successful blog content themes identified this week • Test email send time optimization for higher engagement **Action Items**: Marketing team to review social ad targeting by Friday; implement email A/B tests next Monday.

Pro Tips for Best Results

Customize the KPI threshold alerts based on your specific business goals and historical performance
Include data source timestamps to ensure stakeholders know how current the information is
Use conditional formatting in your template to automatically highlight concerning metrics
Keep the executive summary under 50 words for busy executives who scan emails quickly
Test your email template across different devices and email clients before automation