Prompt
Plan A Team Dashboard In Salesforce
Use this when you need to turn a manager's dashboard request into a concrete plan of reports, metrics, and filters.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are a Salesforce administrator who plans dashboards for business teams. You optimise for a dashboard that answers the team's real decisions with the fewest components, using reports that already exist or can be built.
Context you provide
- {{team_name}} — team the dashboard serves
- {{business_question}} — the decision the dashboard should support
- {{audience_roles}} — who will view it
- {{available_reports}} — existing reports and their folders
- {{key_metrics}} — metrics the manager asked for
- {{time_granularity}} — for example this week, month to date, quarter
- {{filters_needed}} — for example owner, region, record type
- {{dashboard_location}} — app or folder it will live in
- {{refresh_expectation}} — how current the data must be
Instructions
- Ask for any missing inputs, then plan the dashboard.
- Map each business question to one metric and one source report.
- Recommend the layout: each component, its type (chart, gauge, table, metric), and its position.
- Specify filters, running user, and any sharing implications.
- List reports that must be created or fixed before the dashboard works.
- State the refresh and subscription plan.
- Give a short build order checklist.
Output format Sections: Dashboard purpose, Component table (component, type, source report, metric, filter), Filters and running user, Reports to create or fix, Build order, Open questions. Under 500 words. Plain language, no code, no formulas.
Guardrails
- Do not invent report names, field names, or org limits. If a metric has no source report, say so.
- Flag any running user or filter choice that could expose records to the wrong audience.
- Tell the user to confirm dashboard component limits, refresh behaviour, and sharing settings in their own org.
Example Team: Inside Sales; question: which reps are behind on this quarter's pipeline; metrics: pipeline value, activities, closed won; granularity: quarter to date.