Skip to content

Dashboard templates

Technology · IT

Subscription software (SaaS) company running its own platform, API, mobile apps and internal IT. MRR, churn and usage, plus incidents, SLA, failed releases, service availability and the MRR corresponding to service downtime.

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

For platform operations teams at SaaS companies (platform, API, mobile app, internal IT). The "Reliability and MRR" dashboard calculates the MRR tied to service downtime and incidents per 100 paying customers. The "IT incidents and support" and "Availability and changes" dashboards cover availability, MTTR, SLA breaches and failed release rate, while the MRR and retention dashboards show whether incidents lead to churn. Needs account, subscription, MRR movement, MRR snapshot, service catalog and IT ticket data.

Use this template to

  • Put each hour of downtime in MRR terms to prioritize reliability work.
  • Track the failed release rate for the API and integrations.
  • Set internal SLAs by the work types most often overdue.

5 ready-made dashboards

Reliability and MRR

MRR exposed to service downtime, availability, and incidents relative to paying customers.

  • MRR exposed to downtime
  • Service availability
  • Incidents per 100 paying customers
  • Average MRR
  • Affected MRR by service
  • Weekly affected MRR
  • Monthly incidents per 100 customers

IT incidents and support

Tickets, P1 incidents, response and resolution times, and SLA breach rate by service and resolver team.

  • Incidents
  • P1 incidents
  • Mean time to resolve (MTTR, hours)
  • SLA breach rate
  • By service
  • SLA breach rate by work type
  • Response time by resolver team
  • Weekly tickets

Availability and changes

Availability, outage time and change failure rate for each IT service.

  • Service availability
  • Outage minutes
  • Changes deployed
  • Change failure rate
  • Availability by service
  • Outage minutes by criticality
  • Weekly outage minutes

MRR overview

Average MRR, new, expansion and churned MRR, and paying customers of a subscription software company.

  • Average MRR
  • Net new MRR
  • Average paying accounts
  • Average revenue per account (ARPA)
  • MRR movement by segment
  • Month-end MRR by segment
  • Net new MRR by plan

Retention and trials

Churned customers, lost MRR, trial conversion rate and product usage.

  • Logo churn rate
  • Churned MRR
  • Trial conversion rate
  • Daily active users (average)
  • Retention by plan
  • Monthly churned MRR by plan
  • Trial conversion rate by plan
  • Weekly daily active users

Ask Si as soon as the build finishes

  • “How did MRR exposed to downtime change compared with last month?”
  • “What is driving incidents per 100 paying customers this quarter?”
  • “Show service availability by month for the last six months.”
  • “Where is change failure rate highest this month, and why?”

31 defined metrics

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

MetricDefinitionUnit
MRR exposed to downtimeFor each outage: outage minutes divided by 43,200 (a 30-day month), times the total MRR snapshot of that month, times the share of MRR that depends on the service. Summed over all outages in the period. This is the subscription value customers paid for time the service was unusable, the basis for estimating SLA credits.Currency
Incidents per 100 paying customersIncidents (incident-type tickets) opened in the period times 100 divided by average paying customers in the period; measures stability relative to the customer base.= Incidents * 100 / Average paying accountsNumber
Service availabilityOne minus outage minutes divided by the service's planned operating minutes in the period.= 1 - Outage minutes / it_planned_minutesRatio (%)
Change failure rateFailed changes (failed or rolled back) divided by changes deployed in the period.= Failed changes / Changes deployedRatio (%)
Changes deployedNumber of IT changes deployed in the period, by deployment date.Count
Failed changesNumber of changes deployed in the period with a failed or rolled-back outcome.Count
Average first response time (hours)Average hours from ticket creation to first response, across all tickets opened in the period.= it_response_hours_total / IT support ticketsNumber
IncidentsNumber of incident-type tickets opened in the period, by open date.Count
Mean time to resolve (MTTR, hours)Average hours from open to resolution for incidents resolved in the period.= it_incident_hours_total / Resolved incidentsNumber
Outage minutesTotal minutes a service was down or disrupted, counted on the day the outage started.Number
P1 incidentsNumber of highest-priority incidents (P1, critical) opened in the period.Count
Resolved incidentsNumber of incidents resolved in the period, by resolution date.Count
SLA breach rateTickets breaching SLA divided by tickets opened in the period.= SLA breaches / IT support ticketsRatio (%)
SLA breachesTickets opened in the period that were resolved after the SLA deadline (resolution hours greater than the SLA target).Count
IT support ticketsNumber of IT support tickets (incidents and requests) opened in the period, by open date.Count
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
Invoice collection rateAmount collected divided by amount invoiced, for invoices issued in the period.= tech_invoice_paid_amount / Invoiced amountRatio (%)
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
Invoiced amountTotal amount of subscription invoices issued in the period (by issue date).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, it_service, it_ticket

Add if you have it (unlocks more metrics)

plan, invoice, usage_daily, it_change, it_outage

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, it_service, it_ticket.

  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 5 dashboards and 31 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 · IT with your own data

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