64 AI Prompts for Reporting & Dashboards

The best Reporting & Dashboards prompts in the Data Analysis library. Tested on ChatGPT, Claude, Gemini and every major model.

Browse the prompts

## Role
You are an expert sales analyst specializing in funnel performance and conversion optimization.

## Task
Analyze key sales funnel metrics and deliver a structured performance report with industry benchmarks and actionable improvement recommendations.

## Context
Business context: {{business-context}}

Current performance baseline: {{current-metrics}}

## Process
1. Identify the most relevant sales funnel metrics for this business type (conversion rates at each stage, drop-off points, customer acquisition cost, lead velocity, sales cycle length)
2. Provide industry-specific benchmarks for each identified metric
3. Compare current performance against benchmarks to highlight gaps
4. Develop prioritized, actionable improvement plans based on proven optimization strategies

## Output
Deliver your analysis as a markdown table with these columns:
- **Metric**: The KPI name
- **Definitio

Sales Funnel Metrics Tracker and Benchmark Report

Generates a structured performance report comparing your sales funnel KPIs against industry benchmarks, with prioritized improvement plans. Runs on ChatGPT, Claude, and Gemini.

50
## Role
You are a data visualization architect specializing in the CIPD HR Metrics and Analytics Framework. You design dashboards that follow the 3-second rule: critical insights must be immediately apparent without interpretation effort.

## Task
Transform the provided performance data into a multi-layered dashboard system that reveals hidden patterns, triggers immediate action, and guides decision-makers from executive summary to granular detail. Every metric must link directly to a business decision.

## Context
{{organizational-context}}

{{performance-data}}

## Dashboard Design Principles
- Limit each view to 5-7 key metrics to prevent cognitive overload
- Use color strategically: red (critical issues), amber (warnings), green (targets met)
- Focus on leading indicators that predict future performance, not just lagging measures
- Include contextual benchmarks: internal historical a

Performance Dashboard Design Prompt for CIPD Framework

Generates multi-layered dashboard specifications that transform performance data into actionable visualizations following CIPD HR Metrics principles and the 3-second rule. Runs on ChatGPT, Claude, Gemini, and Grok to produce executive, departmental, and trend analysis views with action triggers.

48

Social Media Analytics Report Generator

Generates comprehensive social media analytics reports that measure campaign effectiveness across multiple platforms. Runs on ChatGPT, Claude, Gemini, and Grok to deliver structured performance insights with executive summaries, platform-specific tables, audience analysis, and actionable recommendations.

48

Sales Report Generator for Revenue and Profit Analysis

Generates detailed sales reports with markdown tables tracking revenue, profit margins, customer acquisition costs, and sales growth over custom timeframes. Runs on ChatGPT, Claude, and Gemini.

47

Engagement Program ROI Calculator

Calculates financial returns and cultural value of employee engagement programs using Jack Phillips' five-level ROI framework, producing executive summaries with cost analysis, benefit quantification, and confidence intervals. Runs on ChatGPT, Claude, Gemini, and Grok.

45
## Role
You are an expert social media analyst evaluating the return on investment (ROI) of social media efforts in driving sales.

## Task
Analyze social media metrics and present a comprehensive ROI assessment. Identify key metrics relevant to the business context, define each metric clearly, and explain how it impacts sales. Provide actionable insights for optimizing social media strategies to boost sales performance.

## Context
Business context: {{business-context}}

Consider platform-specific metrics (engagement rate, reach, impressions, click-through rate, conversion rate, customer acquisition cost, lifetime value, share of voice), content performance indicators, audience behavior patterns, and the sales funnel stages from awareness to conversion.

## Output
Deliver your analysis as a markdown table with three columns:

| Metric | Definition | Impact on Sales |
|--------|---------

Social Media ROI Metrics Analysis Prompt

Generates a structured ROI assessment of social media performance with key metrics, definitions, and sales impact analysis. Runs on ChatGPT, Claude, Gemini, and Grok to deliver a markdown table plus prioritized optimization recommendations.

44
## Role
You are an expert sales analyst evaluating pipeline performance and identifying improvement opportunities.

## Task
Analyze key sales metrics and deliver a structured health check of the sales process. Focus on conversion rates, lead velocity, and average deal size. Set realistic targets for each metric and provide actionable recommendations to optimize the pipeline and drive revenue growth.

## Context
{{sales-context}}

*Describe your sales process, industry, and current performance (include conversion rates, deal flow, revenue trends, team size, sales cycle length, and any challenges you're facing).*

## Output
Deliver your analysis as:

1. **Metrics table** with three columns:
   - Metric
   - Current Performance
   - Target

2. **Recommendations** as a bullet-point list of specific, actionable improvements prioritized by impact.

Sales Pipeline Metrics Health Check Prompt

Analyzes conversion rates, lead velocity, and deal size to diagnose sales pipeline performance and recommend targeted improvements. Runs on ChatGPT, Claude, Gemini, and Grok.

40

Inventory Report Generator for Stock Analysis

Generates detailed inventory reports showing stock levels, product movement, and key metrics in markdown tables with actionable insights. Runs on ChatGPT, Claude, Gemini, and Grok.

39

Employee Happiness Index Report Generator

Generates a structured organizational wellness report that translates employee sentiment data into business intelligence through the OECD Better Life Index framework. Runs on ChatGPT, Claude, Gemini, and Grok.

39
## Role
You are a workforce analytics specialist who transforms exit interview data into strategic intelligence, combining rigorous data analysis with visual storytelling to expose turnover patterns that standard HR metrics miss.

## Task
Create a comprehensive Exit Trend Report that reveals root causes of employee turnover and translates complex workforce data into executive-ready insights. Connect exit patterns to business impact and provide data-backed retention recommendations.

## Context
{{organizational-context}}

{{exit-data-sources}}

## Output
Structure the Exit Trend Report with these components:

**EXECUTIVE DASHBOARD**
- One-page visual summary with traffic light indicators for key metrics
- Top 3 turnover drivers with quantified business impact
- Trend arrows showing 3-month, 6-month, and 12-month directional movement

**DETAILED ANALYSIS SECTIONS**

1. **Turnover Overview*

Exit Trend Report Generator for Workforce Analytics

Generates executive-ready exit trend reports that transform employee turnover data into strategic intelligence with root cause analysis, predictive indicators, and retention recommendations. Runs on ChatGPT, Claude, Gemini, and Grok.

38
## Role
You are an expert data visualization specialist designing real-time sales dashboards.

## Task
Create an effective dashboard that tracks key performance indicators for a sales operations team. Design a structured table layout that clearly presents each KPI with its current value, target value, and variance.

## Context
Sales operations team: {{team-context}}

Key performance indicators to track: {{kpis}}

## Output
Deliver a complete dashboard design that includes:

1. **KPI Table Structure** - A markdown table with columns for: KPI name, current value, target value, variance (absolute and percentage), and status indicator

2. **Visual Design Recommendations**
   - Color coding scheme for performance levels (red/yellow/green thresholds)
   - Icon or emoji indicators for at-a-glance status assessment
   - Formatting conventions for positive/negative variances

3. **Technical Speci

Real-Time Sales Dashboard Builder Prompt

Generates a complete real-time sales dashboard design with KPI tracking tables, visual design recommendations, and technical specifications. Runs on ChatGPT, Claude, and Gemini to produce structured markdown dashboards with color coding, variance analysis, and refresh-rate guidelines.

38

Team Productivity Trends Analysis Report Prompt

Generates a comprehensive productivity analysis report with data-driven insights, trend visualizations, and SMART recommendations for improving team efficiency. Runs on ChatGPT, Claude, and Gemini.

37

Influencer Campaign Analytics Report Generator

Generates comprehensive performance reports for influencer marketing campaigns, analyzing true ROI, audience quality, and engagement patterns beyond vanity metrics. Runs on ChatGPT, Claude, Gemini, and Grok.

35

CRM Dashboard Framework Design Prompt

Designs a tiered CRM dashboard framework with strategic KPI selection, visualization recommendations, and implementation guidance. Runs on ChatGPT, Claude, Gemini, and Grok to turn customer data into revenue-focused analytics.

35
## Role
You are an expert financial analyst preparing comprehensive budget reports that track expenses, revenue, and financial performance.

## Task
Produce a detailed budget variance report that:

1. Organizes financial data into the specified budget categories
2. Calculates actual amounts and variances against budget
3. Identifies trends, discrepancies, and areas requiring attention
4. Delivers actionable insights and recommendations

## Context
Department: {{department}}
Reporting period: {{reporting-period}}
Fiscal year: {{fiscal-year}}
Budget categories and financial goals: {{budget-context}}

## Output
Deliver your analysis as:

**Budget Variance Table** (markdown format) with columns:
- Budget Category
- Budgeted Amount
- Actual Amount
- Variance ($ and %)

**Key Insights & Recommendations** as a bullet-point list covering:
- Significant variances and their likely causes
- Trends 

Budget Variance Report Generator for Departments

Generates detailed budget variance reports that compare budgeted versus actual amounts, calculate variances, and deliver actionable insights. Runs on ChatGPT, Claude, Gemini, and Grok.

34
## Role
You are a social media monitoring expert and data visualization specialist.

## Task
Design a comprehensive social media brand monitoring system for {{brand-name}}.

Deliver three components:

1. **Monitoring Methodology** – A multi-platform tracking strategy covering data collection methods, relevant metrics, and monitoring approach for at least five key platforms (e.g., Twitter/X, Instagram, LinkedIn, Reddit, YouTube, TikTok, news sites, forums, review sites). Prioritize platforms with the highest potential for meaningful brand mentions and engagement.

2. **Dashboard Design** – Describe an interactive, real-time dashboard layout. Include:
   - Placement of key elements, charts, and widgets
   - At least five core visualizations (specify data displayed and chart type for each: sentiment trend line chart, mention volume bar chart, top influencers table, geographic heat map, enga

Social Media Brand Monitoring Dashboard Builder

Generates a complete social media monitoring system with multi-platform tracking methodology, interactive real-time dashboard designs, and data-driven insights for brand mentions and engagement. Runs on ChatGPT, Claude, and Gemini.

34

Partnership Performance Metrics Analysis Prompt

Generates a structured sales metrics analysis for any business partnership, complete with performance data and actionable insights. Runs on ChatGPT, Claude, Gemini, and Grok.

33

Sales Performance Metrics and KPI Framework

Generates a structured table of clear, measurable sales metrics and KPIs tailored to your team's goals and context. Outputs a markdown framework for ChatGPT, Claude, or Gemini that balances revenue, pipeline, activity, and customer quality indicators.

32
## Role
You are an expert marketing analyst creating a comprehensive marketing analytics report.

## Task
Track key performance indicators and optimize marketing strategies through structured, data-driven analysis.

## Context
{{business-and-channels}}

{{reporting-period}}

## Process
1. Identify the most relevant KPIs for the business type
2. Analyze data from all specified marketing channels
3. Structure findings in a table with columns for: {{metric-categories}}
4. Populate the table with accurate, current data
5. Analyze each metric, highlighting trends and improvement areas
6. Develop actionable optimization recommendations

## Output
Deliver a markdown table with {{metric-categories}} as column headers, followed by:
- **Analysis**: Key trends, patterns, and notable performance insights for each metric
- **Recommendations**: Specific, actionable strategies to optimize marketing per

Marketing Analytics Report Generator

Generates structured marketing analytics reports with KPI tracking, trend analysis, and optimization recommendations for ChatGPT, Claude, and Gemini. Outputs markdown tables showing performance metrics across specified channels and time periods.

32
## Role

You are a compliance transformation architect specializing in HR analytics. You design predictive dashboards that surface compliance risks before they become violations, combining regulatory frameworks with data-driven early warning systems.

## Task

Design a three-layer HR compliance dashboard that transforms fragmented data into actionable intelligence:

**Executive Overview** – Enterprise-wide compliance health scores, trend indicators, and risk velocity metrics

**Risk Analysis** – Predictive risk scores by department with early warning signals and correlation patterns (e.g., training completion gaps vs. future policy violations)

**Operational Details** – Drill-down views into specific compliance areas with root-cause analysis

Translate complex compliance data into visual stories that non-technical managers can immediately act upon. Focus on leading indicators (what will 

HR Compliance Dashboard Design Prompt

Generates a three-layer HR compliance dashboard design that surfaces predictive risk scores, health metrics, and actionable intelligence from fragmented data. Runs on ChatGPT, Claude, Gemini, and Grok.

31

Employee Exit Dashboard Design Prompt for HR Analytics

Generates a complete implementation plan for interactive employee exit dashboards that surface turnover patterns, predict retention risks, and connect metrics to business impact. Runs on ChatGPT, Claude, Gemini, and Grok.

31

CRM Dashboard Customization Prompt for Data Insights

Generates a complete dashboard customization plan that configures CRM widgets, visualizations, layout, and interactivity to surface actionable business intelligence. Runs on ChatGPT, Claude, and Gemini.

30

Sales KPI Tracking Table Generator

Builds a structured markdown table that tracks key sales performance indicators, including descriptions, targets, and performance columns. Runs on ChatGPT, Claude, and Gemini.

30
## Role
You are an expert data analyst specializing in educational analytics.

## Task
Develop a comprehensive real-time analytics framework for an educational institution. The framework should cover data collection, analysis, and visualization to deliver actionable insights that improve student performance, engagement, and learning outcomes.

## Context
Institution: {{institution-type}}
Current infrastructure: {{current-data-infrastructure}}
Primary focus: {{focus-areas}}
Target stakeholders: {{target-audience}}

Design strategies that align with the institution's existing capabilities while addressing their specific educational priorities and stakeholder needs.

## Output
Deliver your framework as a markdown table with three columns:

| DATA SOURCES | KEY METRICS | VISUALIZATION TECHNIQUES |
|--------------|-------------|-------------------------|

Each row should represent one cohesiv

Real-Time Educational Analytics Framework Builder

Builds a structured real-time analytics framework for educational institutions, mapping data sources, key metrics, and visualization techniques into actionable strategies. Runs on ChatGPT, Claude, and Gemini.

30

What are AI prompts for Reporting & Dashboards?

AI prompts for Reporting & Dashboards are engineered instructions that already work. These are not one-line questions. Each one fixes the role, the context, the task and the output format before you type a word, so you get a usable result on the first run instead of the fourth.

They cover the work Reporting & Dashboards actually get asked for: research and briefs, copy and content, analysis and reporting, planning, outreach and the admin that eats the day. Open a card to see the full prompt and the output it returns.

Popular on this page right now: "Sales Funnel Metrics Tracker and Benchmark Report", "Performance Dashboard Design Prompt for CIPD Framework", "Social Media Analytics Report Generator".

64 on this page, every one scoped to Reporting & Dashboards. Free to read, free to copy.

Why these prompts work for Reporting & Dashboards

A weak prompt costs you the hour you were trying to save: you rewrite it three times, get something generic, then finish the job by hand. An engineered prompt front-loads that thinking once.

In Reporting & Dashboards that means first drafts you can send, analysis you can act on, and the repetitive work handed off, so the time goes into judgement instead of typing.

Every prompt here was written for a real job and tested against the models people actually use. Nothing scraped from a thread.

How to use these prompts

Open a prompt, copy it, and replace the [bracketed] variables with your own product, audience or topic. The structure around them stays as is. That structure is the part doing the work.

Paste it into ChatGPT, Claude, Gemini, Grok or the model you already use. If the output drifts, tighten the context line instead of rewriting the whole prompt.

No account needed to copy one. No setup, no extension, nothing to install.

Which AI tool works best for Reporting & Dashboards prompts?

Text prompts here run well in ChatGPT, Claude, Gemini and Grok; image prompts target Midjourney and Nano Banana. Each card lists the models it was tested with.

Are these AI prompts free to use?

A big part of the library is free: open a prompt, copy it, use it. Premium packs and the Complete AI Bundle unlock the full collection with lifetime updates.

How do I adapt these prompts to my use case?

Start with the [variables]: niche, audience, constraints. If the result still misses, add one example of the output you want. A single good example beats three extra instructions.

For a prompt built from scratch, the Start Now card above opens the custom prompt generator.

Related resources

Get smarter on AI every week

One email a week with the best new prompts, tools, and model updates. Unsubscribe anytime.

Join 100,000+ subscribers. One email a week, real prompts, tools, and model updates. Unsubscribe anytime.