Overview of "State of the Business" data model
The "State of the Business" model provides daily snapshots of a company performance. It breaks down revenue streams by subscriptions / customers and plans and allows for informed decision-making.
Highlights:
Daily Snapshots: Instead of waiting for monthly or quarterly reports, receive updated insights every day.
Widgets Examples:
ARR (Annual Recurring Revenue) / MRR (Monthly Recurring Revenue) : Gauge yearly earnings derived from recurring revenue.
%MoM Growth Rate: Monitor monthly growth rates, essential for spotting trends.
MRR Change: Track the change in MRR to ascertain business momentum.
ARPU: Average Revenue Per Usage - A critical metric for understanding revenue generation capability per customer.
LTV: Lifetime Value - Understand the total revenue a business can expect from a single customer during their lifetime.
Benefits/Use Cases:
Daily Revenue Snapshots
Get a quick snapshot of your revenue streams every day. Compare today's performance with previous days and identify any immediate fluctuations.
Subscription Deep Dive
Review the performance of individual subscription plans or tiers. Identify which ones are most popular and which might need adjustments.
Customer Value Worth
Assess the Average Revenue Per User (ARPU) and the Lifetime Value (LTV) metrics. Get a clear view of each customer's financial impact on your business.
Revenue Breakdown Analyzer
Segment revenue by its source, such as new customers, churned customers, renewals, and others. Understand where your earnings come from and spot patterns.
Strategic Resource Allocation
Identify which revenue streams are most profitable (Segmentation) . Use this data to direct your resources effectively, ensuring you're investing in the right areas.
Revenue Analysis
Categorize revenue into different states like new, churn, reactivation, expansion, contraction, renewal, and idle. This assists in revenue source identification and customer behavior analysis.
Active Customer
Easily identify active customers and subscriptions, crucial for retention strategies.
Segmentation
Segment data by plans, customers, or subscriptions to get tailored insights.
Summary
The "State of the Business" model provides daily snapshots of a company's performance by breaking down revenue streams by subscriptions, customers, and plans, enabling informed decision-making. It includes widgets like ARR/MRR to gauge recurring revenue, %MoM Growth Rate to monitor trends, MRR Change to track business momentum, ARPU to understand revenue per customer, and LTV to assess total customer value. Benefits include quick daily revenue comparisons, deep dives into subscription performance, clear customer value assessment, revenue segmentation, strategic resource allocation, and effective identification of active customers for retention strategies.
Integrations:
Stripe, HubSpot, Salesforce
Examples of questions that can be answered with this model:
What is our current Monthly Recurring Revenue (MRR)?
What's the %MoM Growth Rate for this month compared to last month?
Which plans are contributing the most to our ARR this year?
How has our ARPU evolved over the past three months?
How much revenue did we lose this month due to churn?
What's the current average LTV of our customers? How does it compare with the previous quarter?
Based on our current data, what's our projected MRR for next month?
Based on current trends, what's our projected ARR for the next year?
Which revenue state (new, churn, reactivation, expansion, contraction, renewal, or idle) showed the most growth in the last 30 days?
Which customer segments or plans show the highest retention rates?
How much of our revenue this month was from new customers versus reactivations or renewals?
Who are our top active customers this month?
How does the revenue from our premium plan compare to our basic plan?
How many convert from trials?
How many convert from free plans?
Which customer segment has the highest churn rate?
How has our customer base grown over the past quarter?
What's the retention rate of customers who joined us three months ago?
Which revenue sources should we prioritize for resource allocation to optimize returns?
How does our ARR segment across different customer demographics or segments?
Model preview
This model includes the following joins:
Subscriptions.
Customers.
Plans.
Subscriptions Items.
Products.