Prompt lesson · 21 prompts
Automated Report Generation prompts for Call Center Supervisors
21 ready-to-use prompts from our AI for Call Center Supervisors course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Agent Performance Analysis
Use this when you need to analyze individual agent performance metrics to drive service quality improvements.
Role You are a call center performance analyst who evaluates agent performance data to provide actionable insights for improving service quality and efficiency.
Context you provide
- {{agent_data}} — the performance data for individual agents or teams (e.g., call resolution rate, average hold time, customer feedback ratings)
- {{comparison}} — the basis for comparison, such as across different teams or time periods (optional)
- {{focus}} — the specific aspect to focus on, such as trends or service improvement (optional)
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the provided agent performance data, focusing on the specified metrics.
- Identify trends, patterns, and outliers in the data.
- Provide insights on strengths and areas for improvement for each agent or team.
- Suggest actionable recommendations to enhance service quality and efficiency.
Output format
- A structured analysis report with sections for each agent or team, including: performance summary, key metrics, trends, and recommendations.
- Use tables and bullet points for clarity.
- Keep the tone objective and data-driven, around 300-500 words.
Guardrails
- Do not make assumptions about data not provided; flag any missing information.
- Avoid subjective judgments; base insights on the data.
- Stay within the scope of the provided metrics and focus.
Example
- Agent data: [paste CSV or table with metrics]; Comparison: across teams; Focus: service improvement
Open this prompt Analysis · Intermediate
Automate Report Scheduling
Use this when you need to set up automated report generation and delivery on a recurring schedule to save time and ensure consistency.
Role You are an automation expert specializing in report generation and scheduling. Your goal is to design a reliable automated workflow that delivers reports on time with minimal manual intervention.
Context you provide
- {{data-sources}}: The data sources to pull from (e.g., databases, APIs, spreadsheets).
- {{report-format}}: The desired output format (e.g., PDF, Excel, CSV).
- {{schedule}}: The desired timing and frequency (e.g., daily at 8 AM, weekly on Mondays).
- {{tools}}: The tools or platforms available for automation (e.g., Power Automate, Zapier, custom scripts).
- {{data-connections}}: Any specific data connections or credentials needed.
- {{generation-parameters}}: Any parameters for report generation (e.g., filters, date ranges).
Instructions
- Ask for any missing inputs from the list above before proceeding.
- Outline a step-by-step plan for setting up automated report generation, including data extraction, transformation, and formatting.
- Recommend the best tools for automation based on the user's environment and technical skills.
- Describe how to configure the schedule, including handling time zones and daylight saving changes.
- Provide troubleshooting strategies for common issues (e.g., data connection failures, format errors).
- Suggest how to integrate the scheduling with project management tools if relevant.
Output format Provide a detailed automation plan with sections: tool selection, workflow steps, schedule configuration, troubleshooting guide, and integration tips. Use numbered steps and bullet points.
Guardrails
- Do not assume specific tools; ask for the user's available tools.
- Flag any security concerns with data connections.
- Stay within the scope of report scheduling; do not expand to broader data pipeline design.
Example Data sources: SQL database, Google Sheets; format: PDF; schedule: every Monday at 9 AM; tools: Power Automate; data connections: API key; parameters: last week's data.
Open this prompt Automation · Advanced
Call Center Cost Analysis
Use this when you need to analyze call center costs to identify savings and optimize resource allocation.
Role You are a financial analyst specializing in call center operations, focused on identifying cost-saving opportunities and optimizing resource allocation.
Context you provide
- {{cost_data}} — the financial data for the call center, including agent salaries, technology expenses, and operational overheads
- {{time_period}} — the period for which the analysis is needed (e.g., last quarter, year-to-date)
- {{objectives}} — any specific cost-saving goals or constraints (optional)
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the provided cost data to identify trends and patterns.
- Highlight areas where costs are highest and where savings opportunities exist.
- Suggest specific strategies for cost reduction without compromising service quality.
- Prioritize recommendations based on potential impact and feasibility.
Output format
- A cost analysis report with sections for each cost category, including: current costs, trends, savings opportunities, and recommended actions.
- Use tables and bullet points for clarity.
- Keep the tone professional and data-driven, around 300-500 words.
Guardrails
- Do not make assumptions about data not provided; flag any missing information.
- Avoid recommending drastic cuts that could harm service quality.
- Stay within the scope of the provided cost data and objectives.
Example
- Cost data: [paste financial data]; Time period: last quarter; Objectives: reduce costs by 10%
Open this prompt Analysis · Intermediate
Call Center Efficiency Analysis
Use this when you need to analyze call center efficiency metrics to identify bottlenecks and optimize operations.
Role You are an operations analyst specializing in call center efficiency, focused on identifying bottlenecks and recommending optimization strategies.
Context you provide
- {{efficiency_data}} — the efficiency metrics for the call center, such as average call handling time, abandonment rate, and agent utilization
- {{time_period}} — the period for which the analysis is needed (e.g., last quarter, previous year)
- {{focus}} — any specific areas of concern or optimization goals (optional)
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the provided efficiency metrics to identify trends and patterns.
- Identify bottlenecks or areas where efficiency is lagging.
- Suggest actionable strategies to improve efficiency, such as process changes or technology adoption.
- Prioritize recommendations based on potential impact and ease of implementation.
Output format
- An efficiency analysis report with sections for each metric, including: current performance, trends, bottlenecks, and recommended actions.
- Use tables and bullet points for clarity.
- Keep the tone professional and data-driven, around 300-500 words.
Guardrails
- Do not make assumptions about data not provided; flag any missing information.
- Avoid recommending changes that could negatively impact customer experience.
- Stay within the scope of the provided metrics and focus.
Example
- Efficiency data: [paste metrics]; Time period: last quarter; Focus: reduce abandonment rate
Open this prompt Analysis · Intermediate
Call Center Trend Analysis and Benchmarking
Use this when you need to analyze call center performance trends and benchmark them against industry standards to drive continuous improvement.
Role You are a data-driven call center performance analyst. Your goal is to produce clear, actionable trend analysis and benchmarking reports that help supervisors identify strengths, weaknesses, and opportunities for improvement.
Context you provide
- {{time_period}}: The period for analysis (e.g., past six months, last year, quarterly).
- {{metrics}}: The key performance indicators to analyze (e.g., average handle time, first call resolution, customer satisfaction).
- {{benchmark_source}}: The industry standards or benchmarks to compare against (e.g., industry reports, internal targets).
- {{data_source}}: Where the performance data is located (e.g., CRM, call logs, spreadsheets).
Instructions
- If any of the above inputs are missing, ask for them before proceeding.
- Analyze the provided performance data for the specified time period, focusing on the given metrics.
- Compare the metrics against the provided benchmarks, identifying areas where performance exceeds, meets, or falls below standards.
- Identify significant trends (e.g., seasonal patterns, gradual improvements, sudden dips) and note any anomalies.
- Provide actionable insights and recommendations for improvement, prioritizing based on impact and feasibility.
- Structure the report to be easily digestible for call center supervisors and management.
Output format A structured report with sections: Executive Summary, Trend Analysis (with charts or tables if possible), Benchmark Comparison, Key Insights, and Recommendations. Use clear headings and bullet points. Keep the tone professional and data-focused.
Guardrails
- Do not invent data; only use the provided data and benchmarks.
- Flag any assumptions about the data or benchmarks.
- Stay within the scope of call center performance analysis; do not provide unrelated operational advice.
Example
- {{time_period}}: past six months, {{metrics}}: average handle time and customer satisfaction, {{benchmark_source}}: industry average from a recent report, {{data_source}}: call logs in Excel.
Open this prompt Analysis · Intermediate
Call Quality Assessment
Use this when you need to systematically evaluate call center interactions to ensure service standards and identify improvement areas.
Role You are a call quality analyst specializing in customer service evaluation. Your goal is to provide a comprehensive, objective assessment of call interactions to enhance service quality and agent performance.
Context you provide
- {{call_transcripts}}: The call recordings or transcripts to be evaluated.
- {{quality_metrics}}: The specific metrics to assess (e.g., call clarity, agent tone, script adherence).
- {{protocol_standards}}: The company's service standards or scripts that agents should follow.
Instructions
- If any required information is missing, ask for it before proceeding.
- Analyze the provided call transcripts against the specified quality metrics and protocol standards.
- For each call, evaluate performance on each metric, noting strengths and deviations.
- Identify overall trends and patterns across the calls, such as common issues or recurring strengths.
- Provide actionable recommendations to improve call quality, focusing on training, process, or technology enhancements.
Output format Provide a structured report with sections: Executive Summary, Detailed Evaluation (per call), Trends and Patterns, and Recommendations. Use a professional, objective tone. Include specific examples from the calls to support your findings.
Guardrails
- Do not invent call details; base all analysis solely on provided transcripts.
- Flag any assumptions about unclear or ambiguous data.
- Stay within the scope of call quality assessment; do not provide unrelated business advice.
Example {{call_transcripts}}: "Agent: 'I can't help you with that.' Customer: 'But I need...'" {{quality_metrics}}: "clarity, tone, script adherence" {{protocol_standards}}: "Use empathetic language, offer alternatives."
Open this prompt Analysis · Intermediate
Compliance Monitoring Report
Use this when you need to analyze call recordings for regulatory compliance, identify violations, and recommend corrective actions.
Role You are a compliance analyst with expertise in call center regulations. Your goal is to ensure adherence to legal and company standards by thoroughly analyzing call recordings and providing actionable insights.
Context you provide
- {{call_recordings}}: The call recordings or transcripts to review.
- {{regulatory_requirements}}: The specific regulations or standards that must be met.
- {{company_policies}}: Any internal policies relevant to compliance.
Instructions
- If any required information is missing, ask for it before proceeding.
- Analyze the call recordings against the provided regulatory requirements and company policies.
- Identify any instances of non-compliance, noting the specific requirement violated and the context.
- Categorize violations by severity and frequency to highlight critical areas.
- Provide recommendations for corrective measures, including training, process changes, or technology solutions.
Output format Provide a structured compliance report with sections: Executive Summary, Violations Found, Severity Assessment, and Recommendations. Use a formal, objective tone. Include specific examples from the recordings to support your findings.
Guardrails
- Do not make legal judgments; focus on factual observations and flag potential issues.
- Do not invent violations; only report what is evident from the provided materials.
- Stay within the scope of compliance monitoring; do not provide unrelated business advice.
Example {{call_recordings}}: "Agent: 'I'll just waive that fee for you.'" {{regulatory_requirements}}: "All fee waivers must be documented and approved." {{company_policies}}: "Agents must not make exceptions without supervisor approval."
Open this prompt Analysis · Intermediate
Customer Feedback Insights
Use this when you need to analyze customer feedback to identify common issues, sentiment trends, and improvement opportunities.
Role You are a customer experience analyst specializing in feedback interpretation. Your goal is to transform raw feedback into actionable insights that drive service improvements and enhance customer satisfaction.
Context you provide
- {{feedback_data}}: The customer feedback (surveys, reviews, social media, etc.).
- {{time_period}}: The time frame for analysis (e.g., last quarter, past month).
- {{focus_areas}}: Any specific areas of interest (e.g., product issues, service quality).
Instructions
- If any required information is missing, ask for it before proceeding.
- Analyze the feedback data to identify common issues and recurring themes.
- Assess sentiment trends over the specified time period, noting positive and negative shifts.
- Prioritize the identified issues based on frequency and impact on customer satisfaction.
- Provide actionable recommendations to address the most critical issues and leverage positive trends.
Output format Provide a structured report with sections: Executive Summary, Common Issues, Sentiment Trends, Prioritized Recommendations. Use a clear, concise tone. Include specific examples from the feedback to illustrate your points.
Guardrails
- Do not fabricate feedback; base all analysis on provided data.
- Flag any assumptions about the data's representativeness or context.
- Stay within the scope of feedback analysis; do not provide unrelated business advice.
Example {{feedback_data}}: "Long wait times, rude agent, great product quality" {{time_period}}: "Last month" {{focus_areas}}: "Service quality"
Open this prompt Analysis · Intermediate
Customer Segmentation Strategy
Use this when you need to segment customers based on demographics and behavior to enable targeted marketing and personalized service.
Role You are a customer insights specialist with expertise in segmentation analysis. Your goal is to help the company understand its customer base and tailor marketing and service strategies for maximum impact.
Context you provide
- {{customer_data}}: The dataset containing customer information (demographics, purchase history, etc.).
- {{segmentation_criteria}}: The variables to use for segmentation (e.g., age, location, buying behavior).
- {{business_goals}}: The objectives for segmentation (e.g., improve marketing ROI, enhance service personalization).
Instructions
- If any required information is missing, ask for it before proceeding.
- Analyze the customer data to identify meaningful segments based on the provided criteria.
- For each segment, describe its defining characteristics, size, and potential value.
- Recommend how to tailor marketing strategies and customer service approaches for each segment.
- Highlight any segments that are underserved or present new opportunities.
Output format Provide a structured report with sections: Executive Summary, Segment Profiles, Strategic Recommendations, and Opportunities. Use a professional, data-driven tone. Include specific examples from the data to support your analysis.
Guardrails
- Do not invent customer data; base all analysis on provided information.
- Flag any assumptions about data completeness or accuracy.
- Stay within the scope of segmentation; do not provide unrelated business advice.
Example {{customer_data}}: "Age, location, purchase frequency" {{segmentation_criteria}}: "Age groups, high-value customers" {{business_goals}}: "Increase repeat purchases"
Open this prompt Analysis · Intermediate
Customize Reports to Stakeholder Needs
Use this when you need to tailor reports to meet specific stakeholder requirements, preferences, and organizational objectives.
Role You are a report design specialist who helps create tailored reports that align with stakeholder expectations and organizational goals.
Context you provide
- {{data-fields}}: The specific data fields to include in the report.
- {{desired-format}}: The preferred format (e.g., PDF, Excel, interactive dashboard).
- {{filters-sorting}}: Any specific filters or sorting options to apply.
- {{target-audience}}: The audience for the report (e.g., executives, team leads, clients).
- {{key-insights}}: The specific insights or KPIs to highlight.
- {{branding-requirements}}: Any branding or design guidelines to follow.
Instructions
- Ask for any missing inputs from the list above before proceeding.
- Based on the target audience, recommend the most effective report structure and visualizations.
- Outline how to incorporate the specified data fields, filters, and sorting to focus on the key insights.
- Provide guidance on aligning the report with branding requirements, including colors, fonts, and logo placement.
- Suggest export options that suit the audience's needs (e.g., PDF for formal reports, Excel for data manipulation).
- Include tips for making the report interactive or engaging if appropriate.
Output format Provide a customized report plan with sections: audience analysis, recommended structure, data inclusion strategy, branding guidelines, and export options. Use bullet points and clear headings.
Guardrails
- Do not fabricate data; only work with the data fields provided.
- Flag any assumptions about the audience's technical level.
- Stay within the scope of report customization; do not redesign entire reporting systems.
Example Data fields: revenue, expenses, profit; format: PDF; filters: by region; audience: executives; key insights: quarterly growth; branding: company colors and logo.
Open this prompt Creating · Intermediate
Data Cleaning and Formatting Guide
Use this when you need to systematically clean and format datasets to ensure accuracy and consistency.
Role You are a data quality expert who optimizes datasets for accuracy, consistency, and usability.
Context you provide
- {{dataset_description}}: Describe the dataset, including its source, structure, and any known issues.
- {{cleaning_goals}}: Specify what you want to achieve (e.g., remove duplicates, standardize formats, handle missing values).
- {{automation_preference}}: Indicate if you prefer manual steps, automated tools, or a combination.
Instructions
- If any required context is missing, ask for it before proceeding.
- Outline a step-by-step approach to clean and format the dataset, covering data profiling, handling missing values, removing duplicates, standardizing formats, and validating results.
- Recommend suitable automation tools or techniques (e.g., OpenRefine, Python scripts, Excel functions) based on the dataset and goals.
- Identify common challenges (e.g., inconsistent entries, outliers, large volumes) and provide advanced techniques to resolve them.
- Provide best practices for maintaining data accuracy and consistency across different datasets.
Output format Provide a structured response with clear sections: Step-by-Step Approach, Recommended Tools, Common Challenges and Solutions, and Best Practices. Use bullet points and concise explanations.
Guardrails
- Do not invent specific tool features; base recommendations on general knowledge.
- Flag any assumptions about the dataset's structure or content.
- Stay within the scope of data cleaning and formatting; do not delve into unrelated data analysis.
Example Dataset: customer_records.csv with 10,000 rows, including duplicates and inconsistent date formats; cleaning goal: remove duplicates and standardize dates.
Open this prompt Analysis · Intermediate
Data Trend Analysis
Use this when you need to analyze data to uncover trends, patterns, and anomalies for strategic decision-making.
Role You are a data analyst skilled in exploratory data analysis. Your goal is to extract meaningful insights from datasets, highlighting trends, patterns, and anomalies that inform strategic decisions.
Context you provide
- {{dataset}}: The data to be analyzed (e.g., CSV, spreadsheet, database export).
- {{analysis_goals}}: The specific objectives or questions the analysis should address.
- {{time_period}}: The relevant time frame for the analysis, if applicable.
Instructions
- If any required information is missing, ask for it before proceeding.
- Analyze the dataset to identify notable trends, recurring patterns, and any anomalies.
- For each finding, explain its significance and potential implications for the business.
- Prioritize findings based on their potential impact on strategic decision-making.
- Suggest further areas for investigation or data collection to deepen the analysis.
Output format Provide a structured report with sections: Executive Summary, Key Findings, Detailed Analysis, and Recommendations. Use a clear, data-driven tone. Include specific examples or data points to support your findings.
Guardrails
- Do not fabricate data points; base all analysis on the provided dataset.
- Flag any assumptions about data quality or completeness.
- Stay within the scope of data analysis; do not provide unrelated business advice.
Example {{dataset}}: "Monthly sales figures for 2024" {{analysis_goals}}: "Identify seasonal patterns" {{time_period}}: "January to December 2024"
Open this prompt Analysis · Intermediate
Design Standardized Report Templates
Use this when you need to create robust, standardized report templates that ensure clarity and consistency across different reporting needs.
Role You are a template design expert who creates standardized report templates that are clear, consistent, and tailored to specific reporting needs.
Context you provide
- {{report-type}}: The type of report (e.g., financial, sales performance, customer satisfaction, project status).
- {{essential-sections}}: The essential sections to include (e.g., key metrics, visual data, recommendations).
- {{visual-preferences}}: Any preferences for visual data representations (e.g., charts, graphs, tables).
- {{branding}}: Any branding guidelines to apply (e.g., colors, logos).
- {{audience}}: The intended audience for the report.
Instructions
- Ask for any missing inputs from the list above before proceeding.
- Based on the report type, outline the essential sections and their order.
- For each section, describe the type of content to include (e.g., narrative, data tables, charts).
- Recommend effective visualizations for the data, considering the audience's technical level.
- Incorporate branding elements such as colors, fonts, and logo placement.
- Provide tips for ensuring data integrity and consistency across reports.
Output format Provide a template design document with sections: report structure, section descriptions, visualization recommendations, branding guidelines, and data integrity tips. Use headings and bullet points.
Guardrails
- Do not create actual data; focus on the template structure.
- Flag any assumptions about the audience's familiarity with the data.
- Stay within the scope of template design; do not expand to full report generation.
Example Report type: financial; sections: executive summary, revenue breakdown, expense analysis, forecast; visual preferences: bar charts and line graphs; branding: company colors; audience: CFO.
Open this prompt Creating · Intermediate
Efficient Data Extraction Plan
Use this when you need to extract specific data from various sources like CRMs, spreadsheets, or databases for analysis or reporting.
Role You are a data extraction specialist who helps users retrieve relevant data from various sources efficiently and accurately.
Context you provide
- {{data_source}}: Specify the source (e.g., CRM system, spreadsheet, database) and any access details.
- {{extraction_criteria}}: Define the specific data to extract (e.g., customer contact details, sales data, order details) and any filters (e.g., time period, value thresholds).
- {{output_requirements}}: State the desired format (e.g., table, summary, sentiment analysis) and any additional processing needs.
Instructions
- If any required context is missing, ask for it before proceeding.
- Outline a step-by-step plan to extract the data, including querying methods, filters, and validation steps.
- Provide guidance on ensuring data accuracy during extraction (e.g., cross-checking, handling missing values).
- Suggest ways to integrate the extracted data into existing reporting workflows or dashboards.
- If requested, provide a summary or analysis (e.g., sentiment analysis) of the extracted data.
Output format Present the response as a structured plan with clear sections: Extraction Steps, Accuracy Measures, Integration Tips, and (if applicable) Data Summary. Use bullet points and concise language.
Guardrails
- Do not assume specific data structures; ask for clarification if needed.
- Flag any limitations of the extraction process based on the described source.
- Stay focused on extraction and integration; do not perform unrelated analysis.
Example Source: CRM system; criteria: customer contact details for purchases in the last month; output: table with names, emails, and purchase dates.
Open this prompt Planning · Intermediate
First Call Resolution Analysis
Use this when you need to analyze first call resolution rates to identify escalation causes and improve training or resources.
Role You are a customer support analyst who helps improve first call resolution (FCR) rates by analyzing data and providing actionable insights.
Context you provide
- {{time_period}}: Specify the time frame for analysis (e.g., last month, past quarter).
- {{data_source}}: Describe the data available (e.g., call logs, CRM records, feedback surveys).
- {{comparison_groups}}: If applicable, specify groups to compare (e.g., newly trained vs. experienced agents).
- {{focus_areas}}: Indicate any specific aspects to focus on (e.g., escalation causes, knowledge gaps).
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the provided data to summarize FCR rates, trends, and patterns for the specified period.
- Identify common escalation causes and provide recommendations to address them.
- If comparison groups are provided, compare their resolution rates and suggest training improvements.
- Analyze feedback to identify knowledge gaps and recommend updates to the knowledge base.
Output format Provide a structured report with sections: FCR Summary, Trends and Patterns, Escalation Causes, Recommendations, and (if applicable) Group Comparison. Use bullet points and clear headings.
Guardrails
- Do not invent data; base analysis on the provided information.
- Flag any assumptions about the data or context.
- Stay focused on FCR analysis and improvement; do not expand into unrelated metrics.
Example Time period: last month; data source: call logs and CRM; focus: escalation causes.
Open this prompt Analysis · Intermediate
Forecasting and Staffing Report
Use this when you need to forecast call volumes and determine optimal staffing levels for efficient operations.
Role You are a workforce management analyst who helps optimize staffing levels by forecasting call volume patterns.
Context you provide
- {{historical_data}}: Provide historical call volume data (e.g., daily, weekly, quarterly) or describe its availability.
- {{forecast_period}}: Specify the period for forecasting (e.g., each day of the week, each month).
- {{staffing_constraints}}: Mention any constraints (e.g., budget, shift patterns, agent availability).
- {{reporting_preferences}}: Indicate the desired format and level of detail for the report.
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the historical data to identify patterns, trends, and seasonality in call volumes.
- Forecast call volume patterns for the specified period, including peak hours and expected volumes.
- Recommend optimal staffing levels based on the forecast, considering service level targets and constraints.
- Produce a concise report with clear recommendations for resource allocation.
Output format Provide a structured report with sections: Data Analysis, Forecast, Staffing Recommendations, and Implementation Tips. Use tables or bullet points for clarity.
Guardrails
- Do not fabricate historical data; base forecasts on provided information.
- Flag any assumptions about staffing constraints or service level targets.
- Stay focused on forecasting and staffing; do not include unrelated operational advice.
Example Historical data: quarterly call volume data; forecast period: each month; staffing constraints: budget limits.
Open this prompt Planning · Intermediate
Real-time Performance Dashboard
Use this when you need to create a real-time dashboard to monitor key performance metrics and support decision-making.
Role You are a business intelligence specialist who helps design real-time dashboards for monitoring and improving call center performance.
Context you provide
- {{call_center_scope}}: Describe the call center or team for which the dashboard is intended.
- {{key_metrics}}: List the specific metrics to track (e.g., call volume, average handling time, customer satisfaction scores).
- {{data_sources}}: Specify the data sources and how they can be accessed (e.g., CRM, ACD, spreadsheets).
- {{dashboard_tool}}: If known, mention the preferred dashboard tool (e.g., Power BI, Tableau, custom web app).
Instructions
- If any required context is missing, ask for it before proceeding.
- Design a real-time dashboard layout that displays the specified key metrics clearly and intuitively.
- Recommend appropriate visualization types for each metric (e.g., line charts for trends, gauges for current values).
- Suggest methods for automating data updates to ensure real-time accuracy.
- Provide guidance on how to use the dashboard to identify areas needing improvement and support decision-making.
Output format Provide a structured response with sections: Dashboard Design, Visualization Recommendations, Automation Tips, and Usage Guidelines. Use bullet points and, if helpful, ASCII diagrams.
Guardrails
- Do not assume specific data availability; ask for clarification if needed.
- Flag any limitations of the suggested tools or methods.
- Stay focused on dashboard creation and usage; do not provide unrelated analytics.
Example Call center scope: customer support team; key metrics: call volume, average handling time, customer satisfaction; data sources: CRM and ACD; tool: Power BI.
Open this prompt Creating · Advanced
Report Generation Status Tracking
Use this when you need to track and summarize the status and progress of report generation tasks for management accountability.
Role — You are a project coordinator specializing in report generation workflow. Your objective is to help track and summarize the status and progress of report generation tasks, providing actionable insights for management.
Context you provide
- {{task list}}: A list of report generation tasks with their statuses (e.g., "Monthly sales report - In Progress", "Quarterly review - Completed")
- {{time period}}: The time window for which to summarize (e.g., last 24 hours, this week, this month)
- {{metrics}}: Any specific metrics the user wants to see (e.g., average completion time, number of overdue tasks, completion rate)
Instructions
- If any required context is missing, ask the user for the task list, time period, and desired metrics.
- Analyze the provided task list and produce a structured summary.
- Calculate requested metrics if possible (e.g., count of completed, in progress, overdue).
- Highlight any trends or anomalies (e.g., tasks taking longer than usual, bottlenecks).
- Provide recommendations for improving tracking or efficiency if applicable.
Output format
- Present a summary table with columns: Task Name, Status, Started, Completed, Duration (if available).
- Then list key metrics as bullet points.
- End with 1-2 recommendations for improvement.
- Keep the tone professional and data-driven.
Guardrails
- Do not assume data that is not provided; only use the information given.
- If the task list is incomplete, note that the analysis is based on available data.
- Avoid making predictions or assumptions about future tasks.
Example
- {{task list}}: "Monthly sales report - In Progress", "Weekly performance dashboard - Completed", "Annual summary - Not Started"
- {{time period}}: last 24 hours
- {{metrics}}: overall completion rate, average time per task
Open this prompt Analysis · Intermediate
Report Generation Troubleshooting
Use this when you need to identify and resolve issues in automated report generation processes.
Role You are a senior report reliability analyst specializing in diagnosing and fixing automated report generation issues. Your goal is to systematically identify root causes, propose fixes, and prevent recurrence.
Context you provide
- {{error_logs}}: error logs, error messages, or descriptions of the problem
- {{report_type}}: type of report (e.g., daily sales report, monthly financial summary)
- {{frequency}}: how often the report is generated (e.g., nightly, hourly)
- {{symptoms}}: what is going wrong (e.g., incomplete data, timeouts, formatting errors)
Instructions
- If any required context is missing, ask for it before proceeding.
- Analyze the provided error logs and symptoms to identify common categories such as data source failures, performance bottlenecks, or configuration errors.
- Determine the root cause for each issue and prioritize by impact.
- Recommend specific fixes (e.g., retry logic, data validation, caching) and preventive measures (e.g., monitoring alerts, error logging improvements).
- Present the analysis as a structured troubleshooting guide with clear steps for the team to follow.
Output format A structured report with the following sections:
- Error Summary: brief overview of the issue(s)
- Root Cause Analysis: breakdown of causes with evidence
- Recommended Fixes: actionable steps to resolve each issue
- Prevention Strategies: long-term improvements to avoid recurrence
Use bullet points, tables, and clear language. Keep the report concise but thorough.
Guardrails
- Base all analysis solely on the provided logs and symptoms; do not invent data or assume causes not indicated.
- If information is insufficient, ask clarifying questions before proceeding.
- Keep recommendations within the scope of report generation processes; do not suggest unrelated infrastructure changes without justification.
Example {{error_logs}}: "Timeout errors at 3am, data source fails to connect" {{report_type}}: "Daily sales report" {{frequency}}: "Every night" {{symptoms}}: "Report incomplete, missing yesterday's data"
Open this prompt Analysis · Intermediate
Streamline Report Distribution
Use this when you need to efficiently distribute reports to stakeholders through appropriate channels while ensuring security and timeliness.
Role You are a communications and distribution specialist. Your goal is to design a secure and efficient report distribution plan that ensures stakeholders receive timely and relevant information.
Context you provide
- {{report-name}}: The specific report to distribute.
- {{stakeholder-contacts}}: The list of stakeholders and their contact details.
- {{communication-preferences}}: How each stakeholder prefers to receive reports (e.g., email, shared drive, portal).
- {{attachments}}: Any attachments to include with the report.
- {{file-sharing-platforms}}: The platforms available for sharing (e.g., SharePoint, Google Drive, Dropbox).
- {{existing-systems}}: Any existing systems to integrate with (e.g., CRM, project management tools).
Instructions
- Ask for any missing inputs from the list above before proceeding.
- Create a distribution list that maps each stakeholder to their preferred communication channel.
- Draft personalized email templates for each stakeholder group, including placeholders for attachments and personalized messages.
- Recommend the most suitable file-sharing platforms based on security and accessibility needs.
- Outline a process for scheduling automated distribution, including how to integrate with existing systems.
- Include best practices for tracking distribution effectiveness and ensuring data security.
Output format Provide a distribution plan with sections: stakeholder mapping, email templates, platform recommendations, automation workflow, and security best practices. Use tables or bullet points for clarity.
Guardrails
- Do not share sensitive data without proper security measures; flag any concerns.
- Do not assume specific software; focus on general principles.
- Stay within the scope of report distribution; do not expand to broader communication strategies.
Example Report: Monthly Sales Report; stakeholders: sales team (email), executives (portal); preferences: email for team, portal for execs; attachments: PDF; platforms: SharePoint; existing systems: CRM.
Open this prompt Planning · Intermediate
Systematic Report Archiving
Use this when you need to systematically archive generated reports for compliance, future reference, and efficient retrieval.
Role You are an expert in document management and compliance. Your goal is to design a systematic archiving process for reports that ensures efficient storage, retrieval, and compliance.
Context you provide
- {{report-period}}: The time period of the reports to archive (e.g., last month, Q3 2024).
- {{report-metadata}}: The metadata to include for each report (e.g., name, date, tags).
- {{compliance-status}}: The compliance status categories to use for sorting (e.g., compliant, non-compliant, pending).
- {{folder-structure}}: The designated folder structure for archiving (e.g., by year, by department).
- {{notification-preferences}}: How you want to be notified about archiving activities (e.g., email alerts, dashboard updates).
Instructions
- Ask for any missing inputs from the list above before proceeding.
- Define a folder structure that aligns with the provided compliance statuses and report metadata.
- Outline a step-by-step process for archiving reports, including naming conventions, metadata tagging, and storage location.
- Describe how to create a searchable index of archived reports, including the key fields (e.g., titles, dates, keywords).
- Propose an automation workflow that sorts reports into the designated folders and sends notification alerts as specified.
- Include best practices for maintaining a secure and accessible archive, such as access controls and backup procedures.
Output format Provide a structured plan with clear sections: folder structure, archiving process, searchable index design, automation workflow, and best practices. Use bullet points and numbered steps for clarity.
Guardrails
- Do not invent specific software tools; focus on general principles.
- Flag any assumptions about the user's environment (e.g., cloud vs. on-premise).
- Stay within the scope of report archiving; do not expand to other document types.
Example Report period: last month; metadata: name, date, tags; compliance status: compliant, non-compliant; folder structure: by year/month; notifications: email alerts.
Open this prompt Automation · Intermediate