Calculate Total Users by Product ID Count
if I got in the user properties a list “product_id: 1223,354545,45565” how can I show the total number users by the number of product_id they have (230 user with 2 product, 5969 user with 1 product)?
if I got in the user properties a list “product_id: 1223,354545,45565” how can I show the total number users by the number of product_id they have (230 user with 2 product, 5969 user with 1 product)?
Hi Eden O., 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 show the total number of users by the number of product_ids they have in a list property (e.g., "product_id" on the user profile), you can use Mixpanel's Users page or Insights report with a breakdown on the length of the list property.
Here’s how you can approach this:
1. Create a Custom Property for List Length: Mixpanel allows you to create custom properties using formulas. You can create a custom property that calculates the length of the "product_id" list for each user. This will give you the number of products each user has.
2. Breakdown or Group by the Custom Property: Once you have the custom property (e.g., "Number of Product IDs"), you can use the Users page or an Insights report to group users by this property and count the number of users in each group.
Example Steps: - Go to the Users page. - Use the "Edit Columns" option to add your custom property (the length of the "product_id" list). - Group or breakdown users by this property to see counts like "230 users with 2 products", "5969 users with 1 product", etc.
Note: The knowledge sources confirm that you can create custom properties using formulas and use them for grouping and breakdowns, but they do not provide a direct built-in function for counting the length of a list property on user profiles. However, the custom property feature is designed for such use cases, including mathematical operations and string/list manipulations on properties Custom Properties: Calculate new properties on the fly.
If you do not see a direct "length" function in the custom property formula options, you may need to check Mixpanel's formula documentation or reach out to support for the exact syntax.
Summary: - Create a custom property for the count of product_ids per user. - Group users by this property to get the distribution you want.
Let me know if you need the exact formula syntax or further step-by-step guidance!
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.