Hi kapa.ai I want to know the average monthly active devices instead of users how to do so ?
To measure the average monthly active devices (instead of users) in Mixpanel, you need to track a device identifier (such as a device ID) as a property on your events. Then, you can use Mixpanel’s Insights report to count unique device IDs over a monthly interval, similar to how you would count unique users.Here’s how you can do it: 1. Ensure Device ID is Tracked:
Make sure your events include a property that uniquely identifies each device (e.g., device_id
).2. Create an Insights Report:
- Go to Insights in Mixpanel.
- Select the event(s) that represent meaningful engagement for your definition of “active.”
- Set the time interval to “Month.”3. Change the Measurement:
- By default, Mixpanel counts “Unique Users” (based on distinct_id
).
- Change the measurement to count unique values of your device property (e.g., unique device_id
).
- This will give you the number of unique active devices for each month.4. Calculate the Average:
- You can view the monthly counts over your desired time range and calculate the average (either manually or by exporting the data).Note: The knowledge sources confirm that Mixpanel allows you to count unique values of any property, not just users, by changing the measurement in Insights. However, they do not provide a step-by-step guide specifically for devices, but the process is analogous to counting unique users, just using a different property (Docs: Insights Measurements).If you need to automate the average calculation, you may need to export the monthly data and compute the average externally, as Mixpanel’s UI does not natively provide an “average over time” for unique counts.If you need more detailed steps or run into issues, please let me know!
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.
hi kapa.ai it seems the $device_id is reset everytime a user update the android app while on iOS it’s not the case, the $device_id keeps being the same as long as the icloud account used to install the app is the same how to set up identity so that $device_id does’nt change on android devices
Let me check the knowledge base for you again. One moment! 📚
I'm sorry, but the knowledge sources do not provide specific information or guidance on how to prevent $device_id
from changing on Android devices after an app update. The documentation only states that $device_id
is autogenerated by the SDK and is reset when .reset()
is called, but it does not detail how the SDK handles $device_id
persistence across app updates on Android, nor does it provide a method to configure or override this behavior.If you need to ensure device identity persists across updates, you may need to implement your own device identifier and set it as a custom property, but this approach is not covered in the provided documentation. For further assistance, you may want to consult Mixpanel's support or Android SDK documentation directly for advanced configuration options.Managing User Identity - Android SDK
Default Properties: $device_id
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.