Approaching a Usage Scoring Formula for Company Evaluation
how would you approach a formula to calculate usage scoring of a company being the company my group name?
Hi Juan I., 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> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
To calculate a usage score for a company (which is your group name in Mixpanel), you can use Mixpanel's Formulas feature. Formulas allow you to make calculations using simple arithmetic operators. Here's how you can approach it:1. Click the Metrics button, then select Formula. Each event in the query shows a letter next to it, which indicates its variable name. Use these letters in combination with the operators to calculate a more advanced query.2. You can use numbers as constants in a formula. For example, you can multiply a ratio by 100 to display as a percentage, or divide a property value tracked in seconds by 3,600 to display the value in hours.3. You can rename a formula by selecting Rename in the overflow menu of the formula.4. Note that you cannot nest a formula metric when constructing another formula.5. Once you've created your formula, you can save it for re-use. When a saved metric is updated, it will update across all reports it's being used in. A saved formula can't reference another formula.Remember, the specific formula you'll use to calculate the usage score will depend on the specific metrics you're interested in. For example, you might want to consider factors like the number of users from the company, the frequency of their usage, the features they use, etc.For more details, refer to the Mixpanel documentation on Formulas.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.
Let me check the knowledge base for you again. One moment! đź“š
Creating a health score for a company in Mixpanel would involve identifying key metrics that indicate the health of the company's usage of your product. These metrics could include factors like user engagement, feature usage, session length, frequency of logins, etc. Here's a general approach you could take:1. Identify Key Metrics: Determine which metrics are most indicative of a healthy user or company. This could be based on usage patterns, feature adoption, frequency of use, etc.2. Create Formulas: Use Mixpanel's Formulas feature to create calculations based on these metrics. For example, you might create a formula that calculates the average session length for users in a company, or the percentage of users who have adopted a key feature.3. Aggregate Scores: You might decide to aggregate these individual metric scores into a single "health score". This could be done by simply adding the scores together, or you might decide to weight certain metrics more heavily based on their importance.4. Save and Reuse Formulas: Once you've created your formulas, you can save them for reuse. This allows you to easily calculate the health score for any company in your Mixpanel data.5. Monitor and Adjust: Over time, you might find that certain metrics are more (or less) indicative of health than you initially thought. Adjust your formulas and health score calculation as needed based on these insights.Remember, the specific metrics and formulas you use will depend on your product and what constitutes "healthy" usage for your users or companies.For more details on how to use Formulas in Mixpanel, refer to the Mixpanel documentation on Formulas.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
⤵️ Hint: Mention @kapa.ai in the thread for follow-ups.