Baremetrics is Subscription Analytics and Insights: One click and you get hundreds of valuable metrics and business insights!

The addon enables custom functions to display your Baremetrics data easily on a Google Sheet. To use a metric, simply enter the formula into a cell, like this:

=MRR("2020/12/01")

Make sure you've authorised the addon first!

The available custom functions are:
=ACTIVE_CUSTOMERS(date)
=ACTIVE_SUBSCRIPTIONS(date)
=ACTIVE_TRIALS(date)
=ARPU(date)
=ARR(date)
=CANCELLATIONS(date)
=CHURNED_CUSTOMERS(date)
=CONVERTED_TRIALS(date)
=COUPONS(date)
=DOWNGRADES(date)
=FAILED_CHARGES(date)
=FEES(date)
=LTV(date)
=MRR(date)
=MRR_GROWTH_RATE(date)
=NET_REVENUE(date)
=NET_REVENUE_CHURN(date)
=NEW_CUSTOMERS(date)
=NEW_SUBSCRIPTIONS(date)
=NEW_TRIALS(date)
=OTHER_REVENUE(date)
=PLAN_QUANTITIES(date)
=QUICK_RATIO(date)
=REACTIVATIONS(date)
=REFUNDS(date)
=REVENUE_CHURN(date)
=TRIAL_CONVERSION(date)
=TRIAL_TIME_TO_CANCELATION(date)
=TRIAL_TIME_TO_CONVERSION(date)
=UPGRADES(date)
=USER_CHURN(date)

More information on these metrics can be found in our API documentation:
https://developers.baremetrics.com/reference#available-metrics