Skip to content

Dashboard templates

Technology · Operations

A SaaS company that buys laptops, monitors and point-of-sale devices handed to customers at rollout, software licenses and cloud credits; it keeps equipment in the office warehouse and delivers it to customers and offices. MRR, churn and collections plus supplier on-time rate, equipment inventory, stockouts, equipment deliveries and purchases versus MRR.

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

For operations teams at SaaS companies buying laptops, customer devices, software licenses and cloud credits. The "Procurement spend vs MRR" dashboard shows procurement spend over MRR and per paying customer. The "Purchasing and inventory" and "Warehouse deliveries" dashboards track supplier on-time delivery, device inventory, stockout days and device deliveries. Needs account, subscription, MRR movement, MRR snapshot, purchase order and purchase order line data.

Use this template to

  • Keep procurement spend within a set share of MRR.
  • Avoid running out of customer devices when many rollouts happen at once.
  • See which supplier delivers latest.

6 ready-made dashboards

Procurement spend vs MRR

Spend on equipment, licenses and cloud credits next to MRR and paying customers, to see whether operating spend grows faster than recurring revenue.

  • Purchases to MRR ratio
  • Purchases per paying account
  • Purchase order value
  • Average MRR
  • Monthly procurement spend to MRR
  • Monthly procurement spend per paying customer
  • Purchase order value by item group

Purchasing and inventory

Purchase orders, supplier on-time and in-full delivery, lead time, average inventory and stockouts.

  • Purchase order value
  • Supplier on-time rate
  • Average inventory value
  • Stockout item-days
  • Results by supplier
  • Average inventory by item group
  • Stockout days by item group
  • Weekly average inventory by warehouse

Warehouse deliveries

Deliveries, on-time and failed delivery rates by warehouse and carrier.

  • Shipments
  • On-time delivery rate
  • Failed delivery rate
  • Failed shipments
  • Delivery results by warehouse
  • Failed delivery rate by carrier
  • Weekly failed delivery rate by warehouse

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

Billing and collections

Subscription invoice amounts issued and collection rate by segment and billing cycle.

  • Invoiced amount
  • Invoice collection rate
  • Collection rate by segment
  • Amount invoiced by billing cycle
  • Monthly amount invoiced by segment

Ask Si as soon as the build finishes

  • “How did purchases per paying account change compared with last month?”
  • “What is driving purchases to MRR ratio this quarter?”
  • “Show average inventory value by month for the last six months.”
  • “Where is average supplier lead time (days) highest this month, and why?”

31 defined metrics

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

MetricDefinitionUnit
Purchases per paying accountValue of purchase orders placed in the period divided by the total paying accounts across month-end snapshots in the period; for a one-month period it is that month's purchasing per paying account.= Purchase order value / tech_paying_account_snapshotsCurrency
Purchases to MRR ratioValue of purchase orders (equipment, licenses, cloud credits) placed in the period divided by total MRR across month-end snapshots in the period. For a one-month period it is that month's purchasing relative to that month's MRR.= Purchase order value / tech_mrr_snapshot_totalRatio (%)
Average inventory valueAverage end-of-day inventory value in the period = sum of snapshot values divided by the number of days with a snapshot.= ops_inventory_value_total / ops_snapshot_daysCurrency
Average supplier lead time (days)Average days from order to receipt for purchase orders received in the period.= ops_lead_days_total / Received purchase ordersNumber
Failed delivery rateFailed or returned shipments divided by all outbound shipments in the period.= Failed shipments / ShipmentsRatio (%)
Failed shipmentsOutbound shipments in the period that failed delivery or were returned to the warehouse.Count
On-time delivery rateOn-time deliveries divided by all outbound shipments in the period (by ship date).= ops_on_time_deliveries / ShipmentsRatio (%)
Purchase ordersPurchase orders placed in the period (by order date), excluding cancelled orders.Count
Purchase order valueTotal ordered value (ordered quantity times unit price) of purchase orders placed in the period, excluding cancelled orders.Currency
Received purchase ordersPurchase orders received in the period (by receipt date), including partial receipts.Count
Received goods valueTotal received quantity times unit price for purchase orders received in the period (by receipt date).Currency
ShipmentsOutbound shipments from the warehouse in the period (by ship date), any outcome.Count
Stockout item-daysInventory snapshots with zero (or negative) quantity in the period: each item out of stock at one warehouse on one day counts as 1.Count
Supplier fill rateReceived value divided by ordered value of purchase orders received in the period. 100% means delivered in full; lower means the supplier short-shipped.= Received goods value / ops_closed_po_valueRatio (%)
Supplier on-time rateOn-time PO receipts divided by received purchase orders in the period (by receipt date).= ops_on_time_receipts / Received purchase ordersRatio (%)
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, ops_purchase_order, ops_purchase_order_line

Add if you have it (unlocks more metrics)

plan, invoice, usage_daily, ops_supplier, ops_item, ops_inventory_snapshot, ops_shipment

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, ops_purchase_order, ops_purchase_order_line.

  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 6 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 · Operations with your own data

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