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).
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,5
There are around 27 thousand subscriptions created in 2019 that contributed to MRR.
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.