Count Distinct SKU IDs on Customer Tab for SKU Purchase Events
Is it possible to count number of distinct sku id each customer tab on in event sku_purchase_tab ?
Hi Yanisa S., 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
Yes, it is possible to count the number of distinct SKU IDs each customer taps on in the "sku_purchase_tab" event using Mixpanel's Insights report. You can achieve this using the "Aggregate Property per User" measurement in Mixpanel Insights. Here's how you can do it: 1. In the Insights report, select the "sku_purchase_tab" event. 2. For the measurement, choose "Aggregate Property per User". 3. Select "Distinct count" as the function. 4. Choose the property that represents your SKU ID.This setup will give you the count of distinct SKU IDs per user for the "sku_purchase_tab" event.For more details on how to use the "Aggregate Property per User" function in Mixpanel Insights, you can refer to the Mixpanel documentation on Insights.The documentation provides this example which is similar to your use case: "Distinct count: The number of distinct property values per user. Example: How many different videos did each user watch?"In your case, it would be "How many different SKU IDs did each user tap on?"Remember that you can further analyze this data by using breakdowns or filters to segment your users based on other criteria if needed.
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.