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: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.