Count Distinct SKU IDs on Customer Tab for SKU Purchase Events

Yanisa S. · 2025-01-30T09:45:01.295Z

Is it possible to count number of distinct sku id each customer tab on in event sku_purchase_tab ?

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.

2 comments