Scale · Onboarding / Ramp Systems

Design a Ramp Tracker Dashboard

Spec out a leadership dashboard that shows ramp velocity, milestone status, and at-risk reps across every cohort.

foundermanagerAdvanced⏱ 6-10 hours
When to use
Use when leadership has no real-time visibility into which reps are ramping on pace and which are silently falling behind. This produces a dashboard spec your RevOps team can build in any BI tool. Run once and iterate quarterly.
The prompt
You are a sales enablement lead designing systems to ramp many reps consistently at a digital marketing agency.
Agency: [AGENCY_NAME] — [SERVICES] | Active cohorts: [ACTIVE_COHORTS] | Reps in ramp: [REPS_IN_RAMP] | Ramp target: [RAMP_TARGET_DAYS] to [QUOTA] | Tech stack: [TECH_STACK] | BI tool: [BI_TOOL]
Design a ramp tracker dashboard specification — exact KPIs, how each is calculated, dashboard panel layout, drill-down paths, and alert thresholds — so leadership can see every rep's ramp health at a glance and intervene early on at-risk reps.

- Must show INDIVIDUAL rep status AND aggregate cohort/team status
- Each KPI has a precise formula and data source
- Color-coded alerts (green/amber/red) with numeric thresholds
- Includes both LEADING indicators (activity) and LAGGING (booked MRR)
- Drill-down from cohort → rep → specific milestone status
Three sections: (1) KPI Catalog — Metric | Formula | Data Source | Green/Amber/Red Thresholds; (2) Dashboard Layout — Panel | What It Shows | Drill-Down Path; (3) Alerting Rules — when manager/founder gets pinged.
Variables
  • [AGENCY_NAME] — Your agency name
  • [SERVICES] — Services sold
  • [ACTIVE_COHORTS] — How many cohorts are currently in ramp
  • [REPS_IN_RAMP] — Total reps currently ramping
  • [RAMP_TARGET_DAYS] — Days to full ramp
  • [QUOTA] — Quota target
  • [TECH_STACK] — Source systems
  • [BI_TOOL] — Hex, Looker, Sigma, Power BI, etc.
Example input
Agency: Northstar Media — SEO + Programmatic | Cohorts: 2 active | Reps in ramp: 7 | Ramp: 90 days to $20K MRR | Stack: HubSpot, Gong | BI: Sigma
Example output
1. KPI Catalog
Days in Ramp | TODAY - start_date | HR system | n/a
Certifications Earned | Count of cert badges | Notion API | Wk4 ≥Bronze, Wk8 ≥Silver, Wk12 Gold (R if behind)
Mock Pitch Score | Avg rubric score | Gong tags | G ≥4.0 | A 3-3.9 | R 30% → enablement review meeting triggered
Pro tips
  • Build the simplest version first in a Google Sheet — prove the metrics matter before investing in BI
  • Review the dashboard live in your weekly sales leadership meeting — it forces action
  • Sunset KPIs that never drive a decision — dashboard bloat kills usage faster than anything
Works with
ClaudeChatGPTGemini
Done with prompts? Time to install the system
Book a STAOS call
Related prompts