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.
select
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,5There 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.