top of page
  • Writer's pictureLiam De Seve

Unleashing the Power of NetSuite’s Analytics Warehouse for SaaS Metrics

Introduction


In the fast-paced world of Software as a Service (SaaS), data is not just valuable; it's indispensable. Every click, every interaction, and every transaction holds insights that can drive strategic decisions and foster growth. However, the sheer volume and complexity of SaaS metrics can overwhelm even the most seasoned business leaders. This is where a robust analytics solution like NetSuite's Analytics Warehouse steps in, offering a comprehensive platform to track, analyze, and visualize key performance indicators with unparalleled precision and clarity.


In this blog post, we'll delve into the realm of SaaS metric tracking and visualization, exploring how NetSuite's Analytics Warehouse empowers organizations to harness the full potential of their data. From monitoring customer acquisition costs to understanding churn rates and predicting future trends, we'll uncover the myriad ways in which this powerful tool can drive informed decision-making and propel businesses towards success in the competitive SaaS landscape.





Monthly Recurring Revenue (MRR)


What is it? 


MRR is a vital metric for SaaS businesses, indicating the total predictable monthly revenue generated from subscriptions. This metric is essential for understanding revenue trends and then using this information to drive strategic decisions for growth.



Questions It Can Answer


  • Is our revenue growing steadily each month?

  • Which pricing tiers are generating the most recurring revenue?

  • How do changes in our service offerings affect our monthly revenue?



Formula


MRR = Sum of monthly recurring revenue from all customers



How it can be tracked in NSAW


There are many ways this can be captured but this could be done by creating a custom field on subscription records for monthly fees. Set up a monthly scheduled workflow that aggregates these fees across all active subscriptions to update the MRR value.





Customer Acquisition Cost (CAC)


What is it? 


As the name says, Customer Acquisition Cost (CAC) represents the total cost of acquiring a new customer. This includes all marketing and sales expenses over a specific period, divided by the number of new customers acquired. CAC is crucial for evaluating the effectiveness of marketing strategies and understanding the investment needed to attract customers. It helps businesses determine whether they are spending sustainably relative to their revenue.



Questions It Can Answer


  1. How much are we spending to acquire each new customer?

  2. Are our marketing and sales efforts cost-effective?

  3. How does the CAC compare with the revenue generated by new customers (i.e., is the customer acquisition profitable)?


Formula: 


CAC = (Total Marketing and Sales Expenses) / (Number of New Customers Acquired)



How it can be tracked in NSAW


Track CAC by integrating marketing and sales expense records with customer records. Use workflows to divide total marketing and sales expenses by the number of new customers acquired in a given period.





Customer Lifetime Value (CLV)


What is it? 


Customer Lifetime Value (CLV) represents the total revenue a business can expect from a single customer throughout their entire relationship. CLV is essential for evaluating the effectiveness of customer retention strategies and for making informed decisions about how much to invest in acquiring and retaining customers.


Questions It Can Answer


  1. How much revenue can we expect from an average customer over their lifetime with our service?

  2. Is our customer retention strategy effectively enhancing the CLV?

  3. How does CLV compare to the Customer Acquisition Cost (CAC)?



Formula


CLV = (Average Revenue Per Customer Per Year) x (Average Customer Lifespan)



How it can be tracked in NSAW


Utilize customer transaction records to aggregate revenue per customer. Configure a workflow that calculates average revenue per customer over their lifespan, updating CLV metrics periodically.





Churn Rate


What is it?


Churn Rate measures the percentage of customers who discontinue their subscriptions over a certain period. It’s a vital metric for SaaS businesses, indicating customer retention and satisfaction levels. High churn rates can signal problems with the service, while low rates suggest customer loyalty.


Questions It Can Answer


  1. What percentage of our customers are we losing over a specific period?

  2. Are there specific factors contributing to a high churn rate?

  3. How does customer churn impact our revenue and growth projections?



Formula


Churn Rate = (Number of Customers Lost During Period) / (Total Number of Customers at Start of Period) x 100



How it can be tracked in NSAW


Create a calculated field to mark subscriptions that have been cancelled within a specific period. This field flags each churned subscription, facilitating the monthly calculation of the Churn Rate by dividing the count of flagged subscriptions by the total subscriptions at the period’s start.




Downgrade Churn


What is it?


Downgrade Churn measures the reduction in revenue caused by customers downgrading to lower-tier subscription plans but does not fully churn. This metric provides a nuanced view of the Churn Rate by capturing not just customer losses but also shifts in customer preferences and satisfaction.



Questions It Can Answer


  1. What is the impact of downgrades on our monthly recurring revenue?

  2. Are specific service tiers or features leading to higher downgrade rates?

  3. How does Downgrade Churn affect our long-term revenue and growth strategy?



Formula


Downgrade Churn = (Revenue Lost from Cancellations + Revenue Lost from Downgrades) / Total Revenue at the Start of the Period



How it can be tracked in NSAW


Create a calculated field to identify subscriptions that have been downgraded. This field tags each subscription experiencing a downgrade, enabling the analysis of Downgrade Churn by comparing the number of tagged subscriptions against the total at the beginning of the period.





Conversion Rate


What is it? 


Conversion Rate measures the percentage of potential customers who take a desired action, like subscribing to a service or making a purchase. It’s essential for evaluating the effectiveness of marketing and sales strategies, showing how well a business converts interest into actual sales.



Questions It Can Answer


  1. How effective are our marketing and sales strategies at turning leads into customers?

  2. Which marketing channels or campaigns are yielding the highest conversion rates?

  3. How do changes in our product offerings or pricing models impact our conversion rates?


Formula


Conversion Rate = (Number of Conversions / Number of Total Leads) x 100



How it can be tracked in NSAW


Implement a calculated field to track the conversion of leads to customers. This field calculates the Conversion Rate by dividing the number of leads that become customers within a period by the total number of leads, then multiplying by 100 to get a percentage.






Average Revenue Per User (ARPU)


What is it?


Average Revenue Per User (ARPU) measures the average revenue generated by each customer or user within a certain time frame. This indicates the value each user brings to the company. ARPU helps in assessing the effectiveness of pricing strategies and understanding the overall financial health of the user base.



Questions It Can Answer


  1. What is the average financial contribution of each user to our business?

  2. How do different customer segments contribute to the overall ARPU?

  3. How do updates in pricing strategies affect the average revenue per user?



Formula


ARPU = Total Revenue in a Period / Average Number of Users in that Period



How it can be tracked in NSAW


Configure a calculated field named “ARPU” to determine the average revenue generated per user. This field calculates ARPU by dividing the total revenue within a specific period by the total number of users, providing insights into revenue efficiency and user value.





Gross Margin


What is it? 


Gross Margin measures the percentage of revenue exceeding the direct costs of producing goods or services. It’s a key indicator of a SaaS company’s financial health, reflecting the efficiency of its cost structure and its ability to generate profit after covering production costs.



Questions It Can Answer


  1. What percentage of revenue is retained after covering direct production costs?

  2. How efficient is our cost structure concerning generating revenue?

  3. Are there areas in production where cost optimization can improve our gross margin?



Formula


Gross Margin = [(Total Revenue — Cost of Goods Sold) / Total Revenue] x 100



How it can be tracked in NSAW


Calculated field for “Gross Margin” by subtracting the cost of goods sold (COGS) from total revenue and dividing the result by total revenue. This calculation, expressed as a percentage, offers a clear view of profitability and cost efficiency.





Net Promoter Score (NPS)


What is it? 


Net Promoter Score (NPS) measures customer satisfaction and loyalty by gauging the likelihood of customers recommending the company’s product or service to others. It’s a powerful indicator of customer loyalty and potential for organic growth through word-of-mouth.



Questions It Can Answer


  1. How satisfied and loyal are our customers?

  2. To what extent are customers likely to promote our product or service?

  3. What impact do customer satisfaction levels have on our business growth?



Formula


NPS = % of Promoters (customers who score 9–10) — % of Detractors (customers who score 0–6)



How it can be tracked in NSAW


Create a calculated field named “NPS” to calculate the Net Promoter Score. This field identifies promoters and detractors among surveyed customers, computing NPS by subtracting the percentage of detractors from promoters, providing immediate feedback on customer loyalty.





Customer Engagement Score


What is it? 


Customer Engagement Score measures customer interaction with a SaaS product, factoring in various user activities. Each activity or event is assigned a weight based on its importance, allowing for a nuanced understanding of engagement levels. This weighted approach ensures that more significant actions have a greater impact on the overall score, providing a detailed view of customer behaviour and potential retention.



Questions It Can Answer


  1. How engaged are our customers with our product or service?

  2. Which features or functionalities drive the most customer engagement?

  3. How does customer engagement correlate with customer retention and satisfaction?



Formula


Customer Engagement Score = Sum of weighted engagement metrics (like login frequency, feature usage, etc.)



How it can be tracked in NSAW


Create a calculated field labelled “Customer Engagement Score” to aggregate and weigh various customer interactions, such as product usage and support engagement. This score offers a quantified measure of overall customer involvement and satisfaction with your services.





Conclusion


As we conclude our exploration into SaaS metric tracking and visualization with NetSuite's Analytics Data Warehouse, it's evident that the power of data-driven decision-making cannot be overstated in today's competitive landscape. By leveraging this robust platform, organizations can gain invaluable insights into their SaaS operations, enabling them to optimize processes, enhance user experiences, and drive sustainable growth.


From monitoring key performance indicators to uncovering hidden trends and predicting future outcomes, NetSuite's Analytics Data Warehouse equips businesses with the tools they need to stay ahead of the curve. By centralizing data, providing intuitive visualization tools, and offering advanced analytics capabilities, NetSuite empowers organizations to make informed decisions that drive bottom-line results.


Sky High ERP has been working with this feature since its inception. Our team can help you explore NetSuite Analytics Warehouse and develop a strategy to implement it so you see immediate rewards within your business.


Follow this link to book a free strategy call with our experts today.

40 views0 comments

Comments


bottom of page