kapa.ai I have an event Track Played with the property of AlbumTitle and TrackTitle. I am trying to see the timeline of how my content is doing over three months for SPECIFIC ALBUMS. How do I do this?
To analyze the timeline of how specific albums are performing over three months using your "Track Played" event with "AlbumTitle" and "TrackTitle" properties, you can use Mixpanel's Insights report. Here's how you can set this up: 1. Open the Insights report in Mixpanel.2. Set your date range to the last three months using the date picker.3. Add the "Track Played" event as your main metric.4. Apply a filter to focus on specific albums: - Click on the "Filter" button - Select the "AlbumTitle" property - Choose the specific album titles you want to analyze5. Break down the results by "AlbumTitle": - Click on the "Breakdown" button - Select the "AlbumTitle" property6. Choose an appropriate chart type, such as the line chart, to visualize the timeline.7. If needed, you can further customize your analysis by changing the measurement (e.g., total events, unique users) or adjusting the time bucket (e.g., daily, weekly, monthly).This setup will show you a timeline of how your specific albums are performing over the three-month period. You'll be able to see trends and compare the performance of different albums over time.For more detailed information on using Insights and its features, you can refer to the Mixpanel Insights documentation.
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.
kapa.ai For example I want to analyse 3 shows, I need 3 trendlines
Let me check the knowledge base for you again. One moment! 📚
Certainly! To analyze 3 specific shows with separate trendlines in Mixpanel Insights, you can follow these steps: 1. Open the Insights report in Mixpanel.2. Set your date range to the desired three-month period.3. Add the "Track Played" event as your metric.4. Apply filters to focus on your 3 specific shows: - Click on the "Filter" button - Select the "AlbumTitle" property - Choose "is in list" as the operator - Enter the names of your 3 shows5. Break down the results by "AlbumTitle": - Click on the "Breakdown" button - Select the "AlbumTitle" property6. Choose the line chart visualization to see separate trendlines for each show.This setup will give you three separate trendlines, one for each show, allowing you to compare their performance over time.For more advanced visualization options, you can also use the Table Chart in Insights. According to the Insights Tables Chart documentation, this feature allows you to quickly compare different segments, which could be useful for your show analysis.Remember, you can further customize your analysis by adjusting the measurement (e.g., total events, unique users) or the time bucket (e.g., daily, weekly, monthly) to best suit your needs.If you need more detailed information on using Insights for this type of analysis, you can refer to the Mixpanel Insights documentation.
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.
kapa.ai There is no "is in list" property
Let me check the knowledge base for you again. One moment! 📚
I apologize for the confusion in my previous response. You're right, and I thank you for pointing that out. Let me provide you with the correct information based on the available Mixpanel documentation.To filter for multiple specific shows (albums) in Mixpanel, you can use the "equals" operator multiple times. Here's the correct way to set it up: 1. In the Insights report, add your "Track Played" event as the metric.2. Click on the "Filter" button.3. Select the "AlbumTitle" property.4. Use the "equals" (==) operator for the first show.5. Click on "or" to add another condition.6. Repeat steps 3-5 for each of your three shows.This approach will create a filter that includes all three of your specific shows. Then, you can proceed with breaking down by "AlbumTitle" to get separate trendlines for each show.For more details on using comparison operators in Mixpanel, you can refer to the Custom Properties documentation, which states: "Use the following comparison operators in the Formula field to modify your custom property:
- ==: The first argument is equal to the second argument. If both arguments are strings, the comparison is case-insensitive."I apologize again for the earlier misinformation. Thank you for your patience, and please let me know if you need any further clarification.
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.
kapa.ai There is no '=' filter in the filter options. There is only Is, Is not, Contains, Does not contain, Set, not set
Let me check the knowledge base for you again. One moment! 📚
I apologize for the confusion in my previous responses. You are correct, and I thank you for providing the accurate information about the available filter options. Let me provide you with the correct guidance based on the filter options you've mentioned.To filter for your three specific shows (albums) in Mixpanel Insights, you should use the "Is" filter option. Here's the correct way to set it up: 1. In the Insights report, add your "Track Played" event as the metric.2. Click on the "Filter" button.3. Select the "AlbumTitle" property.4. Choose the "Is" operator.5. Enter the name of your first show/album.6. Click on "or" to add another condition.7. Repeat steps 3-5 for each of your three shows/albums.This approach will create a filter that includes all three of your specific shows. After setting up the filter, you can proceed with breaking down by "AlbumTitle" to get separate trendlines for each show.The "Is" filter in Mixpanel is equivalent to the equals (=) operator we discussed earlier. It will select exact matches for the album titles you specify.For more information on using filters and breakdowns in Mixpanel reports, you can refer to the Mixpanel Reports Overview documentation, which states: "Filters are used to narrow events or behaviors that qualify for analysis. For example, you may want to only consider "Sign Up" events that came from Android. In this case you would you be filtering the "Sign Up" event to only include the "Sign Up" events where the property "Device" is equal to "Android"."Thank you for your patience and for helping to clarify the actual options available. This approach should allow you to analyze your three shows with separate trendlines as you initially requested.
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.
