How can I calculate growth rate?

Hi Tal, Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋

To calculate growth rate in Mixpanel, you have a few options depending on the specific metric you're looking at. Here are some relevant methods:

1. For Monthly Recurring Revenue (MRR) growth rate: The formula is: current MRR / prior MRR

This calculation looks at overall growth in MRR, including upsells.

2. For general user growth rate: Mixpanel's 2024 Benchmarks Report provides insights on growth rates across industries. While it doesn't give a specific formula, it mentions that the average cross-industry growth rate was 2.4%, with the top 10% of companies enjoying a growth rate of 6%.

3. For a more customized growth rate calculation: You can use Mixpanel's Formulas feature in Insights to create a custom growth rate metric. This allows you to make calculations using simple arithmetic operators (+, -, *, /) and combine different metrics.

For example, you could create a formula to calculate the growth rate between two periods by subtracting the previous period's value from the current period's value, dividing by the previous period's value, and multiplying by 100 to get a percentage.

Remember that the specific calculation may vary depending on what exactly you're measuring (users, revenue, etc.) and over what time period.

For more detailed information on using Formulas in Mixpanel, you can refer to the Mixpanel Docs on Formulas.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

Let me check the knowledge base for you again. One moment! 📚

Based on the formula you've provided, it seems you're looking to calculate a retention or growth metric for clients with active subscriptions. This type of calculation is particularly relevant for subscription-based or SaaS (Software as a Service) business models.

Mixpanel offers functionality to help you calculate metrics like this, especially through its revenue analytics features. Here's how you might approach this in Mixpanel:

1. First, you'll need to ensure that you're tracking the necessary data in Mixpanel. This includes: - Client information - Subscription status (active/inactive) - Subscription start and end dates

2. Once you have this data in Mixpanel, you can use the "Computed Properties" feature to create custom metrics. This feature is particularly useful for subscription revenue metrics.

3. Mixpanel has two computed properties that could be helpful for your calculation: - "recurring revenue change": This looks at the numerical difference between two values - "recurring revenue change type": This tells you the type of change (e.g., new, upgrade, downgrade, churn, flat)

4. You can use these computed properties along with Mixpanel's Formulas feature in Insights to create your custom metric.

5. When creating your metric, you'll have two important controls: - Time control: This lets you choose what today's value should be compared against (e.g., 1 month ago, 3 months ago) - Change type: This allows you to specify which types of changes you want to include in your calculation

It's important to note that while Mixpanel provides the tools to create this type of metric, the exact implementation might require some custom setup based on how your data is structured in Mixpanel.

For more detailed information on how to set up and use these features for subscription-based metrics, you can refer to the Mixpanel Guide on Subscriptions Business Models.

Remember, the effectiveness of this metric will depend on how accurately you're tracking client and subscription data in Mixpanel. If you need further assistance with implementation, it might be helpful to consult with Mixpanel's support team or documentation for more specific guidance.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.