This article is a step-by-step guide on how to integrate Google Sheets with Baremetrics.
Baremetrics is the leading analytics platform for SaaS and subscription businesses. By authorizing the Baremetrics API, teams can now easily integrate directly with Google Sheets- no coding required!
Keep reading to learn how to quickly integrate your accounts and start creating functional spreadsheets.
The add-on retrieves information from Baremetrics and puts it into your spreadsheet cell with a quick custom function.
The custom function pulls data from your Baremetrics account and displays it on the Google Sheet. To retrieve a value from your Baremetrics account, directly enter the custom formula into a cell, like this:
=MRR(2021-01-01)
This will retrieve your MRR as evaluated by Baremetrics on January 1st, 2021.
This article will follow these three steps to get your Baremetrics integration working:
Get deep insights into MRR, churn, LTV and more to grow your business
Note: Go back to the add-on menu to verify if the authorization has been completed.
Matthew Ruddy has created an awesome video for you to help you in this process!
Check it out below:
Baremetrics helps you better understand your MRR, ARR, retention by choosing from the 50+ available metrics. These metrics will help you create sophisticated campaigns, reduce churn and create financial models that will help you grow your business.
Once you have added the add-on, you can analyze your metrics by finding out the LTV, MRR, and other required metrics to improve your KPIs.
Once the Baremetrics Authorization is completed, you can directly enter the custom formula into a cell, like this:
=MRR(2020-01-01)
Here is a comprehensive list of available custom functions that we have setup for you. You can pull all of these metrics directly into your Google Sheets!
=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)
Use these functions to find out your company’s important stats such as Active Customers, MRR, Trial Conversions, and more to drive your company’s net growth and to see other foreseeable advantages and avoidable mishaps.
Sign up for a free 14-day Baremetrics trial today!
Using Google Sheets allows for quick collaboration and version control. If you accidentally delete your data, you can go to “Open Version History”. Through this you can see all the edits that you have made from the beginning, thereby preventing data loss.
But why use Google Sheets with the Baremetrics add-on?
Using the Baremetrics add-on keeps your data in one sheet to help you create more accurate financial models. You can better forecast your company’s growth by creating the best and worst-case scenarios to tide your company.
Create your financial model with our updated Baremetrics financial template using your Baremetrics data directly in Google Sheets via our Google Sheets add-on. This template will help you create the right financial scenarios and compare forecasts to actuals.
Read more on the benefits of using a financial model here.
We’ve also updated our article on the SaaS financial model you will actually use, to help you along the way in creating the best business plan for small, medium, and large enterprises!
Baremetrics gives you complete control of your business metrics via smarter dashboards, trial insights, segmentation features, and more. Lead your company in the right direction by making data-driven decisions.
Start your free Baremetrics 14-day trial today to access key business metrics and make more.