AgenticFor EntrepreneursGo-to-Market & Sales

Build a Sales Analytics Dashboard.

When you're ready to manage sales by data, not gut feel — build your analytics foundation early.

ChatGPT · Claude · Gemini·Intermediate·~320 tokens
Curated by the AIPP team
Last updated 14 May 2026 · v3
build-a-sales-analytics-dashboard.md · 320 words
You are a senior {{role}} brought in to help {{target_user}} complete a Build a Sales Analytics Dashboard.

# Context
Original working context:
- Act as a sales operations analyst helping an early-stage Indian startup build their first sales analytics system.
- Step 1: My startup: {{describe}}. CRM: {{hubspot_salesforce_zoho_google_sheets}}. Sales team: {{just_me_2_3_reps}}. What I currently track: {{describe_or_nothing_systematic}}.
- Step 2: Define the essential sales metrics for my stage: Which 10 metrics should every B2B founder track? Why these 10 specifically?
- Step 3: Design the sales dashboard: Layout, sections, and which metrics to show daily vs weekly vs monthly. Create the Google Sheets / CRM dashboard structure (column headers, formulas needed, visual layout).
- Step 4: Build a weekly sales review agenda: How to use the dashboard in a 30-minute weekly sales review meeting. What to look for, what questions to ask, and what decisions to make.
- Step 5: Self-check: Is this dashboard actually actionable? Flag any vanity metrics I may have included and replace with leading indicators that predict revenue.

# Goal
Produce the exact deliverable requested for this use-case. Make the output practical, specific, and ready to use.

# Constraints
- Use the user's variables exactly where relevant.
- Avoid generic filler and vague advice.
- Be specific to the stated audience, platform, market, role, industry, or situation.
- Ask only essential clarifying questions if required; otherwise make reasonable assumptions and continue.

# Output
Return the final deliverable in a clean, skimmable format with clear headings, bullets, tables, scripts, templates, or steps as appropriate.

The variables to fill in

PlaceholderWhat to put thereExample
{{describe}}Describeinsert your specific value
{{hubspot_salesforce_zoho_google_sheets}}Hubspot salesforce zoho google sheetsinsert your specific value
{{just_me_2_3_reps}}Just me 2 3 repsinsert your specific value
{{describe_or_nothing_systematic}}Describe or nothing systematicinsert your specific value
{{role}}Rolefreelance client onboarding strategist
{{target_user}}Target usera freelance consultant

How to customize this prompt

  1. Replace each {{double-curly}} with your real context.
  2. Adjust the constraints section to match your tone — formal, casual, blunt.
  3. If the engagement is recurring, change the duration line to mention milestones rather than days.
  4. Run it in your tool of choice. The output should be ready to paste with at most one small edit.

When to use

When you're ready to manage sales by data, not gut feel — build your analytics foundation early.

PRO TIP

Vanity metrics feel good. Leading indicators drive decisions. Track pipeline velocity, conversion rates by stage, and average deal cycle length — not just total pipeline value. The first tells you what you have. The others tell you what you'll actually close.

Related prompts

Structured

Business Idea Validator

Validate this business idea rigorously. Assess market size, competition, feasibility, and risk. Give an honest recommendation — do not flatter.

Structured

Competitor Analysis Generator

Conduct a structured competitor analysis. Map each competitor's strengths, weaknesses, positioning, pricing, and target customer. Identify the market gaps your business can own.

Structured

Pitch Deck Narrative Builder

Write the complete narrative for a 10-slide pitch deck. For each slide, write the title, the key message (one sentence), and the talking points (3-5 bullets).

Structured

Pricing Strategy Advisor

Recommend a pricing strategy with full rationale. Provide 3 pricing options (low/mid/premium tier) and explain what each achieves. Recommend one as optimal for the stated goal.

★ EXPLORE MORE PROMPTS

More for Entrepreneurs

Browse all prompts built for Entrepreneurs — free and premium, ready to copy.

Browse more prompts →