Skip to content

Dashboard templates

Technology · Sales

A subscription software (SaaS) company: new MRR, expansion, churn, collections and trials plus opportunities, win rate and quota attainment of the sales team; the share of new MRR from contracts closed by sales.

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

For sales teams at SaaS companies. The "Sales-led MRR" dashboard shows new MRR from deals the sales team closed and the share of new MRR that comes from sales. The "Opportunities and quota" dashboard tracks opportunities, win rate, contract value, sales cycle and quota attainment, while the MRR, retention and collections dashboards show whether closed customers stay. Needs account, subscription, MRR movement and sales opportunity data.

Use this template to

  • Know how much new MRR comes from sales and how much from self-serve signups.
  • Track which AEs hit quota and which opportunity sources close best.
  • Compare customers closed by sales with their later churn rate.

5 ready-made dashboards

Sales-led MRR

The share of new MRR from contracts closed by the sales team versus self-serve trial sign-ups.

  • New MRR from sales contracts
  • Sales-led share of new MRR
  • New MRR
  • Won amount
  • Sales-led new MRR by segment
  • Monthly share of new MRR from sales

Opportunities and quota

New opportunities, win rate, closed value and quota attainment of the sales team.

  • Won amount
  • Win rate
  • Open pipeline value
  • Average sales cycle (days)
  • Results by salesperson
  • Quota attainment by team
  • Win rate by opportunity source
  • Monthly closed value by region

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 new MRR from sales contracts change compared with last month?”
  • “What is driving sales-led share of new MRR this quarter?”
  • “Show average deal size by month for the last six months.”
  • “Where is average sales cycle (days) highest this month, and why?”

28 defined metrics

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

MetricDefinitionUnit
New MRR from sales contractsNew MRR in the period from customers with a won sales opportunity (contract closed by the sales team), matched by customer name.Currency
Sales-led share of new MRRNew MRR from sales contracts divided by total new MRR in the period; the rest comes from self-serve customers who signed up for a trial and then paid.= New MRR from sales contracts / New MRRRatio (%)
Average deal sizeWon amount divided by the number of won opportunities.= Won amount / Won opportunitiesCurrency
Average sales cycle (days)Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunitiesNumber
Lost opportunitiesNumber of opportunities lost, by close date.Count
New opportunitiesSales opportunities created in the period (by creation date), including open, won and lost ones.Count
Open pipeline valueTotal value of opportunities created in the period that are still open (neither won nor lost).Currency
Sales targetTotal sales targets of sales reps. Targets are set monthly and recorded on the first day of the month.Currency
Quota attainmentWon amount divided by sales target. Above 100% means the target is exceeded.= Won amount / Sales targetRatio (%)
Win rateWon opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities)Ratio (%)
Won amountTotal value of won opportunities, by close date.Currency
Won opportunitiesNumber of opportunities won, by close 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, opportunity

Add if you have it (unlocks more metrics)

plan, mrr_snapshot, invoice, usage_daily, sales_rep, sales_target

Three steps to this dashboard

  1. 1

    Connect your data

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

  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 28 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 · Sales with your own data

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