Dashboard Template Library

Purpose

This recipe produces a library of pre-built dashboard templates organized by startup business model (SaaS, marketplace, ecommerce, services), each with default KPIs, widget layouts, SQL calculation queries, and embedded industry benchmarks. The output enables any startup to deploy a functional metrics dashboard in 1-3 hours by selecting their business model template and connecting data sources. [src1]

Prerequisites

• Business model identified — SaaS/subscription, marketplace/platform, ecommerce/DTC, or services/agency
• PostgreSQL database with at least 3 months of transactional data — Supabase or Neon
• Dashboard tool — Retool, Metabase, or custom React framework
• Primary data source connected — Stripe (SaaS), Shopify (ecommerce), or custom payment system (marketplace)
• Revenue model parameters — pricing structure, billing frequency, commission/take rates

Constraints

• Templates are starting points. Customize KPIs within 30 days based on actual data availability and team priorities.
• KPI formulas assume standard definitions. Verify LTV, CAC, and churn calculations match your accounting methodology before presenting to investors. [src1]
• Benchmarks are industry medians from 2025-2026 data. Show top-quartile and bottom-quartile ranges alongside to avoid false confidence. [src6]
• Widget layouts designed for 1280px+ desktop. Mobile-responsive layouts require separate breakpoint configuration.
• Data source connections are template-specific. SaaS template assumes Stripe + CRM; marketplace assumes payment processor + matching engine; ecommerce assumes Shopify/WooCommerce.

Tool Selection Decision

Which template?
├── SaaS / Subscription business
│   └── TEMPLATE A: SaaS Metrics — MRR, churn, NRR, LTV/CAC, pipeline
├── Marketplace / Platform business
│   └── TEMPLATE B: Marketplace Metrics — GMV, take rate, liquidity, match rate
├── Ecommerce / DTC business
│   └── TEMPLATE C: Ecommerce Metrics — AOV, ROAS, conversion rate, inventory
└── Services / Agency business
    └── TEMPLATE D: Services Metrics — utilization, project margin, pipeline, capacity

Execution Flow

Step 1: Select and Deploy Template

Duration: 15-30 minutes · Tool: Dashboard tool

Choose the template matching your business model. Each template includes a JSON layout configuration with widget positions and sizes: SaaS template has KPI row + MRR trend + MRR waterfall + cohort retention + LTV/CAC trend + churn analysis. Marketplace template has GMV trend + supply/demand balance + transaction funnel + time-to-match + cohort retention. Ecommerce template has revenue by channel + conversion funnel + product performance + ad spend vs revenue + inventory. Services template has revenue by client + utilization + project margin + pipeline + resource capacity.

Verify: Template layout renders in dashboard tool. All widget placeholders visible. If failed: Check dashboard tool supports JSON layout format.

Step 2: Configure KPI Calculations

Duration: 30-60 minutes · Tool: SQL

Deploy the SQL queries for each KPI in the selected template. SaaS: MRR aggregation, NRR by cohort, logo churn rate. Marketplace: GMV with take rate, liquidity percentage, buyer:seller ratio. Ecommerce: AOV with conversion rate, ROAS by channel, repeat purchase rate. Services: utilization by person, project margin scatter, pipeline by stage.

Verify: All KPI queries return data for at least 3 months. No NULL values in primary metrics. If failed: Check table names — templates assume standard naming. Map to your actual schema.

Step 3: Embed Industry Benchmarks

Duration: 30 minutes · Tool: SQL or dashboard config

Load benchmark data for your business model (bottom quartile, median, top quartile). Display as colored bands on KPI charts: green (above median), yellow (median), red (below bottom quartile). Add benchmark reference lines on trend charts. Benchmarks cover all primary KPIs per model with 2025-2026 data.

Verify: Benchmark bands visible on all KPI widgets. Color coding matches threshold values. If failed: Check conditional formatting rules in dashboard tool.

Step 4: Connect Data Sources

Duration: 30-60 minutes · Tool: Dashboard tool data source config

Connect template-specific data sources: SaaS needs Stripe + CRM + accounting; marketplace needs payment processor + user/listing DB; ecommerce needs Shopify/WooCommerce + GA4 + ad platforms; services needs time tracking + CRM + invoicing.

Verify: KPI widgets populate with real data. At least 3 months of history visible. If failed: Check API connection credentials. Verify date range filters include historical data.

Step 5: Customize and Extend

Duration: 1-2 hours · Tool: Dashboard tool

Remove irrelevant KPIs, add company-specific metrics, set alert thresholds based on your targets, configure date range defaults, and create filtered views for different audiences (CEO, department heads, investors).

Verify: All active widgets show data. Custom KPIs calculate correctly. Alert thresholds fire test notifications.

Step 6: Export Template for Reuse

Duration: 15-30 minutes · Tool: Dashboard tool export or JSON

Export template configuration as JSON with parameterized queries (using table name placeholders), benchmark data, and setup instructions. Output files: template layout JSON, individual SQL query files per KPI, and benchmark data JSON.

Output Schema

{
  "output_type": "dashboard_template_library",
  "format": "JSON configuration + SQL query files",
  "templates": [
    {"model": "saas", "kpi_count": 12, "widgets": 8, "queries": 6},
    {"model": "marketplace", "kpi_count": 10, "widgets": 8, "queries": 6},
    {"model": "ecommerce", "kpi_count": 10, "widgets": 7, "queries": 5},
    {"model": "services", "kpi_count": 8, "widgets": 6, "queries": 5}
  ],
  "benchmarks_included": true,
  "customization_level": "widget-level (add, remove, reposition, restyle)"
}

Quality Benchmarks

If below minimum: Check that SQL queries use standard table/column naming. Templates with hardcoded table names break on import.

Error Handling

Cost Breakdown

Anti-Patterns

Wrong: Using a SaaS template for a marketplace business

Marketplace fundamentals (GMV, take rate, liquidity) are structurally different from SaaS metrics (MRR, churn, NRR). Forcing marketplace data into SaaS templates produces misleading KPIs. [src5]

Correct: Match template to business model, then customize

Select the template matching your primary revenue model. Hybrid businesses should start with the dominant model and add KPIs from the secondary model as custom widgets.

Wrong: Treating template benchmarks as targets

Industry median benchmarks describe average performance, not your target. A pre-seed startup comparing against Series B medians will appear to underperform. Benchmarks without stage context mislead founders and investors. [src6]

Correct: Layer stage-appropriate benchmarks with your own targets

Display three reference points on each KPI: (1) your own target, (2) stage-matched median, (3) top-quartile for your stage. Set targets based on your fundraising plan, not general industry data.

When This Matters

Use when a startup needs to deploy a metrics dashboard quickly from a working template rather than designing from scratch. Especially valuable for founders who know their business model but lack dashboard design experience, or for agencies deploying dashboards for multiple startup clients. This recipe provides the templates — for building underlying data infrastructure, use the data integration architecture recipe.