Skip to content

Dashboard templates

Technology · Data & analytics

A SaaS software company whose data team loads subscriptions, product usage events, CRM, invoices and support tickets into the warehouse. A key KPI board (MRR, net new MRR, ARPA, paying accounts, churn rate, trial conversion, active users, product engagement) plus pipeline reliability, data quality, analysis requests and dashboard usage.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For data teams at SaaS companies loading subscriptions, product usage events, CRM, invoices and support tickets. The "KPI board" dashboard shows average MRR, net new MRR, ARPA, paying customers, churn rate, trial conversion, daily active users and events per active user. The "Data reliability" and "Requests and usage" dashboards measure pipelines, quality tests, freshness and request delivery time. Needs account, subscription, MRR movement, MRR snapshot and pipeline run log data.

Use this template to

  • Report MRR to investors with proof that the product event pipeline runs reliably.
  • Catch duplicate subscription records before calculating churn rate.
  • Measure product engagement by month so the product team can set targets.

3 ready-made dashboards

KPI board

Key SaaS metrics of the software company next to the reliability of the data behind them.

  • Average MRR
  • Net new MRR
  • Average revenue per account (ARPA)
  • Average paying accounts
  • Logo churn rate
  • Trial conversion rate
  • Daily active users (average)
  • Events per active user
  • Run success rate
  • Check pass rate

Data reliability

Are pipelines running reliably, is data as fresh as promised, and how many quality checks pass.

  • Run success rate
  • Freshness breaches
  • Check pass rate
  • Average run duration (minutes)
  • By data table
  • Weekly failed runs by domain
  • Failed checks by type

Requests and usage

How many analysis requests departments send, how fast the data team delivers, and how often dashboards are viewed.

  • Analysis requests
  • Average request lead time (days)
  • Dashboard views
  • Departments viewing dashboards
  • By department
  • Views by dashboard
  • Weekly new analysis requests

Ask Si as soon as the build finishes

  • “How did events per active user change compared with last month?”
  • “What is driving product usage events this quarter?”
  • “Show departments viewing dashboards by month for the last six months.”
  • “Where is average request lead time (days) highest this month, and why?”

29 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Events per active userProduct usage events divided by total daily active user count in the period; shows how many actions each user performs per day of product use.= Product usage events / tech_active_user_daysNumber
Product usage eventsTotal events (actions) customers performed in the product in the period, from the daily usage table the data team loads into the warehouse.Count
Departments viewing dashboardsNumber of distinct departments with at least one dashboard view in the period.Count
Average request lead time (days)Average days from when a department submits a request to when the data team delivers it, for requests delivered in the period.= da_request_lead_days_total / Delivered requestsNumber
Average run duration (minutes)Average minutes from start to finish of successful runs in the period.= da_run_minutes_total / da_successful_runsNumber
Check pass ratePassed checks divided by all data quality checks in the period.= (Data quality checks - Failed checks) / Data quality checksRatio (%)
Dashboard viewsTotal dashboard views by users across departments in the period.Count
Delivered requestsDelivered requests with a delivery date in the period (by delivery date).Count
Failed checksData quality checks with a standardized result of fail in the period.Count
Failed runsPipeline runs with a standardized status of failed (including errors and timeouts), by start date.Count
Freshness breachesSuccessful runs where the gap since the previous successful load of the same table exceeds that table's freshness commitment (freshness_sla_hours).Count
Pipeline runsData loading pipeline runs started in the period, including successful, failed and skipped runs.Count
Data quality checksData quality checks run in the period (freshness, completeness, uniqueness, validity).Count
Analysis requestsAnalysis and report requests that departments submitted to the data team in the period (by submission date).Count
Run success rateSuccessful runs divided by runs with an outcome (successful plus failed). Skipped runs are excluded.= da_successful_runs / (da_successful_runs + Failed runs)Ratio (%)
Average revenue per account (ARPA)Average MRR per paying account = total MRR across snapshots divided by the number of paying-account occurrences in those snapshots.= tech_mrr_snapshot_total / tech_paying_account_snapshotsCurrency
Daily active users (average)Average number of active users per day in the period = total daily active users divided by the number of days.= tech_active_user_days / tech_usage_daysNumber
Average MRRAverage monthly recurring revenue in the period = total MRR across month-end snapshots divided by the number of snapshot dates.= tech_mrr_snapshot_total / tech_snapshot_countCurrency
Average paying accountsNumber of accounts with positive MRR, averaged over the month-end snapshots in the period.= tech_paying_account_snapshots / tech_snapshot_countNumber
Churned accountsAccounts with at least one churn event (subscription cancellation) in the period.Count
Churned MRRTotal MRR lost from customers cancelling their subscriptions in the period, as a positive number.Currency
Contraction MRRTotal MRR decrease from retained customers (fewer seats, plan downgrades) in the period, as a positive number.Currency
Expansion MRRTotal MRR increase from existing customers (more seats, plan upgrades) in the period.Currency
Logo churn rateChurned accounts in the period divided by average paying accounts in the period.= Churned accounts / Average paying accountsRatio (%)
Net new MRRNew MRR plus expansion, minus contraction and churn, in the period.= New MRR + Expansion MRR - Contraction MRR - Churned MRRCurrency
New MRRTotal MRR from subscriptions that start paying in the period (events of type new), by effective date.Currency
Trial conversion rateTrials converted to paid divided by trials started in the period.= Trials converted / Trials startedRatio (%)
Trials convertedSubscriptions that started a trial in the period and converted to paid (up to the data cut-off date).Count
Trials startedSubscriptions that started a trial in the period (by trial start date).Count

Data you need

Required

account, subscription, mrr_movement, mrr_snapshot, da_pipeline_run

Add if you have it (unlocks more metrics)

plan, invoice, usage_daily, da_dataset, da_quality_check, da_request, da_dashboard_view

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: account, subscription, mrr_movement, mrr_snapshot, da_pipeline_run.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 3 dashboards and 29 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Technology · Data & analytics with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes