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
Dashboard templates
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.
The share of new MRR from contracts closed by the sales team versus self-serve trial sign-ups.
New opportunities, win rate, closed value and quota attainment of the sales team.
Average MRR, new, expansion and churned MRR, and paying customers of a subscription software company.
Churned customers, lost MRR, trial conversion rate and product usage.
Subscription invoice amounts issued and collection rate by segment and billing cycle.
Versioned definitions, shared by dashboards, Si, reports and MCP.
| Metric | Definition | Unit |
|---|---|---|
| New MRR from sales contracts | New 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 MRR | New 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 MRR | Ratio (%) |
| Average deal size | Won amount divided by the number of won opportunities.= Won amount / Won opportunities | Currency |
| Average sales cycle (days) | Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunities | Number |
| Lost opportunities | Number of opportunities lost, by close date. | Count |
| New opportunities | Sales opportunities created in the period (by creation date), including open, won and lost ones. | Count |
| Open pipeline value | Total value of opportunities created in the period that are still open (neither won nor lost). | Currency |
| Sales target | Total sales targets of sales reps. Targets are set monthly and recorded on the first day of the month. | Currency |
| Quota attainment | Won amount divided by sales target. Above 100% means the target is exceeded.= Won amount / Sales target | Ratio (%) |
| Win rate | Won opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities) | Ratio (%) |
| Won amount | Total value of won opportunities, by close date. | Currency |
| Won opportunities | Number 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_snapshots | Currency |
| 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_days | Number |
| Average MRR | Average 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_count | Currency |
| Average paying accounts | Number of accounts with positive MRR, averaged over the month-end snapshots in the period.= tech_paying_account_snapshots / tech_snapshot_count | Number |
| Churned accounts | Accounts with at least one churn event (subscription cancellation) in the period. | Count |
| Churned MRR | Total MRR lost from customers cancelling their subscriptions in the period, as a positive number. | Currency |
| Invoice collection rate | Amount collected divided by amount invoiced, for invoices issued in the period.= tech_invoice_paid_amount / Invoiced amount | Ratio (%) |
| Contraction MRR | Total MRR decrease from retained customers (fewer seats, plan downgrades) in the period, as a positive number. | Currency |
| Expansion MRR | Total MRR increase from existing customers (more seats, plan upgrades) in the period. | Currency |
| Invoiced amount | Total amount of subscription invoices issued in the period (by issue date). | Currency |
| Logo churn rate | Churned accounts in the period divided by average paying accounts in the period.= Churned accounts / Average paying accounts | Ratio (%) |
| Net new MRR | New MRR plus expansion, minus contraction and churn, in the period.= New MRR + Expansion MRR - Contraction MRR - Churned MRR | Currency |
| New MRR | Total MRR from subscriptions that start paying in the period (events of type new), by effective date. | Currency |
| Trial conversion rate | Trials converted to paid divided by trials started in the period.= Trials converted / Trials started | Ratio (%) |
| Trials converted | Subscriptions that started a trial in the period and converted to paid (up to the data cut-off date). | Count |
| Trials started | Subscriptions that started a trial in the period (by trial start date). | Count |
account, subscription, mrr_movement, opportunity
plan, mrr_snapshot, invoice, usage_daily, sales_rep, sales_target
Upload an Excel file or connect a source with: account, subscription, mrr_movement, opportunity.
Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.
The build gives you 5 dashboards and 28 metrics; ask Si anytime.
Connectors with a setup guide that feed the entities this template needs. Excel always works.
Free plan with no time limit · No card required · Sample workspace ready in minutes