website logo
Contact SupportSign In
User Documentation
Developers
Navigate through spaces
⌘K
Welcome!
Accounts Receivable
Accounts Payable
Reporting
Integrations
Setting Up Invoiced
Subscription Billing
Release Notes
Videos
Docs powered by
Archbee
Subscription Billing

Subscription Metrics

24min

Invoiced includes analytics and reports to help you understand the health of your recurring revenue business. You can track common subscription key performance indicators (KPIs) like monthly recurring revenue (MRR), customer lifetime value (LTV), churn, and more.

Document image


Available Charts

Invoiced includes the following subscription metric reports out of the box. Many of these reports support segmentation (month, customer, plan) and filtering.

  • Monthly Recurring Revenue
  • Annual Recurring Revenue
  • MRR Movements
  • Total Subscribers
  • Churn
  • Average Sale Price
  • Lifetime Value
  • Net Revenue Retention
Document image


Custom Reports

If you have access to the report builder then you can build custom MRR reports with your own filtering and segmentation, as well as drill down into the line item level detail behind MRR. You can use the MRR Item and MRR Movement reporting data types to do this.

How MRR is calculated

Monthly recurring revenue (MRR) is the basis for tracking recurring revenue. On Invoiced, MRR is derived from recurring line items that were billed. A recurring line item is any line item that has an associated subscription plan and a service period.

The MRR of each line item is normalized depending on the plan interval. If the line item is prorated then the service period is an additional factor used to convert the billed amount to MRR. We only track MRR for what has been billed to a customer. Subscription events such as upgrades and cancellations are derived from line items and not from the subscription itself.

For example, if a customer was billed $120 for a yearly subscription, then this would add $10 to your MRR for each month covered by the service period.

Subscription metrics are periodically calculated. When viewing reports please pay attention to the last calculation date to know whether recent changes were included in your metrics.

MRR Movements

MRR movements capture the types of changes that can happen to your MRR. As your recurring revenue base grows you would see this reflected as MRR movements. We calculate MRR movements from the line items that are billed to customers. As your customer's MRR changes month over month we break these down into the specific line items that caused the MRR change.

There are five different types of MRR movements that we will explain.

  • New Business
  • Expansion
  • Contraction
  • Lost
  • Reactivation

New Business

All MRR in the first month of a customer's relationship with you is considered new business.

Expansion

Expansion occurs when a customer's MRR increases from the previous month. The previous month MRR must be non-zero for it to be considered expansion revenue.

Contraction

When a customer's MRR decreases from the previous month but has not churned, then this is considered a contraction. Since this is a decrease in MRR, contraction MRR should be a negative value.

Lost

Lost MRR is observed when a customer has churned and their MRR has gone to zero. Since this is a decrease in MRR, lost MRR should be a negative value.

Reactivation

Reactivation MRR is similar to New Business with one important distinction. We categorize MRR as reactivation if the customer previously had MRR but had previously canceled. Reactivation is the first month of MRR that occurs after the customer has canceled.

Metrics

These are the formulas we use to calculate each subscription metric that you see in the application, charts and reports.

Annual Recurring Revenue (ARR)

\text{ARR} = \text{MRR}*12


Average Revenue Per User (ARPU)

\text{ARPU} = \dfrac{\text{MRR}}{\text{Total Customers}}


Lifetime Value (LTV)

\text{LTV} = \dfrac{\text{ARPU}}{\text{User Churn}}


When user churn is 0% then Lifetime Value then the calculation becomes:

\text{LTV} = \text{ARPU}*\text{36 months}


User Churn

\text{User Churn} = \dfrac{\text{Lost Customers}}{\text{Starting Customers}}


Revenue Churn

\text{Revenue Churn} = \dfrac{\text{Lost MRR}}{\text{Starting MRR}}


Growth Rate

\text{Growth Rate} = \dfrac{\text{MRR}-\text{Starting MRR}}{\text{Starting MRR}}


Net Revenue Retention (NRR)

\text{NRR} = \scriptsize{\dfrac{\text{Starting MRR}+\text{Expansion MRR}+\text{Reactivation MRR}-\text{Contraction MRR}+\text{Lost MRR}}{\text{Starting MRR}}}


Average Sale Price (ASP)

\text{ASP} = \dfrac{\text{New Business MRR}}{\text{New Customers}}




Did this page help you?
PREVIOUS
Coupons
NEXT
Release Notes
Docs powered by
Archbee
TABLE OF CONTENTS
Available Charts
Custom Reports
How MRR is calculated
MRR Movements
New Business
Expansion
Contraction
Lost
Reactivation
Metrics
Annual Recurring Revenue (ARR)
Average Revenue Per User (ARPU)
Lifetime Value (LTV)
User Churn
Revenue Churn
Growth Rate
Net Revenue Retention (NRR)
Average Sale Price (ASP)
Docs powered by
Archbee