1 min read

Where New MRR Comes From

In this post we’ll try to answer a very simple question: where does new MRR come from? We want to break down new MRR by simplified plan (Awesome or Business).

Data Collection

In order to calculate “new” MRR, we’ll gather all of the subscriptions created in the past couple of months.

  s.id as subscription_id
  , date(s.created_at) as created_date
  , s.plan_id
  , s.simplified_plan_id
  , s.trial_start_at is not null as has_trial
  , max(m.mrr_amount) as mrr
from dbt.stripe_subscriptions as s
inner join dbt.subscription_mrr_values as m
  on s.id = m.subscription_id
where s.created_at >= '2019-03-01'
and s.successful_charges >= 1
group by 1,2,3,4,5

There are around 27 thousand subscriptions created in 2019 that contributed to MRR.

Exploratory Analysis

Let’s break down this MRR by simplified biling plan.

## `summarise()` regrouping output by 'created_month' (override with `.groups` argument)

It looks like a bit more New MRR comes from Business customers.