Data Table and MRR Movements

 

You will find a data table listing the MRR movements under many of the charts in ChartMogul. There are five MRR movement categories which are: New business MRR, Expansion MRR, Contraction MRR, Churn MRR and Reactivation MRR. The total MRR amount and the number of activities associated with each movement type are listed for the selected time period and configured segment. 

Screen_Shot_2018-09-14_at_4.39.24_PM.png

 

MRR movement definitions 

New business MRR

The MRR at the moment a lead converts into a paid customer for the first time is counted.

Expansion MRR

Any increase in the MRR of an existing customer, e.g. an increase in quantity, upgrade to a higher plan, adding a 2nd subscription, or a discount expiring.

Contraction MRR

Any decrease in MRR. e.g. a decrease in quantity, downgrade to a lower plan, or a discount being added.

Churn MRR

The MRR at the time a customer cancels their subscription. The time of the churn event depends on your churn recognition option. A customer only counts towards Churn MRR if they don’t have any other active subscriptions. If there are other active subscriptions, the cancellation of one of them would be considered a contraction. 

Reactivation MRR

When a previously paying customer that had churned moves back onto a paid plan.

 

Using the data table to dig deeper into your data

The data table lets you easily drill down into your metrics and see exactly what type of customer activity caused a particular change.

To drill down into one of the movement types, simply click on the tab in the data table for which you want to view the individual activities. You will see a list drop down below the data table that lists every activity. You can also click on the activity itself to open the customer profile in another browser tab. 

 

Screen_Shot_2018-09-14_at_4.42.27_PM.png

The data table and plan filters

When you are filtering the data to only see the MRR from a particular plan, then the MRR breakdown will only be showing in activities that resulted in a customer having a particular plan. For instance, if you are filtering by Plan A, and a customer contracted from Plan A to Plan B, then you will not see this activity among the Contraction MRR.

However you will be able to see such plan switches included in the rows 'MRR that entered the segment' and 'MRR that left the segment'. These show the total value of a subscription before it 'left' or 'entered' the segment you are filtering by. If in the above example the customer transitioned from a $50 Plan A to a $30 Plan B, then the 'MRR that left the segment' would be $50.

 MRR_that_entered-left_segment.png

These additional rows are only visible when you are using the 'Plan is any of' filter, and if there have been movements in or out of the segment you are filtering by. It also works for plan groups, so if you have a plan group for your annual plans, you would be able to see the customers who are moving into such a plan.

Bear in mind that once you click on a cell for one of the new rows, we display the activities that resulted in the plan on a subscription to be changed. The size of the activity is not the same as the size of the subscription before the change.

A current limitation is that MRR that entered or left the segment only includes the MRR from switches that also resulted in changes in MRR. If someone changed from Plan A to Plan B, but the MRR remained the same, then this will not be included in the breakdown.