)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
HubSpot can’t perform complex MRR growth rate calculations because it lacks the formula flexibility needed for compound growth rates, rolling calculations, and segmented growth analysis. You can see revenue amounts and dates, but calculating CMGR, year-over-year growth, and cohort-specific growth rates requires capabilities that HubSpot doesn’t support.
Here’s how to create custom MRR growth rate calculations using your HubSpot revenue fields with automated updates and trend analysis.
Build sophisticated growth rate formulas with live HubSpot data using Coefficient
Coefficient extracts revenue data from HubSpot into HubSpot spreadsheets where you can build custom growth rate calculations that update automatically. This gives you the compound growth analysis and trend tracking that subscription businesses need but HubSpot can’t calculate natively.
How to make it work
Step 1. Import historical revenue data.
Connect to HubSpot and extract deal amounts, close dates, subscription values, and custom MRR fields with complete historical records. Include customer segments and product categories to enable segmented growth rate analysis across different business dimensions.
Step 2. Build period-over-period and compound growth formulas.
Create formulas that calculate MRR growth rates across monthly, quarterly, and annual periods using HubSpot revenue data. Build calculations for compound monthly growth rate (CMGR), year-over-year growth, and rolling 12-month growth rates using standard spreadsheet functions like POWER and AVERAGE.
Step 3. Create segmented growth analysis.
Calculate growth rates by customer segment, product line, or revenue category using HubSpot’s custom fields. Use SUMIFS and AVERAGEIFS functions to group revenue data and track how different segments contribute to overall growth patterns.
Step 4. Automate growth rate updates and trend visualization.
Schedule regular imports to continuously update growth calculations as new revenue data flows from HubSpot. Formula Auto Fill Down ensures that growth rate calculations are automatically applied to new data, maintaining consistent growth metrics while creating visualizations that show growth trends and acceleration patterns.
Start measuring growth that matters
Custom MRR growth rate calculations with HubSpot revenue fields give you the precise growth insights needed for strategic planning and investor reporting. With automated updates and segmented analysis, you can identify which growth drivers actually work. Begin calculating growth rates today.
