Verified skill
Real-time security audit skill scanning for OWASP Top 10 vulnerabilities and infrastructure misconfigurations.
Premium skill
Salesforce Custom Report and Dashboard Generator
This skill automatically discovers available Salesforce objects, fields, relationships, and existing reports or dashboards within a specified organization. It interprets natural language requests to understand the desired data, filters, groupings, and visualization types. The skill produces new Salesforce reports and dashboards, configured with the correct report types, fields, filters, and charts. It also optimizes existing reports for performance and accuracy, suggesting improvements to filters, joins, and summary formulas. It verifies generated reports by running them, checking returned data against expected outcomes, and validating filter logic. For performance optimization, it analyzes query execution times and suggests indexing or filter adjustments.
What It Does
This skill automatically discovers available Salesforce objects, fields, relationships, and existing reports or dashboards within a specified organization. It interprets natural language requests to understand the desired data, filters, groupings, and visualization types. The skill produces new Salesforce reports and dashboards, configured with the correct report types, fields, filters, and charts. It also optimizes existing reports for performance and accuracy, suggesting improvements to filters, joins, and summary formulas. It verifies generated reports by running them, checking returned data against expected outcomes, and validating filter logic. For performance optimization, it analyzes query execution times and suggests indexing or filter adjustments.
The Problem It Removes
Business users and analysts frequently need custom reports and dashboards in Salesforce to gain insights, but creating them requires specific Salesforce knowledge and can be time-consuming. This often leads to a backlog of requests for administrators or developers, or users creating inefficient, inaccurate reports.
The real cost includes delayed decision-making due to lack of timely data, wasted time in manual report creation, performance degradation from poorly constructed reports, and potential misinterpretations from inaccurate data.
This skill removes the recurring bottleneck of manual report and dashboard creation and optimization. It empowers users to get the data they need quickly and accurately, freeing up administrators and developers for more complex tasks, and ensuring that business decisions are based on reliable, performant data.
Who It Is For
Salesforce Administrators, Business Analysts, Sales Managers, Marketing Managers, and Data Analysts in any organization using Salesforce for reporting.
Especially valuable when:
- Organizations with a high demand for ad-hoc reporting and data insights.
- Teams struggling with report performance or data accuracy issues.
- Environments where business users need self-service reporting capabilities.
- Companies aiming to reduce the workload on Salesforce administrators.
- Enterprises with complex Salesforce data models.
- Organizations needing to standardize reporting practices.
- Teams looking to improve data-driven decision-making.
Why This Price
Business users and analysts frequently need custom reports and dashboards in Salesforce to gain insights, but creating them requires specific Salesforce knowledge and can be time-consuming. This often leads to a backlog of requests for administrators or developers, or users creating inefficient, inaccurate reports.
The real cost includes delayed decision-making due to lack of timely data, wasted time in manual report creation, performance degradation from poorly constructed reports, and potential misinterpretations from inaccurate data.
This skill removes the recurring bottleneck of manual report and dashboard creation and optimization. It empowers users to get the data they need quickly and accurately, freeing up administrators and developers for more complex tasks, and ensuring that business decisions are based on reliable, performant data.
The value compounds over time as it continuously provides accurate, optimized reports on demand, preventing costly errors and enabling faster, data-driven decisions. The price reflects the significant time savings for multiple users, the prevention of critical business errors, and the expertise embedded in automatically navigating complex Salesforce metadata and best practices.
One payment, yours permanently. Download it again at any time and get later versions free.
How It Differs From Similar Skills
salesforce-automation automates tasks, but not the intelligent generation and optimization of complex reports and dashboards based on semantic understanding of a request. This skill performs a data-centric operational job.
data-storytelling focuses on narrative from data, but this skill focuses on the *creation* and *optimization* of the underlying data visualization assets within Salesforce itself.
kpi-dashboard-design helps design dashboards, but this skill *builds* and *optimizes* them directly in Salesforce, integrating with the platform's specific capabilities and data model.
When To Use
- A sales manager needs to see open opportunities by stage for the current quarter, immediately.
- A marketing analyst requires a dashboard showing lead conversion rates by source for the last month.
- A Salesforce admin receives a request for a complex report that would take hours to build manually.
- An existing report is running slowly, and a user needs it optimized for better performance.
- A new business requirement emerges, necessitating a new report that reflects recent data model changes.
Inputs
Salesforce Org Credentials: Authentication details for connecting to the Salesforce organization.
Natural Language Request: A description of the desired report or dashboard, including data, filters, groupings, and visualization.
Outputs
Generated Report/Dashboard Details: Details of the created Salesforce report and/or dashboard, including its ID, URL, and a summary of its configuration.
Performance Optimization Recommendations: Suggestions for improving report performance, such as indexing fields or refining filter logic.
Validation Results: A summary of the checks performed on the report's data and logic, indicating any discrepancies.
How It Works From Start To Finish
- Connect to Salesforce org.
- Discover available Salesforce objects, fields, and relationships.
- Analyze natural language request for desired data and insights.
- Identify optimal report type and necessary fields.
- Construct report filters, groupings, and summary formulas.
- Generate appropriate chart types for dashboards.
- Create the report and/or dashboard in Salesforce.
- Execute the generated report to fetch data.
- Validate report data against request intent and data integrity.
- Analyze report performance and suggest optimizations (e.g., indexing).
- Apply performance enhancements if approved.
- Share report/dashboard with specified users or folders.
What you supply
- Salesforce Org credentials.
- Natural language request describing the desired report or dashboard (e.g., "Show me all open opportunities for Q3 by sales rep, grouped by stage").
What it finds out on its own
- All standard and custom objects, fields, and their relationships.
- Existing report types, reports, and dashboards.
- User roles and profiles for sharing permissions.
- Salesforce data volumes and field usage for performance insights.
Step By Step
-
Connect to Salesforce Org
Use Salesforce API to establish a connection with the provided credentials.
Done when: A successful API session is established and authenticated.
If it cannot finish: Report connection failure, detailing the error (e.g., invalid credentials, network issue).
-
Discover Salesforce Metadata
Query Salesforce Metadata API to retrieve all standard and custom objects, fields, relationships, existing report types, reports, and dashboards.
Done when: All relevant metadata for the specified org is successfully retrieved and cached.
If it cannot finish: Report metadata discovery failure, indicating which metadata could not be retrieved.
-
Analyze Natural Language Request
Parse the user's natural language request to identify desired objects, fields, filters, groupings, summary formulas, and visualization types.
Done when: The request is fully parsed into structured components, and any ambiguities are identified.
If it cannot finish: If ambiguity is detected (e.g., multiple fields with similar names or unclear timeframes), prompt the user for clarification before proceeding.
-
Identify Optimal Report Type
Based on the requested objects and their relationships, select the most appropriate existing Salesforce report type. If no direct match, suggest the closest available or indicate a custom report type is needed.
Done when: A suitable report type is identified that encompasses all necessary objects and allows for the required joins.
If it cannot finish: If no suitable report type is found, report the missing component and suggest alternatives or ask for correction, or recommend creating a custom report type.
-
Construct Report Logic
Configure report filters, groupings, summary formulas, and selected fields based on the parsed request and identified report type.
Done when: All report components (fields, filters, groupings, summaries) are defined according to the request and Salesforce syntax.
If it cannot finish: If a requested field or object does not exist within the chosen report type, report the missing component and suggest alternatives or ask for correction.
-
Generate Dashboard Components
Design and configure appropriate chart types and dashboard layouts to visualize the report data, linking them to the generated report.
Done when: Dashboard components are defined and linked to the report.
If it cannot finish: If chart generation fails due to incompatible data types or missing data, report the issue and suggest alternative visualization types.
-
Create Report and Dashboard in Salesforce
Use Salesforce API to create the new report and/or dashboard with the defined logic and components, applying specified sharing settings.
Done when: The report and/or dashboard is successfully created in the target Salesforce org.
If it cannot finish: If creation fails due to Salesforce API limits or permission issues, report the error and suggest breaking the request or checking permissions.
-
Execute and Validate Report Data
Run the newly created report, retrieve its data, and perform verification checks against the user's intent and data integrity rules.
Done when: The report has executed, data is retrieved, and all verification checks have passed.
If it cannot finish: If data validation fails, highlight the discrepancies and the expected values, allowing the user to investigate the data source or report logic.
-
Analyze Performance and Optimize
Analyze the report's SOQL query execution time and identify potential performance bottlenecks. Suggest specific optimizations like indexing or filter adjustments.
Done when: Performance analysis is complete, and optimization recommendations are generated.
If it cannot finish: If performance analysis tools are unavailable or return errors, report the issue and proceed without optimization suggestions.
How It Checks Its Own Work
Checks before it delivers
- Run the generated report and verify that the number of records and key aggregates align with expectations based on the request.
- Validate that all specified filters and groupings are correctly applied.
- Check for common reporting errors, such as incorrect report types or missing fields.
- Measure report execution time and compare against performance benchmarks.
- Confirm that the dashboard components correctly visualize the report data.
If something goes wrong
- If the natural language request is ambiguous: Request clarification from the user, listing specific ambiguities (e.g., "Which 'amount' field do you mean?").
- If a requested field or object does not exist: Report the missing component and suggest alternatives or ask for correction.
- If report generation fails due to Salesforce API limits: Report the limit exceeded and suggest breaking the request into smaller parts.
- If a report performs poorly: Provide a detailed analysis of the performance bottleneck and suggest specific optimizations, but do not apply them without explicit approval.
- If data validation fails: Highlight the discrepancies and the expected values, allowing the user to investigate the data source or report logic.
Mistakes It Prevents
| The mistake | What it costs | How the skill prevents it |
|---|---|---|
| Selecting an incorrect report type that does not contain all necessary objects or fields. | The generated report will be incomplete, missing critical data, or unable to join required objects, leading to inaccurate insights. | Verify the selected report type against the natural language request and the relationships between requested objects, ensuring all required fields are available. |
| Implementing flawed filter logic that either excludes too much data or includes irrelevant records. | Reports will show inaccurate data, leading to incorrect business decisions or wasted time in manual data reconciliation. | Execute the report with sample data and compare the record count and key aggregates against the user's explicit filter criteria and known data patterns. |
| Choosing suboptimal fields for display or constructing incorrect summary formulas. | Reports will be difficult to interpret, lack key metrics, or contain redundant information, reducing their overall utility and trustworthiness. | Cross-reference requested metrics and groupings with available fields and standard Salesforce summary capabilities, ensuring calculated values align with business intent. |
| Generating reports with inefficient SOQL queries that lead to poor performance. | Slow-loading reports will frustrate users, impact productivity, and potentially hit Salesforce API limits, making the data inaccessible when needed. | Analyze the report's SOQL query plan and execution time, identifying unindexed fields or complex joins that could be optimized, and suggest improvements. |
| Assigning incorrect sharing settings or placing reports in inaccessible folders. | Authorized users will be unable to access necessary reports, or sensitive data may be exposed to unauthorized individuals, creating security and compliance risks. | Validate the report's sharing settings and folder placement against the user's specified audience and Salesforce's sharing model, confirming appropriate access levels. |
| Misinterpreting ambiguous natural language requests without seeking clarification. | Generating a report that does not match the user's true intent, leading to rework, frustration, and a perception of inaccuracy. | If ambiguity is detected (e.g., multiple fields with similar names or unclear timeframes), prompt the user for clarification before proceeding with report generation. |
Edge Cases It Handles
- The natural language request is ambiguous, e.g., 'amount' field could refer to 'Amount' or 'ExpectedRevenue'.
- Prompt the user for clarification, listing specific ambiguous terms and available options before proceeding.
- A requested object or field does not exist in the Salesforce org or is inaccessible to the authenticated user.
- Report the missing component, suggest alternatives if similar fields exist, and ask the user for correction or confirmation.
- The selected report type does not support all the necessary object relationships for the requested data.
- Identify the missing relationships, explain why the current report type is insufficient, and suggest either a different existing report type or the need for a custom report type.
- The generated report query is inefficient, leading to long execution times or Salesforce governor limits.
- Analyze the query plan, identify bottlenecks (e.g., unindexed fields, complex joins), and provide specific, actionable optimization recommendations to the user for approval.
- The user requests a dashboard, but the underlying report data is not suitable for the requested chart type.
- Explain the incompatibility (e.g., trying to sum text fields) and suggest alternative chart types that are appropriate for the data.
- The specified sharing settings for the report or dashboard conflict with Salesforce's sharing model or user permissions.
- Report the permission conflict, explain the Salesforce sharing rules, and suggest adjusted sharing settings or request the user to update permissions.
- An existing report is requested for optimization, but it is locked or owned by another user without edit permissions.
- Report that the report cannot be modified due to permissions and advise the user to contact the owner or a Salesforce administrator.
- The Salesforce API returns an error during report creation or execution due to a temporary service issue.
- Implement a retry mechanism with exponential backoff. If persistent, report the API error and advise the user to try again later.
A Worked Example
A sales manager needs a quick overview of their team's performance for the current quarter, specifically focusing on open opportunities and their potential revenue.
Input
Generate a report showing all open opportunities for my sales team in Q3 2024, grouped by Sales Stage, with the total 'Amount' for each stage. Also, create a dashboard component visualizing this data as a bar chart.Expected output
A new Salesforce report named 'Q3 2024 Open Opportunities by Stage' is created in the 'Sales Reports' folder. It uses the 'Opportunities' report type, filters for 'Stage' not equal to 'Closed Won' or 'Closed Lost', 'Close Date' within Q3 2024, and 'Owner' in the sales manager's team. The report is grouped by 'Stage' and includes a summary field for 'Sum of Amount'. A dashboard component, 'Q3 Open Opps by Stage Chart', is created, displaying a bar chart of 'Sum of Amount' by 'Stage', linked to the new report. Both are accessible to the sales manager and their direct reports. Performance analysis indicates the report runs in 3 seconds, well within benchmarks.Why this output: The skill correctly interpreted 'open opportunities' as 'Stage' not 'Closed Won' or 'Closed Lost', 'Q3 2024' for the 'Close Date' filter, and 'my sales team' for 'Owner' based on the manager's profile. It selected the 'Opportunities' report type, grouped by 'Stage', and summarized 'Amount'. A suitable bar chart was chosen for the dashboard, and appropriate sharing settings were applied. The report was executed and validated for data accuracy and performance.
Keeping It Current And Knowing Its Limits
Keeping it current
The skill can be configured to periodically review existing reports and dashboards for performance degradation or relevance changes due to data model updates, suggesting optimizations or archival. It can also re-generate reports if underlying data sources change significantly.
What it will not do
- It will not invent data or make assumptions about business logic not explicitly stated or discoverable in Salesforce metadata.
- It cannot create custom report types; it uses existing ones or suggests their creation.
- It requires appropriate Salesforce API access and permissions to create/modify reports and dashboards.
- It will not interpret complex business rules that are not directly reflected in Salesforce data or metadata.
Limitations
Installation
Copy SKILL.md to your skills directoryBefore You Run It
Security notes
- This skill requires full Salesforce Org credentials, including username, password, and security token. Ensure these are handled securely and provided only through trusted channels.
- The skill operates with the permissions granted to the provided Salesforce user. Misconfigured permissions could lead to unintended data exposure or modification.
- Performance optimizations are suggested and require explicit user approval before being applied, preventing unauthorized changes to existing reports.
- The skill will not expose sensitive data to unauthorized users by ignoring Salesforce sharing rules, but relies on the existing Salesforce sharing model.
Questions People Ask
What Salesforce permissions are required for this skill to function?
The skill needs API access permissions to read metadata, create and modify reports and dashboards, and execute reports within your Salesforce organization. It operates under the security context of the provided user credentials.
Can this skill modify my existing Salesforce reports or dashboards?
The skill can suggest optimizations for existing reports, but it will not modify them without your explicit confirmation. New reports and dashboards are created as requested, and you retain full control over them.
What if my natural language request is unclear or ambiguous?
If the skill detects ambiguity in your request, such as multiple fields with similar names, it will prompt you for clarification. It will not proceed with report generation until the intent is clear, ensuring accuracy.
Does this skill create custom report types in Salesforce?
No, this skill utilizes existing Salesforce report types. If your request requires a custom report type that doesn't exist, the skill will inform you and suggest that it be created as a prerequisite.
How does the skill ensure the generated reports are accurate?
After generating a report, the skill executes it and performs verification checks against your original request and data integrity rules. It validates filters, groupings, and key aggregates, highlighting any discrepancies for your review.
What people say, and where to get help
No ratings yet. If you have used this skill, yours would be the first.
Sign in to leave a rating
An account keeps your review with your name on it, and lets you edit it later. Sign in or create one free.
No reviews yet
This skill has not been rated. If you have run it, a short note about what you used it for helps the next person more than any description can.
Related Skills You May Like
Discover more AI agent skills in the same category to enhance your workflow automation.
Diagnose OpenClaw Android, iOS, or macOS node pairing, QR/setup code, route, auth, and connection failures.
Leverages AI-assisted debugging and multi-agent orchestration to systematically diagnose, resolve, and prevent production issues, reducing Mean Time To Recovery (MTTR).
A fully functional, temporary preview environment is deployed from a feature branch, verified for correctness, and ready for review.
Automatically detects and safely remediates configuration drift in Salesforce orgs, ensuring alignment with desired state and preventing deployment failures.
Interact directly with MCP servers using the mcporter CLI for listing, configuring, authenticating, and calling tools via HTTP or stdio.
Have a Skill to Share?
Join the community and help AI agents learn new capabilities. Submit your skill and reach thousands of developers.