Is there a way to extract screens per session from mixpanel?

Hi Bogdan G., 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> 👋

Yes, you can extract information about screens per session in Mixpanel. This can be done using the Sessions feature, which allows you to analyze user behavior within sessions. Here are a couple of ways to approach this:1. Average Pages per Session: You can calculate the average number of pages (or screens) visited per session using Mixpanel's Insights report. As described in the Sessions Use Cases documentation, you can do this by dividing the number of Page View events by the number of Session Start events using a formula.2. Breakdown of Pages per Session: To get a more detailed view, you can use the "Session Event Count" property, which is automatically added to Session events. This property indicates the number of events during a session, which can correspond to the number of screens if you're tracking screen views as events.3. Flow Analysis: The Sessions documentation mentions that you can use the "Session Start" and "Session End" events in the Flows report to view the top events within a session. This could give you a visual representation of the screens users typically visit in a session.4. Session Replay: If you're using Mixpanel's Session Replay feature, you can actually watch playbacks of user sessions, which would allow you to see exactly which screens users visited. However, this is more for qualitative analysis rather than extracting quantitative data.Remember that to make these analyses meaningful, you should be tracking an event for each page or screen a user views. This can be done automatically with Mixpanel's JavaScript SDK or through a CDP like Segment.It's important to note that the exact implementation and analysis might vary depending on your specific setup and the type of application you're analyzing (web or mobile).

ℹ️ 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! 📚

Yes, you can create a chart showing all the events containing a certain word in Mixpanel. This can be done using the Insights report and leveraging the event filtering capabilities. Here's how you can approach this:1. Use the Events Menu: As mentioned in the Events Menu documentation, you can access all your events by clicking on "Add Metric" or "Select Step". This menu shows all events by default, except for hidden events.2. Search for Events: In the events menu, you can use the search functionality to filter events containing a specific word. Simply type the word you're looking for in the search bar.3. Create an Insights Report: Once you've identified the events containing your keyword, you can add them to an Insights report. You can select multiple events to create a chart comparing their occurrences.4. Visualize the Data: In the Reports Overview, it's mentioned that you can change the type of visualization for your report in the top right corner. You can choose from various chart types to best represent your data.5. Use Custom Events: If you frequently need to analyze events containing a specific word, you might want to consider creating a custom event. This allows you to combine certain events or filter events based on specific properties.6. Leverage Lexicon: The Lexicon feature provides options to filter your events. You can use tags or other filtering options to organize your events, which could make it easier to find and analyze events containing specific words.Remember, the exact steps might vary depending on your Mixpanel setup and the specific events you're tracking. If you're having trouble finding specific events, you might want to review your event naming conventions or consider using Mixpanel's event context feature to add more context to your events.

ℹ️ 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! 📚

Yes, you can create a custom event in Mixpanel that includes all the events with a certain tag. This is a great way to group related events for easier analysis. Here's how you can do it:1. Custom Events: Mixpanel's custom events feature allows you to combine multiple events into a single virtual event. This is perfect for grouping events that share a common tag.2. Creating a Custom Event: To create a custom event, follow these steps as outlined in the Custom Events documentation: - Expand the Event dropdown in either an Insights, Funnels or Retention report. - Select the plus button to the right of the search bar. - Select the events you want to include (in this case, all events with a certain tag). - Name your custom event and click "Save".3. Using Tags: As mentioned in the Events Menu documentation, if you organize your events using tags in Lexicon, these tags will show up as filtering options in the event menu. When you select a tag, a list of events that share the same tag appears. This makes it easy to select all events with a specific tag when creating your custom event.4. Lexicon: You can manage your tags and custom events in Lexicon. This is where you can view, edit, or delete any custom events you've created.By creating a custom event that includes all events with a certain tag, you're essentially creating a higher-level event that can be used in various Mixpanel reports. This can be particularly useful for analyzing user behavior across a group of related events or for simplifying your reporting structure.Remember, custom events are virtual events used in the Reports UI and cannot be exported via the Raw Event Export API. If you need to export data related to your custom event, you'll need to export the underlying raw events that make up the custom event.

ℹ️ 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! 📚

I understand you're looking for an automated way to create a custom event that includes 160 events with a specific tag in Mixpanel. Unfortunately, the knowledge sources provided don't contain specific information about automating this process for a large number of events. However, I can provide some insights based on the available information:1. Manual Creation: The Custom Events documentation describes a manual process for creating custom events, which involves selecting events individually. This method might be time-consuming for 160 events.2. Tag Filtering: The Events Menu documentation mentions that tags can be used as filtering options in the event menu. This could potentially make it easier to select multiple events with the same tag, but it's not clear if there's a "select all" option for tagged events.3. Lexicon: The Lexicon feature allows project owners to merge events, but it doesn't specifically mention an automated way to merge all events with a particular tag.4. API or Programmatic Solution: The provided knowledge sources don't mention any API or programmatic method to create custom events based on tags.Given the lack of specific information about automating this process for a large number of events, I would recommend reaching out to Mixpanel's support team or consulting their developer documentation for potential API solutions that might not be covered in the provided knowledge sources. They may have additional tools or methods for handling bulk operations like this that aren't mentioned in the general user documentation.

ℹ️ 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! 📚

To extract one-day retention in Mixpanel, you can use the Retention report. Here's how you can do it:1. Access the Retention Report: Navigate to the Retention report in Mixpanel.2. Set Up Your Retention Query: - Define your initial action (Event A) and your return action (Event B). - Set the time range for your analysis.3. Configure Retention Settings: - In the Retention Criteria section, set the "Each" dropdown to "Day". - Set the "For" dropdown to show the number of days you want to analyze (make sure it's at least 2 days to see one-day retention).4. View One-Day Retention: - In the resulting retention table, look at the "Day 1" column. This represents your one-day retention. - The percentage in this column shows the proportion of users who returned to perform the specified action one day after their initial action.5. Interpret the Results: - As explained in the Retention documentation, "Each box within a row is assigned a shade of purple. The shading gets darker the higher the retention percentage."6. Download the Data: - If you need to extract this data for further analysis, you can download the report. As mentioned in the Downloading Reports from Mixpanel section, you can download reports in CSV, PNG, or PDF formats. - To download, click the "..." icon on the upper right corner of the report and select your preferred format.Remember, Mixpanel calculates retention based on unique users, not event totals. Each user is counted only once per cohort bucket, even if they performed the action multiple times.For a more detailed analysis, you can also use the Frequency view to see how many unique days users performed the action within a week or month.If you need to analyze this data programmatically, you might want to look into Mixpanel's Query API for Retention, which allows you to fetch retention data directly.Retention Analytics Primer

ℹ️ 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! 📚

To extract the average time between two events in Mixpanel, you can use the Funnels report with its Time to Convert feature. Here's how you can do it:1. Create a Funnel: Navigate to the Funnels report and create a funnel with the two events you're interested in measuring the time between.2. Use Time to Convert: As described in the Time to Convert documentation, you can select a Time to Convert aggregation to see how quickly or slowly your funnel converts.3. Select Average Time: In the Time to Convert options, select "Average" as your aggregation method. This will give you the average time between the two events.4. Adjust Time Range: Make sure to set an appropriate conversion window that covers the typical time range between your two events.5. Interpret Results: The result will show you the average time users take to go from the first event to the second event in your funnel.6. Visualize Data: You can view this as a summarized value by selecting "Metric" or "Bar" visualizations, or see it as a trend using the "Line" visualization.7. Detailed Breakdown: For a more detailed view, you can use the Time to Convert breakdown. As mentioned in the documentation, "Use the Time to Convert breakdown to see a distribution of time users took between any two steps in the funnel or all steps."Remember, this method calculates the time for users who completed both events within the specified conversion window. Users who didn't complete the second event won't be included in this average.If you need more granular data or want to analyze this information outside of Mixpanel, you might want to consider exporting the raw event data and calculating the time difference in your preferred analysis tool.Funnels Time to Convert

ℹ️ 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! 📚

To calculate session frequency in Mixpanel, you can use the Frequency report within the Retention analysis. Here's how you can do it:1. Access the Frequency Report: Navigate to Reports > Retention, and then select the "Frequency" option under the toggle for retention, as described in the Retention Frequency documentation.2. Set Up Your Query: - Choose the event you want to analyze. If you want to analyze sessions specifically, you can use the "Session Start" event. - Set your desired time range.3. Configure Frequency Settings: - You can choose the interval for your analysis: unique hours in a day, unique days in a week, or unique days in a month. - For example, if you want to see how many users started sessions on unique days in a week, you would select "day" as your interval and "week" as your time unit.4. Interpret the Results: The report will show you how frequently users perform the selected event (in this case, start sessions) within the chosen time frame. For example, it might show that 13.04% of users started sessions on 4 unique days in a week.5. Choose Frequency Criteria: As mentioned in the documentation, you have two options for frequency criteria: - "Cumulative Frequency": This calculates the number of users who did the event in at least X unique intervals. - "Non-cumulative Frequency": This calculates the number of users who did the event in exactly X unique intervals.6. Analyze the Data: You can use this report to understand how engaged users are with your product in terms of session frequency. For instance, you might find that a certain percentage of your users have daily sessions, while others use your product less frequently.7. Export the Data: If you need to perform further analysis, you can export the data using Mixpanel's export options.Additionally, if you need more flexibility or want to access this data programmatically, you can use the Query Frequency Report API. This API allows you to get data about how frequently users are performing events, which you can use to calculate session frequency.Remember, the key to accurate session frequency analysis is ensuring that your sessions are properly configured in Mixpanel. You may want to review your Session Settings to make sure they accurately reflect how users interact with your product.Retention Frequency View Query Frequency Report API Sessions Documentation

ℹ️ 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! 📚

I apologize for the misunderstanding. You're right, this is a different question. To find out how many sessions per day a user does on average, we can use Mixpanel's Insights report. Here's how you can calculate this:1. Create an Insights Report: Navigate to the Insights report in Mixpanel.2. Set Up Your Query: - Select "Session Start" as your event. - Set the time range to the period you want to analyze (e.g., last 30 days).3. Use the Frequency per User Measurement: As described in the Measurements documentation, you can use the "Frequency per User" measurement. This calculates the number of events performed per user.4. Configure the Measurement: - Click on the measurement dropdown (it might say "Total" or "Unique Users" by default). - Select "Frequency per User" from the options. - In the aggregation options that appear, select "Average" to get the average number of sessions per user.5. Set the Time Bucket: Change the time bucket to "Day" in the date range selector. This will give you the average number of sessions per user per day.6. Interpret the Results: The resulting number will represent the average number of sessions a user starts per day.7. Visualize the Data: You can view this as a trend over time to see if the average sessions per user per day is changing.Remember, this method calculates the average across all users. If you want to see the distribution of session frequency among your users, you might want to use the Frequency report in Retention as described in the previous answer, or create a breakdown in Insights by user properties.Also, ensure that your Session Settings are configured correctly to accurately reflect user sessions in your product.Insights Measurements Documentation Sessions Documentation

ℹ️ 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! 📚

To calculate churn rate in Mixpanel, you have a few options depending on your specific needs and business model. Here's how you can approach it:1. For Subscription-Based Models: If you're running a subscription-based business, you can use the MRR Churn metric. As described in the Revenue Analytics blog post, MRR Churn looks at existing customers and how that revenue has dropped, without considering upsells. The formula is: MRR Churn = (current MRR from existing business - upsell MRR) / prior MRR2. Using Retention Analysis: You can use Mixpanel's Retention report to calculate churn rate. As explained in the Retention Analytics Primer, retention is the inverse of churn. So, if you calculate retention, you can easily derive churn: Churn Rate = 1 - Retention Rate To do this: - Use the Retention report - Define your retention event (e.g., "Active Use" or "Subscription Renewed") - Set your time period (e.g., monthly) - The resulting retention percentage for each period can be subtracted from 100% to get your churn rate3. For Non-Subscription Models: If you're not using a subscription model, you can still calculate churn using custom events or user properties. For example: - Create a cohort of users who were active in a given period - Use the Insights report to see how many of those users remained active in the following period - Churn rate would be the percentage who did not remain active4. Using Revenue Analytics: If you're using Mixpanel's Revenue Analytics feature, you can track metrics like Net Revenue Retention (NRR). As mentioned in the Revenue Analytics blog post, if NRR is less than 100%, it indicates that your existing customers are a "leaky bucket", which is another way of looking at churn.Remember, the exact method you use should align with how your business defines churn. It's important to consistently apply the same definition across your analysis.For a deeper understanding of retention (and by extension, churn), you might want to review the Retention Analytics Primer, which provides steps for analyzing retention in Mixpanel.Revenue Analytics Explained Retention Analytics Primer

ℹ️ 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! 📚

To count the average events per user on a certain timeframe in Mixpanel, you can use the Insights report with the "Average per User" measurement. Here's how you can do it:1. Create an Insights Report: Navigate to the Insights report in Mixpanel.2. Set Up Your Query: - Select the event you want to analyze. - Set the time range to the specific timeframe you're interested in.3. Use the Average per User Measurement: As described in the Insights Measurements documentation, you can use the "Average per User" measurement. This calculates the average number of times each user performed the event.4. Configure the Measurement: - Click on the measurement dropdown (it might say "Total" or "Unique Users" by default). - Select "Average per User" from the options.5. Interpret the Results: The resulting number will represent the average number of times each user performed the selected event within the specified timeframe.6. Visualize the Data: You can view this as a single metric or as a trend over time to see how the average events per user changes over your selected timeframe.Remember, this method calculates the average across all users who performed the event at least once. Users who didn't perform the event at all during the timeframe won't be included in this average.If you want to include all users in your calculation (even those who didn't perform the event), you might need to use a more complex query or export the data for custom analysis.Also, keep in mind that you can break down this metric by user properties or cohorts to get more granular insights into how different user segments behave.Insights Measurements Documentation

ℹ️ 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! 📚

To check the users who performed an event every day in the past 30 days, you can use Mixpanel's Retention report with the Frequency view. Here's how you can do it:1. Access the Retention Report: Navigate to Reports > Retention in Mixpanel.2. Switch to Frequency View: As described in the Retention Frequency documentation, toggle to the "Frequency" view instead of the default "Retention" view.3. Set Up Your Query: - Choose the event you want to analyze. - Set your time range to the past 30 days.4. Configure Frequency Settings: - Set the interval to "day" and the time unit to "month". - This will show you how many unique days in the past month users performed the event.5. Interpret the Results: - Look for the row that shows users who performed the event on 30 unique days (or the highest number of days available if no one did it every single day). - The percentage and number of users in this row are those who performed the event every day in the past 30 days.6. View User List: As mentioned in the View Users documentation, you can click on any data point to see the list of users who meet that criteria. This will allow you to see exactly who these highly engaged users are.7. Create a Cohort (Optional): If you want to use this group of users for further analysis, you can save them as a cohort. The Cohorts documentation explains how to create and use cohorts in Mixpanel.Remember, this method will show users who performed the event on the maximum number of unique days in the past 30 days, which might not necessarily be all 30 days if no users were that consistent. If you need to be more precise, you might need to export the data and perform a custom analysis.Retention Frequency View View Users in Reports Cohorts Documentation

ℹ️ 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! 📚

To check the users who performed a certain event every day for a specific period in Mixpanel, you can use the Retention report with the Frequency view, similar to the approach we discussed for the past 30 days. Here's how you can do it:1. Access the Retention Report: Navigate to Reports > Retention in Mixpanel.2. Switch to Frequency View: As described in the Retention Frequency documentation, toggle to the "Frequency" view instead of the default "Retention" view.3. Set Up Your Query: - Choose the specific event you want to analyze. - Set your time range to the period you're interested in.4. Configure Frequency Settings: - Set the interval to "day" and the time unit to match your period of interest (e.g., "week" for a week-long period, "month" for a month-long period). - This will show you how many unique days within your chosen period users performed the event.5. Interpret the Results: - Look for the row that shows users who performed the event on the maximum number of days (equal to the number of days in your chosen period). - The percentage and number of users in this row are those who performed the event every day during your specified period.6. View User List: As mentioned in the View Users documentation, you can click on the data point representing users who performed the event every day to see the list of these highly engaged users.7. Create a Cohort (Optional): If you want to use this group of users for further analysis, you can save them as a cohort.Remember, this method will show users who performed the event on the maximum number of unique days in your chosen period. If no users were perfectly consistent (i.e., did the event every single day), you'll see the highest level of consistency achieved.For more precise analysis or for periods not easily accommodated by Mixpanel's preset options, you might need to use the JQL (JavaScript Query Language) feature or export the data for custom analysis.Retention Frequency View View Users in Reports

ℹ️ 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! 📚

Yes, there are alternatives to the Frequency view in Mixpanel for analyzing user behavior and engagement. One notable alternative is the Behavioral Properties feature. Here's an overview of this alternative:Behavioral Properties: Mixpanel's Behavioral Properties feature allows you to use a user's activity as a property in your analysis. As described in the Behavioral Properties documentation, this feature offers two main options that can serve as alternatives to the Frequency view:1. Frequency per User: This option allows you to segment your users by how many times they performed a specific event. You can use this to filter users based on their event frequency or to break down your analysis by frequency groups.2. Aggregate Property per User: This option lets you select an event and a property on that event, then choose an aggregation type for this property. For example, you could use this to segment users by their total watch time or to filter for users who have a certain level of engagement based on a numeric property.These Behavioral Properties can be used in various Mixpanel reports, including Insights, Funnels, and Retention, providing a flexible alternative to the Frequency view.Additionally, for more complex analyses or custom time ranges, you might consider:3. JQL (JavaScript Query Language): While not mentioned in the provided knowledge sources, Mixpanel's JQL feature allows for more advanced and customized queries, which could be used to create frequency-like analyses tailored to your specific needs.4. Custom Events: As mentioned in the Custom Events documentation, you can create custom events that combine multiple events. This could potentially be used to create frequency-like metrics tailored to your specific use case.Remember, the best alternative will depend on your specific analysis needs and the nature of your data. You might need to experiment with different approaches to find the one that best suits your requirements.Behavioral Properties Documentation Custom Events Documentation

ℹ️ 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! 📚

I apologize, but I need more context to provide a specific answer to your question "how do I do 1". The previous conversation doesn't provide enough information to understand what "1" refers to. To help you effectively, could you please provide more details about what you're trying to accomplish in Mixpanel? Are you referring to a specific feature, report, or analysis method we discussed earlier? Once you provide more context, I'll be able to give you a more accurate and helpful answer based on Mixpanel's capabilities.

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