I want to find the number of users who did two specific events within a week and compare that number to the number of users who did only one of the two events. I'd like to monitor this number weekly. How can I achieve that in Mixpanel?
Hi Igor K., 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 achieve this in Mixpanel, you can use the Insights report with custom events and formulas. Here's how you can set it up:
1. First, create two custom events: - One for users who did both specific events within a week - Another for users who did only one of the two events
2. Then, use the Insights report to visualize and compare these custom events over time.
Here's a step-by-step guide:
1. Create custom events: - Go to Lexicon and create a new custom event for users who did both events within a week - Create another custom event for users who did only one of the two events Custom Events
2. Set up an Insights report: - Add your two custom events as separate metrics - Set the measurement to "Unique Users" for both metrics - Set the time interval to "Weekly" to monitor the numbers weekly Insights Report
3. Use a formula to compare the numbers: - Click on the "Metrics" button and select "Formula" - Create a formula to calculate the difference or ratio between the two metrics Formulas in Insights
4. Visualize the results: - Choose an appropriate chart type (e.g., line chart) to display the trends over time - You can use the "Compare to past" feature to compare with previous periods Time Period Comparisons
By following these steps, you'll be able to monitor and compare the number of users who performed both events within a week against those who performed only one event, on a weekly basis.
Remember to save your report so you can easily access and update it in the future.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ 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 knowledge sources provided, Custom Events in Mixpanel primarily support combining events using an OR operator. However, there isn't explicit information about supporting an AND operator for Custom Events.
The Custom Events documentation states that Custom Events can be used to:
1. Merge two events into a single event ("User Signup" + "Account Created" -> "Signup") 2. Create an event based on a filter on another event ("Purchase" where Country = "US" -> "US Purchases")
These examples suggest that Custom Events are designed to combine events using an OR logic or to filter a single event based on certain properties.
If you're looking to create a more complex event definition that requires an AND operator between events, you might need to explore alternative approaches. Unfortunately, the provided knowledge sources don't contain enough information to suggest a direct method for creating Custom Events with an AND operator.
For more advanced event combinations or complex logic, you may want to consider using other Mixpanel features like JQL (JavaScript Query Language) or Warehouse Connectors if you need more flexibility in defining events. However, these options would require a different approach than using the standard Custom Events feature.
If you need a definitive answer about the capabilities of Custom Events regarding AND operators, I recommend reaching out to Mixpanel's support team for the most up-to-date and accurate information.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
