Understanding MRR Value Calculation in Mixpanel: Key Considerations
If I agreggate a property like the MRR from companies, and during different months the MRR suffers changes. What is the date mixpanel is using to consider the MRR value?
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
Mixpanel uses the most recent value of a user profile property for its calculations. This means that if the MRR (Monthly Recurring Revenue) of a company changes over time, Mixpanel will use the current value of the MRR for its computations, even if the value has changed over time. However, Mixpanel also supports historical user profile properties. This means you can capture changes in each property over time, not just the latest value. When you apply a breakdown by a historical property like MRR, the property value will be picked based on the time of the event, instead of the current property value. For example, if you're creating a cohort with changing user properties like MRR, you can optionally add Time and Measurement to specify the time-range over which to search for the property value. This will allow you to analyze the MRR over time.Sources: - User Profile Properties - Historical Profile Values - Creating a Cohort with Changing User Properties
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! đź“š
To keep track of historical values and see how the MRR evolves over time, you can use Mixpanel's Profile History feature. This feature allows you to analyze users and groups based on their attributes at any given time. For example, you can track subscription revenue changes over time.To use Profile History, you need to point Mixpanel at a table that has the history of a profile, and it will let you analyze that profile over time. This means Mixpanel can ingest Slowly Changing Dimension tables, doing an “over-time” or “asof” join between these tables and your events. This enables accurate analysis on recurring revenue and subscription states without unnaturally forcing state tables into the event-based model.When you apply a breakdown by a historical property like MRR, the property value will be picked based on the time of the event, instead of the current property value. This means that the value of the property used in charts can vary over time.You can import historical properties via Warehouse connectors. Historical properties can be used anywhere that regular profile properties can be used.Sources: - Evolving our data model: warehouse events - Importing Historical Profile Values
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.
Juan I.··I dont have this availabel in my account: Project Settings → Warehouse Sources. kapa.ai why
Let me check the knowledge base for you again. One moment! đź“š
The Warehouse Sources option in Mixpanel is part of the Warehouse Connectors feature. This feature allows you to sync data from your data warehouse into Mixpanel. If you don't see this option in your account, it could be due to one of the following reasons:1. Your Mixpanel plan may not include the Warehouse Connectors feature. This feature might be available only on certain plans.2. You might not have the necessary permissions to access this feature. In Mixpanel, certain features and settings can only be accessed by users with specific roles, such as project owners or admins.If you believe you should have access to this feature, I recommend reaching out to Mixpanel Support or your Account Manager for further assistance.Sources: - User Profile: Demographic attributes for your users - Debugging: Validate your data and troubleshoot your implementation
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! đź“š
The Warehouse Connectors feature is an enterprise add-on in Mixpanel. Even though you're on the Enterprise plan and you're an admin of the project, it's possible that this add-on hasn't been enabled for your account yet. To have it enabled, you need to reach out to the Mixpanel team. You can do this by visiting the following link: Contact Mixpanel Sales. Once the Warehouse Connectors feature is enabled for your account, you should be able to see the Warehouse Sources option in your Project Settings.Source: Warehouse Connectors
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! đź“š
To see how many new companies you acquire every month using Mixpanel, you can use the "First Time" event in Mixpanel's Funnels, Segmentation, or Insights reports. Here's a general step-by-step guide:1. Go to the Segmentation report. 2. Select the event that represents a new company acquisition (e.g., "Company Created", "New Subscription", etc. depending on your tracking plan). 3. Set the filter to "First Time". 4. Set the time unit to "Month".This will give you a chart showing the number of new companies acquired each month.Please note that the exact steps and event names may vary depending on how you've set up your tracking in Mixpanel. If you're using Mixpanel's demo data, you can explore the data to find the appropriate events and properties that represent new company acquisitions.For more detailed instructions and information on how to use Mixpanel's reports, you can refer to the following resources:- Segmentation Report - Funnels Report - Insights ReportFor a more comprehensive understanding of tracking SaaS business KPIs with Mixpanel, you can check out the SaaS KPIs template provided by Mixpanel.
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! đź“š
To find out when a company ID first appears in the historical tables, you can use SQL queries to extract the minimum timestamp (or the first event time) for each company ID. Here's an example of how you might do this:
LBKSSELECT company_id, MIN(event_time) as first_appearance FROM `your_project.your_dataset.your_table` GROUP BY company_idLBKSIn this query, replaceyour_project.your_dataset.your_tablewith the actual BigQuery path to your table. This will return a table with eachcompany_idand the timestamp of its first appearance in the data.Please note that the actual column names may vary depending on how your data is structured. You might need to adjust the query to match your actual column names.Source: Amplitude user schemakapa.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.