App Icon
Baremetrics: Subscription Analytics & Insights for Stripe, Braintree, Recurly & more!
Works with:
480
Overview
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

Additional information
Privacy policy
Terms of service
Baremetrics for Sheets will ask for the permissions shown below. Learn more
Baremetrics for Sheets will need access to your Google account
This will allow Baremetrics for Sheets to :
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
Josh Rowles
April 11, 2021
Great app!
Is this review helpful?
Yes
No
Profile Picture
Brian Sierakowski
June 10, 2021
Perfect!
Is this review helpful?
Yes
No
1-2 of 2
Search
Clear search
Close search
Google apps
Main menu